SQL TRAINING COURSES REDDITCH
About Enable Technology Redditch SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given SQL courseware which they can refer to after the training. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver SQL training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Redditch. 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Yell Group PLC, Birmingham City Council, Lloyds TSB Bank PLC, DHL Express, Total Telecommunications Limited, GKN PLC, Royal & Sun Alliance Group PLC and Fujistu PLC.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Redditch
- 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 ... Perform Transformation Tasks
- See Training Course Details...
Add Data Flow Components to a Data Flow Task
Secure Databases Working with MDS and Windows Azure
Execute Packages from Different Control Flow Working with Dynamic Variables
Overview of Data Warehouses
Configure the Package Execution Strategy
Add Packages to an SSIS Project Managing Control Flow
Track Changed Data Managing Data Flow
Work with Windows Azure
Create Fact Tables
Configure MDS
Work with MDS Databases
Create Expressions with Variables
Debugging and Troubleshooting Packages
Create an SSIS Project
Introduction to Data Warehouses
Create Package Templates Implementing Data Flow
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Change Granularity Creating Fact Tables and Columnstore Indexes
SQL
- 2 day course
- Location: Redditch
- 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 ... DELETE
- See Training Course Details...
Outer Joins
Sorting By a Single Column
Whitespace and Semi-colons
Adding and Dropping Columns
Creating Views
Sorting Records
Simple SELECT Statements
Creating and Modifying Tables
Sorting By Multiple Columns
Creating Tables
The WHERE Clause and Operator Words
Dropping Stored Procedures
Common Math Functions
Conditional Processing with CASE
Using CASE Inserting, Updating and Deleting Records
Order of Evaluation Advanced SELECTs
Mathematical Calculations
Transact SQL
- 2 day course
- Location: Redditch
- Telephone on 01952 938014
- Course Outline
-
In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database. You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server error handling features.
The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.
- Some of the training topics covered include ... Work with Window Functions
- See Training Course Details...
Manage Transactions Querying SQL Server System Metadata
Update Data
Work with PIVOT and UNPIVOT
Work with String and Numeric Data Types
Perform Advanced Filtering Querying Data from Multiple Tables
Configure User-Defined Functions (UDF)
Write SELECT Statements
Manage SQL Server Constraints Writing SELECT Queries
Work with Date and Time Data Types
Work with System Catalog Views Optimizing Query Performance
Manage Triggers
Delete Data
Group and Aggregate Data Programming in T-SQL
Filter the Queried Results
Work with Binary Data Types
Manage Query Plans
Create Queries Using Built-in Functions
Insert Data
Work with SSMS Working with T-SQL
Manage Stored Procedures
Oracle PL/SQL
- 3 day course
- Location: Redditch
- 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 ... Cascading Triggers and Mutating Tables
- See Training Course Details...
Dependencies and Validation
Internal LOBs
The PL/SQL Execution Environment
Record Variables
External LOBs
Character Data
Compile-Time Warnings
The Implicit (SQL) Cursor
The DBMS_OUTPUT Package
Closing Cursors
The UTL_FILE Package
Triggers
Scope and Name Resolution
Exception Handling
The Package Interface and Implementation
Types of Triggers
Multi-Row Queries
Generating an Error
SQLCODE and SQLERRM
Oracle SQL
- 2 day course
- Location: Redditch
- 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 ... Buffer Manipulation Commands
- See Training Course Details...
Explicit Locking
SQL*Plus LOB Support
Other Database Objects
Data Manipulation and Transactions
Running SQL*Plus Scripts
Creating Views
Joining Tables
SQL Queries - Joins
Interactive SQL*Plus Scripts
Compound Expressions
The INSERT Statement
Selecting from Multiple Tables
Correlated Subqueries
Tailoring Your SQL*Plus Environment
Outer Joins
Using SQL Functions
SQL Queries
Loading Tables From External Sources
Concurrency
IN and BETWEEN
Email us about this courses
Other Redditch Enable Technology Training Courses
SSIS Redditch Training Courses
DAX Redditch Training Courses
Report Builder - Redditch SQL Server Reporting Services Training Courses
Excel 365 Advanced Redditch Training Courses
Power Query Redditch Training Courses
JQuery Redditch Training Courses
Excel 365 Basic - Redditch Excel Training Courses
SSRS - Redditch SQL Server Reporting Services Training Courses
SSAS Tabular - Redditch SQL Server Analysis Services Training Courses
JQuery Mobile - Redditch JavaScript Training Courses
Access VBA - Redditch Access Training Courses
Excel 365 Intermediate Redditch Training Courses
Access - Redditch Access Training Courses
SSAS Redditch Training Courses
Excel Power Pivot - Redditch Excel Training Courses