SQL Master Class

Course Overview

In this course, you’ll acquire the foundational and advanced skills needed to manage and manipulate relational databases with precision. We have designed the curriculum in such a way that it focuses on teaching you how to write efficient queries, design and optimize database schemas, and perform complex data analysis. You’ll learn to extract valuable insights from large datasets using SQL’s powerful querying capabilities, ensuring you can handle data retrieval, updating, and reporting tasks with confidence. By mastering SQL, you’ll enhance your ability to manage data effectively, and support data-driven decision-making.

Rating :

Reviews :10

Students :118

Available In :English | Hindi

Updated On :January, 2024

Trainer :Sagar Thorat

Fee :

₹ 15,000

Find A Batch

Key Features

Zero to Hero
Learn with fun

Who should join?

Anyone and Everyone: Anyone and Everyone working in non-technical backgrounds seeking to transition into technical roles by acquiring SQL skills to bridge the gap between their current positions and new technical opportunities

Aspirants: Anyone who wants to become Data Engineer, Data Analyst, Power BI Developer, Financial Analyst, Software Developer, Data Scientist, Database Administrator, Back-end Developer, Manager, HR Professional, Consultant, MIS Executive, and more

Experience Professionals: Anyone who deals with large volumes of data and wants to manage and process it effectively to extract valuable insights

Students and Graduates: Students or Graduates who want to add a valuable technical skill to their resume

Pre-requisites

Curious to Learn

Willingness to Practice

Course content

IMPORTANT: Currently we are re-desiging all our courses and latest syllabus will be available as soon as it is ready.

1.Installing & Setting Up SQL Server
- Download SQL Server
- Installing SQL Server
2.Introduction To Data, DBMS & RDBMS
- What is Data
- Types Of Data
- What Is Database
- What Is DBMS?
- What Is RDBMS?
- What is SQL
3.Database Normalization
- What Is Database Normalization
- Importance Of Database Normalization
- Normalization To 3NF
4.Getting Started With SQL Server
- Understanding SQL Server
- Overview Of SQL Server Management Studio
5.Importing Excel And Flat Files
- Import Data From Excel File
- Import Data From Flat File
6.Understanding Data Types In SQL Server
- Choosing Appropriate Data Type
- Key Generating
- Choosing Data Type For Keys
7.Creating Database, Schema And Table In SQL Server
- Creating, Altering And Deleting Database
- Creating, Altering And Deleting Schema
- Creating, Altering And Deleting Table
- Creating Table From Another Table
8.Truncating & Deleting Table Data
- Truncating Table Data
- Deleting Table Data
- Truncate Vs Delete
9.Types Of TSQL Commands
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
10.Working With SQL Queries
- SELECT, INSERT, UPDATE, DELETE
- Using Alias In Query
- WHERE Clause
- Using ORDER BY & GROUP BY Clause
- Limiting Or Sampling Rows
- Extracting Random Records
- Getting Distinct Values
- Working With Logical Function If, Select Case
- Using And & Or Conditions To Restrict Data
- Using Between
- Using In & Not In
- Using Like Operator
- Using Sub Queries
- Combining Query Result Set
- Pivoting & Un-Pivoting
- Apply Operator
- Corelated Query
- INTERSECT & EXCEPT
11.Using SQL In-built Functions
- Numeric Functions
- Character Functions
- Conversion Functions
- Date & Time Functions
- Aggregate Functions
- Ranking Functions
- Over (Partition By) Clause
12.Constraints
- Primary Key Constraints
- Foreign Constraints
- Default Constraints
- Check Constraints
- Unique Constraints
- Procedural Integrity Constraints
- Declarative Integrity Constraints
- Not Null Constraints
- Referential Integrity Constraints
13.Indexes
- Clustered Index
- Non-Clustered Index
- Balanced Trees
- Heaps
- Handling Fragmentation
- Distribution Statistics
- Creating, Altering And Droping Indexes
14.Bulk Insert & Update Query
- Bulk Insert Query
- Bulk Update Query
15.Understanding Joins
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Cross Join
- Self Join
- Equi Join
- Natural Join
- Non-Equi Join
16.Working With Stored Procedures
- Creating Stored Procedures
- Input Parameter
- Output Parameter
- Return Value
- Output Clause In Insert, Update And Delete
- Dynamic Output Parameter
- Parameter As Optional And Default Value
- Retrieving Identity Column Value
17.Working With Stored Functions
- Creating, Altering And Dropping
- Types Of User Defined Functions
- Scalar Functions
- Table Valued Functions
- Inline Table Valued Functions
- Multi Statement Table Valued Functions
- Permissions On User Defined Functions
18.Working With Common Table Expressions
- Creating Temp Tables
- Table Variables
- Creating CTE
- Derived Tables
- Except Operator
19.Creating Triggers
- Purpose Of Triggers
- Creating, Altering And Dropping Triggers
- Magic Tables
- Instead Of Triggers
- DML Triggers
- AFTER Triggers
20.Creating Views
- Creating, Altering And Dropping Views
- Simple and Complex Views
21.Exception Handling
- Detecting Exceptions
- Implementing Exception Handling
- Raising Exceptions Manual
22.Export
- Export data to excel file
- Export data to flat File
23.Working With Cursors
- Types Of Cursors
- Forward_Only And Scroll Cursors
- Static, Dynamic And Keyset Cursors
- Local And Global Cursors
24.SQL Server Backup & Restore
- Full Backup
- Differential Backup
- Restore Database
25.Table Partitioning
- Horizontal Partitioning
- Vertical Partitioning
26.Securing & Managing Database Users
- Login Creation
- SQL Server Authenticated Login
- Windows Authenticated Login
- User Creation
- Granting Permissions
- Revoking Permissions
- Managing Roles
27.Transaction Management
- Begin Transaction
- Commit Transaction
- Rollback Transaction
- Save Transaction
- Role Of Log File In Transaction Management
- Implicit Transactions
28.Advanced Transactioning
- Transactions
- ACID Properties
- ANSI Isolation Levels
- Concurrency issues
- Locking
- Understanding Sql Server Isolation Levels
- Using Locking Hints
- Row Versioning
- Sql Server Row Versioning Infrastructure
- Read Committed Snapshot
- Snapshot Isolation Level
- Development, Administration And Monitoring
- Using Programming Objects
29.TSQL Querying & TSQL Programming
- Drawbacks Of TSQL that leads to TSQL Programming
- Introduction To TSQL Programming
- Control Statements In TSQL Programming
- Conditional Control Statements
- If
- Case
- Looping Control Statements
- While
30.Query Optimization & Performance Tuning
- Partitioning data
- B-Tree Indexes
- Hash Indexes
- Hash Joins
- Merge Joins
- Joins
- Partition By Range
- Partition By List
- Partition By Hash
- Materialized Views
- Creating Materialized Views
- Refreshing Materialized Views
- Collect Statistics About Data In Tables
- Parallel Query Execution