Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Microsoft SQL

Learn MS SQL Server 2017 With Db Design Techniques

With real time data base designing techniques, SQL, Joins, SPs, Functions, Views, Transactions, Triggers and lot more...
Rating: 4.5 out of 54.5 (404 ratings)
10,469 students
Created by Manzoor Ahmed
Last updated 8/2018
English
30-Day Money-Back Guarantee

What you'll learn

  • By the end of this course you will be in a position to do the following :-
  • Creating, Altering And Dropping DataBase Creating Tables
  • Primary Keys, Identity Columns and Unique Keys DataBase Diagram and Creating Relationships between tables
  • DataTypes In SQL Server
  • Insert Statement, Update Statement and Delete Statement
  • Select Statement with Top(), Order by, Where, in, not in, between, not between and Like Clauses, Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,
  • DateTime Functions Like getDate(), Day(), Month(), Year(), DateDiff(), DateAdd(), etc.,
  • Group By and Having Clause with Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join. Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
  • Creating Stored Procedures With No Input And Output Params Creating Stored Procedures With Input And No Output Params Creating Stored Procedures With Input And Output Params and Creating Functions

Course content

10 sections • 43 lectures • 10h 26m total length

  • Preview36:14
  • Preview37:26
  • Day 3 - Assigment-Insert-Update-Delete-Select Start
    37:42
  • Day 4 - OrderBy-Where-String-Aggrigate
    48:11
  • Day 5 - DateTimeFunctions-GroupBy-IntroToJoins
    40:46
  • Day 6 - Implementing 2 And 3 Tables Joins
    24:16
  • Day 7 - SelfJoin-Union-Simple-Correlates-SubQueries
    34:26
  • Day 8 - Views And Common Table Expression (CTE)
    31:25
  • Day 9 - StoredProcedures-Functions
    33:00
  • Day 10 - Table Variables - Transactions - SCD - ScopeIdentity
    36:26
  • Day 11 - Triggers Admin Tasks And Assignment
    34:01

  • Preview07:50
  • Preview04:41
  • Preview14:31

  • Preview03:55
  • Preview03:09

  • Select Statement
    04:10
  • Various Clauses
    11:19

  • Built In Functions
    12:24
  • DateTime Functions
    08:41

  • Group By and Having Clause
    11:50
  • Understanding Joins
    06:30
  • Implementing Joins
    08:35
  • Self Join
    05:32

  • Creating Stored Procedures With No Input And Output Params
    04:33
  • Creating Stored Procedures With Input And No Output Params
    03:56
  • Creating Stored Procedures With Input And Output Params
    05:07
  • Creating User Defined Functions
    07:42

  • Scalar SubQueries
    05:56
  • Multivalued Subqueries
    08:03
  • EXISTS and not EXISTS
    03:25
  • Correlated Queries
    13:23

  • Delete Vs Truncate
    07:45
  • OUTPUT clause
    03:12
  • IIF()
    01:41
  • Case When
    09:14
  • IF...ELSE
    11:53

  • Views
    07:58
  • Slowly Changing Dimensions
    06:10
  • Scope Identity Function
    07:48
  • Transactions
    05:57
  • Triggers
    06:08
  • Download Queries
    10 pages

Requirements

  • Need MS Sql Server express of any version higher than 2005 installed on your system.

Description

Q: Is it possible for me to learn query writing against MS SQL Server database, even if I don't have any basics of DBMS?

A: Yes! you can learn and this course is perfect for those who are absolute beginners in MS SQL Server technology. In this course we are going to learn every thing from scratch i.e., right from installing MS SQL Server management Studio, creating database, tables, understanding relationships, performing basic insert, update, delete and select operations, using basic builtin functions till all types of joins.

We will also understand how to write different kinds of stored procedures and user defined function. Then we will go for writing sub querieswhich includes scalar, multi valued and correlated sub queries.

Moving ahead we see the programming logic in query writing using T-SQL and understand how to write conditional statements in your large complex stored procedures. And finally we will try to understand the advanced concepts like views, scope identity function, transactions and triggers.

So, I ensure you that you will enjoy each and every minute of the videos by learning something new

Topics Covered are :

  • Introduction-Database-Table-Keys (36:14)

  • DataTypes-ForeignKey-DBDesign-Techniques (37:26)

  • Insert-Update-Delete-Select Start (37:42)

  • OrderBy-Where-String-Aggrigate (48:11)

  • DateTimeFunctions-GroupBy-IntroToJoins (40:46)

  • Implementing 2 And 3 Tables Joins (24:16)

  • SelfJoin-Union-Simple-Correlates-SubQueries (34:26)

  • Views And Common Table Expression (CTE) (31:25)

  • StoredProcedures-Functions (33:00)

  • Table Variables - Transactions - Slowly Changing Dimensions - ScopeIdentity (36:26)

  • Triggers - Admin Tasks - Assigment (34:00)

Who this course is for:

  • Fresh Graduates

Instructor

Manzoor Ahmed
Microsoft Certified Trainer
Manzoor Ahmed
  • 4.3 Instructor Rating
  • 7,073 Reviews
  • 126,313 Students
  • 12 Courses

Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.