Course Contents

SQL (Structured Query Language) is the leading programming language for relational database management systems.

This course helps learners to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure database, author efficient SQL statements, and clauses, and manage SQL database for scalable growth.

Introduction to SQL
1. SQL Server Overview and Installation
2. SQL Commands (DDL,DML,DCL,TCL,DQL)
Database Management
1. Creating altering and dropping a database
2. Creating and working with tables
3. Rename Database,Table and Field
4. Union and Intersect in SQL Server
5. Where Clasue ,In Operator, WildCharacters
6. Operators
Functions in SQL
1. Aggregate Functions and Date Functions
2. Text Functions (Left,Right,CharIndex,Substring)
3. IF and Case Statement
4. Create Copy of Table
5. Constraints
6. Adding and Drop Constraints
7. Data Type in SQL Server
Group By and Having
Joins in SQL Server
Stored Procedures
Create View and Get SQL Data into Excel
Create and Execute Trigger
1. Alter Trigger
Pivot in SQL Server and Error Handling
Subqueries In SQL Server
Job creation and scheduling
Cursor

Basic knowledge of coding

Instructor Profile

White Knight Ventures

White Knight Ventures is in the quest of imparting top-of-the-class knowledge. We are engaged in continuous improvement of content and processes to build value for our learners.