Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

SQL Tutorial - Full Database Course for Beginners

via freeCodeCamp

Start learning Write review
Coursera Ad

Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off

Learn More → Scrimba Ad

Our career paths help you become job ready faster

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.

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

Reviews

5.0 rating, based on 4 Class Central reviews

Start your review of SQL Tutorial - Full Database Course for Beginners

  • Profile image for Aizen Lois
    Aizen Lois
    This course is awesome and very understandable! I gained a lot of knowledge that I know I can use in my journey as an aspiring Software Engineer. This course guide is what I actually looking for. The knowledge I gained from this course will be the strong foundation of my skills in backend programming. With this, I will be confident enough to apply to my desired companies as an intern for my internship requirements.

    The details are well taught by the instructor and the videos are clear and in good quality. Bravo!
  • Usha Devi
    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.
  • Haarish Irshad Khan
    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.
  • Profile image for Mohamed
    Mohamed
    SO 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
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.