SQL TRAINING COURSES CROSBY
About Enable Technology Crosby SQL Training Courses
Enable Technology provides practical SQL skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away SQL courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our SQL courses. Delegates can contact the course tutor with specific SQL questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. Our delivery method during the Covid 19 period is online virtual classrooms. 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 SQL course exercises. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham Heartlands Hospital, Vodafone Group Services, Queen's Medical Centre Nottingham, Carillion PLC, Shell UK Oil Products Ltd, Loughborough University, University of Birmingham and Keele University.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Crosby
- 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 ... Create an SSIS Project
- See Training Course Details...
Add Script Tasks and Script Components to an SSIS Package
Examine MSI Packages
Secure Packages
Create Fact Tables
Work with MDS Databases
Create Expressions with Variables
Add Data Flow Components to a Data Flow Task
Debug Package Execution Components
Overview of Data Warehouses
Create Package Templates Implementing Data Flow
Secure Databases Working with MDS and Windows Azure
Configure MDS
Configure the Package Execution Strategy
Perform Transformation Tasks
Track Changed Data Managing Data Flow
Install Integration Services Working with Integration Services
Deploy SSIS Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Debugging and Troubleshooting Packages
Oracle SQL
- 2 day course
- Location: Crosby
- 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 ... Regular Expression Functions
- See Training Course Details...
Relational Database and SQL Overview
SQL Functions
Concurrency
Other Database Objects
SQL Queries - Joins
Sequences
Compound Expressions
Date Formats
Aggregate Functions and Advanced Techniques
Sample Database
Interactive SQL*Plus Scripts
Inline Constraints
Running SQL*Plus Scripts
String Functions
Creating Views
Defining Tables
Datatypes
Transact SQL
- 2 day course
- Location: Crosby
- 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 ... Work with SSPs and SMOs
- See Training Course Details...
Manage Query Plans
Sort the Queried Data
Work with String and Numeric Data Types
Merge Data Working with SQL Server Built-in Functions
Delete Data
Work with Grouping Sets Managing Error Handling and Transactions
Configure User-Defined Functions (UDF)
Work with Date and Time Data Types
Create Queries to Test Nullability
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Variables and Batches
Write SELECT Statements
Manage Triggers
Overview of T-SQL
Update Data
Work with Binary Data Types
Create Queries Using Built-in Functions
Write CASE Expressions Working with SQL Data Types
Combine Data Using Simple Joins
Analyze Data from Query Plans
SQL
- 2 day course
- Location: Crosby
- 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 ... Popular Databases
- See Training Course Details...
Common Date Functions Subqueries, Joins and Unions
Tables
Grouping and Aggregating Data
Common String Functions
Checking for Equality
Case Sensitivity
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Aliases
Creating Stored Procedures
Table Aliases
Stored Procedures
Data Types
Sorting Records
Relational Database Management System
Dropping Views
Relational Databases
Selecting Specific Columns
Oracle PL/SQL
- 3 day course
- Location: Crosby
- 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 ... FORALL Statement
- See Training Course Details...
The PL/SQL Execution Environment
The DBMS_METADATA Package
Using Nested TABLEs
Selecting into a Variable
The DBMS_LOB Package
Parameter Modes
Oracle Directories
Nesting Blocks
Closing Cursors
Procedures and Functions
The Cursor FOR Loop
Conditional Statements IF/THEN
Date Intervals
Named Parameter Notation
Stored Procedures and Functions
Collection Methods
Records and Collections
Other Supplied Packages
Email us about this courses
Other Crosby Enable Technology Training Courses
CSS - Crosby Web Development Training Courses
Crystal 2008 - Crosby Crystal Reports Training Courses
VBA - Crosby Excel Training Courses
SSIS 2005 Crosby Training Courses
Microsoft Project Level 3 Crosby Training Courses
HTML Crosby Training Courses
Oracle BI Crosby Training Courses
Power Graphics Crosby Training Courses
Access VBA Crosby Training Courses
SSIS 2008 Crosby Training Courses
Crystal 2013 - Crosby Crystal Reports Training Courses
PowerPoint Basic Crosby Training Courses
DAX Crosby Training Courses
Data Mining Crosby Training Courses
JQuery Mobile Crosby Training Courses
North West - Possible SQL Training Course Locations
Carlisle, Sale, Lytham Urmston, Runcorn, Stockport, Southport, Merseyside, Eccles, North West, Blackburn, Leyland, Rochdale, Leigh, Manchester, Preston, Oldham, Altrincham, Huyton, Denton, Chester, Accrington, Bury, Wigan, Barrow-in-Furness, Kirkby, Prestwich, Warrington, Bootle, Blackpool, Birkenhead, Northwich, Skelmersdale, Middleton, Bolton, Liverpool, Lancaster, Burnley, Macclesfield, Crewe, Cheshire, Farnworth, Winsford, Chorley, Lancashire, Thornton-Cleveleys, Crosby, Wythenshawe, Saddleworth, Widnes, Salford, Ashton-under-Lyne, Hyde, Chadderton, Morecambe, Wallasey, Ellesmere Port, Stretford