SQL TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with SQL training materials which they keep 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 offers instructor led training taught by technology specialists. 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. If delivery onsite is an issue we will organise a venue near you in Mid Glamorgan. The SQL syllabus can be modified to accommodate your specific training needs.
SQL courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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: Royal & Sun Alliance Group PLC, Countrywide Homes Limited, Shell UK Oil Products Ltd, Unipart Group, Birmingham City Council, Vodafone Group Services, Loughborough University and Canadian High Commission.
SQL
- 2 day course
- Location: Mid Glamorgan
- Telephone on 01952 938014
- Course Outline
-
This practical hands on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.
- Some of the training topics covered include ... Selecting All Columns in All Rows
- See Training Course Details...
Common Math Functions
Sorting By a Single Column
The IN Operator
Creating Views
Sorting By Multiple Columns
Conditional Processing with CASE
Sorting By Column Position
Mathematical Calculations
Checking for NULL
Calculated Fields
Whitespace and Semi-colons
Relationships
Creating Tables
The NOT Operator
Creating Stored Procedures
Checking Multiple Conditions
Popular Databases
Order of Evaluation Advanced SELECTs
Oracle PL/SQL
- 3 day course
- Location: Mid Glamorgan
- 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 ... Row-Level Triggers
- See Training Course Details...
External LOBs
Overloading Package Functions and Procedures
Selecting into a Variable
Datatypes
Using the %ROWTYPE Attribute
Structure of a Package
Conditional Statements IF/THEN
VARRAY and Nested TABLE Collections
Using Packages
Types of Triggers
The Package Interface and Implementation
Subtypes
Cursors
Oracle Directories
Creating Packages
Calling a Stored Procedure
Compile-Time Warnings
Calling a Stored Function
BULK COLLECT Clause
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Mid Glamorgan
- 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 ... Debugging and Troubleshooting Packages
- See Training Course Details...
Deploy SSIS Packages
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Work with Windows Azure
Examine Data Warehousing Concepts
Secure Packages
Add Data Flow Components to a Data Flow Task
Add Packages to an SSIS Project Managing Control Flow
Execute Packages from Different Control Flow Working with Dynamic Variables
Configure MDS
Install Integration Services Working with Integration Services
Overview of Data Warehouses
Cleanse Data Using DQS Managing SSIS Package Execution
Create Fact Tables
Examine MSI Packages
Debug Package Execution Components
Create Expressions with Variables
Securing Packages and Databases
Work with MDS Databases
Profile OLTP Data
Transact SQL
- 2 day course
- Location: Mid Glamorgan
- 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 ... Combine Data Using Simple Joins
- See Training Course Details...
Manage Stored Procedures
Manage Triggers
Analyze Data from Query Plans
Work with Predicates
Work with Set Operators
Write CASE Expressions Working with SQL Data Types
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with SSMS Working with T-SQL
Filter the Queried Results
Create Queries Using Built-in Functions
Create Queries to Test Nullability
Manage Transactions Querying SQL Server System Metadata
Assign Aliases Using Queries
Work with System Catalog Views Optimizing Query Performance
Configure User-Defined Functions (UDF)
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Date and Time Data Types
Work with Binary Data Types
Delete Data
Group and Aggregate Data Programming in T-SQL
Oracle SQL
- 2 day course
- Location: Mid Glamorgan
- 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 ... Viewing Table Characteristics
- See Training Course Details...
Data Definition and Control Statements
Datatypes
Loading Tables From External Sources
Deleting a Table Definition
Other Database Objects
Joining Tables
Updatable Views
Defining Tables
Synonyms
Using SQL Functions
The SQL Buffer
String Functions
The Aggregate Functions
SQL*Plus
Outer Joins
Explicit Locking
Regular Expression Functions
Selecting from Multiple Tables
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
VBA - Mid Glamorgan Excel Training Courses
SSRS Mid Glamorgan Training Courses
Excel 365 Intermediate - Mid Glamorgan Excel Training Courses
Excel 365 Basic Mid Glamorgan Training Courses
SSIS - Mid Glamorgan SQL Server Integration Services Training Courses
Excel 365 Advanced - Mid Glamorgan Excel Training Courses
Access - Mid Glamorgan Access Training Courses
SSAS Tabular - Mid Glamorgan SQL Server Analysis Services Training Courses
DAX Mid Glamorgan Training Courses
Report Builder Mid Glamorgan Training Courses
Power BI Mid Glamorgan Training Courses
JavaScript Mid Glamorgan Training Courses
Power Query - Mid Glamorgan Excel Training Courses
Excel Power Pivot Mid Glamorgan Training Courses
JQuery Mobile - Mid Glamorgan JavaScript Training Courses