SQL Power Queries Course

Our Style: Hands-on, Practical
Location: Online, Instructor-led
Duration: 1 Day
Times: arrange a time for your time zone

SQL Queries Course, 1-Day

• 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, saving hours of online training.

• This 1 Day course is packed with power query techniques.

Relational Database Concepts:

Database:

• What is a Relational Database?

• Tables, Rows and Columns

• Indexes, Primary Keys and Foreign Keys

• Data Types

SQL Language Essentials:

Basics.

• SQL Language Essentials:

• The SQL Select Statement

• SQL Conditions and the Where Clause

• The SQL Order By Clause

• SQL Arithmetic Operations, Expression Queries

• SQL Column Aliases

• Limit/Top, Distinct

• Working with Null Values

SQL Summarizing and Grouping Data:

Group by

• Aggregate Functions (Sum, Avg, Count, Max, Min)

• The Group By Clause

• The Having Clause

Querying Multiple Tables:

Joins

• Inner Joins, Outer Joins, Self Joins, Full Joins,

• Cross Joins

• Alternative Join Syntax

• The Union, Intersect and Minus Operators

Basic Subqueries

• Basics of CTE tables

• Basics of subqueries

What's Included

• PCWorkshops Course Certificate on completion

• SQL Course Notes

• SQL Code Examples

• Practical SQL Course exercises and Code Samples

• After the course: 1-Hour personalised online revision session