Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Learn SQL + Database Concepts in 20 Minutes
Play lesson

SQL Concepts - Learn SQL + Database Concepts in 20 Minutes

Master SQL Essentials: From Beginner to Pro in Data Analysis and Beyond!

4.0 (0)
12 learners

What you'll learn

Understand the basics of SQL and its application in data analysis
Utilize SQL with tools like Power BI for comprehensive data reporting
Master different types of SQL joins to manipulate and analyze data effectively
Learn how to create and manage a database using MS Access

This course includes

  • 6.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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/installer/ Sakila Database information - https://dev.mysql.com/doc/sakila/en/sakila-structure.html Advanced Excel Course - https://chandoo.org/wp/excel-school-program/ 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: https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO More on SQL: =========== Learn SQL in an hour: https://youtu.be/l8DCPaHc5TQ SQL basics: https://youtu.be/yfWcZ6eot4g SQL in an hour - article: https://chandoo.org/wp/learn-sql-for-data-analysis/ ~ #sql #database #chandoo #freedataanalystcourse #fdac

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere