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
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










