YoVDO

SQL Tutorial - Full Database Course for Beginners

Offered By: freeCodeCamp

Tags

SQL Courses MySQL Courses Relational Databases Courses Schema Design Courses Database Management Courses Nested Queries Courses

Course Description

Overview

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

Related Courses

Managing Big Data with MySQL
Duke University via Coursera
Database Management Essentials
University of Colorado System via Coursera
Business Metrics for Data-Driven Companies
Duke University via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Базы данных (Databases)
Saint Petersburg State University via Coursera