SQL Course, 1-Day in Manchester
This SQL Course provides all necessary SQL knowledge and skills 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.
- Classroom: Select your option at checkout.
SQL Course Outline
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
- Subquery examples
- CTE Tables
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
