SQL TRAINING COURSES YSTRAD MYNACH
About Enable Technology Ystrad Mynach SQL Training Courses
We are a company that offers short, practical, SQL hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued SQL training manuals they can refer to after the course. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite training location in Ystrad Mynach. All SQL courses can be customised to meet your particular requirements.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Our clients include: Norfolk Police Constabulary, Royal Air Force, EDF Energy PLC, Total Telecommunications Limited, GKN PLC, Vodafone Group Services, Birmingham City Council and Loughborough University.
Transact SQL
- 2 day course
- Location: Ystrad Mynach
- 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 Triggers
- See Training Course Details...
Modifying Data
Manage Transactions Querying SQL Server System Metadata
Work with Date and Time Data Types
Overview of SQL Server
Work with Binary Data Types
Manage SQL Server Constraints Writing SELECT Queries
Overview of T-SQL
Configure User-Defined Functions (UDF)
Insert Data
Work with SSPs and SMOs
Implement Error Handling
Work with Predicates
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Configure Indexes
Work with Window Functions
Work with the XML Data Type Sorting and Filtering Data
Analyze Data from Query Plans
Work with String and Numeric Data Types
Work with Dynamic SQL Working with Subqueries and Table Expressions
Control Program Flow
Oracle PL/SQL
- 3 day course
- Location: Ystrad Mynach
- 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 ... Cursors
- See Training Course Details...
FORALL Statement
Fetching Rows
Beyond Declarative Integrity
REF CURSOR Variables
Nesting Blocks
Anchored Types
The DBMS_UTILITY Package
Conditional Statements CASE
Stored Procedures and Functions
Iterating Through Collections
Large Object Types
SQLCODE and SQLERRM
Named Parameter Notation
Stored Functions and SQL
Triggers
The Implicit (SQL) Cursor
Exception Handlers
SQL
- 2 day course
- Location: Ystrad Mynach
- Telephone on 01952 938014
- Course Outline
-
SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.
- Some of the training topics covered include ... Popular Databases
- See Training Course Details...
Subqueries
The BETWEEN Operator
Creating Views
Checking for Inequality
NULL Values
WHERE and ORDER BY
Using CASE Inserting, Updating and Deleting Records
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Dropping Stored Procedures
Selecting Specific Columns
Foreign Keys
Relational Databases
Calculated Fields
Order of Evaluation Advanced SELECTs
The LIKE Operator
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Ystrad Mynach
- 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 ... Execute SSIS Packages on the Server
- See Training Course Details...
Examine Data Warehousing Concepts
Secure Databases Working with MDS and Windows Azure
Deploy a Control Flow
Create Dimensions
Overview of Data Warehouse Components
Create Expressions with Variables
Work with Windows Azure
Debug Package Execution Components
Introduction to Data Warehouses
Create an SSIS Project
Work with MDS Databases
Profile OLTP Data
Add Packages to an SSIS Project Managing Control Flow
Debugging and Troubleshooting Packages
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Deploy SSIS Packages
Install Integration Services Working with Integration Services
Configure the Package Execution Strategy
Cleanse Data Using DQS Managing SSIS Package Execution
Oracle SQL
- 2 day course
- Location: Ystrad Mynach
- 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 ... Outer Joins
- See Training Course Details...
Explicit Locking
Defining Tables
Constraints
Sample Database
Other Database Objects
Transaction Management
SQL*Plus
Using Oracle SQL*Plus
NULL Values
Connecting to a SQL Database
Data Inconsistencies
Logical and Physical Storage Structures
Modifying Table Definitions
The CASE...WHEN Expression
The SELECT Statement
Review of Relational Database Terminology
SQL Queries - Joins
Viewing Table Characteristics
Email us about this courses
Other Ystrad Mynach Enable Technology Training Courses
Report Builder - Ystrad Mynach SQL Server Reporting Services Training Courses
SSIS - Ystrad Mynach SQL Server Integration Services Training Courses
JQuery Ystrad Mynach Training Courses
DAX Ystrad Mynach Training Courses
Access Ystrad Mynach Training Courses
JQuery Mobile - Ystrad Mynach JavaScript Training Courses
Power Query Ystrad Mynach Training Courses
Excel 365 Advanced Ystrad Mynach Training Courses
Excel 365 Basic - Ystrad Mynach Excel Training Courses
SSAS Ystrad Mynach Training Courses
VBA - Ystrad Mynach Excel Training Courses
SSRS Ystrad Mynach Training Courses
Access VBA - Ystrad Mynach Access Training Courses
Excel 365 Intermediate - Ystrad Mynach Excel Training Courses
Power BI - Ystrad Mynach Microsoft Power BI Training Courses