SQL TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. 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. We can set up a training lab at your premises and deliver SQL courses onsite at your site. We are also more than happy to organise a local course at a training location in Sheffield. The SQL syllabus can be adjusted and additional topics incorporated if helpful.
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 been delivering technical training in the Midlands for twenty years. Our clients include: Yell Group PLC, Halfords Group PLC, Barclays Bank PLC, West Bromwich Building Society, Nationwide Building Society Limited, Canadian High Commission, Capita Group PLC and Royal Air Force.
Oracle PL/SQL
- 3 day course
- Location: Sheffield
- 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 ... Maintaining PL/SQL Code
- See Training Course Details...
Selecting into a Variable
Temporary LOBs
Using VARRAYs
User-Defined Exceptions
Associative Array Collections
Triggers
PL/SQL Syntax and Logic
Fetching Rows
Compile-Time Warnings
Privileges for Stored Programs
XML Packages
Row-Level Triggers
Types of Triggers
Triggers
Internal LOBs
Oracle Directories
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Sheffield
- 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 ... Execute SSIS Packages on the Server
- See Training Course Details...
Add Script Tasks and Script Components to an SSIS Package
Install Integration Services Working with Integration Services
Work with Windows Azure
Track Changed Data Managing Data Flow
Overview of Data Warehouses
Debug Package Execution Components
Examine MSI Packages
Add Data Flow Components to a Data Flow Task
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Examine Data Warehousing Concepts
Configure MDS
Secure Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Deploy SSIS Packages
Overview of Data Warehouse Components
Create an SSIS Project
Work with MDS Databases
Deploy a Control Flow
Debugging and Troubleshooting Packages
SQL
- 2 day course
- Location: Sheffield
- Telephone on 01952 938014
- Course Outline
-
This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.
- Some of the training topics covered include ... Aggregate Functions
- See Training Course Details...
Datatypes
Dropping Stored Procedures
The IN Operator
Sorting By Column Position
Benefits of Views
Columns
Tables
Foreign Keys
Common Date Functions Subqueries, Joins and Unions
Sorting Records
Concatenation
Conditional Processing with CASE
Common String Functions
Relational Databases
The BETWEEN Operator
Calculated Fields
Relational Database Management System
Oracle SQL
- 2 day course
- Location: Sheffield
- 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 ... SQL Functions
- See Training Course Details...
Relational Database Management Systems
Outer Joins
Introduction to SQL
The INSERT Statement
Running SQL*Plus Scripts
Data Manipulation and Transactions
Controlling Access to Your Tables
Creating Views
Viewing Table Characteristics
Sequences
SQL*Plus LOB Support
Conversion Functions
Regular Expression Functions
Date Formats
Correlated Subqueries
Choosing Rows with the WHERE Clause
The SELECT Statement
Nulls and DISTINCT
Transact SQL
- 2 day course
- Location: Sheffield
- 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 ... Create Queries Using Join Algorithms
- See Training Course Details...
Work with Variables and Batches
Configure Indexes
Sort the Queried Data
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Grouping Sets Managing Error Handling and Transactions
Combine Data Using Simple Joins
Assign Aliases Using Queries
Work with Data Access Technologies Implementing Stored Procedures
Work with System Databases
Work with Window Functions
Write SELECT Statements
Manage Query Plans
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Implement Error Handling
Work with SSPs and SMOs
Manage Triggers
Write CASE Expressions Working with SQL Data Types
Manage Stored Procedures
Delete Data
Analyze Data from Query Plans
Email us about this courses
Other Sheffield Enable Technology Training Courses
DAX - Sheffield Excel Training Courses
SSAS Tabular - Sheffield SQL Server Analysis Services Training Courses
JQuery Sheffield Training Courses
VBA - Sheffield Excel Training Courses
Excel 365 Basic Sheffield Training Courses
Excel 365 Advanced - Sheffield Excel Training Courses
JQuery Mobile Sheffield Training Courses
Excel 365 Intermediate Sheffield Training Courses
Power Query - Sheffield Excel Training Courses
SSAS Sheffield Training Courses
Power BI - Sheffield Microsoft Power BI Training Courses
Excel Power Pivot - Sheffield Excel Training Courses
Access VBA Sheffield Training Courses
SSRS - Sheffield SQL Server Reporting Services Training Courses
Access Sheffield Training Courses