arrow_back
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
How To Connect To A Database
A Tour Of The Database 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
How To Select Multiple Columns From A Single Table
How To Remove All Duplicates From Your Data
Understanding Sorting
Understanding Multi Column Sort
How To sort Data in a Table in Ascending and Descending Order
How To Add Limits And Offset To Your Output
The Data Filter Toolbar
Understanding the Data Filter Toolbar
Filtering Rows - [Visually] - 01
Filtering Rows - [Visually] - 01 - integrating the filter
Filtering Rows - [Visually] - 02
Filtering Rows - [Visually] - 03
Filtering Rows - [Visually] - 04
Filtering Rows - [Visually] - 05
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
A Quick Video To Show You The Same Process Inside Flyspeed
Creating Inner-Joins Visually!
All about Inner-Joins
Creating An Inner Join Visually Using Flyspeed Query Tool - 01
Creating An Inner Join Visually Using Flyspeed Query Tool - 02
Creating An Inner Join Visually Using Flyspeed Query Tool - 03
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
Creating Aggregate Functions - Visually- 02
Aggregate Functions - Challenge- 01
Challenge - 01 [Solution-code]
Aggregate Functions - Challenge - 02
Challenge - 02 [Solution Code]
Aggregate Functions - Challenge- 03
Challenge - 03 [Solution Code]
Aggregate Functions - Challenge - 04
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
Working With Grouping - Visually- 02
Working With Grouping - Challenge- 01
Challenge - 01 [Solution Code]
Working With Grouping - Challenge- 02
Challenge - 02 [Solution Code]
Working With Grouping - Challenge- 03
Challenge - 03 [Solution Code]
The date Filter
The date filter
Preparing To Use Date Filters
Working With Date-Filters - 01
Working With Date-Filters -02
Date Filter - Challenge- 01
Challenge - 01 [Solution-code]
Some Bonus Flyspeed Tips!
How To Execute the Same SQL Query On Different Databases Instantly!
How To Customize Flyspeed's Interface To Speed Up Your Workflow
A Hidden Search Feature Inside Flyspeed!