06. August 2018 - 11:00
One Victoria Square, Birmingham
Share it on:

SQL Queries 1-Day Course, Birmingham | Monday, 06. August 2018

SQL Course summaryGet 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 Course OutlineRelational Database Concepts



What is a Relational Database?


Tables, Rows and Columns, Indexes, Primary Keys and Foreign Keys


Data Types



SQL Language Essentials



The SQL Select Statement


SQL Conditions and the Where Clause


The SQL Order By Clause


SQL Arithmetic Operations


SQL Column Aliases



SQL Summarizing and Grouping Data



Aggregate Functions


The Group By Clause


The Having Clause



Querying Multiple Tables



Joining Tables


Inner Joins, Outer Joins, Self Joins, Full Joins, Alternative Join Syntax



Additional SQL Features



Combining Queries


The Union, Intersect and Minus Operators


Basic Subqueries



 


WHAT IS INCLUDED:



SQL Course Certificate 


Course notes 


Tea, coffees, but no lunch 


Max group size is 4.