Speak to our team now  0118 324 3000

SQL Introduction to Querying

How to write super effective SQL queries like a pro in only 2 days.
The ability to process data into information can make the difference between success and failure.

  • SQL is the most widely used database language in the world.
  • Be able to query, create, update and analyse the data you need.
  • Learn a highly sort after skill

Learn SQL could be one of the best career decisions you make. From the potential salary benefits, from no longer needing others to give you information, and from being able to ask ANY question about your business, learning SQL enables you to do stacks more

2 Day Course

Thu 13 Jun 2019£595 for 2 Days (ex vat)
Tue 16 Jul 2019£595 for 2 Days (ex vat)
Wed 21 Aug 2019£595 for 2 Days (ex vat)
Wed 18 Sep 2019£595 for 2 Days (ex vat)
Mon 21 Oct 2019£595 for 2 Days (ex vat)
Mon 18 Nov 2019£595 for 2 Days (ex vat)
Mon 16 Dec 2019£595 for 2 Days (ex vat)

Our Course Benefits


  • Hand-on Training


  • Comprehensive Manual


  • Refreshment & Lunch


  • Post Course Support

Our Reading Training Center

  • Reading Station – 0.3 miles
  • Reading West Station – 0.9 miles
  • Heathrow Airport – 25.4 miles
  • Find nearest car park
  • Systematix Ltd, Soane Point, 6-8 Market Place, Reading, RG1 2EG

Course Outline

Overview

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

Prerequisites

Windows Introduction or equivalent knowledge

Benefits

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

Target student

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

Course Content

Introduction to databases and SQL

  • Database concepts
  • Understanding SQL concepts

Introduction to the SELECT statement

  • An overview of the SELECT statemen
  • Syntax rules you’ll want to know

Calculating data

  • Aggregate functions
  • Column aliases
  • Performing calculations
  • Date functions

Selecting specific rows

  • The WHERE clause
  • The ORDER BY clause

Working with other operators

  • Searching for tex
  • Logical operators
  • NULLs

Grouping data

  • The GROUP BY clause
  • The HAVING clause
  • Comparing the WHERE and HAVING clauses

Multi-table queries

  • Joins
  • Joining tables
  • Outer joins

Querying a database using Access

  • Connecting to a database
  • Querying a database
  • Generating a report of the data

Querying with unions and advanced joins

  • Querying multiple tables with unions
  • Advanced Joins
  • Calculating with COMPUTE

Querying with subqueries

  • Subqueries

Querying with subqueries

  • Subqueries

Adding data

  • Inserting data
  • SELECT INTO

Updating and removing data

  • Updating records
  • Deleting records
  • Deleting the contents of tables

Manipulating tables and views

  • Creating tables
  • Modifying tables
  • Deleting tables
  • Adding and removing views

Manipulating indexes

  • Adding and removing indexes

Ensuring data integrity with transactions

  • Transactions

Creating databases

  • Creating a database with SQL
  • Deleting a database
PDF Outline