Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The SQL Freedom Course
Welcome, Setups, Tours and More..
Introduction
Welcome and What We Will Be Covering [What This Course is All About!]
The Course Story:
Download And Install FlySpeed Query Tool
The DBMS Used In This Course
sample_shop [sqlite database]
A Quick Tour of Flyspeed Query Tools Interface (3:09)
How To Connect To A Database (2:33)
Understanding the Sample Tables:
The Vendors Table
The Products Table
The Customers Table
The Orders Table
Order Items Table
Intro To Visual Query Building
Getting Your feet Wet !
How To Build A Simple SQL Query - Visually (6:10)
How To Select Multiple Columns From A Single Table (3:10)
How To Remove All Duplicates From Your Data (1:28)
Understanding Sorting
Understanding Multi Column Sort
How To sort Data in a Table in Ascending and Descending Order (2:39)
How To Add Limits And Offset To Your Output (1:47)
The Data Filter Toolbar
Understanding the Data Filter Toolbar
Filtering Rows - [Visually] - 01 (2:47)
Filtering Rows - [Visually] - 01 - integrating the filter (2:43)
Filtering Rows - [Visually] - 02 (3:17)
Filtering Rows - [Visually] - 03 (2:30)
Filtering Rows - [Visually] - 04 (1:15)
Filtering Rows - [Visually] - 05 (3:07)
The Mechanism Of An Inner Join.
What's an inner-join? And why do we need them so badly when working inside a database?
how do we join tables - which all belong together, anyway?
Lets Inner-join 2 tables -Manually!
inner-join-bonus-course sample database
A Quick Video To Show You The Same Process Inside Flyspeed (0:49)
Creating Inner-Joins Visually!
All about Inner-Joins
Creating An Inner Join Visually Using Flyspeed Query Tool - 01 (2:47)
Creating An Inner Join Visually Using Flyspeed Query Tool - 02 (2:35)
Creating An Inner Join Visually Using Flyspeed Query Tool - 03 (4:32)
Understanding Aggregate Functions -[Summarizing Your Data]
Summaries Rock!
What Are Aggregate Functions?
A Closer Look At How Aggregate Functions Work
Creating Aggregate Functions - Visually- 01 (0:34)
Creating Aggregate Functions - Visually- 02 (1:12)
Aggregate Functions - Challenge- 01 (1:02)
Challenge - 01 [Solution-code]
Aggregate Functions - Challenge - 02 (0:19)
Challenge - 02 [Solution Code]
Aggregate Functions - Challenge- 03 (0:23)
Challenge - 03 [Solution Code]
Aggregate Functions - Challenge - 04 (0:50)
Challenge - 04 [Solution Code]
Grouping Data
Man! This is the chapter you should be proud conquering!
The Mechanism Of Grouping - A Deep Dive Into What’s Happening Under The Hood
Working With Grouping - Visually- 01 (1:50)
Working With Grouping - Visually- 02 (1:39)
Working With Grouping - Challenge- 01 (0:48)
Challenge - 01 [Solution Code]
Working With Grouping - Challenge- 02 (1:36)
Challenge - 02 [Solution Code]
Working With Grouping - Challenge- 03 (0:41)
Challenge - 03 [Solution Code]
The date Filter
The date filter
Preparing To Use Date Filters
Working With Date-Filters - 01 (2:19)
Working With Date-Filters -02 (1:54)
Date Filter - Challenge- 01 (0:55)
Challenge - 01 [Solution-code]
Some Bonus Flyspeed Tips!
How To Execute the Same SQL Query On Different Databases Instantly! (2:12)
How To Customize Flyspeed's Interface To Speed Up Your Workflow (2:57)
A Hidden Search Feature Inside Flyspeed! (1:18)
How To Connect To A Database
Complete and Continue