With SQL Queries, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course. Queries are made easy and simple by this hands-on, practical course. Ask your SQL questions in small, friendly classroom SQL Course. Save hours of online training.
This course is Platform Independant.
This 1 Day course is packed with power query techniques.
This SQL Introduction Course is hands-on and practical with many excellent query examples.
What is a Relational Database?
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
The SQL Select Statement
SQL Conditions and the Where Clause: >,<,>=,<=,=,, Not, Between, AND, OR, Like, Wildcards
The SQL Order By Clause
SQL Arithmetic Operations, Expression Queries
SQL Column Aliases
Working with Null Values
Aggregate Functions (Sum, Avg, Count, Max, Min)
The Group By Clause
The Having Clause
Inner Joins, Outer Joins, Self Joins, Full Joins, Cross Joins
Alternative Join Syntax
The Union, Intersect and Minus Operators
Sign up to receive lessons, tips, examples, quizzes and other training materials.