Learn SQL Server Step by Step

Lab 1:- Basic Fundamentals Database, Tables, rows and columns. 1 lecture 16:14 Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 1:- Basic Fundamentals Database, Tables, rows and columns. 1 lecture 16:14 Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 1:- Basic Fundamentals Database, Tables, rows and columns. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. In this lab we see how to create databases , tables , rows , columns and also understand how to use SQL Server management studio. Lab 2:- Primary key, foreign key, referential integrity and constraints. 1 lecture 23:46 Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Lab 2:- Primary key, foreign key, referential integrity and constraints. 1 lecture 23:46 Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Primary key, foreign key, referential integrity and constraints. 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams 1:- NULLS 2 :- Identity 3 :- Unique key 4 :- Candidates / Primary keys 5 :- Refe Integrity and FK 6 :- Database digrams Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms). 1 lecture 33:35 Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms). 1 lecture 33:35 Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Database Normalization (1st, 2nd and 3rd normal forms). 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design 1 :- First, second and third normal forms 2 :- Database design problems 3 :- Duplicate and Redundancy 4 :- Atomic and repeating groups 5 :- Design issues of partial dependency 6 :- Transitional dependency 7 :- Many to Many design Lab 4: - SQL basics(Select, Insert, Update and Delete) 1 lecture 01:20:00 Lab 4: - SQL basics(Select, Insert, Update and Delete) 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 4: - SQL basics(Select, Insert, Update and Delete). 1 lecture 01:20:00 Lab 4: - SQL basics(Select, Insert, Update and Delete) 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 4: - SQL basics(Select, Insert, Update and Delete) 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 4: - SQL basics(Select, Insert, Update and Delete) 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 4: - SQL basics(Select, Insert, Update and Delete) 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...