SQL TRAINING COURSES STOCKPORT
About Enable Technology Stockport SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL course will be provided with training materials and practice files to retain after the course. 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. This taught SQL course is available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic. Every SQL course can me modified to meet your bespoke requirements.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Loughborough University, TalkTalk Direct Limited, Norwich Union PLC, Nuclear Engineering Services, Dollond & Aitchison Limited, Capita Group PLC, EDF Energy PLC and Boots UK Limited.
Transact SQL
- 2 day course
- Location: Stockport
- Telephone on 01952 305730
- 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...
Create Queries Using Built-in Functions
Combine Data Using Simple Joins
Work with SSPs and SMOs
Merge Data Working with SQL Server Built-in Functions
Work with Subqueries
Manage Views
Sort the Queried Data
Work with Set Operators
Work with T-SQL Statements
Work with Window Functions
Work with Binary Data Types
Assign Aliases Using Queries
Configure User-Defined Functions (UDF)
Work with String and Numeric Data Types
Insert Data
Work with Dynamic SQL Working with Subqueries and Table Expressions
Manage Triggers
Work with Variables and Batches
Write SELECT Statements
Create Queries Using Join Algorithms
Oracle PL/SQL
- 3 day course
- Location: Stockport
- Telephone on 01952 305730
- 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...
Anchored Types
FOR UPDATE Cursors
Records and Collections
Local Procedures and Functions
Procedures and Functions
Maintaining Stored Programs
Record Variables
Conditional Statements CASE
Associative Array Collections
Triggers
Generating an Error
Declaring Variables
Oracle Directories
Maintaining Triggers
The PL/SQL Execution Environment
PL/SQL Syntax and Logic
The Package Interface and Implementation
Creating a Stored Function
Closing Cursors
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Stockport
- Telephone on 01952 305730
- 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 ... Execute SSIS Packages on the Server
- See Training Course Details...
Secure Databases Working with MDS and Windows Azure
Examine Data Warehousing Concepts
Configure the Package Execution Strategy
Secure Packages
Deploy a Control Flow
Install Integration Services Working with Integration Services
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Expressions with Variables
Perform Transformation Tasks
Change Granularity Creating Fact Tables and Columnstore Indexes
Overview of Data Warehouse Components
Create an SSIS Project
Work with Windows Azure
Debug Package Execution Components
Introduction to Data Warehouses
Add Packages to an SSIS Project Managing Control Flow
Create Fact Tables
Overview of Data Warehouses
Add Script Tasks and Script Components to an SSIS Package
Oracle SQL
- 2 day course
- Location: Stockport
- Telephone on 01952 305730
- 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 ... Tailoring Your SQL*Plus Environment
- See Training Course Details...
Numeric Functions
Defining Tables
The INSERT Statement
The SQL Buffer
Data Definition and Control Statements
Concurrency
Using SQL Functions
Data Inconsistencies
Logical and Physical Storage Structures
Grouping Rows
Modifying Table Definitions
Sequences
Data Manipulation and Transactions
Scalar Functions
Constraints
Inline Constraints
The SELECT Statement
Creating Views
SQL
- 2 day course
- Location: Stockport
- Telephone on 01952 305730
- 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 ... Sorting Records
- See Training Course Details...
Checking for Inequality
Sorting By Multiple Columns
Dropping Tables
Multi-table Joins
Creating Tables
Creating and Modifying Tables
Renaming Tables
Tables
Checking for Equality
Calculated Fields
Common Math Functions
Checking for NULL
The NOT Operator
Conditional Processing with CASE
Concatenation
CASE syntax
Email us about this courses
Other Stockport Enable Technology Training Courses
JQuery - Stockport JavaScript Training Courses
SSIS 2008 Stockport Training Courses
SSAS 2008 - Stockport SQL Server Analysis Services Training Courses
Project 2016 L1 Stockport Training Courses
Project 2016 - Stockport Microsoft Project Training Courses
CSS Stockport Training Courses
Visio 2013 - Stockport Visio Training Courses
SSAS 2017 Stockport Training Courses
Access 2016 Stockport Training Courses
Excel Basic - Stockport Excel Training Courses
SSRS 2008 - Stockport SQL Server Reporting Services Training Courses
SSRS 2014 Stockport Training Courses
Excel Power Pivot - Stockport Excel Training Courses
Crystal 2013 - Stockport Crystal Reports Training Courses
Power BI Stockport Training Courses
North West - Possible SQL Training Course Locations
Chadderton, Crosby, Ellesmere Port, Burnley, Birkenhead, Bury, Rochdale, Preston, Southport, Northwich, Accrington, Leyland, Wythenshawe, Oldham, Middleton, Bootle, Manchester, Widnes, Lytham Urmston, Winsford, Stretford, Chester, Lancashire, Denton, Kirkby, Carlisle, Wallasey, Farnworth, Leigh, Hyde, Bolton, Salford, Eccles, Prestwich, Sale, Macclesfield, North West, Ashton-under-Lyne, Liverpool, Runcorn, Barrow-in-Furness, Wigan, Altrincham, Huyton, Thornton-Cleveleys, Skelmersdale, Merseyside, Cheshire, Stockport, Warrington, Crewe, Chorley, Saddleworth, Blackpool, Blackburn, Morecambe, Lancaster