SQL TRAINING COURSES LEICESTER
About Enable Technology Leicester SQL Training Courses
We offer intensive two and three days SQL courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive SQL training materials and practice files which are theirs to refer to after the course. 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 training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Leicester. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Canadian High Commission, Keele University, Loughborough University, Yell Group PLC, Unipart Group, Nationwide Building Society Limited, Fujistu PLC and University of Birmingham.
Transact SQL
- 2 day course
- Location: Leicester
- 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 Dynamic SQL Working with Subqueries and Table Expressions
- See Training Course Details...
Manage Triggers
Write CASE Expressions Working with SQL Data Types
Create Queries to Test Nullability
Manage Stored Procedures
Work with PIVOT and UNPIVOT
Work with System Databases
Work with Predicates
Control Program Flow
Create Queries Using Built-in Functions
Perform Advanced Filtering Querying Data from Multiple Tables
Filter the Queried Results
Work with Grouping Sets Managing Error Handling and Transactions
Configure User-Defined Functions (UDF)
Manage SQL Server Constraints Writing SELECT Queries
Manage Views
Work with Data Access Technologies Implementing Stored Procedures
Combine Data Using Simple Joins
Work with Window Functions
Configure Indexes
Work with SSPs and SMOs
Oracle PL/SQL
- 3 day course
- Location: Leicester
- 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 ... PL/SQL Stored Program Compilation
- See Training Course Details...
Associative Array Collections
Using Nested TABLEs
Triggers on Views
Cascading Triggers and Mutating Tables
Exception Handlers
External LOBs
Conditional Statements IF/THEN
The UTL_FILE Package
PL/SQL Variables and Datatypes
Fetching Rows
Records and Collections
FORALL Statement
Packages
Record Variables
Loops
Exception Handling
Calling a Stored Procedure
Large Object Types
Oracle SQL
- 2 day course
- Location: Leicester
- 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 ... The EXISTS Operator
- See Training Course Details...
Joining Tables
Sample Database
Updatable Views
Tailoring Your SQL*Plus Environment
Viewing Table Characteristics
The CASE...WHEN Expression
Intervals
Literal Values
Datatypes
Relational Database and SQL Overview
Aggregate Functions and Advanced Techniques
Subqueries
SQL*Plus
Datatypes
The Aggregate Functions
Self Joins
Using SQL Functions
Running SQL*Plus Scripts
SQL
- 2 day course
- Location: Leicester
- 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 ... Concatenation
- See Training Course Details...
Checking for NULL
The LIKE Operator
Columns
WHERE and ORDER BY
Datatypes
CASE syntax
Calculated Fields
Dropping Stored Procedures
Whitespace and Semi-colons
Aliases
Table Aliases
Sorting Records
Data Types
Mathematical Calculations
Using CASE Inserting, Updating and Deleting Records
Foreign Keys
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Leicester
- 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 ... Secure Databases Working with MDS and Windows Azure
- See Training Course Details...
Perform Transformation Tasks
Cleanse Data Using DQS Managing SSIS Package Execution
Install Integration Services Working with Integration Services
Overview of Data Warehouse Components
Execute SSIS Packages on the Server
Work with MDS Databases
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Debugging and Troubleshooting Packages
Introduction to Data Warehouses
Create Dimensions
Secure Packages
Create Fact Tables
Deploy a Control Flow
Examine Data Warehousing Concepts
Track Changed Data Managing Data Flow
Execute Packages from Different Control Flow Working with Dynamic Variables
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Package Templates Implementing Data Flow
Deploy SSIS Packages
Email us about this courses
Other Leicester Enable Technology Training Courses
Excel Power Pivot - Leicester Excel Training Courses
JavaScript Leicester Training Courses
JQuery - Leicester JavaScript Training Courses
Report Builder Leicester Training Courses
Access Leicester Training Courses
JQuery Mobile - Leicester JavaScript Training Courses
DAX - Leicester Excel Training Courses
Access VBA Leicester Training Courses
SSAS Tabular - Leicester SQL Server Analysis Services Training Courses
Excel 365 Advanced Leicester Training Courses
Power Query - Leicester Excel Training Courses
SSRS - Leicester SQL Server Reporting Services Training Courses
VBA - Leicester Excel Training Courses
Excel 365 Intermediate - Leicester Excel Training Courses
Power BI Leicester Training Courses