Learn SQL + Database Concepts in 20 Minutes @chandoo_
Learn SQL + Database Concepts in 20 Minutes  @chandoo_
Uploaded July 2024 | Updated November 2026, 3 hours ago
First lesson of my FREE Data Analyst Course.

๐Ÿ’ฅImportant Links:
================

Get the materials and instructions here - chandoo.org/dac
Install MySQL - dev.mysql.com/downloads/installer
Sakila Database information - dev.mysql.com/doc/sakila/en/sakila-structure.html
Advanced Excel Course - chandoo.org/wp/excel-school-program
Power BI Course - chandoo.org/wp/power-bi-course


๐Ÿค”What you will learn:
==================
What is a database?
What is SQL
How to install MySQL on your computer
How to write SQL queries
Using the sample database - Sakila


โฑ๏ธtopics in this video:
==================
0:00 - What you are going to learn in this video?
0:17 - What is a database?
1:55 - What is SQL?
3:26 - Key Database Terminology and how databases look
6:42 - Types of database software
8:21 - How to install MySQL and sample datasets (Sakila) on your computer?
10:15 - Using MySQL workbench
12:30 - Understanding the Sakila Sample Database
14:28 - Writing your first SQL queries
17:40 - Using column names, where clause in SQL
19:30 - Using ORDER BY clause
20:30 - Solving a work problem with SQL (all rentals in the last week)
24:03 - What is coming up in the lesson #2

๐Ÿ“บ Watch next:
=============
Lesson 2 - Advanced SQL Concepts + 10 queries: Coming on 6-August
Free Data Analyst Course Playlist: youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO

More on SQL:
===========

Learn SQL in an hour: youtu.be/l8DCPaHc5TQ
SQL basics: youtu.be/yfWcZ6eot4g
SQL in an hour - article: chandoo.org/wp/learn-sql-for-data-analysis

~

#sql #database #chandoo #freedataanalystcourse #fdac
Learn SQL + Database Concepts in 20 Minutes35 Must have Excel ShortcutsExcel Data Cleaning Trick๐Ÿ’กfor uneven rows of data #EXCELPower Query MAGIC! โšกAuto-Categorize Text Like a PRO!Stop Dragging in Excel, there is a BETTER way!UNPIVOT: Data Cleaning Power Tricks ๐Ÿ’กPowerful trick to get data from any folder in Excel (works even after renaming!)Excel formula to get CLOSEST Matching ValueIntroducing Free Data Analyst Course - SQL / Excel / Power BI / Python3 Things I do in my new Job to Succeed as a Data Analyst3 Powerful Data Slides for your NEXT Presentation (Free PPT File)Excel PROs use these hidden features to work faster ๐Ÿš€
Chandoo |

Learn SQL + Database Concepts in 20 Minutes

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER