access
Lifetime
content
1.0 Hours
Description
This course is for anyone who's having difficulty writing SQL queries using the traditional 'code-based' method prevalent everywhere. Imagine being able to create SQL queries without writing any code. You simply interact with your data and the software builds the code for you in the background. It’s so simple, that you'll wish you had your hands on this training methodology earlier, to start using SQL everywhere.
It's a system that follows a path of tiny increments, instead of creating yet another mountain of information that goes nowhere. Every topic is de-constructed into itty-bitty steps that are easy to understand. It allows the student to not just learn, but to retain and easily implement any of the data-driven strategies and tactics.
- Access 18 lectures & 1 hour of content 24/7
- Create SQL queries without writing any code
- Let the software build the code for you in the background
- Slice & dice your data in a drag-and-drop way
- Understand aggregate functions
- Get some bonus flyspeed tips
Sanjeev Krishna | SequelBytes
For the past 10 years, he's been coding with PHP and SQL. He also coaches people on how to write SQL queries. Sanjeev started by coaching his clients who ran PHP/WordPress-based eCommerce shops and had varied needs to query their data.
For the past 10 years, he's been coding with PHP and SQL. He also coaches people on how to write SQL queries. Sanjeev started by coaching his clients who ran PHP/WordPress-based eCommerce shops and had varied needs to query their data.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Your First Program
- 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
access
Lifetime
content
1.0 Hours