Decade of Excellence : Successfully completed 10 years of providing impactful training and mentorship. Global Reach: Delivered training to over 34,000 professionals worldwide. Outstanding Ratings: Achieved an impressive overall rating of 4.5/5 from trainees. Transformative Results: Maximum salary increase: 220%. Minimum salary increase: 70%. Average salary increase: 140%.

SQL Queries [Basic To Advanced]

Master the art of SQL and unlock the full potential of databases with our comprehensive course, from basic principles to advanced techniques!

5.0 (3465 ratings)
Language : English
Validity Period : Lifetime
₹18,000 47% OFF

₹10,000/- Excluding 18% GST

Description Course Content

Description:

Master SQL Queries from Basic to Advanced

You can now easily improve your database skills. Our SQL Queries Course is perfect for beginners and experienced professionals. You will learn how to write and optimize queries, retrieve data efficiently, and manage databases. This database testing course online covers SQL fundamentals, joins, subqueries, stored procedures, and performance tuning. With hands-on practice, you will gain real-world experience in database management. Whether you are a developer, tester, or analyst, this course will help you become proficient in SQL. Enroll now and improve your SQL for Data Analysts skills to advance your career in data management and analysis.

Top Features of Our SQL Queries Course

Learn SQL Window Functions to perform advanced calculations and ranking within result sets for efficient data analysis.
Master SQL for Testers to validate, debug, and optimize database queries for software testing and quality assurance.
Gain hands-on experience with SQL with Live Projects to apply your skills in real-world database scenarios.
Improve database efficiency with SQL Performance Tuning techniques for faster query execution and optimized data retrieval.

Learn SQL Online

Understand SQL fundamentals, including data retrieval, filtering, joins, and subqueries, through interactive lessons and practical exercises.

SQL Interview Preparation

Get ready for job interviews with expert SQL Interview Preparation, common SQL questions, and hands-on problem-solving techniques.

SQL for Business Analysts

Learn how to analyze business data, create insightful reports, and make data-driven decisions using SQL queries.

SQL Query Optimization & Stored Procedures

Master SQL Query Optimization techniques to improve performance and efficiency, along with SQL Stored Procedures & Functions for automating database operations.

Session-1: Environment Setup & Basics of SQL

1. Download SQL Server
2. Download SSMS
3. Install SQL Server with Mixed Mode
4. Install SSMS
5. Launch SSMS
6. Login with Windows Authentication
7. Login with SQL Server Authentication
8. Create Database
9. Type of Objects in Database
10. Data Types
Class Notes
Assignment

Session-2: Basic SQL - SQL Commands

1. Data Type Handling
2. Create Tables
3. Insert Statement
4. Update Statement
5. Delete Statement
6. Select Statement
Class Notes
Assignment

Session-3: Basic SQL - Table Script & Data Movement

1. Generate Table Script
2. Generate Table & Data Script
3. Copy Data from Existing table to Another Existing Table
4. Create Table at runtime and copy data from Existing Table
5. Objects Handling with special Characters
Class Notes
Assignment

Session-4: Basic SQL - Play with Columns

1. Add a column in Existing Table
2. Drop a column from Existing Table
3. Change Data Type of Column in Existing Table
4. Change Size of Column in Existing Table
5. Rename an Existing column
Class Notes
Assignment

Session-5: Basic SQL - SQL Keywords

1. Distinct, Top
2. Where
3. AND, OR, Between
4. Like
5. IN, Not IN
6. Order By
Class Notes
Assignment

Session-6: Intermediate SQL - Group By

1. What is Group By?
2. Why we need Group By?
3. Why we need Having?
4. Group By + Order By
5. Group By + Having
6. Where + Group By + Having
7. Where + Group By + Having + Order By
Class Notes
Assignment

Session-7: Intermediate SQL - Aggregate Functions

1. Count()
2. Sum()
3. Avg()
4. Min()
5. Max()
6. Aggregate Functions with Group By
Class Notes
Assignment

Session-8: Intermediate SQL - Constraints [Part-1]

1. What is Constraints and why we use Constraints?
2. Not Null
3. Unique Key
4. Primary Key
5. Foreign Key
6. Check
7. Default
8. Surrogate Key
Class Notes
Assignment

Session-9: Intermediate SQL - Constraints [Part-2]

1. Add Not Null Constraint
2. Remove Not Null Constraint
3. Add Unique Key on Single column
4. Add Unique Key for Multiple columns
5. Remove Unique Key
6. Add Primary Key on Single column
7. Add Primary Key on Multiple columns
8. Remove Primary Key
9. Add Foreign Key on Single column
10. Add Foreign Key on Multiple columns
11. Remove Foreign Key
12. Add Default constraint
13. Add Check constraint
14. Add Surrogate Key
Class Notes
Assignment

Session-10: Intermediate SQL - Constraints [Part-3]

1. Primary Key Vs. Foreign Key
2. Primary Key Vs. Surrogate Key
3. Primary Key Vs. Unique Key
4. Primary Key Vs. Candidate Key
5. Primary Key Vs. Composite Key
6. Primary Key Vs. Natural Key
Class Notes
Assignment

Session-11: Intermediate SQL - Date Functions

1. DateAdd()
2. DatePart()
3. DateDiff()
4. GetDate()
5. Practice with date functions on Realtime project
Class Notes
Assignment

Session-12: Intermediate SQL - Null Handling

1. What is NULL in SQL?
2. Checking NULL values
3. NULL in SELECT expressions
4. COALESCE() & ISNULL()
5. NULL in WHERE clause Include NULLs Exclude NULLs
6. NULL with Aggregate functions
7. NULL vs Empty String ('')
Class Notes
Assignment

Session-13: Intermediate SQL - Subquery, Co-related Subquery

1. Subquery (Non-Correlated Subquery) What is Subquery? Scalar Subquery (returns single value) Multiple-row Subquery Subquery in SELECT Subquery in FROM (Derived Table)
2. Correlated Subquery What is Correlated Subquery? Example of Correlated Subquery Difference between Subquery & Correlated Subquery
Class Notes
Assignment

Session-14: Intermediate SQL - String Functions

1. UPPER() / LOWER()
2. LEN() / DATALENGHT()
3. LTRIM() / RTRIM() / TRIM()
4. SUBSTRING()
5. LEFT() / RIGHT()
6. CHARINDEX()
7. CONCAT()
8. REPLACE()
9. REPLICATE()
10. SPACE()
11. STUFF()
12. STUFF()
13. PATINDEX()
14. FORMAT()
15. STRING_SPLIT()
16. QUOTENAME()
Class Notes
Assignment

Session-15: Advanced SQL - Unions

1. What is Union?
2. Why we use Union?
3. Type of Unions
4. All 6 Scenarios of using Unions
5. Difference between Union & Union All
Class Notes
Assignment

Session-16: Advanced SQL - Analytic Functions

1. Why we use Analytic Functions?
2. Lag()
3. Lead()
Class Notes
Assignment

Session-17: Advanced SQL - Case Statement

1. Why we use Case Statement?
2. Where we use Case Statement?
3. Syntax of Case Statement?
4. Simple CASE
5. Searched CASE (Most Used)
6. CASE with Multiple Conditions (AND / OR)
7. CASE with NULL Handling
8. CASE with Date Conditions
9. CASE inside WHERE Clause
10. CASE in ORDER BY
11. CASE with Aggregate Functions
12. CASE with COUNT
13. Nested CASE Statements
14. CASE in UPDATE Statement
15. CASE with DISTINCT Logic
16. CASE inside JOIN condition
Class Notes
Assignment

Session-18: Advanced SQL - JOINS [Part-1]

1. What is Joins & Why we use?
2. Type of Joins: Inner Join Left Join Right Join Full Join Self Join Cross Join
3. Practice with all type of Joins with Two Tables
Class Notes
Assignment

Session-19: Advanced SQL - JOINS [Part-2]

1. Practice on Joins with 3 / 4 Tables
2. Realtime Challenges with Joins
3. Become an expert on Joins
Class Notes
Assignment

Session-20: Advanced SQL - Conversion Functions

1. What are conversion functions and why we use?
2. Cast()
3. Convert()
4. Try_Cast()
5. Try_Convert()
Class Notes
Assignment

Session-21: Advanced SQL - Common Table expression

1. What is common table expression and what kind of problem it solves?
2. Find Unique Records
3. Find Latest Records
4. Find Oldest Records
5. Find Duplicate Records
6. Remove Duplicate
7. Row_Number(), Rank(), Dense_Rank()
Class Notes
Assignment

Session-22: Advanced SQL - Normalization & Denormalization

1. Normalization in SQL
2. Denormalization in SQL
Class Notes
Assignment

Session-23: Advanced SQL - Views

1. What is a View?
2. Why Do We Use Views? Simplify complex queries Improve security (column-level access) Reusability Abstraction layer Reporting & ETL convenience
3. Complex View (JOIN, CASE, Aggregates)
4. Read-Only View
5. Indexed View (Materialized)
6. Partitioned View
7. Partitioned View
8. ALTER & DROP View
9. View vs Table
10. View vs Stored Procedure
Class Notes
Assignment

Session-24: Advanced SQL - Index

1. What is an Index?
2. Type of Index: Clustered Index Non-Clustered Index Unique Index Composite Index Filtered Index Covering Index Columnstore Index Hash Index
3. Index Usage in Real-Time
4. Index vs Scan
5. Clustered vs Non-Clustered
Class Notes
Assignment

Session-25: Advanced SQL - Functions

1. What is a Function?
2. Scalar UDF
3. Inline Table-Valued Function
4. Multi-Statement Table-Valued Function
5. Function vs Stored Procedure
Class Notes
Assignment

Session-26 : Advanced SQL - Stored Procedures

1. What is a Stored Procedure?
2. Why Use Stored Procedures? Faster execution (precompiled) Reusability Security (no direct table access) Reduced network traffic Centralized business logic
3. Basic Stored Procedure
4. Stored Procedure with Input Parameters
5. Stored Procedure with Multiple Parameters
6. Stored Procedure with OUTPUT Parameter
7. Stored Procedure with RETURN Value
8. Stored Procedure with INSERT / UPDATE / DELETE
9. Stored Procedure with TRY…CATCH (Error Handling)
10. Stored Procedure with TRANSACTION
11. Stored Procedure vs Function
12. Stored Procedure vs View
Class Notes
Assignment

Session-27: Advanced SQL - Cursor

1. What is a Cursor in SQL?
2. Cursor Life Cycle
3. Syntax of Cursor
4. Real-Time Example
Class Notes
Assignment

Session-28: Advanced SQL - Error Handling in SQL

1. Why Error Handling?
2. TRY…CATCH (Core Mechanism)
3. Error Handling with TRANSACTION
4. Getting Error Details (Very Important)
5. Error Handling with TRANSACTION
6. Custom Error Logging Table (ETL Standard)
7. Handling Errors in Stored Procedures
Class Notes
Assignment

Session-29: Advanced SQL - Transactions

1. What is a Transaction?
2. Transaction Commands
3. Simple Transaction
4. Transaction with Error Handling
5. SAVEPOINT
6. Nested Transactions
7. IMPLICIT vs EXPLICIT Transactions
8. Transactions in Stored Procedures
Class Notes
Assignment

Session-30: Advanced SQL - Jobs

1. What is Jobs and why we need?
2. Create Job with simple steps
3. Create Job with multiple steps
4. Schedule a Job
Class Notes
Assignment

Session-31: Advanced SQL - Linked Servers

1. What is a Linked Server in SQL Server?
2. Why do we use a Linked Server?
3. Naming Convention
4. How to Create a Linked Server
5. Querying Data from a Linked Server
Class Notes
Assignment