Course Information

Overview

Students will learn what SQL is and how it can help them query a database to answer business questions.

Target Student

Students should be familiar with the components that make up the PC, including input, output, and storage devices. They should also be familiar with concepts related to database structure and terminology.

Benefits

Students will learn how to use SQL statements to query a database.

Prerequisites

Windows Introduction or equivalent knowledge.

Outline

  • Database concepts
  • Understanding SQL concepts
  • An overview of the SELECT statement
  • Syntax rules you’ll want to know
  • Aggregate functions
  • Column aliases
  • Performing calculations
  • Date functions
  • The WHERE clause
  • The ORDER BY clause
  • Searching for text
  • Logical operators
  • NULLs
  • The GROUP BY clause
  • The HAVING clause
  • Comparing the WHERE and HAVING clauses
  • Joins
  • Joining tables
  • Outer joins
  • Connecting to a database
  • Querying a database
  • Generating a report of the data
  • Querying multiple tables with unions
  • Advanced Joins
  • Calculating with COMPUTE
  • Subqueries
  • Inserting data
  • SELECT INTO
  • Updating records
  • Deleting records
  • Deleting the contents of tables
  • Creating tables
  • Modifying tables
  • Deleting tables
  • Adding and removing views
  • Adding and removing indexes
  • Transactions
  • Creating a database with SQL
  • Deleting a database
Dates and Prices
Choose a location...

If you would like onsite training for this course, request a quote.

image
2 Days
Public Dates

Upcoming Dates

ReadingWed 26th Feb 2020£595
LondonMon 23rd Mar 2020£695
Mon 23rd Mar 2020£695
ReadingWed 20th May 2020£595
LondonMon 8th Jun 2020£695
More Dates

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle