SQL TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester SQL Training Courses
We are a company that provides short intensive SQL training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL training manuals they can refer to after the course. It is our company policy to provide SQL training participants with ongoing support from the course Tutor. People who attend a SQL course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. If delivery onsite is an issue we will organise a venue near you in Gloucester. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Birmingham Heartlands Hospital, DHL Express, Barclays Bank PLC, TalkTalk Direct Limited, Lloyds TSB Bank PLC, Keele University, South Staffordshire Water PLC and Queen's Medical Centre Nottingham.
SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 938014
- Course Outline
-
This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.
- Some of the training topics covered include ... The BETWEEN Operator
- See Training Course Details...
Simple SELECT Statements
Foreign Keys
The WHERE Clause and Operator Words
Creating Tables
Using the WHERE clause to check for greater or less than
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Datatypes
Popular Databases
Common Date Functions Subqueries, Joins and Unions
Renaming Tables
Creating Stored Procedures
Concatenation
Checking for NULL
Benefits of Views
Selecting Distinct Records
Sorting By a Single Column
Outer Joins
Comments
Oracle PL/SQL
- 3 day course
- Location: Gloucester
- Telephone on 01952 938014
- 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 ... Scope and Name Resolution
- See Training Course Details...
Collection Methods
The DBMS_METADATA Package
Selecting into a Variable
Overloading Package Functions and Procedures
Comments and Labels
FORALL Statement
Calling a Stored Procedure
WHILE and FOR Loops
Exception Handling
XML Packages
PL/SQL Variables and Datatypes
Triggers on Views
The PL/SQL Execution Environment
External LOBs
FOR UPDATE Cursors
Records and Collections
Maintaining Triggers
Using the %ROWTYPE Attribute
Oracle SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 938014
- 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 ... Relational Database Management Systems
- See Training Course Details...
Date Formats
The Aggregate Functions
Data Inconsistencies
Nulls and DISTINCT
Concurrency
The DELETE statement
Outer Joins
Subqueries
Pattern Matching: LIKE and REGEXP_LIKE
Controlling Access to Your Tables
Data Definition and Control Statements
Using Oracle SQL*Plus
Tailoring Your SQL*Plus Environment
Conversion Functions
Literal Values
Datatypes
Choosing Rows with the WHERE Clause
Intervals
Inline Constraints
Transact SQL
- 2 day course
- Location: Gloucester
- Telephone on 01952 938014
- 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 ... Merge Data Working with SQL Server Built-in Functions
- See Training Course Details...
Create Queries Using Join Algorithms
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Variables and Batches
Manage SQL Server Constraints Writing SELECT Queries
Analyze Data from Query Plans
Manage Triggers
Work with Date and Time Data Types
Work with T-SQL Statements
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Work with Data Access Technologies Implementing Stored Procedures
Work with PIVOT and UNPIVOT
Assign Aliases Using Queries
Work with Predicates
Manage Views
Combine Data Using Simple Joins
Work with Grouping Sets Managing Error Handling and Transactions
Modifying Data
Work with Set Operators
Work with Binary Data Types
Filter the Queried Results
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Gloucester
- Telephone on 01952 938014
- 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 ... Work with Windows Azure
- See Training Course Details...
Configure the Package Execution Strategy
Introduction to Data Warehouses
Examine Data Warehousing Concepts
Deploy a Control Flow
Securing Packages and Databases
Create Expressions with Variables
Perform Transformation Tasks
Add Script Tasks and Script Components to an SSIS Package
Work with MDS Databases
Create Package Templates Implementing Data Flow
Secure Packages
Deploy SSIS Packages
Add Data Flow Components to a Data Flow Task
Debug Package Execution Components
Execute Packages from Different Control Flow Working with Dynamic Variables
Secure Databases Working with MDS and Windows Azure
Profile OLTP Data
Examine MSI Packages
Email us about this courses
Other Gloucester Enable Technology Training Courses
Report Builder Gloucester Training Courses
Excel Power Pivot - Gloucester Excel Training Courses
SSIS - Gloucester SQL Server Integration Services Training Courses
VBA - Gloucester Excel Training Courses
DAX - Gloucester Excel Training Courses
Access - Gloucester Access Training Courses
SSRS Gloucester Training Courses
Excel 365 Intermediate Gloucester Training Courses
JavaScript Gloucester Training Courses
JQuery Mobile Gloucester Training Courses
SSAS Gloucester Training Courses
Excel 365 Basic Gloucester Training Courses
JQuery Gloucester Training Courses
Power Query Gloucester Training Courses
SSAS Tabular - Gloucester SQL Server Analysis Services Training Courses