SQL Course summary
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.
SQL 90 minutes Crash Course
What is a Relational Database?
- Tables, Rows and Columns, Data Types
- Relationships, Primary Keys and Foreign Keys
- SQL Queries with the Select Statement
- The Select and From Clause
- Column Aliases
- The Order By Clause
- Conditions and the Where Clause
- Wildcards
- Working with null values
- Expression queries
- SQL Arithmetic Operation
- SQL Query Summarizing and Grouping
- SQL Aggregate Functions
- Sum, Avg, Count, Max, Min
- The Group By Clause
- The Having Clause
- Querying Multiple Tables
- Joining Tables Inner Joins
WHAT IS INCLUDED:
- SQL Course Certificate
- Course notes
- C ourse exercises and worked examples
- Personal attention, max group size is 4.
