Login

AI-Powered Automation Test Engineer Program

Wishlist Share

Course Content

Module 1: Introduction to SQL
Master SQL fundamentals and relational database concepts. Apply normalization techniques and ER modeling.

Module 2: MySQL Installation & Setup
Install MySQL Community and configure Workbench. Connect to servers and import sample databases.

Module 3: Working with Databases & Tables
Create, alter, truncate, and drop databases/tables. Perform CRUD operations with filtering and sorting.

Module 4: Operators, Constraints & Data Types
Use comparison, logical operators and indexing strategies. Implement constraints and select appropriate data types.

Module 5: Functions in SQL
Apply aggregate, scalar, string, numeric, and date functions. Handle duplicates and use general utility functions.

Module 6: Subqueries, Operators & Derived Tables
Write nested queries and use derived table constructs. Optimize complex query performance.

Module 7: Window Functions
Implement ranking, aggregate, and value window functions. Use LEAD, LAG, NTILE, and FIRST_VALUE effectively.

Module 8: Working with Views
Create, alter, and manage updatable views with check options. Understand view processing algorithms.

Module 9: Stored Procedures & Triggers
Develop reusable procedures and automated triggers. Implement business logic at database level.

Module 10: Performance Optimization
Apply indexing, query optimization, and best practices. Monitor and tune database performance.

Student Ratings & Reviews

No Review Yet
No Review Yet