SQL TRAINING COURSES WARRINGTON
About Enable Technology Warrington SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a SQL course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the SQL course can contact the tutor for as long as they like if they encounter SQL problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver SQL courses at your site. We also offer the option of scheduling of SQL course at a venue near you in Warrington. The SQL syllabus can be adjusted and additional topics incorporated if helpful.
SQL courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Lloyds TSB Bank PLC, TalkTalk Direct Limited, Canadian High Commission, Shell UK Oil Products Ltd, Aston University, Fujistu PLC, Yell Group PLC and Carillion PLC.
Oracle PL/SQL
- 3 day course
- Location: Warrington
- 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 ... Character Data
- See Training Course Details...
FORALL Statement
Maintaining Triggers
Oracle Directories
Maintaining Stored Programs
Using the %ROWTYPE Attribute
VARRAY and Nested TABLE Collections
External LOBs
Record Variables
Creating Packages
Triggers
Scope and Name Resolution
Date Intervals
Packages
Overloading Package Functions and Procedures
Exception Handlers
Stored Functions and SQL
System Triggers
Calling a Stored Procedure
Comments and Labels
Oracle SQL
- 2 day course
- Location: Warrington
- 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 ... Data Definition and Control Statements
- See Training Course Details...
Data Manipulation and Transactions
Transaction Management
SQL*Plus
Oracle Pseudocolumns
Correlated Subqueries
Interactive SQL*Plus Scripts
SQL*Plus Substitution Variables
SQL Queries
Using SQL Functions
Review of Relational Database Terminology
Date Functions
Joining Tables
Modifying Table Definitions
Creating Views
NULL Values
Buffer Manipulation Commands
Pattern Matching: LIKE and REGEXP_LIKE
SQL*Plus LOB Support
Numeric Functions
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Warrington
- 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 ... Deploy SSIS Packages
- See Training Course Details...
Add Packages to an SSIS Project Managing Control Flow
Troubleshoot Package Failures Deploying Packages
Profile OLTP Data
Work with Windows Azure
Execute Packages from Different Control Flow Working with Dynamic Variables
Secure Databases Working with MDS and Windows Azure
Debug Package Execution Components
Create Fact Tables
Overview of Data Warehouse Components
Perform Transformation Tasks
Create Expressions with Variables
Introduction to Data Warehouses
Create Dimensions
Examine MSI Packages
Create Package Templates Implementing Data Flow
Deploy a Control Flow
Install Integration Services Working with Integration Services
Overview of Data Warehouses
Add Data Flow Components to a Data Flow Task
SQL
- 2 day course
- Location: Warrington
- Telephone on 01952 938014
- Course Outline
-
This practical hands on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.
- Some of the training topics covered include ... WHERE and ORDER BY
- See Training Course Details...
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Relationships
Dropping Stored Procedures
Checking for Inequality
Benefits of Stored Procedures
Case Sensitivity
Creating Stored Procedures
Primary Keys
Adding and Dropping Columns
The WHERE Clause and Operator Words
Checking for Equality
DELETE
Data Types
Creating and Modifying Tables
Transact SQL
- 2 day course
- Location: Warrington
- 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 Binary Data Types
- See Training Course Details...
Work with Date and Time Data Types
Work with Window Functions
Assign Aliases Using Queries
Work with the XML Data Type Sorting and Filtering Data
Create Queries Using Join Algorithms
Manage Views
Filter the Queried Results
Analyze Data from Query Plans
Overview of SQL Server
Work with PIVOT and UNPIVOT
Insert Data
Manage Triggers
Work with System Databases
Create Queries to Test Nullability
Overview of T-SQL
Work with Variables and Batches
Configure User-Defined Functions (UDF)
Modifying Data
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with String and Numeric Data Types
Email us about this courses
Other Warrington Enable Technology Training Courses
Power BI Warrington Training Courses
Access Warrington Training Courses
JQuery Mobile Warrington Training Courses
JQuery - Warrington JavaScript Training Courses
SSIS Warrington Training Courses
SSAS - Warrington SQL Server Analysis Services Training Courses
SSRS Warrington Training Courses
DAX - Warrington Excel Training Courses
SSAS Tabular - Warrington SQL Server Analysis Services Training Courses
JavaScript - Warrington JavaScript Training Courses
Excel 365 Advanced Warrington Training Courses
VBA Warrington Training Courses
Excel 365 Basic Warrington Training Courses
Report Builder Warrington Training Courses
Excel Power Pivot Warrington Training Courses