Master SQL Live Classes
(15 hrs-10 Sessions)

Learn SQL from scratch with practical to become SQL ready. SQL is most important for Data Engineer & Data Science.

• 🔑 Register for Free →

Disclaimer: This is complete Free live class, No hidden Charges.Session will Start from 13-Sep-2022

Who is the Instructor of this Course?

Deepak Goyal

• 14+ Years Experienced IT professional
• Microsoft Certified Trainer
• Microsoft Certified Solution Architect
• Founder of Azurelib.com
• Linkedin Celebrity with having 57K+ Followers
• Helped many organizations to build Data data platforms

• 🔓 Enroll Now →

The Full Curriculum

Getting Started• Day 1 :
1. Introduction to Data, Databases
2. Need of Databases
3. Database Software
4. Market Trends in Databases
5. MS SQL Server• Day 2:
1. SQL
2. Why SQL?
3. DDL/DML/DCL
4. DataTypes• Day 3:
1. Keys
2. Constraints• Day 4:
1. Understanding Select Statement
2. Usage of Top, Distinct, Null etc...keywords
3. Using String and Arithmetic Expressions• Day 5
1. Using functions in Queries
2. Count, Sum, Min, Max, Avg
3. Group By and Having Clause
4. Using Group By with Rollup and Cube• Day 6
1. Joins and Set Operations• Day 7
1. Views
2. Cursor
3. Trigger
• Day 8.
1.Data Control Language (DCL)
2. Creating Users & Roles
3. Granting & Revoking of Roles & Privileges
4. Managing using Management Studio
5. Backup & Restore• Day9
1. Index
2. Stored Procedures
3. User-Defined Functions• Day10.
1. Performance monitoring
2. Case Study Demo

• 🔓 Register for Free →

Course Highlights

• Email
• Twitter
• LinkedIn