HDTutorial
EN
SQL Tutorial - Full Database Course for Beginners

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SQL Tutorial - Full Database Course for Beginners

21,073,067 views October 26, 2018 4:20:39

Watch on YouTube
ChannelfreeCodeCamp.org

In brief

This course teaches absolute beginners how to manage databases using SQL and MySQL, covering everything from installation and basic queries to advanced topics like joins, triggers, and schema design. You’ll build a practical company database while learning core concepts like keys, constraints, and ER diagrams—ideal for those starting from zero.

Questions & answers

Do I need prior programming experience?

No, this course is designed for complete beginners.

Will I work with real-world examples?

Yes, you’ll build a company database throughout the course.

Chapters

Description from the creator

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.

The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

You can get PopSQL to follow along here: popsql.com/freecodecamp

🔗Company Database Code: giraffeacademy.com/databases/sql/creating-compa…

❤️ Try interactive Databases courses we love, right in your browser: scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba)

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas

Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw

🔗The Giraffe Academy website: giraffeacademy.com/

--

Learn to code for free and get a developer job: freecodecamp.org

Read hundreds of articles on programming: medium.freecodecamp.org

About this tutorial

freeCodeCamp.org published this 4:20:39 video tutorial on October 26, 2018. It has been watched 21,073,067 times on YouTube.

Category
Education
Duration
4:20:39
Published
October 26, 2018
Views
21,073,067
Likes
383,870

Tags

Share

This tutorial in other languages