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

ReadingMon 16th Dec 2019£595
ReadingMon 20th Jan 2020£595
LondonMon 27th Jan 2020£695
LondonMon 24th Feb 2020£695
ReadingWed 26th Feb 2020£595
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