Course Includes:
- Price: ₹ 14,999
- Instrutor: Srikanth K
- Days: Monday - Friday
- Duration: 45 Hours
- Enrolled: 65 students
- Articles: 1 Article
- Language: English
- Certificate: Yes
MySQL Database & SQL Mastery
- Learn the foundations of databases and SQL using MySQL — from setup to advanced querying.
- Master data manipulation, joins, subqueries, and aggregation for efficient data analysis.
- Build expertise in stored procedures, triggers, transactions, and indexing for optimized database performance.
- Understand user management, roles, and security to safeguard data and control access.
- Explore advanced MySQL features — CTEs, window functions, JSON handling, and replication.
- Integrate MySQL with Python, Java, and BI tools (Power BI, Tableau) for real-world analytics and application development.
Course Curriculum
Module 1. Introduction to Databases & MySQL
- What is a Database?
- RDBMS vs DBMS
- Features & Advantages of MySQL
- Installing MySQL (Workbench, CLI)
- Database Clients & Tools
Module 2. SQL Basics
- Database creation & deletion
- Creating & dropping tables
- SQL data types
- Primary key, foreign key, unique, NOT NULL
- Default values & AUTO_INCREMENT
Module 3. Data Manipulation Language (DML)
- INSERT INTO (single & multiple rows)
- UPDATE with conditions
- DELETE with conditions
- SELECT basics
Module 4. Operators & Expressions
- Arithmetic, comparison & logical operators
- BETWEEN, IN, LIKE, IS NULL
- String functions
- Numeric functions
- Date & time functions
Module 5. Querying Data
- ORDER BY
- LIMIT & OFFSET
- Filtering with WHERE
- Aliases
Module 6. Aggregate Functions & Grouping
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY
- HAVING vs WHERE
- ROLLUP & CUBE
Module 7. Joins in MySQL
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN (using UNION)
- CROSS JOIN
- Self joins
Module 8. Subqueries & Nested Queries
- Scalar subqueries
- Row subqueries
- Table subqueries
- Correlated subqueries
- EXISTS & NOT EXISTS
Module 9. Constraints & Indexing
- Constraints
- Indexes (single & multi-column)
- Clustered vs non-clustered
- Index performance considerations
Module 10. Views
- Creating & managing views
- Updatable views
- Security using views
Module 11. Stored Procedures & Functions
- Stored procedures
- Input & output parameters
- Stored functions
- Control flow statements
- Error handling
Module 12. Triggers & Events
- Triggers (BEFORE & AFTER)
- Row-level & statement-level triggers
- Event scheduler
Module 13. Transactions & Concurrency
- ACID properties
- Transaction control
- Concurrency issues
- Isolation levels
Module 14. User Management & Security
- User creation
- Grant & revoke privileges
- Role-based access control
- Password policies & encryption
- Securing MySQL connections
Module 15. MySQL Performance Optimization
- EXPLAIN & execution plans
- Optimizing joins & subqueries
- Index optimization
- Caching & buffering
- Table partitioning
Module 16. Backup, Restore & Replication
- Logical & physical backups
- Restoring databases
- Replication strategies
- High availability concepts
Module 17. Advanced MySQL Features
- JSON data handling
- Common Table Expressions (CTEs)
- Window functions
- Dynamic SQL
- Temporary & derived tables
Module 18. Integration with Applications
- MySQL with Python
- MySQL with Java (JDBC)
- MySQL with Flask/Django
Module 19. MySQL in Data Engineering & Analytics
- Data import & export
- ETL using MySQL
- BI tools integration
- Data warehousing concepts
Course Rating
5.00 average rating based on 7 rating
Haley Bennet
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Simon Baker
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Richard Gere
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.