SQL TRAINING COURSES TORQUAY
About Enable Technology Torquay SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away SQL courseware which can be used as reference materials after the training. Our policy is to provide open ended SQL post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
SQL courses are taught by a Microsoft Certified Solutions Expert. 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 socially distanced venue near you in Torquay. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Dollond & Aitchison Limited, Wolverhampton City Council, Fujistu PLC, Carillion PLC, Aston University, Total Telecommunications Limited, Lloyds TSB Bank PLC and Homeserve PLC.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Torquay
- 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 ... Execute Packages from Different Control Flow Working with Dynamic Variables
- See Training Course Details...
Work with MDS Databases
Add Packages to an SSIS Project Managing Control Flow
Change Granularity Creating Fact Tables and Columnstore Indexes
Overview of Data Warehouse Components
Securing Packages and Databases
Execute SSIS Packages on the Server
Configure the Package Execution Strategy
Perform Transformation Tasks
Secure Packages
Configure MDS
Add Script Tasks and Script Components to an SSIS Package
Examine MSI Packages
Create Fact Tables
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Debug Package Execution Components
Create Dimensions
Deploy a Control Flow
Track Changed Data Managing Data Flow
Create Expressions with Variables
SQL
- 2 day course
- Location: Torquay
- Telephone on 01952 305730
- 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 ... Case Sensitivity
- See Training Course Details...
The LIKE Operator
Checking for Equality
Creating and Modifying Tables
Adding and Dropping Columns
The BETWEEN Operator
Primary Keys
Using the WHERE clause to check for greater or less than
Simple SELECT Statements
Benefits of Stored Procedures
Aggregate Functions
Using CASE Inserting, Updating and Deleting Records
Creating Views
Creating Stored Procedures
Primary Keys
Dropping Tables
Datatypes
Oracle SQL
- 2 day course
- Location: Torquay
- 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 ... Loading Tables From External Sources
- See Training Course Details...
Data Definition and Control Statements
Relational Database Management Systems
Scalar Functions
The UPDATE Statement
Self Joins
Buffer Manipulation Commands
SQL Queries - Joins
Selecting from Multiple Tables
NULL Values
Numeric Functions
Explicit Locking
Tailoring Your SQL*Plus Environment
Other Database Objects
Deleting a Table Definition
Intervals
Interactive SQL*Plus Scripts
Oracle PL/SQL
- 3 day course
- Location: Torquay
- 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 ... The DBMS_OUTPUT Package
- See Training Course Details...
Associative Array Collections
Stored Functions and SQL
Package Variables
Maintaining PL/SQL Code
The Implicit (SQL) Cursor
Packages
Datatypes
Creating a Stored Procedure
The DBMS_UTILITY Package
The Cursor FOR Loop
Triggers on Views
Conditional Statements CASE
Working with LOBs
PL/SQL Variables and Datatypes
Subtypes
PL/SQL Blocks and Programs
System Triggers
Maintaining Triggers
Transact SQL
- 2 day course
- Location: Torquay
- 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 ... Filter the Queried Results
- See Training Course Details...
Modifying Data
Work with Subqueries
Update Data
Create Queries to Test Nullability
Overview of SQL Server
Manage SQL Server Constraints Writing SELECT Queries
Work with System Catalog Views Optimizing Query Performance
Combine Data Using Simple Joins
Work with Data Access Technologies Implementing Stored Procedures
Insert Data
Perform Advanced Filtering Querying Data from Multiple Tables
Group and Aggregate Data Programming in T-SQL
Assign Aliases Using Queries
Work with PIVOT and UNPIVOT
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with T-SQL Statements
Overview of T-SQL
Implement Error Handling
Configure User-Defined Functions (UDF)
Work with the XML Data Type Sorting and Filtering Data
Email us about this courses
Other Torquay Enable Technology Training Courses
Excel Intermediate - Torquay Excel Training Courses
SSIS 2014 - Torquay SQL Server Integration Services Training Courses
VBA - Torquay Excel Training Courses
SSAS 2008 Torquay Training Courses
SSAS 2005 Torquay Training Courses
SSAS 2017 - Torquay SQL Server Analysis Services Training Courses
Access 2016 - Torquay Access Training Courses
Crystal 2011 Torquay Training Courses
DAX Torquay Training Courses
SSRS 2005 Torquay Training Courses
Crystal 2008 - Torquay Crystal Reports Training Courses
Power BI Torquay Training Courses
SSIS 2005 Torquay Training Courses
Crystal XI Torquay Training Courses
SSRS 2008 - Torquay SQL Server Reporting Services Training Courses
South West - Possible SQL Training Course Locations
Somerset SQL Training Courses
Cheltenham SQL Training Courses
Bath SQL Training Courses
Wells SQL Training Courses
Exeter SQL Training Courses
Chippenham SQL Training Courses
Christchurch SQL Training Courses
Torquay SQL Training Courses
Trowbridge SQL Training Courses
Wiltshire SQL Training Courses
Devon SQL Training Courses
Taunton SQL Training Courses
Tewkesbury SQL Training Courses
Swindon SQL Training Courses
Gloucester SQL Training Courses
Bristol SQL Training Courses
Stroud SQL Training Courses
Yoevil SQL Training Courses
Cirencester SQL Training Courses
Bournemouth SQL Training Courses
Poole SQL Training Courses
Dorset SQL Training Courses
Gloucestershire SQL Training Courses
Weymouth SQL Training Courses
Dorchester SQL Training Courses
Salisbury SQL Training Courses
South West SQL Training Courses
Plymouth SQL Training Courses
Somerset, Cheltenham, Bath, Wells, Exeter, Chippenham, Christchurch, Torquay, Trowbridge, Wiltshire, Devon, Taunton, Tewkesbury, Swindon, Gloucester, Bristol, Stroud, Yoevil, Cirencester, Bournemouth, Poole, Dorset, Gloucestershire, Weymouth, Dorchester, Salisbury, South West, Plymouth