Archi's Academy

BLACK FRIDAY

85% Discount for all November

whatsapp
Get in touch
FreeBackendintermediate

MySQL

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
YouTube

Curated from YouTube

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

StartFreeCourse

StartFreeCourse
button-icon
MySQL

Course Curriculum

1 modules · 4 subjects · 13 lessons
01
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.

Why Should You Learn This Course?

Build Robust Backend Systems

Learn Java, Spring Boot, and PostgreSQL to design secure, highly scalable, and performant RESTful APIs.

Self-Paced Practical Learning

Focused, bite-sized lessons that let you learn active skills at your own pace.

100% Free & Accessible

Zero cost, zero barriers—just high-value training to upgrade your skillset immediately.

Related Courses

Ready to Start Learning?

Access this course for free and build real skills.

StartFreeCourse

StartFreeCourse
button-icon