FreeBackendintermediate

MySQL

Name: MySQL
Availability: InStock

Are you curious how websites store data or how your favorite apps remember everything? Dive into MySQL—the brain behind the scenes. This course turns mystery into mastery

4 weeksEN13 lessons439 enrolled

Curated from YouTube

This course was hand-picked from YouTube by our experts and organized into a structured, step-by-step curriculum.

StartFreeCourse

Course Curriculum

1 modules · 4 subjects · 13 lessons

MySQL TutorialMystery into mastery

4 subjects

MySQL Fundamentals & SetupNew Description

2 lessons

Getting Started with MySQLThis module introduces MySQL, covers installation process, and basic database operations.
Table Creation and Data TypesThis module covers table creation, understanding MySQL data types, and basic table management.

Data Manipulation and Basic OperationsNew Description

3 lessons

Data Modification and Transaction ControlThis module covers updating, deleting data, and understanding transaction control in MySQL.
Data Constraints and ValidationThis module focuses on implementing data integrity through various MySQL constraints.
Advanced Database Structure and RelationshipsThis module covers primary keys, auto-increment functionality, their importance in database design and relationships between tables using foreign keys.

Querying, Functions, Operations & ViewsNew Description

4 lessons

Functions and OperatorsThis module covers MySQL built-in functions and logical operators for advanced data manipulation.
Pattern Matching and SortingThis module covers pattern matching techniques, data sorting, and result limitation.
Set Operations and Self JoinsThis module covers combining result sets and working with hierarchical data structures.
Views and Database AbstractionThis module focuses on creating virtual tables through views for data abstraction and security.

Performance, Power & PrecisionNew Description

4 lessons

Indexing and Query OptimizationThis module covers database performance optimization through proper indexing strategies.
Subqueries, Grouping and Aggregate FunctionsThis module covers nested queries, data grouping and statistical functions for reporting and analysis.
Referential Integrity and Cascading OperationsThis module covers advanced foreign key behaviors and data integrity management
Stored Procedures and Database AutomationThis module covers advanced database programming with stored procedures and triggers.

Skill Track

Backend

Build robust, secure, and highly scalable server-side systems and databases. Master Java, Spring Boot, PostgreSQL, and event-driven communication using Kafka.