Learn SQL + Database Concepts in 20 Minutes

Опубликовано: 22 Февраль 2025
на канале: Chandoo

99,529

3.7k

First lesson of my FREE Data Analyst Course.

💥Important Links:
================

Get the materials and instructions here - https://chandoo.org/dac
Install MySQL - https://dev.mysql.com/downloads/insta...
Sakila Database information - https://dev.mysql.com/doc/sakila/en/s...
Advanced Excel Course - https://chandoo.org/wp/excel-school-p...
Power BI Course - https://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:    • FREE Data Analyst Course

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

Learn SQL in an hour:    • Learn SQL for Data Analysis in one ho...
SQL basics:    • SQL Basics for people with no prior k...
SQL in an hour - article: https://chandoo.org/wp/learn-sql-for-...

~

#sql #database #chandoo #freedataanalystcourse #fdac