Learn SQL Basics, 1-day Course, Online Instructor-Led

Description

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional.
Private individuals are also very welcome.
Evening courses also running.

Details

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

Join us on your booked dates on https://meet.goto.com/910697125

With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in 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 SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course.

Learn SQL. Relational Database Concepts:

Database:
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types

Learn SQL Essentials:

Basics.
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct

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

Basic Subqueries

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

Combine Queries
The Union Operator
Intersect and Minus Operators
Simulating combined Intersect and Minus queries by using sub-queries