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

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

This SQL Queries Course covers retrieval and analysing data in a powerful, feature-filled training day. Instructor-led and Classroom.

By PCWorkshops

Select date and time

Tue, 23 Apr 2024 02:00 - 07:00 PDT

Location

Online

Refund Policy

Contact the organiser to request a refund.

About this event

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

 

 

 

 

Tags

Organised by

PCWorkshops

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

£100