SQL For Beginners In 4 Hours (Complete Course) | Easiest Way To Learn SQL | Briteflux
HTML-код
- Опубликовано: 11 сен 2024
- SQL For Beginners In 4 Hours (Complete Course) | Easiest Way To Learn SQL | Briteflux
Content Of The Video
00:00 - Introduction To SQL
05:25 - How To Register A Free Google Big Query Account
11:34 - Big Query Environment
15:26 - Adding Public Dataset
18:53 - London Crime Dataset
22:33 - Select Statement (Excel)
25:56 - Select Statement Part 1
32:10 - Select Statement Part 2
34:56 - Select Statement Part 3
43:37 - Select Statement Part 4
47:07 - Limit Statement
48:59 - Where Statement (Excel)
54:41 - Where Statement Part 1
1:00:43 - AND & OR Statement
1:10:49 - Where Statement 2
1:18:20 - NULL OR NOT NULL Statement
1:22:52 - IN & NOT IN Statement
1:31:28 - Where Statement Summary
1:39:33 - Union Statement
1:53:35 - Big Query Tips
2:04:21 - SQL Tips
2:15:07 - Order By (Excel)
2:16:42 - Order By Statement
2:30:21 - Group By (Excel)
2:32:32 - Group By Statement
2:44:02 - Count
2:51:04 - Count Distinct
2:55:10 - MAX & MINI
3:02:42 - Joins (Pictures)
3:13:30 - Introduction To Joins
3:22:45 - Joins (Excel)
3:29:27 - Inner Join
3:37:31 - Right Join
3:45:03 - Full Outer Join
3:52:40 - Outer
You can sign up for bigquery here: bit.ly/3yUHiis
You can watch the breakdown of this tutorial in parts using this link:
• How To Register A Free...
Where to find the Top 5 SQL books for beginners? Here are some links • TOP 5 SQL BOOKS FOR BE...
- Sams Teach Yourself SQL in 10 Minutes: amzn.to/3g9cTG0
- Learning SQL: amzn.to/3sm2H1L
- SQL: The Ultimate Beginners Guide To Learning SQL Programming with Hands-On Projects:
amzn.to/2VSBZC9
- SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL: amzn.to/3m86qyG
- Head First SQL: Your Brain on SQL - A Learner's Guide: amzn.to/3xRDxJp
This SQL Tutorial For Beginners Course is specially designed to help the student easily master SQL with the following:
1) SQL concepts were taught using the Bigquery environment. Google Bigquery was specifically chosen due to the ease of installation & the availability of multiple real-life datasets. As the popular saying goes that "Learning by doing is the best way to learn."
2) SQL concepts were first carried out in Excel. This concept was followed to help users with excel knowledge easily relate their excel knowledge to easily learn the SQL statements.
Briteflux is focused on helping students master the most important mathematical and data concepts. We offer very personalized short classes that demonstrate various methodologies to help students simplify the complexity of arithmetic and data science. In math, we go from the basic foundational math to complex further math topics. For more interesting maths and data science topics, Kindly subscribe to our channel. We are committed to providing you the best content.