00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

SQL Introduction

 

Description

  • 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)

Price €595 per person

Dates

  • Book a place on this course and pay with your credit card.23rd and 24th August 2017 , 2 Days
  • Book a place on this course and pay with your credit card.12th and 13th September 2017 , 2 Days
  • Book a place on this course and pay with your credit card.6th and 7th December 2017 , 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

Course Outline
Click here to download course oultline

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

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.