Curriculum
- 1 Section
- 29 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Microsoft SQL Server33
- 2.0Installation of SQL Server
- 2.1Installation of SSMS
- 2.2Introduction to Microsoft SQL Server
- 2.3Data Types in SQL Server
- 2.4Built in functions in SQL Server
- 2.5Constraints in SQL Server
- 2.6DDL & DML Hands-on
- 2.7How to create Views in SQL Server
- 2.8SQL Server – Hands on Session Day 2
- 2.9SQL Queries – Hands on Session Day 3
- 2.10How to clone or duplicate a table in SQL Server
- 2.11What is Correlated Subquery and Plain Subquery in SQL Server
- 2.12SET Operators in SQL Server
- 2.13Joins in SQL Server
- 2.14IN Operator in SQL Server
- 2.15Exists Operator in SQL Server
- 2.16How to find and Remove Duplicate Records in SQL
- 2.17How to find the Nth Maximum Salary
- 2.18Grouping sets and rollup functions in SQL Server
- 2.19CUBE function
- 2.20How to Pivot and Unpivot the data
- 2.21Stored Procedure
- 2.22Transaction Control Statements in SQL Server
- 2.23Stored Procedure and Stored Function in SQL Server
- 2.24Common Table Expression (CTE) in SQL Server
- 2.25Analytic Functions in SQL Server
- 2.26FIRST_VALUE and LAST_VALUE functions in SQL Server
- 2.27Lead () and Lag () functions in SQL Server
- 2.28What is a trigger , When to use trigger ,its use cases & Limitations
- 2.29Correlated and Non-Correlated query Quiz10 Minutes7 Questions
- 2.30Joins Quiz10 Minutes10 Questions
- 2.31Analytical Functions Quiz10 Minutes10 Questions
- 2.32Stored Procedure Quiz10 Minutes1 Question
