SQL TRAINING COURSES HALIFAX
About Enable Technology Halifax SQL Training Courses
We are a company that provides short intensive SQL training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL training participant with learning resources which they can refer to post training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL for as long as they need.
Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL courses at your site. The SQL course could also be scheduled at a socially distanced site near you in Halifax. We are happy to discuss customising the course content should you have particular SQL training requirements.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Lloyds TSB Bank PLC, Yell Group PLC, DHL Express, Vodafone Group Services, Keele University, West Bromwich Building Society and Shell UK Oil Products Ltd.
SQL
- 2 day course
- Location: Halifax
- Telephone on 01952 938014
- Course Outline
-
SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.
- Some of the training topics covered include ... Dropping Stored Procedures
- See Training Course Details...
Dropping Tables
Sorting By a Single Column
The NOT Operator
Creating Tables
Simple SELECT Statements
Aliases
NULL Values
Renaming Tables
Table Aliases
Aggregate Functions
Creating Tables
Relationships
The IN Operator
WHERE and ORDER BY
Primary Keys
The BETWEEN Operator
Benefits of Views
Oracle SQL
- 2 day course
- Location: Halifax
- 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 ... Updatable Views
- See Training Course Details...
SQL Functions
Compound Expressions
Other Database Objects
Pattern Matching: LIKE and REGEXP_LIKE
Using SQL Functions
Controlling Access to Your Tables
Deleting a Table Definition
The SELECT Statement
SQL Queries - Joins
Sequences
Views
The SQL Buffer
Literal Values
Sample Database
Combining SELECT Statements
SQL*Plus LOB Support
The Aggregate Functions
The EXISTS Operator
Creating Views
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Halifax
- 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...
Configure MDS
Create Package Templates Implementing Data Flow
Examine Data Warehousing Concepts
Work with Windows Azure
Change Granularity Creating Fact Tables and Columnstore Indexes
Debug Package Execution Components
Install Integration Services Working with Integration Services
Track Changed Data Managing Data Flow
Troubleshoot Package Failures Deploying Packages
Deploy a Control Flow
Deploy SSIS Packages
Introduction to Data Warehouses
Secure Databases Working with MDS and Windows Azure
Examine MSI Packages
Cleanse Data Using DQS Managing SSIS Package Execution
Configure the Package Execution Strategy
Add Packages to an SSIS Project Managing Control Flow
Overview of Data Warehouses
Secure Packages
Create Fact Tables
Transact SQL
- 2 day course
- Location: Halifax
- 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 ... Analyze Data from Query Plans
- See Training Course Details...
Work with SSPs and SMOs
Getting Started with SQL Server 2012
Control Program Flow
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Write SELECT Statements
Filter the Queried Results
Work with Dynamic SQL Working with Subqueries and Table Expressions
Manage Query Plans
Write CASE Expressions Working with SQL Data Types
Work with Data Access Technologies Implementing Stored Procedures
Work with System Catalog Views Optimizing Query Performance
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Create Queries Using Join Algorithms
Manage Stored Procedures
Overview of T-SQL
Delete Data
Work with Binary Data Types
Update Data
Combine Data Using Simple Joins
Insert Data
Oracle PL/SQL
- 3 day course
- Location: Halifax
- 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 ... Oracle Directories
- See Training Course Details...
Triggers
Row-Level Triggers
Parameter Modes
The DBMS_LOB Package
Calling a Stored Function
Subtypes
Overloading Package Functions and Procedures
Temporary LOBs
Cursor Parameters
Character Data
Exception Handling
Privileges for Stored Programs
Associative Array Collections
Dependencies and Validation
The PL/SQL Execution Environment
Scope and Name Resolution
Internal LOBs
Networking Packages
Oracle-Supplied Packages
Email us about this courses
Other Halifax Enable Technology Training Courses
Access VBA - Halifax Access Training Courses
Excel 365 Basic - Halifax Excel Training Courses
Power BI Halifax Training Courses
DAX - Halifax Excel Training Courses
JQuery Mobile Halifax Training Courses
SSRS - Halifax SQL Server Reporting Services Training Courses
Access Halifax Training Courses
Excel 365 Advanced Halifax Training Courses
SSAS Halifax Training Courses
Report Builder - Halifax SQL Server Reporting Services Training Courses
SSIS Halifax Training Courses
Excel 365 Intermediate Halifax Training Courses
JavaScript - Halifax JavaScript Training Courses
Power Query - Halifax Excel Training Courses
Excel Power Pivot Halifax Training Courses