Basic Math 
Pre Algebra
Algebra I 
Algebra I
Algebra II 
Geometry 
Trigonometry 
Precalculus 
Math Analysis 
AP Calculus AB 
AP Calculus BC
AP Statistics
Gen. Statistics 
Gen. Statistics
Probability 
College Calculus: Level I
College Calculus: Level II 
Multivariable Calculus 
Linear Algebra 
Differential Equations 
General Chemistry 
Gen. Chemistry
AP Chemistry 
Biochemistry 
Organic Chemistry 
Organic Chemistry Lab 
Physical Chemistry 
Physics – High School (Theory & Application) 
AP Physics 1 & 2 
AP Physics C: Mechanics 
AP Physics C: Electricity & Magnetism 
AP Physics B
AP Physics C: Mechanics
AP Physics C: Electricity Magnetism
Life Science (Middle School)
Regular Biology
Anatomy & Physiology 
General Biology 
AP Biology 
AP Environmental Science
Microbiology
Molecular Biology 
Intro to Psychology
AP Psychology
AP US History
AP World History
HTML Training 
HTML 5
Intro to Ruby Programming 
Web Design & E-Commerce
Introduction to C++
Intermediate Level C++
CSS Intro
Java
AP CompSci: Intro to Java
JavaScript
Introduction to PHP 
Advanced PHP Training w/ mySQL 
C#
Visual Basic
XML Training
QuickBooks (How-To Guide) 
MATLAB
Excel Power Query
Adobe Dreamweaver CC
Adobe Dreamweaver CS6 
Adobe Photoshop CS6 
Photoshop Designs to Code
Edge Animate CC
jQuery Mobile
Adobe Illustrator CS6
Adobe Premiere Pro CS6
Adobe Premiere Elements 11
ColdFusion 9
ColdFusion 9: Application Framework
Fireworks CS6: Web Workflow
Adobe Photoshop Elements 11 
English Grammar
Advanced English Grammar
English Composition
Application Essays
AP English Language & Composition
AP English Literature & Composition
Shakespeare: Plays & Sonnets
Reading Comprehension
AP Spanish
AP Studio Art 2-D
Music Composition
Music Theory
Music History & Appreciation
Learn Piano for Beatmakers and Producers
Answer EngineTable of Contents
Section 1: SQL Database Queries Fundamentals |
|||||
|---|---|---|---|---|---|
| What You Will Learn | 1:26 | ||||
| Overview of what we will cover in this course | |||||
| All About SQL | 4:07 | ||||
| Let us go over the basics of SQL | |||||
| Setting Up Your Training Ground | 3:50 | ||||
| Setup the software that you need to follow the exercises | |||||
| Data Manipulation | 8:03 | ||||
| Let us learn how to manipulate data | |||||
| Running the Initial SQL File | 4:31 | ||||
| Setup the initial database and the tables | |||||
| Simple Queries | 13:11 | ||||
| We discuss SQL simple queries | |||||
| Simple Queries (exercise) | 5:19 | ||||
| We solve together the exercises for simple queries | |||||
| Advanced Simple Queries | 10:59 | ||||
| We discuss SQL advanced simple queries | |||||
| Advanced Simple Queries (exercise) | 5:39 | ||||
| We solve together the exercises for advanced simple queries | |||||
| Joins | 9:22 | ||||
| Learn all about SQL joins | |||||
| Joins (exercise) | 10:05 | ||||
| We solve together the exercises for joins | |||||
| Subqueries | 5:01 | ||||
| Learn all about SQL subqueries | |||||
| Subqueries (exercise) | 6:15 | ||||
| We solve together the exercises for subqueries | |||||
| More SQL Examples and Exercises! | 9:09 | ||||
| More SQL Exercises to solve together | |||||
If you want to get better at Microsoft SQL so you get a better paying job or just get answers & insights from your data FAST, then you are in the right place!
No matter if you are an SQL Beginner or NEVER USED SQL before, you are sure to benefit from this quick course which goes through the MUST KNOW SQL queries & features.
You will be able to master straight away the following (in just 90 minutes):
- Everything about SQL and Databases
- Simple to Advanced Single Table Queries
- Joining Multiple Tables
- Writing Subqueries
In Just 90 Minutes You Will Walk Away With...
- Master writing SQL queries in just 90 minutes!
- Understand the essence of these queries, without memorizing them!
- See how each of these queries are used with real examples!
Bryan is a best-selling book author of the 101 Excel Series paperback books and a Microsoft Certified Systems Engineer with IT experience of more than 10 years.
Courses Bryan is focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping students in whatever means possible, whether it be reaching them via courses or by books.
