Data Analysis with SQL Course, SQL Query Basics Course, 1 Day Online

This is a power hour in the Basics of SQL queries. Learn the techniques for extracting required subsets of data from large data sources.

SQL Beginners Course Including AI Tools

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

Real-life adata base examples