Structured Query Language

Categories Database Management

4.33(3 Ratings)

Course Duration: 25h

About Course

The Structured Query Language (SQL) Training course provides participants with a comprehensive understanding of SQL, the programming language used to communicate with relational databases. Participants will learn essential SQL concepts, such as database querying, data manipulation, and database management. The course covers both basic and advanced SQL topics, enabling participants to write complex queries, perform data analysis, and manage database operations efficiently.

Understand the fundamental concepts of SQL and its role in database management systems.
Learn how to create and modify database tables using Data Definition Language (DDL) statements.
Perform data manipulation operations, such as inserting, updating, and deleting records, using Data Manipulation Language (DML) statements.
Explore advanced SQL queries, including joins, grouping, and aggregation functions.
Master techniques for data analysis and reporting using SQL.
Gain practical experience in writing complex SQL queries to retrieve and manipulate data from relational databases.
Understand the importance of data integrity and constraints in database design and management.

Course Curriculum

Basic Concepts
Introduction to SQL Data Definition Language (DDL), Data Manipulation Language (DML), Transaction Control Language (TCL), Data Control Language (DCL) Table modification Constraints Select and Distinct Statements Order by Merge Update and Delete Limit – Min & Max Nth highest salary or Lower salary Count, Average, Sum Like and Wild Card Alias Joins Group By Having

Basic Concepts

Advanced Topic
Subqueries: Correlated Subqueries Nested Subqueries Scalar Subqueries Subqueries in SELECT, FROM, WHERE, HAVING clauses Set Operators: UNION INTERSECT EXCEPT Window Functions: ROW_NUMBER() RANK() DENSE_RANK() NTILE() LEAD() and LAG() FIRST_VALUE() and LAST_VALUE() Common Table Expressions (CTEs): Recursive CTEs Non-Recursive CTEs Using CTEs for recursive queries and hierarchical data Advanced Joins: LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN CROSS JOIN Self Joins Joining Multiple Tables Indexing and Performance Optimization: Creating and managing indexes Query optimization techniques Analyzing query execution plans Transactions and Concurrency Control: ACID properties (Atomicity, Consistency, Isolation, Durability) Transaction isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE) Locking mechanisms (Explicit and Implicit Locks) Stored Procedures and Functions: Creating and executing stored procedures Input and output parameters Error handling in stored procedures User-defined functions (Scalar, Table-Valued) Triggers: Creating and managing triggers Trigger types (BEFORE, AFTER, INSTEAD OF) Trigger events (INSERT, UPDATE, DELETE) Views and Materialized Views: Creating and managing views Indexed views Materialized views and their advantages Advanced Data Types and Manipulation: XML and JSON data types ARRAY data type (if supported by the database) Handling hierarchical and semi-structured data Security and Authentication: User and role management Granting and revoking privileges Row-level security and column-level security