Embark on a comprehensive database management and SQL journey with this full course designed for beginners. Learn the fundamentals of database management using MySQL RDBMS, covering essential topics such as schema design, basic C.R.U.D operations, aggregation, nested queries, joins, and keys. Begin with an introduction to databases, explore table structures and key concepts, and progress through SQL basics. Follow along with step-by-step MySQL installation guides for both Windows and Mac. Dive into practical exercises, creating tables, inserting data, and implementing constraints. Master update and delete operations, execute basic queries, and work with a company database. Explore advanced topics including functions, wildcards, unions, joins, nested queries, triggers, and on-delete cascades. Conclude by learning about ER diagrams, designing them, and converting them to schemas. Gain hands-on experience using PopSQL and access additional resources to further enhance your database management skills.
Overview
Syllabus
) Introduction.
) What is a Database?.
) Tables & Keys.
) SQL Basics.
) MySQL Windows Installation.
) MySQL Mac Installation.
) Creating Tables.
) Inserting Data.
) Constraints .
) Update & Delete.
) Basic Queries.
) Company Database Intro.
) Creating Company Database.
) More Basic Queries.
) Functions.
) Wildcards.
) Union.
) Joins.
) Nested Queries.
) On Delete.
) Triggers.
) ER Diagrams Intro.
) Designing an ER Diagram.
) Converting ER Diagrams to Schemas.
Taught by
freeCodeCamp.org
Related Courses
Related articles
Reviews
5.0 rating, based on 3 Class Central reviews
-
He has explained really nicely and i have learned alot from this course about SQL . Its will be very helpful. Looking forward to learn more courses from this platform.
-
MohamedSO GOOD AND SIMPLE AND very helpful for me i hop this guys make so many courses like this thanks to him i can build data abse from zero to one -
this course proovides me a wonderful knowledge of the sql and it has boost my confidence. I think you should make more videos like this.
