SQL TRAINING COURSES BURTON ON TRENT
About Enable Technology Burton On Trent SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL resources which they can continue to use after the 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.
Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver SQL courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the SQL course is at a local socially distanced training site. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations training requirements.
Taught SQL courses are also 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Norfolk Police Constabulary, South Staffordshire Water PLC, Yell Group PLC, Total Telecommunications Limited, Unipart Group, Dollond & Aitchison Limited, Aston University and Nationwide Building Society Limited.
Oracle SQL
- 2 day course
- Location: Burton On Trent
- 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 ... Oracle Versioning and History
- See Training Course Details...
SQL*Plus Substitution Variables
Relational Database Management Systems
Aggregate Functions and Advanced Techniques
Buffer Manipulation Commands
SQL Functions
Datatypes
Choosing Rows with the WHERE Clause
NULL Values
Modifying Table Definitions
Pattern Matching: LIKE and REGEXP_LIKE
Sample Database
Literal Values
Updatable Views
SQL*Plus LOB Support
Date Formats
Explicit Locking
Connecting to a SQL Database
Oracle PL/SQL
- 3 day course
- Location: Burton On Trent
- 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 ... System Triggers
- See Training Course Details...
Subtypes
Using Packages
Iterating Through Collections
The DBMS_OUTPUT Package
Overloading Package Functions and Procedures
Character Data
Types of Triggers
Large Object Types
Exception Handlers
Cursors
Associative Array Collections
Selecting into a Variable
Calling a Stored Procedure
Row-Level Triggers
Oracle Directories
Creating Packages
Transact SQL
- 2 day course
- Location: Burton On Trent
- 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 ... Configure User-Defined Functions (UDF)
- See Training Course Details...
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Manage Views
Write SELECT Statements
Manage Query Plans
Work with System Databases
Assign Aliases Using Queries
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Create Queries Using Built-in Functions
Control Program Flow
Update Data
Getting Started with SQL Server 2012
Work with Predicates
Work with SSMS Working with T-SQL
Work with SSPs and SMOs
Overview of SQL Server
Perform Advanced Filtering Querying Data from Multiple Tables
Modifying Data
Work with String and Numeric Data Types
Write CASE Expressions Working with SQL Data Types
Work with Variables and Batches
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Burton On Trent
- 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 ... Examine Data Warehousing Concepts
- See Training Course Details...
Troubleshoot Package Failures Deploying Packages
Install Integration Services Working with Integration Services
Debug Package Execution Components
Change Granularity Creating Fact Tables and Columnstore Indexes
Add Packages to an SSIS Project Managing Control Flow
Execute SSIS Packages on the Server
Create Fact Tables
Introduction to Data Warehouses
Perform Transformation Tasks
Secure Packages
Create an SSIS Project
Create Dimensions
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Examine MSI Packages
Configure MDS
Profile OLTP Data
Execute Packages from Different Control Flow Working with Dynamic Variables
Overview of Data Warehouse Components
SQL
- 2 day course
- Location: Burton On Trent
- Telephone on 01952 938014
- 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 ... Mathematical Calculations
- See Training Course Details...
Outer Joins
Simple SELECT Statements
DELETE
Sorting By Column Position
Benefits of Views
Relational Databases
Checking Multiple Conditions
Table Aliases
Dropping Tables
NULL Values
Conditional Processing with CASE
Calculated Fields
Relational Database Management System
Dropping Stored Procedures
Common String Functions
Selecting Specific Columns
Email us about this courses
Other Burton On Trent Enable Technology Training Courses
SSIS Burton On Trent Training Courses
Access VBA - Burton On Trent Access Training Courses
SSRS - Burton On Trent SQL Server Reporting Services Training Courses
Excel 365 Advanced Burton On Trent Training Courses
SSAS Tabular - Burton On Trent SQL Server Analysis Services Training Courses
Power Query Burton On Trent Training Courses
JavaScript - Burton On Trent JavaScript Training Courses
SSAS Burton On Trent Training Courses
JQuery Mobile - Burton On Trent JavaScript Training Courses
DAX Burton On Trent Training Courses
JQuery Burton On Trent Training Courses
Report Builder - Burton On Trent SQL Server Reporting Services Training Courses
Excel 365 Intermediate Burton On Trent Training Courses
VBA - Burton On Trent Excel Training Courses
Power BI - Burton On Trent Microsoft Power BI Training Courses