SQL TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL course will be provided with training materials and practice files to retain after the course. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. SQL courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL onsite. Another option is we can organise a local training site in Stratford Upon Avon. The SQL syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual SQL class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Royal Air Force, Dollond & Aitchison Limited, Keele University, Lloyds TSB Bank PLC, Birmingham City University, Homeserve PLC, Carillion PLC and Queen's Medical Centre Nottingham.
Transact SQL
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Configure User-Defined Functions (UDF)
- See Training Course Details...
Modifying Data
Work with T-SQL Statements
Work with Predicates
Assign Aliases Using Queries
Group and Aggregate Data Programming in T-SQL
Insert Data
Manage Views
Manage Stored Procedures
Overview of SQL Server
Work with System Catalog Views Optimizing Query Performance
Delete Data
Manage Triggers
Create Queries Using Built-in Functions
Combine Data Using Simple Joins
Work with PIVOT and UNPIVOT
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Work with System Databases
Work with Subqueries
Create Queries to Test Nullability
Work with Dynamic SQL Working with Subqueries and Table Expressions
Oracle PL/SQL
- 3 day course
- Location: Stratford Upon Avon
- 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 ... REF CURSOR Variables
- See Training Course Details...
The DBMS_UTILITY Package
Closing Cursors
Maintaining PL/SQL Code
Subtypes
Character Data
Local Procedures and Functions
System Triggers
Creating Packages
Stored Procedures and Functions
Using Packages
The PL/SQL Execution Environment
Triggers
Scope and Name Resolution
Calling a Stored Procedure
SQLCODE and SQLERRM
Other Supplied Packages
Creating a Stored Function
Loops
Maintaining Stored Programs
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Stratford Upon Avon
- 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...
Create Package Templates Implementing Data Flow
Add Data Flow Components to a Data Flow Task
Securing Packages and Databases
Perform Transformation Tasks
Configure the Package Execution Strategy
Create Dimensions
Execute SSIS Packages on the Server
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Cleanse Data Using DQS Managing SSIS Package Execution
Configure MDS
Add Script Tasks and Script Components to an SSIS Package
Examine Data Warehousing Concepts
Overview of Data Warehouses
Change Granularity Creating Fact Tables and Columnstore Indexes
Track Changed Data Managing Data Flow
Execute Packages from Different Control Flow Working with Dynamic Variables
Work with MDS Databases
Overview of Data Warehouse Components
Oracle SQL
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Self Joins
- See Training Course Details...
Correlated Subqueries
Choosing Rows with the WHERE Clause
Relational Database Management Systems
The DELETE statement
Pattern Matching: LIKE and REGEXP_LIKE
Numeric Functions
Date Formats
Transaction Management
Connecting to a SQL Database
SQL*Plus Substitution Variables
Sequences
NULL Values
Interactive SQL*Plus Scripts
The SELECT Statement
Date Functions
Joining Tables
Concurrency
SQL
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Relational Databases
- See Training Course Details...
Dropping Views
Popular Databases
Comments
DELETE
Benefits of Views
Stored Procedures
Sorting By a Single Column
Common String Functions
Data Types
Conditional Processing with CASE
Foreign Keys
Checking Multiple Conditions
Benefits of Stored Procedures
Calculated Fields
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
Excel Power Pivot - Stratford Upon Avon Excel Training Courses
Excel 365 Advanced - Stratford Upon Avon Excel Training Courses
Access Stratford Upon Avon Training Courses
VBA - Stratford Upon Avon Excel Training Courses
SSIS Stratford Upon Avon Training Courses
JQuery Mobile - Stratford Upon Avon JavaScript Training Courses
Power Query Stratford Upon Avon Training Courses
SSAS - Stratford Upon Avon SQL Server Analysis Services Training Courses
Power BI - Stratford Upon Avon Microsoft Power BI Training Courses
Excel 365 Basic - Stratford Upon Avon Excel Training Courses
JavaScript - Stratford Upon Avon JavaScript Training Courses
DAX - Stratford Upon Avon Excel Training Courses
Excel 365 Intermediate Stratford Upon Avon Training Courses
Report Builder - Stratford Upon Avon SQL Server Reporting Services Training Courses
JQuery Stratford Upon Avon Training Courses