Learn the basics of SQL in just 15 minutes with this tutorial.
Take our SQL for Business Analysts course: https://www.careerprinciples.com/courses/sql-for-business-analytics

Download the database for this video: https://careerprinciples.myflodesk.com/wandnfcrg2
Download MySQL: http://dev.mysql.com/downloads/installer

In this tutorial, you will learn how to use SQL with mySQL. First, you will learn what SQL is and the different relational database management systems that exist. Second, you will learn how to install mySQL on your computer. Third, you will learn how to import a real database so you can practice.
Then we start writing queries. First we will write simple SELECT statements, then SELECT with DISTINCT and finally aggregate functions like COUNT or AVG. Then we will move on to filtering using the WHERE statement. After that we will learn GROUP BY, ORDER BY and even adding a LIMIT. Finally you will learn how to export your query scripts and result tables and import them into Excel or Power BI.

LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The complete finance and valuation course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel course for business and finance: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses

SOCIAL MEDIA:
Instagram – https://www.instagram.com/careerprinciples/?hlen
TikTok – https://www.tiktok.com/@career_principles
‍ LinkedIn – https://www.linkedin.com/company/careerprinciples/

Chapter:
0:00 – SQL Introduction
0:58 – Installing MySQL
2:40 – Importing a real database
4:04 – SELECT statement
5:30 – CLEAR
6:00 – Aggregate functions
8:40 – Filtering with WHERE
10:55 – Combing through SELECT, COUNT and WHERE
11:45 – GROUP BY, ORDER BY and LIIMIT
15:10 – Export data

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.