SQL TRAINING COURSES LICHFIELD
About Enable Technology Lichfield SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. 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. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver SQL courses at your site. If you prefer we can offer an offsite training location in Lichfield. We will work with you prior to the course to tailor the SQL syllabus to match your requirements.
SQL courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Capita Group PLC, Royal Air Force, EDF Energy PLC, Lloyds TSB Bank PLC, Nuclear Engineering Services, Birmingham Heartlands Hospital, Keele University and Royal & Sun Alliance Group PLC.
SQL
- 2 day course
- Location: Lichfield
- 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 ... Dropping Tables
- See Training Course Details...
Adding and Dropping Columns
Relational Database Management System
Aliases
Common Date Functions Subqueries, Joins and Unions
Common String Functions
Selecting Specific Columns
Simple SELECT Statements
Relational Databases
Foreign Keys
Sorting By a Single Column
Outer Joins
Renaming Tables
DELETE
Oracle PL/SQL
- 3 day course
- Location: Lichfield
- 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 ... PL/SQL Blocks and Programs
- See Training Course Details...
Iterating Through Collections
Calling a Stored Function
Datatypes
Calling a Stored Procedure
Cursors
Declaring Variables
The DBMS_LOB Package
REF CURSOR Variables
Networking Packages
Procedures and Functions
Temporary LOBs
Beyond Declarative Integrity
Selecting into a Variable
Stored Procedures and Functions
Internal LOBs
Structure of a Package
Other Supplied Packages
Maintaining Triggers
Transact SQL
- 2 day course
- Location: Lichfield
- Telephone on 01952 938014
- Course Outline
-
In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database. You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server error handling features.
The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.
- Some of the training topics covered include ... Modifying Data
- See Training Course Details...
Manage Query Plans
Create Queries to Test Nullability
Merge Data Working with SQL Server Built-in Functions
Work with System Catalog Views Optimizing Query Performance
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Configure User-Defined Functions (UDF)
Analyze Data from Query Plans
Assign Aliases Using Queries
Work with Variables and Batches
Filter the Queried Results
Work with Dynamic SQL Working with Subqueries and Table Expressions
Group and Aggregate Data Programming in T-SQL
Manage SQL Server Constraints Writing SELECT Queries
Delete Data
Update Data
Work with Data Access Technologies Implementing Stored Procedures
Work with Grouping Sets Managing Error Handling and Transactions
Manage Views
Work with Set Operators
Write SELECT Statements
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Lichfield
- 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 ... Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
- See Training Course Details...
Execute SSIS Packages on the Server
Execute Packages from Different Control Flow Working with Dynamic Variables
Securing Packages and Databases
Debug Package Execution Components
Work with MDS Databases
Track Changed Data Managing Data Flow
Work with Windows Azure
Examine MSI Packages
Create Package Templates Implementing Data Flow
Add Packages to an SSIS Project Managing Control Flow
Debugging and Troubleshooting Packages
Troubleshoot Package Failures Deploying Packages
Overview of Data Warehouses
Cleanse Data Using DQS Managing SSIS Package Execution
Install Integration Services Working with Integration Services
Create Fact Tables
Examine Data Warehousing Concepts
Add Data Flow Components to a Data Flow Task
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Oracle SQL
- 2 day course
- Location: Lichfield
- 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 ... Sample Database
- See Training Course Details...
Aggregate Functions and Advanced Techniques
Choosing Rows with the WHERE Clause
Relational Database Management Systems
Using SQL Functions
Concurrency
Views
Relational Database and SQL Overview
IN and BETWEEN
Datatypes
The EXISTS Operator
Introduction to SQL
Modifying Table Definitions
SQL*Plus LOB Support
Tailoring Your SQL*Plus Environment
Sequences
Inline Constraints
The INSERT Statement
Conversion Functions
Outer Joins
Email us about this courses
Other Lichfield Enable Technology Training Courses
Power Query - Lichfield Excel Training Courses
Power BI - Lichfield Microsoft Power BI Training Courses
Excel 365 Advanced - Lichfield Excel Training Courses
JQuery - Lichfield JavaScript Training Courses
Excel 365 Intermediate - Lichfield Excel Training Courses
SSAS - Lichfield SQL Server Analysis Services Training Courses
SSIS Lichfield Training Courses
Access - Lichfield Access Training Courses
Report Builder - Lichfield SQL Server Reporting Services Training Courses
JQuery Mobile Lichfield Training Courses
SSRS - Lichfield SQL Server Reporting Services Training Courses
Excel Power Pivot Lichfield Training Courses
JavaScript Lichfield Training Courses
Excel 365 Basic Lichfield Training Courses
Access VBA - Lichfield Access Training Courses