Learn MS SQL Server 2017 With Db Design Techniques
4.1 (346 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,199 students enrolled

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...
4.1 (346 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,199 students enrolled
Created by Manzoor Ahmed
Last updated 8/2018
English
Current price: $11.99 Original price: $29.99 Discount: 60% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10.5 hours on-demand video
  • 11 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
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
Expand all 43 lectures 10:26:51
+ Learn MS SQL Server 2017 From With Db Design Techniques
11 lectures 06:33:53
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
+ Data Manipulation Language - Insert,Update And Delete
2 lectures 07:04

Adds a new row to a table or a view using Insert statement

Preview 03:55

Updating and deleting an existing row to a table using Update and delete statement

Preview 03:09
+ Data Manipulation Language - Select
2 lectures 15:29

Retriving existing rows from a table using select statement.

Select Statement
04:10

Top(), Order by, Where, in, not in, between, not between and Like Clauses

Aggregate Functions like Sum(), Avg(), Min(), Max(), Count() etc.,

Various Clauses
11:19
+ Data Manipulation Language - Built In Functions
2 lectures 21:05

string Functions Like Lower(), Upper(), Reverse(), SubString(), etc.,

Built In Functions
12:24
DateTime Functions
08:41
+ Data Manipulation Language - Advance clauses and Joins
4 lectures 32:27

Group By and Having Clause

Group By and Having Clause
11:50

Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join

Understanding Joins
06:30

Implementing Joins Like Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.

Implementing Joins
08:35
Self Join
05:32
+ Data Manipulation Language - Stored Procedures And Functions
4 lectures 21:18

Creating Stored Procedures With No Input And Output Params

Creating Stored Procedures With No Input And Output Params
04:33

Creating Stored Procedures With Input And No Output Params

Creating Stored Procedures With Input And No Output Params
03:56

Creating Stored Procedures With Input And Output Params

Creating Stored Procedures With Input And Output Params
05:07

Creating User Defined Functions

Creating User Defined Functions
07:42
+ Subqueries
4 lectures 30:47
Scalar SubQueries
05:56
Multivalued Subqueries
08:03
EXISTS and not EXISTS
03:25
Correlated Queries
13:23
+ Advanced Data Manuplation And Control Structures
5 lectures 33:45
Delete Vs Truncate
07:45
OUTPUT clause
03:12
IIF()
01:41
Case When
09:14
IF...ELSE
11:53
+ Advanced Operations
6 lectures 34:01
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 viewsscope identity functiontransactions 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