Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

sql server tutorial

Name: sql server tutorial
Rating: 4.5 (142 reviews)

These step by step video lessons will teach you Sql Server step by step from scratch.

Created byShivprasad Koirala

Last updated 7/2022

English

What you'll learn

SQL Server installation, creating entities like database , tables , rows and columns. Covers fundamentals like primary key,foreign key , referential integrity , constraints , normalization ( first , second and third normal forms), Denormalization,OLTP , OLAP, StarSchema and SnowFlake design.
Writing DML and DDL query like inner join,left join,right join, outer join, union , co-related queries, union all, alias,case statements,cartesian,ISNULL, aggregate( sum/count),wild card , top, order by, create , insert, bulk insert , update , backup , restore,ISNULL,Coalesce,Row_Number, Partition, Rank ,DenseRank , Pivot and Unpivot.
Understanding importance of indexes , how it makes our search faster , non-clustered indexes vs clustered indexes , page splits in indexes and column store indexes.
Triggers,Insteadof , After trigger ,Inserted , deleted tables ,Stored Procedures,CDC,8 KB page and SQL Server agent.

Course content

21 sections • 21 lectures • 7h 3m total length

Lab1 :- Basic fundamentals Database, Tables, rows and columns16:14
In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio.

Lab 4: - SQL basics(Select, Insert, Update and Delete)1:20:05
1. SQL Practice 1:- Select all columns and all rows of the table
2. SQL Practice 2:- Select only needed columns from table.
3. SQL Practice 3:- Select using a numeric criterion.
4. SQL Practice 4:- Select using a string criterion.
5. SQL Practice 5:- Select using AND and OR.
6. SQL Practice 6:- Sort data using ascending and descending.
7. SQL Practice 7:- Provide user friendly ALIAS for column names.
8. SQL Practice 8:- Display unique records from a table.
9. SQL Practice 9:- Searching using pattern and wildcards.
10. SQL Practice 10:- Create runtime calculated columns.
11. SQL Practice 11:- CASE statements with SQL.
12. SQL Practice 12:- Join data from two SELECTS using UNION and UNION ALL.
13. SQL Practice 13:- Show matching data from two tables.( Inner Join)
14. SQL Practice 14:- Show all records from one table and only matching record from other table. ( Left and Right)
15. SQL Practice 15:- Show all records from matching or unmatching. (FULL outer join).
16. SQL Practice 16:- Show cartersian of two tables( CROSS JOIN)
17. SQL Practice 17:- Writing a complex SQL inner join statement.
18. SQL Practice 18:- Display aggregate values from a table (GROUP BY)
19. SQL Practice 19:- Filter on Aggregate values (HAVING CLAUSE)
20. SQL Practice 20:- Self Join
21. SQL Practice 21:- INSULL
22. SQL Practice 22:- Sub Queries
23. SQL Practice 23:- Co-related Queries
24. SQL Practice 24:- Find Max, Min and Average.
25. SQL Practice 25:- Find the between numeric values.
26. SQL Practice 26:- Dump table data in to new table (SELECT INTO)
27. SQL Practice 27:- Insert data in to table.
28. SQL Practice 28:- Insert bulk data in existing table
29. SQL Practice 29:- Update data in to table.
30. SQL Practice 30:- Delete data from a table.
31. SQL Practice 31:- The SQL designer window.

Lab 5:- DDL ( Data definition language) Queries31:43
SQL Practice Lab 31 :- Create Database Query
SQL Practice Lab 32 :- Create Database with FileName , Size , MaxSize and Growth.
SQL Practice Lab 33 :- Backup Database.
SQL Practice Lab 34 :- Restore Database.
SQL Practice Lab 35 :- Create table
SQL Practice Lab 37 :- Alter a table structure drop a existing column.
SQL Practice Lab 38 :- Alter a table structure change a existing column.
SQL Practice Lab 39 :- Adding validation constraints NOT NULL and UNIQUE
SQL Practice Lab 40 :- Check Constraints for data value validation.
SQL Practice Lab 41 :- Provide Default values for a table.
SQL Practice Lab 42 :- Creating Primary and Foreign key constraints
Designer VS SQL Scripts

Lab 6: - Transactions, Locks and Isolation level in SQL Server.1:08:16
Chapter 1 :- Defining transactions.
Chapter 2 :- Basic syntax Begin , commit & rollback tran
Chapter 3:- Nested transaction ,check points & trancount.
Chapter 4:- Understanding concurrency and issues associated with it.
Chapter 5:- Understanding and demonstrating Exclusive (X) locking.
Chapter 6:- Understanding row level locking concept.
Chapter 7:- Read committed ,Read Uncommitted mode and NOLOCK .
Chapter 8:- sp_lock and sp_who
Chapter 9:- Dead lock and demonstration of the same.
Chapter 10:- How to stop dead lock ?
Chapter 11:- Update locks and how is it different from shared lock.
Chapter 12:- Lock heirarchy
Chapter 13:- Intent lock
Chapter 14 :- ISOLATION LEVEL
Chapter 15:- Repeatable read , Dirty reads and Phantom rows
Chapter 16:- Locking compatibility matrix
Chapter 17:- Conversion locks SIX,SIU and UIX
Chapter 18:- ACID properties
Revision note

Requirements

No experienced required , should have the will to learn :-)

Description

It has 21 labs which covers the below syllabus.

Lab 1:- Basic Fundamentals Database, Tables, rows and columns.

Lab 2:- Primary key, foreign key, referential integrity and constraints.

Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).

Lab 4: - SQL basics(Select, Insert, Update and Delete)

Lab 5 :- DDL (Data definition language) Queries.

Lab 6: - Transactions, Locks and Isolation level in SQL Server.

Lab 7: - ISNULL and Coalesce functions.

Lab 8: - Row_Number, Partition, Rank and DenseRank

Lab 9: - Triggers, inserted and deleted tables

Lab 10: - Instead of and after triggers.

Lab 11: - Denormalization, OLTP and OLAP.

Lab 12: - Understanding Star schema and Snow flake design.

Lab 13: - SQL Server 8 kb pages.

Lab 14 :- Index and performances

Lab 15 :- Page Split and indexes

Lab 16 :- Clustered vs non-clustered

Lab 17: - Stored procedures and their importance.

Lab 18: - Change Data Capture.

Lab 19: - Explain Columnstore Indexes?

Lab 20: - SQL Server agent

Lab 21: - How can we implement Pivot & Unpivot in SQL Server?

Who this course is for:

Developers who want to become SQL Server developers

sql server tutorial

What you'll learn

Explore related topics

Course content

Lab1 :- Basic fundamentals Database, Tables, rows and columns1 lecture • 16min

Lab2 :- Primary key, foreign key, referential integrity and constraints1 lecture • 24min

Lab3 :- (Database normalization) First , Second and Third normal form1 lecture • 34min

Lab 4: - SQL basics(Select, Insert, Update and Delete)1 lecture • 1hr 20min

Lab 5:- SQL Server1 lecture • 32min

Lab 6: - Transactions, Locks and Isolation level in SQL Server.1 lecture • 1hr 8min

Lab 7: - ISNULL and Coalesce functions.1 lecture • 6min

Lab 8:- Row_Number, Partition, Rank and DenseRank1 lecture • 11min

Lab 9:- Triggers, inserted and deleted tables1 lecture • 16min

Lab 10:- Instead of and after triggers.1 lecture • 16min

Requirements

Description

Who this course is for: