Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online

Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online

Actions and Detail Panel

£290

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.

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

 

 

 

 

Data analysis with SQL Course. SQL Queries, 1-Day, Manchester, Online image

Share with friends

Save This Event

Event Saved