SQL TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter SQL Training Courses
We offer intensive two and three days SQL courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. SQL courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver SQL courses onsite at your site. If delivery onsite is an issue we will organise a venue near you in Uttoxeter. 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Nuclear Engineering Services, Vodafone Group Services, Boots UK Limited, Barclays Bank PLC, Canadian High Commission, Aston University, Halfords Group PLC and Birmingham City Council.
Oracle PL/SQL
- 3 day course
- Location: Uttoxeter
- 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 ... Maintaining Stored Programs
- See Training Course Details...
WHILE and FOR Loops
Date Intervals
Selecting into a Variable
Generating an Error
Large Object Types
Oracle-Supplied Packages
Oracle Directories
Creating Packages
Associative Array Collections
LOB Locators
SQLCODE and SQLERRM
Passing Parameters and Default Arguments
Character Data
Triggers on Views
The Implicit (SQL) Cursor
Using Packages
Package Variables
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Uttoxeter
- 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 ... Overview of Data Warehouse Components
- See Training Course Details...
Debug Package Execution Components
Examine MSI Packages
Work with Windows Azure
Create Dimensions
Configure MDS
Deploy a Control Flow
Create Package Templates Implementing Data Flow
Change Granularity Creating Fact Tables and Columnstore Indexes
Execute Packages from Different Control Flow Working with Dynamic Variables
Add Packages to an SSIS Project Managing Control Flow
Deploy SSIS Packages
Create Fact Tables
Add Script Tasks and Script Components to an SSIS Package
Secure Packages
Troubleshoot Package Failures Deploying Packages
Perform Transformation Tasks
Create an SSIS Project
Securing Packages and Databases
Debugging and Troubleshooting Packages
SQL
- 2 day course
- Location: Uttoxeter
- 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 ... Using the WHERE clause to check for greater or less than
- See Training Course Details...
Table Aliases
Dropping Tables
The LIKE Operator
Concatenation
Creating and Modifying Tables
Benefits of Views
Sorting By a Single Column
Mathematical Calculations
Creating Tables
Checking for Inequality
Relational Database Management System
Foreign Keys
Renaming Tables
Data Types
Simple SELECT Statements
Benefits of Stored Procedures
Case Sensitivity
Selecting All Columns in All Rows
Transact SQL
- 2 day course
- Location: Uttoxeter
- 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 ... Overview of T-SQL
- See Training Course Details...
Implement Error Handling
Sort the Queried Data
Work with Window Functions
Create Queries to Test Nullability
Filter the Queried Results
Work with the XML Data Type Sorting and Filtering Data
Overview of SQL Server
Work with Set Operators
Work with Predicates
Combine Data Using Simple Joins
Work with String and Numeric Data Types
Getting Started with SQL Server 2012
Configure User-Defined Functions (UDF)
Manage Triggers
Modifying Data
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Insert Data
Work with Data Access Technologies Implementing Stored Procedures
Write CASE Expressions Working with SQL Data Types
Work with PIVOT and UNPIVOT
Oracle SQL
- 2 day course
- Location: Uttoxeter
- 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 ... Controlling Access to Your Tables
- See Training Course Details...
Compound Expressions
Scalar Functions
The CASE...WHEN Expression
Constraints
NULL Values
IN and BETWEEN
SQL*Plus Substitution Variables
Deleting a Table Definition
Transaction Management
SQL*Plus
Pattern Matching: LIKE and REGEXP_LIKE
Subqueries
SQL Queries
Relational Database and SQL Overview
Datatypes
Outer Joins
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
SSRS Uttoxeter Training Courses
Power Query Uttoxeter Training Courses
SSAS Tabular - Uttoxeter SQL Server Analysis Services Training Courses
Excel 365 Advanced - Uttoxeter Excel Training Courses
Excel 365 Intermediate - Uttoxeter Excel Training Courses
JavaScript Uttoxeter Training Courses
Excel 365 Basic Uttoxeter Training Courses
Report Builder Uttoxeter Training Courses
DAX - Uttoxeter Excel Training Courses
Power BI Uttoxeter Training Courses
Access VBA Uttoxeter Training Courses
Excel Power Pivot - Uttoxeter Excel Training Courses
SSIS - Uttoxeter SQL Server Integration Services Training Courses
SSAS - Uttoxeter SQL Server Analysis Services Training Courses
JQuery - Uttoxeter JavaScript Training Courses