Learn SQL Course, 1-Day
SQL Queries Course, 1-Day.
Who should attend:
Basic SQL syntax for beginners to SQL
Many attendees are in-work IT Professional.
Private individuals are also very welcome.
Our Style: Hands-on, Practical
Location: Online, Instructor-led
Times: Arrange a time for your time zone
Software and Sample Data: We will contact you upon booking to discuss software and sample data
Learn SQL Course, 1-Day
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK.
Queries are made easy and simple, saving hours of online training.
This 1 Day course is packed with power query techniques.
This SQL Introduction Course is hands-on, practical with many excellent query examples.
This course is Platform Independent.
This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in small, friendly classroom SQL Course.
Online, Instructor-led, Interactive, full screen sharing.
Hour 1: Learn SQL Relational Database Concepts:
Database:
What is a Relational Database? Tables, Rows and Columns; Indexes, Primary Keys and Foreign Keys; Data Types
Hour 2: Learn SQL Essentials:
Basics.
SQL Language Essentials:
The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
SQL Expression Queries; SQL Column Aliases; Limit/Top, Distinct
Hour 3: Summarizing and Grouping Data:
Group by
Aggregate Functions in SQL (Sum, Avg, Count, Max, Min)
The SQL Group By Clause
The Having Clause
Hour 4: Querying Multiple Tables:
Joins
Joining Tables
Inner Joins, Outer Joins, Self Joins, Full Joins,
Cross Joins
Alternative Join Syntax
Combine Queries
Combine Queries
The Union Operator
Intersect and Minus Operators
Simulating combine Intersect and Minus queries by using sub-queries
Hour 5: Working with dates
Dates Functions
Date parts, System date and time
Dates in the where clause
Formatting dates and times
Date calculations in SQL
Using dates and date parts in the group by clause
Date functions comparison for different databases
Hour 6: Basic SQL Subqueries
SQL Sub-queries
Basics of CTE tables
SQL subqueries
Using subqueries in the FROM clause
Using subqueries in the WHERE clause
Using subqueries in the SELECT clause
Using subqueries in the HAVING clause
What is 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
Book the SQL Course
About us
Our experienced trainers are award winners.
