SQL TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester SQL Training Courses
We are company which specialises in short, two and three day intensive SQL technology training courses. All Enable Technology tutors are Microsoft certified experts. We will issue each SQL training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver SQL courses onsite at your offices. You simply need to provide a suitable room. We are also more than happy to organise a local course at a socially distanced training location in Gloucester. The SQL syllabus can be modified to accommodate your specific training needs.
SQL courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are DHL Express, Dollond & Aitchison Limited, Royal Air Force, Norfolk Police Constabulary, Keele University, Norwich Union PLC, Capita Group PLC and Aston University.
Transact SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 305730
- Course Outline
-
This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.
The course id practical, hands on and does not assume prior SQL or programming experience.
- Some of the training topics covered include ... Work with Data Access Technologies Implementing Stored Procedures
- See Training Course Details...
Insert Data
Manage Triggers
Modifying Data
Manage Stored Procedures
Assign Aliases Using Queries
Group and Aggregate Data Programming in T-SQL
Work with PIVOT and UNPIVOT
Work with Dynamic SQL Working with Subqueries and Table Expressions
Combine Data Using Simple Joins
Write SELECT Statements
Work with Date and Time Data Types
Work with Variables and Batches
Work with Predicates
Work with Set Operators
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Binary Data Types
Control Program Flow
Work with T-SQL Statements
Configure User-Defined Functions (UDF)
Overview of SQL Server
SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 305730
- Course Outline
-
This hands on SQL (Structured Query Language) course will equip participants the skills necessary to extract filtered data from all of the leading database platforms. No prior knowledge is assumed. Participants will learn how to extract data from a relational database, create aggregated grouped reports, update, insert and delete data, create tables, views and stored procedures.
- Some of the training topics covered include ... DELETE
- See Training Course Details...
Table Aliases
Common String Functions
Creating Tables
Benefits of Stored Procedures
Primary Keys
The LIKE Operator
Popular Databases
WHERE and ORDER BY
Aggregate Functions
Relational Database Management System
Checking for NULL
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Checking Multiple Conditions
Creating Stored Procedures
Sorting By a Single Column
Creating Tables
Creating and Modifying Tables
Mathematical Calculations
Oracle SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.
- Some of the training topics covered include ... Data Definition and Control Statements
- See Training Course Details...
Defining Tables
Sequences
Data Inconsistencies
Relational Database Management Systems
Choosing Rows with the WHERE Clause
The CASE...WHEN Expression
Concurrency
Scalar Functions
Explicit Locking
The SELECT Statement
SQL Queries
Grouping Rows
IN and BETWEEN
Buffer Manipulation Commands
Conversion Functions
Modifying Table Definitions
The EXISTS Operator
SQL Queries - Joins
Nulls and DISTINCT
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Gloucester
- Telephone on 01952 305730
- Course Outline
-
Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.
The course requires a working knowledge of SQL.
- Some of the training topics covered include ... Perform Transformation Tasks
- See Training Course Details...
Introduction to Data Warehouses
Deploy a Control Flow
Create an SSIS Project
Create Dimensions
Debug Package Execution Components
Configure the Package Execution Strategy
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Data Flow Components to a Data Flow Task
Add Packages to an SSIS Project Managing Control Flow
Overview of Data Warehouse Components
Create Expressions with Variables
Add Script Tasks and Script Components to an SSIS Package
Secure Databases Working with MDS and Windows Azure
Execute Packages from Different Control Flow Working with Dynamic Variables
Work with MDS Databases
Execute SSIS Packages on the Server
Profile OLTP Data
Configure MDS
Oracle PL/SQL
- 3 day course
- Location: Gloucester
- Telephone on 01952 305730
- Course Outline
-
This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.
- Some of the training topics covered include ... Procedures and Functions
- See Training Course Details...
Networking Packages
The DBMS_METADATA Package
Stored Functions and SQL
Exception Handlers
Loops
The DBMS_UTILITY Package
Package Variables
PL/SQL Variables and Datatypes
Datatypes
Types of Triggers
Stored Subprograms
Character Data
Associative Array Collections
Records and Collections
Creating a Stored Procedure
Assignment and Conversions
Cascading Triggers and Mutating Tables
Privileges for Stored Programs
Multi-Row Queries
Email us about this courses
Other Gloucester Enable Technology Training Courses
SSAS 2017 Gloucester Training Courses
HTML Gloucester Training Courses
SSIS 2005 - Gloucester SQL Server Integration Services Training Courses
Crystal 2011 - Gloucester Crystal Reports Training Courses
SSRS 2005 Gloucester Training Courses
Data Mining - Gloucester Data Analytics Training Courses
SSRS 2016 Gloucester Training Courses
JQuery Mobile Gloucester Training Courses
Microsoft Project Level 3 - Gloucester Microsoft Project Training Courses
SSAS 2014 - Gloucester SQL Server Analysis Services Training Courses
Project 2016 L1 - Gloucester Microsoft Project Training Courses
Oracle BI Gloucester Training Courses
DAX Gloucester Training Courses
SSRS 2008 Gloucester Training Courses
SSAS 2005 Gloucester Training Courses
South West - Possible SQL Training Course Locations
Wiltshire SQL Training Courses
Stroud SQL Training Courses
Weymouth SQL Training Courses
Poole SQL Training Courses
Bristol SQL Training Courses
Gloucestershire SQL Training Courses
Wells SQL Training Courses
Bath SQL Training Courses
Christchurch SQL Training Courses
Devon SQL Training Courses
Bournemouth SQL Training Courses
Torquay SQL Training Courses
Dorchester SQL Training Courses
Cheltenham SQL Training Courses
Trowbridge SQL Training Courses
Yoevil SQL Training Courses
Somerset SQL Training Courses
Salisbury SQL Training Courses
Cirencester SQL Training Courses
Swindon SQL Training Courses
Taunton SQL Training Courses
Gloucester SQL Training Courses
Exeter SQL Training Courses
South West SQL Training Courses
Tewkesbury SQL Training Courses
Chippenham SQL Training Courses
Dorset SQL Training Courses
Plymouth SQL Training Courses
Wiltshire, Stroud, Weymouth, Poole, Bristol, Gloucestershire, Wells, Bath, Christchurch, Devon, Bournemouth, Torquay, Dorchester, Cheltenham, Trowbridge, Yoevil, Somerset, Salisbury, Cirencester, Swindon, Taunton, Gloucester, Exeter, South West, Tewkesbury, Chippenham, Dorset, Plymouth