Only Few Seats Left

Module

1

Introduction to Databases

·        Understanding the fundamentals of databases and their significance.

·        Introduction to DBMS and their role in data organization.

·        Exploring various types of DBMS architectures.

Module

2

SQL Fundamentals

·        Understanding the ACID properties and their importance in database transactions.

·        Installation and setup of MySQL.

·        Introduction to SQL and its subsets: DDL, DML, DQL, DCL, TCL.

·        Creating, dropping, and managing databases.

·        Understanding basic data types and table structures.

·        Implementing primary keys, auto-increment, and constraints.

Module

3

Data Manipulation with SQL

·        Comprehensive coverage of CRUD operations: Create, Read, Update, Delete.

·        Mastering SELECT statements with various clauses: WHERE, GROUP BY, HAVING, ORDER BY, LIMIT.

·        Utilizing string functions for data manipulation and transformation.

Module

4

Advanced SQL Techniques

·        Exploring subqueries and joins: INNER, OUTER, LEFT, RIGHT, CROSS.

·        Implementing foreign keys and managing relationships between tables.

·        Performing data analysis using aggregation functions: SUM, AVG, COUNT, MIN, MAX.

·        Utilizing ranking functions like RANK, DENSE RANK, ROW_NUMBER for result ranking.

Module

5

Data Optimization

·        Exploring advanced SQL features like UNIQUE constraints, adding/dropping columns, and column modifications.

·        Understanding complex query operations using comparison & logical operators, and CASE statements.

·        Optimization techniques for improving query performance and database efficiency.

·        Utilizing advanced features like UPDATEABLE views and WITH ROLLUP for enhanced data management.