SQL TRAINING COURSES TONYPANDY
About Enable Technology Tonypandy SQL Training Courses
We are a company that offers short, practical, SQL hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and SQL course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
SQL courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Tonypandy. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
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.
We have operated primarily in the West Midlands for twenty years. Our clients include: Homeserve PLC, South Staffordshire Water PLC, National Power PLC, Lloyds TSB Bank PLC, Boots UK Limited, Halfords Group PLC, Norfolk Police Constabulary and Loughborough University.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Tonypandy
- 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 Fact Tables
- See Training Course Details...
Secure Databases Working with MDS and Windows Azure
Add Packages to an SSIS Project Managing Control Flow
Execute SSIS Packages on the Server
Examine Data Warehousing Concepts
Perform Transformation Tasks
Profile OLTP Data
Configure the Package Execution Strategy
Troubleshoot Package Failures Deploying Packages
Add Data Flow Components to a Data Flow Task
Work with Windows Azure
Work with MDS Databases
Overview of Data Warehouse Components
Create Expressions with Variables
Add Script Tasks and Script Components to an SSIS Package
Debug Package Execution Components
Create Dimensions
Deploy SSIS Packages
Secure Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Overview of Data Warehouses
Transact SQL
- 2 day course
- Location: Tonypandy
- 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 ... Manage Query Plans
- See Training Course Details...
Write SELECT Statements
Configure Indexes
Manage Triggers
Work with Grouping Sets Managing Error Handling and Transactions
Manage Stored Procedures
Work with Window Functions
Insert Data
Work with PIVOT and UNPIVOT
Write CASE Expressions Working with SQL Data Types
Filter the Queried Results
Work with String and Numeric Data Types
Delete Data
Overview of SQL Server
Work with T-SQL Statements
Work with Date and Time Data Types
Work with Data Access Technologies Implementing Stored Procedures
Work with SSPs and SMOs
Analyze Data from Query Plans
Work with Subqueries
Combine Data Using Simple Joins
Oracle SQL
- 2 day course
- Location: Tonypandy
- 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 ... Numeric Functions
- See Training Course Details...
The UPDATE Statement
Tailoring Your SQL*Plus Environment
Concurrency
Logical and Physical Storage Structures
Sequences
The SELECT Statement
Self Joins
Introduction to SQL
Date Formats
NULL Values
Datatypes
Data Definition and Control Statements
Relational Database and SQL Overview
Interactive SQL*Plus Scripts
SQL*Plus Substitution Variables
Other Database Objects
Explicit Locking
Compound Expressions
Using SQL Functions
SQL
- 2 day course
- Location: Tonypandy
- Telephone on 01952 938014
- Course Outline
-
This hands on SQL (Structured Query Language) course will equip participants the skills necessary to extract filtered data from all of the leading database platforms. No prior knowledge is assumed. Participants will learn how to extract data from a relational database, create aggregated grouped reports, update, insert and delete data, create tables, views and stored procedures.
- Some of the training topics covered include ... Popular Databases
- See Training Course Details...
Relational Database Management System
Sorting Records
Selecting All Columns in All Rows
CASE syntax
Conditional Processing with CASE
Checking for Inequality
Data Types
The LIKE Operator
Sorting By a Single Column
Foreign Keys
Adding and Dropping Columns
Dropping Views
Dropping Stored Procedures
Table Aliases
Oracle PL/SQL
- 3 day course
- Location: Tonypandy
- 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 ... XML Packages
- See Training Course Details...
Associative Array Collections
Stored Procedures and Functions
Creating a Stored Function
Structure of a Package
Compile-Time Warnings
Scope and Name Resolution
The DBMS_UTILITY Package
Package Variables
Subtypes
Cursor Parameters
Creating a Stored Procedure
Nesting Blocks
FORALL Statement
Iterating Through Collections
Cascading Triggers and Mutating Tables
The DBMS_LOB Package
WHILE and FOR Loops
Passing Parameters and Default Arguments
FOR UPDATE Cursors
Calling a Stored Function
Email us about this courses
Other Tonypandy Enable Technology Training Courses
Power BI - Tonypandy Microsoft Power BI Training Courses
SSAS - Tonypandy SQL Server Analysis Services Training Courses
Excel 365 Advanced - Tonypandy Excel Training Courses
Excel 365 Intermediate - Tonypandy Excel Training Courses
Report Builder - Tonypandy SQL Server Reporting Services Training Courses
JQuery - Tonypandy JavaScript Training Courses
SSRS - Tonypandy SQL Server Reporting Services Training Courses
Power Query - Tonypandy Excel Training Courses
SSAS Tabular - Tonypandy SQL Server Analysis Services Training Courses
JQuery Mobile - Tonypandy JavaScript Training Courses
DAX - Tonypandy Excel Training Courses
JavaScript Tonypandy Training Courses
VBA - Tonypandy Excel Training Courses
Access Tonypandy Training Courses
SSIS - Tonypandy SQL Server Integration Services Training Courses