Master SQL – an essential skill for AI, machine learning, data analysis, and more! 📚 This beginner-friendly course teaches you SQL from scratch.

🚀 Want a complete SQL deep dive?
- Check out my full course: https://mosh.link/sql-course
- Subscribe for more awesome content: https://goo.gl/6PYaGF

✋ Want more? Follow me on:
- Twitter: https://twitter.com/moshhamedani
- Facebook: https://www.facebook.com/programmingwithmosh/
- Instagram: https://www.instagram.com/codewithmosh.official/
- LinkedIn: https://www.linkedin.com/school/codewithmosh/

📕 Get the FREE goodies:
- SQL cheat sheet: https://mosh.link/sql-cheatsheet
- Scripts to create databases: https://bit.ly/3rvtqdO

📖 TABLE OF CONTENT
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

💡 Why Learn SQL?
- It's the standard language for working with databases.
- In-demand skill for developers, data scientists, and more.
- MySQL is popular, open-source, and easy to learn.

👉 This tutorial is perfect for you if:
- You're completely new to SQL.
- You want a practical, hands-on approach.
- You work (or want to work) with data.

#programming #coding

In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort.

SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.

👋 Additional resources
- Download & install Microsoft SQL Server: https://www.microsoft.com/en-u....s/sql-server/sql-ser
- Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
- Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ....-whNsNYa3M9O0USq1WhQ
- Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ....-whNsGOcpx-aZS1RN2yA
- SQL Functions: https://docs.microsoft.com/en-....us/sql/t-sql/functio

⌚ Timestamps
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer
44:09 Wrap up

📃 Watch related playlists
- Playlist with all my videos on SQL: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLJxr

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #sql

Tableau Basics Full Course Tutorial (6+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/5fdyc9n2

Who it's for: Data Analysts, Business Intelligence pros, and anyone who works with Big Data on a regular basis.

What it is: Tableau is a popular tool for analyzing and visualizing data, with powerful tools like interactive dashboards, custom reports, and more.

What you'll learn: In this 4-part series, we start with the basics, giving you an overview of Tableau and showing you how to create your first visualizations and dashboards. Then, we jump into working with data, with row-level, aggregate, and table calculations. Next, we refine our visualizations and dashboards to make them look great and tell effective stories. We take some time to go over trends, distributions, and forecasting, and then end with sharing data stories and some advanced Tableau tips and tricks.

Start 0:00
Tableau Fundamentals 0:09
Working with Data in Tableau 35:05
Moving from Simple to Advanced Visualizations 1:28:21
Row-Level and Aggregate Calculations 1:57:38
Table Calculations 2:47:45
Visualization Formatting 3:24:04
Telling Data Stories with Dashboards 3:46:57
Adding Value to Analysis 4:36:24
Making Data Work for You 5:11:38
Advanced Techniques, Tips, and Tricks 5:31:06
Sharing Your Data Story 6:23:07
Conclusion 6:38:18

#tableau #tableaututorial #tableauclasses
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Power BI Basics Beginner Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Data Web Link: https://www.fdic.gov/bank-fail....ures/failed-bank-lis

Exercise Files: https://tinyurl.com/3d7h6ju4

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In the Power BI Basics Beginner course, you will learn foundational skills for using Power BI, a powerful business intelligence tool. The course introduces you to the Power BI Desktop app, walking through its interface and how it shares similarities with other Microsoft 365 products like Excel. You'll discover how to import data from various sources, shape and transform it using Power Query, and create stunning visuals and reports. By the end of the course, you'll know how to build reports with interactive visualizations, create and edit query steps, combine data from different tables, and establish relationships between them, setting you up for more advanced Power BI skills.

Start 0:00
Introduction 0:09
Navigating the PowerBi Interface 4:10
Importing From Data Sources 15:22
Shape tranform combine w power query 22:51
DAX for Creating Tables 35:05
Producing a Report PT 1 Page Setup 43:28
Producing a Report PT 2 Working w Visuals 51:01
Producing Reports PT 3 Working w Slicers 56:55
Conclusion 1:05:28

#powerbi learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

Power BI Full Course Tutorial (8+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/y9f8rue6

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

Start 0:00
Introduction 0:03
Introduction to Data Analytics and Power BI 5:16
Data Shaping 1:35:53
Enhancing Data Structure 1:49:49
Designing Data Model 2:02:01
DAX 2:38:38
Optimizing Model Performance 3:33:18
Reports and Accessibility 4:01:14
Dashboards 5:15:49
Paginated Reports 6:20:21
Performing Advanced Analytics 6:54:54
Managing Workspaces 7:44:48
Managing Datasets 8:03:06
Conclusion 8:18:20

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

#powerbi #powerbitutorial
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.