SQL Queries 1-Day Course, Online, Instructor-led.
Multiple dates

SQL Queries 1-Day Course, Online, Instructor-led.

SQL queries are made easy by this hands-on, practical, instructor-led, online course. Get interesting, essential business insight from data.

By PCWorkshops

Location

Online

Refund Policy

No refunds

About this event

SQL Beginners Course Including AI Tools

All courses online instructor-led, practical, interactive!

If you have more questions , contact

Get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course. SQL Queries are made easy and simple by this hands-on, practical course. Ask your SQL questions in small, friendly classroom SQL Course. Save hours of online training.

This course is Platform Independent. Read more.


SQL Beginners Course Outline

Online, Instructor-led, Practical ,Interactive.

This SQL course will get you up and running to construct SQL queries, to extract data sub-sets from your data. It helps summarise and analyse data. Read more


  • Use generative AI Tools to create the queries for you

SQL Course outline

Hour 1 and 2

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
  • S ubquery examples
  • C TE Tables
  • Use generative AI Tools to create the queries for you


How does it work:

  • Online
  • Instructor-led
  • Fully interactive, with screen-sharing
  • Clear explanations with demonstrations and examples
  • Practical exercises to be tried out by delegate
  • Ask your questions and get the solutions straight away.
  • Just as good as a classroom session.

System requirements: You need you SQL Database and query interface ready for the course. We will provide sample data that you should have ready installed on your system before we start.

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

System requirements:

It would be best if your SQL Database, query interface and sample data is ready for the course.

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

Frequently asked questions

Do I need SQL on my Laptop?

Ideally spoken yes, but if not possible, on the 1 day course, you could use our online platform.

What version of SQL do I need?

The queries and SQL Statements used on this day are platform independant, so any version

Can I pay by BACS?

Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com

Can I pay with PayPal?

Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com

Do I get an invoice?

Yes, on request.

Can I pay with a PO (Purchase Order Number)?

Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com

Do I get a certificate?

Yes, a PCWorkshops SQL Queries Certificate

Can I attend in classroom?

Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchestre, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes.

Can beginners follow this course?

Yes, this is a beginner friendly course. We offer courses with max 4 peopl, so we make sure each delegates fully understand the material covered

Can I customise the course?

Yes, all our courses are customisable. We can customise the dates, times, location. course outline.

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.

 

 Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html

 

From £216.19
Multiple dates