SQL Course Syllabus

Home
Courses

SQL Training in Hyderabad

Curriculum

Week 1: Introduction to Databases and SQL
- - Overview of databases and SQL.
- - History and evolution of SQL.
- - Types of database management systems (DBMS)
- - Relational database concepts
- - Installing and setting up a database environment (e.g., MySQL, PostgreSQL , Oracle)

Week 2: Basic SQL Queries Data Types Types Of Languages:
- - Data Definition Language (DDL)
- - Data Manipulation Language (DML)
- - Data Control Language (DCL)
- - Transaction Control Language
- - Constraints in SQL
- - Types of Keys in SQL

Week 3: Normalization and Data Integrity
- - Introduction to Normalization
- - First Normal Form (1NF)
- - Second Normal Form (2NF)
- Third Normal Form (3NF)
- - Boyce-Codd Normal Form (BCNF)
- - Ensuring Data Integrity through Constraints

Week 4: Intermediate SQL Queries

SQL Constraints:

- Operators in SQL
- Sorting data using ORDER BY
- Using LIMIT to restrict the number of results
- Built-in SQL functions
- Math Functions
- Aggregate Functions
- Datetime Functions
- User Defined Functions

Week 5: Aggregation, Grouping, and Filtering

- Aggregating data with GROUP BY
- Filtering grouped data with HAVING
- Advanced filtering techniques
- Working with complex queries

Week 6: Advanced SQL Queries Joins:

- Inner Join
- Left (Outer) Join
- Right (Outer) Join
- Full (Outer) Join
- Self Join

- Subqueries:

- Scalar subqueries
- Correlated subqueries

Week 7: Indexing and Optimization

- Importance of indexing
- Types of indexes
- Using EXPLAIN to analyze query performance
- Views and Stored Procedures
- Creating and using views
- Advantages and limitations of views
- Introduction to stored procedures
- Writing and executing stored procedures
- Using parameters in stored procedures
- Triggers
- Creating and using triggers
- BEFORE and AFTER triggers
- INSTEAD OF triggers
- Practical use cases for functions and triggers