SQL Queries Course, 1-Day
SQL Queries Course, 1-Day. Basic SQL syntax.
Most attendees are in-work IT Professional.
Private individuals are also very welcome.
Evening courses also running.
Our Style: Hands-on, Practical
Location: Online, Instructor-led
Download: anaconda.com
Duration: 6 weeks, 1 evening per week, 6pm - 8pm
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 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.
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
Joining Tables
Inner Joins, Outer Joins, Self Joins, Full Joins,
Cross Joins
Alternative Join Syntax
The Union, Intersect and Minus Operators
Basic Subqueries
Sub-queries
Basics of CTE tables and subqueries
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