SQL Queries Course, 1-Day, Virtual Classroom

Actions Panel

SQL Queries Course, 1-Day, Virtual Classroom

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 Course summary

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 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
  • Subquery examples
  • CTE Tables

WHAT IS INCLUDED:

  • SQL Course Certificate
  • Course notes
  • Code samples
  • Personal attention: max group size is 4.

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.

Organised by

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