SQL TRAINING COURSES WEST GLAMORGAN
About Enable Technology West Glamorgan SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each SQL training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. SQL courses are delivered through a mix of practical hands on exercises and walk throughs. 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 West Glamorgan. We are happy to discuss customising the course content should you have particular SQL 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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are West Bromwich Building Society, Countrywide Homes Limited, EDF Energy PLC, Shell UK Oil Products Ltd, Vodafone Group Services, Keele University, National Power PLC and Lloyds TSB Bank PLC.
Oracle PL/SQL
- 3 day course
- Location: West 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 ... Procedures and Functions
- See Training Course Details...
The Implicit (SQL) Cursor
Package Variables
XML Packages
Dates and Timestamps
Calling a Stored Procedure
Associative Array Collections
LOB Locators
Maintaining Stored Programs
Privileges for Stored Programs
Networking Packages
Fetching Rows
The Package Interface and Implementation
Declaring Variables
Temporary LOBs
Using Packages
Creating Packages
The DBMS_UTILITY Package
Dependencies and Validation
Other Supplied Packages
Oracle SQL
- 2 day course
- Location: West 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 ... Scalar Functions
- See Training Course Details...
Graphical Clients
The DELETE statement
Nulls and DISTINCT
The EXISTS Operator
Data Definition and Control Statements
Sequences
Relational Database Management Systems
Compound Expressions
SQL*Plus LOB Support
Connecting to a SQL Database
Explicit Locking
Relational Database and SQL Overview
String Functions
Logical and Physical Storage Structures
Numeric Functions
Date Functions
Data Manipulation and Transactions
SQL
- 2 day course
- Location: West Glamorgan
- 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 ... Dropping Stored Procedures
- See Training Course Details...
Creating Tables
Foreign Keys
Creating Stored Procedures
WHERE and ORDER BY
Renaming Tables
Aliases
Benefits of Views
Common Math Functions
Popular Databases
CASE syntax
The BETWEEN Operator
Using the WHERE clause to check for greater or less than
Adding and Dropping Columns
Case Sensitivity
Outer Joins
The IN Operator
Calculated Fields
Subqueries
SQL Server Data Warehouse Implementation
- 3 day course
- Location: West 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 ... Execute Packages from Different Control Flow Working with Dynamic Variables
- See Training Course Details...
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Work with MDS Databases
Troubleshoot Package Failures Deploying Packages
Overview of Data Warehouse Components
Securing Packages and Databases
Debugging and Troubleshooting Packages
Configure the Package Execution Strategy
Profile OLTP Data
Create Expressions with Variables
Add Data Flow Components to a Data Flow Task
Change Granularity Creating Fact Tables and Columnstore Indexes
Create Package Templates Implementing Data Flow
Create Fact Tables
Add Packages to an SSIS Project Managing Control Flow
Examine Data Warehousing Concepts
Debug Package Execution Components
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Track Changed Data Managing Data Flow
Create Dimensions
Transact SQL
- 2 day course
- Location: West Glamorgan
- 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 ... Work with String and Numeric Data Types
- See Training Course Details...
Configure Indexes
Manage Triggers
Configure User-Defined Functions (UDF)
Analyze Data from Query Plans
Delete Data
Work with Variables and Batches
Work with System Databases
Work with the XML Data Type Sorting and Filtering Data
Create Queries to Test Nullability
Work with T-SQL Statements
Work with Binary Data Types
Manage Query Plans
Getting Started with SQL Server 2012
Create Queries Using Join Algorithms
Insert Data
Update Data
Create Queries Using Built-in Functions
Work with Grouping Sets Managing Error Handling and Transactions
Filter the Queried Results
Group and Aggregate Data Programming in T-SQL
Email us about this courses
Other West Glamorgan Enable Technology Training Courses
Access VBA West Glamorgan Training Courses
Power BI - West Glamorgan Microsoft Power BI Training Courses
Excel 365 Intermediate - West Glamorgan Excel Training Courses
DAX - West Glamorgan Excel Training Courses
Report Builder West Glamorgan Training Courses
SSAS West Glamorgan Training Courses
Excel 365 Basic - West Glamorgan Excel Training Courses
SSRS - West Glamorgan SQL Server Reporting Services Training Courses
Excel 365 Advanced West Glamorgan Training Courses
SSAS Tabular West Glamorgan Training Courses
JavaScript West Glamorgan Training Courses
SSIS - West Glamorgan SQL Server Integration Services Training Courses
JQuery West Glamorgan Training Courses
Excel Power Pivot West Glamorgan Training Courses
Access - West Glamorgan Access Training Courses