Learn SQL + Database Concepts in 20 Minutes
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
Watch video Learn SQL + Database Concepts in 20 Minutes online without registration, duration hours minute second in high quality. This video was added by user Chandoo 30 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 99,529 once and liked it 3.7 thousand people.