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

Need something more custom?

Our Course Benefits


Hand-on Training
Comprehensive Manual
Resfreshment & 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