Advanced SQL - India
- Offered byThe knowledge academy
Advanced SQL - India at The knowledge academy Overview
Duration | 2 days |
Start from | Start Now |
Total fee | ₹35,995 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Admission Process
Advanced SQL - India at The knowledge academy Highlights
- Earn a certificate after completion of the course
Advanced SQL - India at The knowledge academy Course details
Senior Data Analysts
Database Administrators
SQL Developers
Data Engineers
Software Engineers
Database Architects
IT Professionals Specializing in Databases
To explore Advanced SQL concepts such as window functions, recursive queries, and Common Table Expressions (CTEs)
To learn techniques for optimizing SQL queries for improved performance and scalability
To understand how to work with complex data types and structures within SQL databases
To master the art of database administration, including indexing strategies and query optimization techniques
To learn to write stored procedures, triggers, and functions for automating database tasks
This Advanced SQL Course delves into complex database querying, optimization techniques, and advanced data manipulation
Participants will gain proficiency in handling large datasets efficiently, improving database performance, and mastering Advanced SQL functionalities for comprehensive data management
It demonstrates proficiency in complex SQL queries and strengthens job candidacy in data-driven industries
Advanced SQL - India at The knowledge academy Curriculum
Module 1: Creating Tables
Creating Tables in SQL
Inserting Data
Inserting Multiple Rows
View Table
Module 2: Stored Procedure Basics
Pros and Cons of Stored Procedures
Creating Stored Procedures
Two Ways to Execute
System Stored Procedures
Module 3: Variables
Declaring Variables
SET Versus SELECT
Global Variables
Tricks with Variables
Module 4: Parameters and Return Values
Passing Parameters
Default Values and WHERE Clauses
Output Parameters
Using RETURN
Module 5: Scalar Functions
Introduction to Scalar Functions
Various Scalar Functions
Advantages of Scalar Functions
Module 6: Testing Conditions
IF/ELSE Conditions
Using CASE Where Possible
Module 7: Looping
While Loop
Breaking Out of a Loop
Basic Transactions
Using DELETE and UPDATE
Sys.Objects
Module 8: Temporary Tables and Table Variables
Using Temporary Tables
Creating Table Variables
Pros and Cons of Each Approach
Module 9: Table Valued Functions
In-line Table-Valued Functions
Multi-Statement Table-Valued Functions
Limitations of User-Defined Functions
Module 10: Derived Tables and CTEs
Using Derived Tables
Common Table Expressions (CTEs)
Recursive CTEs
Module 11: Subqueries
Subquery
Using ALL, ANY and IN
Correlated Subqueries
Using EXISTS
Module 12: Cursors
What is Cursor?
Life Cycle of Cursor
Types of Cursors
Syntax of Fetching Rows
Module 13: Error-Handling
Using TRY/CATCH
System Error Functions
Custom Error Messages
Obsolete @Error Function
SQL Server Debugger
Advanced SQL - India at The knowledge academy Admission Process
Important Dates
Other courses offered by The knowledge academy
Student Forum
Anything you would want to ask experts?