SQL TRAINING COURSES MERTHYR TYDFIL
About Enable Technology Merthyr Tydfil SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training SQL resources which they can continue to use after the training. We also provide an ongoing support service to people attending our SQL courses. Delegates can contact the course tutor with specific SQL questions for as long as they need following the course.
Enable Technology training courses are delivered as instructor led courses. Our SQL training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Merthyr Tydfil. We are happy to modify the SQL syllabus to match your teams training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: GKN PLC, Queen's Medical Centre Nottingham, Birmingham City University, Vodafone Group Services, DHL Express, Lloyds TSB Bank PLC, Norfolk Police Constabulary and University of Birmingham.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Merthyr Tydfil
- 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 Packages from Different Control Flow Working with Dynamic Variables
Work with MDS Databases
Debugging and Troubleshooting Packages
Create Expressions with Variables
Securing Packages and Databases
Deploy SSIS Packages
Configure the Package Execution Strategy
Examine Data Warehousing Concepts
Configure MDS
Secure Databases Working with MDS and Windows Azure
Profile OLTP Data
Overview of Data Warehouse Components
Create Dimensions
Execute SSIS Packages on the Server
Create Fact Tables
Add Script Tasks and Script Components to an SSIS Package
Add Data Flow Components to a Data Flow Task
Cleanse Data Using DQS Managing SSIS Package Execution
Track Changed Data Managing Data Flow
SQL
- 2 day course
- Location: Merthyr Tydfil
- 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...
Creating Views
Creating Stored Procedures
Creating Tables
Foreign Keys
Simple SELECT Statements
Aliases
Benefits of Stored Procedures
Subqueries
Popular Databases
Concatenation
Comments
Adding and Dropping Columns
Common Math Functions
Common Date Functions Subqueries, Joins and Unions
Oracle PL/SQL
- 3 day course
- Location: Merthyr Tydfil
- 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 ... Local Procedures and Functions
- See Training Course Details...
The UTL_FILE Package
External LOBs
Records and Collections
PL/SQL Syntax and Logic
Fetching Rows
Dates and Timestamps
Conditional Statements IF/THEN
Datatypes
The DBMS_LOB Package
Using the %ROWTYPE Attribute
Cursors
Generating an Error
Privileges for Stored Programs
Loops
Stored Procedures and Functions
PL/SQL Blocks and Programs
Maintaining Triggers
Procedures and Functions
REF CURSOR Variables
Oracle SQL
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Interactive SQL*Plus Scripts
- See Training Course Details...
Updatable Views
Joining Tables
Regular Expression Functions
Synonyms
Scalar Functions
Introduction to SQL
Correlated Subqueries
Oracle Versioning and History
SQL*Plus LOB Support
SQL Functions
Buffer Manipulation Commands
Aggregate Functions and Advanced Techniques
The EXISTS Operator
Deleting a Table Definition
Relational Database and SQL Overview
Data Inconsistencies
Loading Tables From External Sources
Transact SQL
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Manage Query Plans
- See Training Course Details...
Write CASE Expressions Working with SQL Data Types
Work with Grouping Sets Managing Error Handling and Transactions
Control Program Flow
Work with System Catalog Views Optimizing Query Performance
Work with Binary Data Types
Work with String and Numeric Data Types
Insert Data
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Analyze Data from Query Plans
Combine Data Using Simple Joins
Manage Triggers
Modifying Data
Work with System Databases
Work with the XML Data Type Sorting and Filtering Data
Delete Data
Implement Error Handling
Work with Set Operators
Work with T-SQL Statements
Write SELECT Statements
Work with Variables and Batches
Email us about this courses
Other Merthyr Tydfil Enable Technology Training Courses
SSIS - Merthyr Tydfil SQL Server Integration Services Training Courses
JQuery Mobile Merthyr Tydfil Training Courses
Excel 365 Basic - Merthyr Tydfil Excel Training Courses
Access VBA Merthyr Tydfil Training Courses
SSAS Tabular - Merthyr Tydfil SQL Server Analysis Services Training Courses
Power BI Merthyr Tydfil Training Courses
Excel 365 Advanced Merthyr Tydfil Training Courses
JavaScript Merthyr Tydfil Training Courses
Excel Power Pivot Merthyr Tydfil Training Courses
VBA Merthyr Tydfil Training Courses
DAX - Merthyr Tydfil Excel Training Courses
JQuery - Merthyr Tydfil JavaScript Training Courses
Access - Merthyr Tydfil Access Training Courses
SSAS - Merthyr Tydfil SQL Server Analysis Services Training Courses
Report Builder Merthyr Tydfil Training Courses