SQL Queries 1-Day Course, Online, Instructor-led.

SQL Beginners Course Including AI Tools

All courses online instructor-led, practical, interactive!

If you have more questions , contact

Get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course. SQL 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 Independent. Read more.

SQL Beginners Course Outline

Online, Instructor-led, Practical ,Interactive.

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. Read more

• Use generative AI Tools to create the queries for you

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
• 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 Joins

Hour 6

• The Basic Concept and Structure of Subqueries
• S ubquery examples
• C TE Tables
• Use generative AI Tools to create the queries for you

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.

Read more: https://pcworkshopslondon.co.uk/sql-beginners-1-day-course.html

System requirements:

It would be best if your SQL Database, query interface and sample data is ready for the course.

https://pcworkshopslondon.co.uk/sql-beginners-1-day-course.html