Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online
This Instructor-led, interactive, practical, online SQL Queries Course shows you how to retrieve and analyse data held in a database.
About this event
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.
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
