SQL
Course Overview
SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.
Duration: 2 day course
Course Content
Relational Databases
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Simple SELECT Statements
Comments
Whitespace and Semi-colons
Case Sensitivity
Selecting All Columns in All Rows
Selecting Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Aggregate Functions
Grouping and Aggregating Data
Selecting Distinct Records
Common Math Functions
Common String Functions
Common Date Functions
Subqueries, Joins and Unions
Subqueries
Joins
Table Aliases
Multi-table Joins
Outer Joins
Conditional Processing with CASE
CASE syntax
Using CASE
Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE
Creating and Modifying Tables
Data Types
Creating Tables
NULL Values
Primary Keys
Foreign Keys
Creating Tables
Adding and Dropping Columns
Renaming Tables
Dropping Tables
Views
Creating Views
Dropping Views
Benefits of Views
Stored Procedures
Creating Stored Procedures
Dropping Stored Procedures
Benefits of Stored Procedures
Email us about this courses
Telephone on 01952 938014