SQL TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive SQL training materials and practice files which are theirs to refer to 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.
SQL courses are taught by a Microsoft Certified Solutions Expert. We are set up to deliver SQL training courses onsite at your premises. We can also deliver the SQL course at a local training venue in Uttoxeter. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Aston University, Yell Group PLC, Norwich Union PLC, Birmingham City University, Nuclear Engineering Services, Total Telecommunications Limited, DHL Express and National Power PLC.
Transact SQL
- 2 day course
- Location: Uttoxeter
- 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...
Perform Advanced Filtering Querying Data from Multiple Tables
Write CASE Expressions Working with SQL Data Types
Work with System Catalog Views Optimizing Query Performance
Manage SQL Server Constraints Writing SELECT Queries
Assign Aliases Using Queries
Manage Query Plans
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Configure Indexes
Work with Grouping Sets Managing Error Handling and Transactions
Configure User-Defined Functions (UDF)
Work with Subqueries
Work with Binary Data Types
Write SELECT Statements
Analyze Data from Query Plans
Work with Window Functions
Work with the XML Data Type Sorting and Filtering Data
Work with Set Operators
Modifying Data
Overview of SQL Server
Update Data
Oracle PL/SQL
- 3 day course
- Location: Uttoxeter
- 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 ... Fetching Rows
- See Training Course Details...
Stored Subprograms
PL/SQL Stored Program Compilation
Named Parameter Notation
LOB Locators
Oracle Directories
Declaring and Opening Cursors
Selecting into a Variable
Privileges for Stored Programs
Internal LOBs
Exception Handling
BULK COLLECT Clause
Scope and Name Resolution
XML Packages
WHILE and FOR Loops
Collection Methods
Calling a Stored Procedure
Anchored Types
Using the %ROWTYPE Attribute
Calling a Stored Function
Oracle SQL
- 2 day course
- Location: Uttoxeter
- 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 ... Synonyms
- See Training Course Details...
NULL Values
Pattern Matching: LIKE and REGEXP_LIKE
Constraints
Data Inconsistencies
Controlling Access to Your Tables
Scalar Functions
Buffer Manipulation Commands
Relational Database and SQL Overview
Combining SELECT Statements
Subqueries
Creating Views
SQL Queries
Data Definition and Control Statements
Nulls and DISTINCT
The SELECT Statement
SQL Queries - Joins
Literal Values
SQL*Plus Substitution Variables
Connecting to a SQL Database
Numeric Functions
SQL
- 2 day course
- Location: Uttoxeter
- 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 ... Multi-table Joins
- See Training Course Details...
Stored Procedures
Relational Databases
Comments
Aggregate Functions
Aliases
Subqueries
Sorting By a Single Column
The WHERE Clause and Operator Words
Mathematical Calculations
Common Math Functions
Simple SELECT Statements
The LIKE Operator
Checking for Inequality
Popular Databases
Outer Joins
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Uttoxeter
- 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 ... Securing Packages and Databases
- See Training Course Details...
Execute SSIS Packages on the Server
Create Fact Tables
Change Granularity Creating Fact Tables and Columnstore Indexes
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Data Flow Components to a Data Flow Task
Work with MDS Databases
Examine Data Warehousing Concepts
Create an SSIS Project
Overview of Data Warehouses
Add Script Tasks and Script Components to an SSIS Package
Debug Package Execution Components
Examine MSI Packages
Configure MDS
Install Integration Services Working with Integration Services
Work with Windows Azure
Debugging and Troubleshooting Packages
Overview of Data Warehouse Components
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
JQuery Mobile Uttoxeter Training Courses
DAX - Uttoxeter Excel Training Courses
JQuery Uttoxeter Training Courses
Excel 365 Intermediate - Uttoxeter Excel Training Courses
JavaScript - Uttoxeter JavaScript Training Courses
SSAS - Uttoxeter SQL Server Analysis Services Training Courses
Excel 365 Advanced Uttoxeter Training Courses
Excel 365 Basic - Uttoxeter Excel Training Courses
Report Builder - Uttoxeter SQL Server Reporting Services Training Courses
Power BI Uttoxeter Training Courses
SSRS - Uttoxeter SQL Server Reporting Services Training Courses
Excel Power Pivot - Uttoxeter Excel Training Courses
Access VBA Uttoxeter Training Courses
VBA Uttoxeter Training Courses
Access - Uttoxeter Access Training Courses