There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
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!
star
star
star
star
star
5.0 (3465 ratings)
Language : English
Validity Period : Lifetime
₹18,000 47% OFF
Language : English
Validity Period : Lifetime
₹18,000 47% OFF
₹10,000/- Excluding 18% GST
▶Description:
Master SQL Queries from Basic to AdvancedYou 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
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 AnalystsLearn how to analyze business data, create insightful reports, and make data-driven decisions using SQL queries. SQL Query Optimization & Stored ProceduresMaster 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
|
| 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)
|
2. 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:
|
| 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?
|
| 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:
|
| 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?
|
| 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-21: 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: Intermediate SQL - Constraints [Part-1]
| 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 |
▶Session-32: Advanced SQL - SQL Query Optimization Techniques
| 1. What is SQL Query Optimization Technique |
| 2. Why we need Query Optimization Technique |
| 3. Optimize SQL Query |
| Class Notes |
| Assignment |
With 18 years of experience in the IT industry, our team of experts has established itself as a trusted authority in trending technologies.
Important Links
Packages - Live Sessions
Copyright © 2025