Description
This course is aimed at beginners who want to grow their SQL skills rapidly. The course will include learning about how database servers work, using SQL to output reports, modifying data with SQL, creating a simple database, working with views, creating tables with SQL and also learning how to program through SQL (with stored procedures)
Two Day Course Price: €800 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- 06 June 2023, 2 Days
- 28 August 2023, 2 Days
- 03 October 2023, 2 Days
- 04 December 2023, 2 Days
TARGET AUDIENCE
This course is designed for participants new to writing SQL queries, who wish to use SQL to query and update data in SQL Server, MS Access and Oracle databases.
PREREQUISITES
None.
GOALS AND OBJECTIVES
- Understand how Database Servers work
- Learn to use SQL to output reports
- Learn to modify data with SQL
- Learn to create a simple database
- Learn to create simple work with Views
- Learn to create tables with SQL
- Learn to program through SQL (stored procedures)
Relational Database Basics
Overview of Relational Database Management Systems
Normalisation
Tables, Rows and Columns
Datatypes
Relationships
Primary Keys
Foreign Keys
SQL Statements
Data Control Language (DCL)
Data Manipulation Language (DML)
Data Definition Language (DDL)
Overview of Database Types
Oracle
MySQL
MS Access
MS SQL Server
Similarities & Differences between different database types
Simple SELECTs
SELECTing All Columns in All Rows
Comments
Exploring the Tables
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
Sorting Results
The WHERE Clause and Operator Symbols
Checking for NULL
Using WHERE and ORDER BY Together
The WHERE Clause and Operator Words
The BETWEEN. IN, LIKE, NOT, AND & OR Operators
Writing SELECTs with Multiple Conditions
Views
Creating Views
Dropping Views
Benefits of Views
Creating a View
Programming with MySQL and Oracle (PL/SQL) Overview
Stored Procedures
Triggers
Functions
Anonymous Blocks
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Calculating Fields
Aggregate Functions and Grouping
Grouping Data
Selecting Distinct Records
Working with Aggregate Functions
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Data Manipulation Functions
Other Analytical Functions
Subqueries, Joins and Unions
Subqueries
Joins
Table Aliases
Multi-table Joins
Using Joins
Outer Joins
Unions
UNION ALL
UNION Rules
Working with Unions
Conditional Processing with CASE
Using CASE
Working with CASE
Inserting, Updating and Deleting Records
INSERT
Inserting Records
UPDATE – to change record values
DELETE – Deleting records
Updating and Deleting Records
Creating and Modifying Tables
Data Types
Creating Tables
NULL Values
Primary Keys
Foreign Keys
Creating Tables
Adding and Dropping Columns
Renaming Tables
Dropping Tables
User Management (Oracle) Overview
Users
Roles
Privileges
Using Other Software with Databases
ODBC & Creating DSNs
Using Access to work with SQL Server databases
Using Excel to work with SQL Server databases