SQL Course

Master SQL  With The Most Advanced Complete Course On The Market. From Beginner to Advanced. 

Course Duration - 6 Weeks

Course Content

SQL Courses

Module 1: Introduction to RDBMS and Microsoft SQL Server

  • Introduction to RDBMS concepts
  •  Normalization Technique
  •  SQL Server Architecture
  •  Introduction to Microsoft SQL Server
  •  Introduction to SQL Server Management Studio
  •  Installation of SQL server Management Studio

Module 2: Creating tables, databases and importing and exporting data

  •  Introduction of Language Statements (DDL, DML, DCL, TCL)
  • Creating table and DDL commands
  •  Introduction of Import and Export Wizard

Module 3: SQL Constraints and data types

  •  SQL Data Types
  •  SQL Constraints
  •  SQL Indexing

Module 4: Select statement and working with Sorting and Filtering data

  •  Select Statement
  •  SQL Distinct keyword
  •  SQL Where Clause
  •  SQL wild card concept
  •  SQL Group by and Having clause
  •  SQL CASE statements

Module 5: Working with Multiple tables using Join concept

  •  Introduction of Join
  • Inner Join
  •  Outer Join
  •  Left Join
  •  Right Join
  •  Self Join
  •  Cross Join
  •  Concept of Nested Join with Where Clause

Module 6: Using DML to modify data

  •  SQL Update Statement
  •  SQL Insert Statement
  •  SQL Delete Statement
  •  SQL Transaction control Language

Module 7: Using Built In Functions

  •  SQL Number Functions
  •  SQL Date Functions
  •  SQL Text Functions
  •  SQL Special Functions

Module 8: Using Subqueries concepts and Table Expressions

  •  SQL Scalar Sub queries
  •  SQL Multivalued Sub Queries
  •  SQL Table Values Sub Queries
  •  SQL Common Table Expression

Module 9: Using Set operators and Windows Ranking, and Aggregate Functions

  •  SQL UNION, UNION ALL, INTERSECT AND EXCEPT
  •  SQL CROSS APPLY operator
  •  SQL RANK function
  •  SQL DENSE_RANK function
  •  SQL ROW_NUMBER function
  •  SQL Over Clause

Module 10: Programming with T-SQL and Stored Procedure

  •  SQL If condition
  •  SQL While Loop
  •  Creating Stored Procedure
  •  Modifying Stored Procedure

Module 11: Working with User Defined Functions

  •  Creating User Defined Function
  •  Modifying User Defined Function
  •  SQL Pivot and Unpivot Concept

Module 12: Applying Error Handling concept in T SQL Programming

  •  Implementing T-SQL Error Handling
  •  Redirecting Errors with Try/Catch
  •  Using THROW to pass an error message back to a client
  •  Applying Error Handling in Stored Procedure
  •  Applying Error Handling in Stored Procedure

Module 13: Concept of Cursor and Index

  •  Introduction of Cursor
  •  Creating cursor
  •  Modifying cursor
  •  Detailed description about Index

Module 14: Performance Tuning

  •  Query optimization
  •  Performance Tuning