Data Analysis with SQL Course, SQL Query Basics Course, Virtual Classroom

This SQL course will get you up and running to construct SQL queries, to extract data sub-sets from your data. It helps summarise and analyse data. 

SQL Course outline

Hour 1 and 2

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 ( > , >=, <, <=,, = , and, or, in, between )
• Wildcards
• Working with null values

Hour 3

Expression queries

• SQL Arithmetic Operation
• Case, iif, choose
• Date function and date formatting basics

Hour 4

SQL Query Summarizing and Grouping

• SQL Aggregate Functions
• Sum, Avg, Count, Max, Min
• The Group By Clause
• The Having Clause

Combining Queries :

• The Union,
• Intersect and
• Minus Operators

Hour 5

Querying Multiple Tables

• Joining Tables Inner Joins,
• Left and right Joins,
• Full Joins,
• Self Joins,
• Cross Coins

Hour 6

Basic Subqueries:

Practical Exercises

How does it work:

• Online
• Instructor-led
• Fully interactive, with screen-sharing
• Clear explanations with demonstrations and examples
• Practical exercises to be tried out by delegate
• Ask your questions and get the solutions straight away.
• Just as good as a classroom session.

System requirements: You need you SQL Database and query interface ready for the course. We will provide sample data that you should have ready installed on your system before we start.

FEE: £290

Registration: Data Analysis with SQL Course, SQL Query Basics Course, Virtual Classroom