SQL Course, 1-Day in Manchester

We are post-Corona New Age: Online, Instructor-led, Practical ,Interactive.

This SQL Course provides SQL Queries knowledge and skills needed to retrieve and analyse data held in a database.  

Who Should Attend the SQL Course

Anyone who needs to understand and use SQL to manipulate a database, should attend this SQL Course. There are no formal pre-requisites for this course, although an understanding of databases and exposure to information technology in general would be useful.  

Virtual Classroom: Attend online, Instructor-led, Interactive, Practical.

Read more

SQL Course Outline

Relational Database Concepts

• What is a Relational Database?
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Data Types
• The Data Dictionary
• Getting Started

SQL Queries Language Essentials

• The Select Statement
• The Select and From Clauses
• Conditions and the Where Clause
• The Order By Clause
• Arithmetic Operations
• Column Aliases
• Practical Exercises

Summarizing and Grouping Data

• Aggregate Functions
• The Group By Clause
• The Having Clause
• Practical Exercises

Querying Multiple Tables

• Joining Tables with Inner Joins
• Column Qualification and Table Aliases
• Outer Joins, Self Joins, Alternative Join Syntax
• Practical Exercises

Additional SQL Features

• Combining Queries
• The Union, Intersect and Minus Operators
• Basic Subqueries
• Practical Exercises

INCLUDED:

Certificates:  Certificates included

Included: Notes. Query examples and exercises. 

After course support: 1-hours online revision session

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