SQL TRAINING COURSES GLOUCESTERSHIRE
About Enable Technology Gloucestershire SQL Training Courses
Enable Technology offer short intensive skills based SQL training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training SQL resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific SQL queries. This support is open ended.
SQL courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver SQL training courses onsite at your premises. We are also more than happy to organise a local course at a training location in Gloucestershire. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
We can also deliver SQL courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Capita Group PLC, EDF Energy PLC, Norwich Union PLC, Aston University, Cadbury PLC and Wolverhampton City Council.
Transact SQL
- 2 day course
- Location: Gloucestershire
- 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 ... Work with SSPs and SMOs
- See Training Course Details...
Work with System Catalog Views Optimizing Query Performance
Manage Triggers
Configure Indexes
Merge Data Working with SQL Server Built-in Functions
Insert Data
Work with Subqueries
Work with Binary Data Types
Work with PIVOT and UNPIVOT
Work with T-SQL Statements
Work with SSMS Working with T-SQL
Create Queries to Test Nullability
Overview of T-SQL
Manage Views
Write CASE Expressions Working with SQL Data Types
Manage SQL Server Constraints Writing SELECT Queries
Manage Transactions Querying SQL Server System Metadata
Configure User-Defined Functions (UDF)
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Window Functions
Write SELECT Statements
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Gloucestershire
- 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...
Overview of Data Warehouses
Introduction to Data Warehouses
Configure MDS
Create Package Templates Implementing Data Flow
Work with MDS Databases
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Add Data Flow Components to a Data Flow Task
Configure the Package Execution Strategy
Debug Package Execution Components
Deploy a Control Flow
Troubleshoot Package Failures Deploying Packages
Create Expressions with Variables
Install Integration Services Working with Integration Services
Cleanse Data Using DQS Managing SSIS Package Execution
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Securing Packages and Databases
Add Packages to an SSIS Project Managing Control Flow
Debugging and Troubleshooting Packages
Oracle SQL
- 2 day course
- Location: Gloucestershire
- 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 ... Data Inconsistencies
- See Training Course Details...
Data Manipulation and Transactions
Literal Values
Self Joins
The INSERT Statement
Nulls and DISTINCT
Date Functions
Datatypes
Relational Database Management Systems
Joining Tables
Running SQL*Plus Scripts
Synonyms
Intervals
SQL Queries - Joins
The EXISTS Operator
Scalar Functions
Viewing Table Characteristics
Introduction to SQL
Compound Expressions
Oracle PL/SQL
- 3 day course
- Location: Gloucestershire
- 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 ... Fetching Rows
- See Training Course Details...
XML Packages
Stored Subprograms
The Package Interface and Implementation
The DBMS_UTILITY Package
External LOBs
Subtypes
Maintaining Triggers
Nesting Blocks
Exception Handling
Cursor Parameters
The DBMS_LOB Package
Creating a Stored Function
Record Variables
Closing Cursors
VARRAY and Nested TABLE Collections
Calling a Stored Function
Multi-Row Queries
SQL
- 2 day course
- Location: Gloucestershire
- Telephone on 01952 938014
- Course Outline
-
This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.
- Some of the training topics covered include ... The BETWEEN Operator
- See Training Course Details...
Popular Databases
CASE syntax
Stored Procedures
The LIKE Operator
Comments
Sorting By a Single Column
Common String Functions
Checking for NULL
Using CASE Inserting, Updating and Deleting Records
Selecting All Columns in All Rows
Aggregate Functions
Datatypes
Data Types
Selecting Specific Columns
Tables
Email us about this courses
Other Gloucestershire Enable Technology Training Courses
SSRS Gloucestershire Training Courses
Access VBA Gloucestershire Training Courses
JQuery Mobile - Gloucestershire JavaScript Training Courses
SSAS Tabular - Gloucestershire SQL Server Analysis Services Training Courses
SSIS Gloucestershire Training Courses
Access - Gloucestershire Access Training Courses
VBA - Gloucestershire Excel Training Courses
JavaScript - Gloucestershire JavaScript Training Courses
SSAS Gloucestershire Training Courses
Report Builder - Gloucestershire SQL Server Reporting Services Training Courses
DAX - Gloucestershire Excel Training Courses
Excel 365 Intermediate Gloucestershire Training Courses
Power BI Gloucestershire Training Courses
Excel 365 Basic - Gloucestershire Excel Training Courses
Power Query Gloucestershire Training Courses