SQL TRAINING COURSES GWENT
About Enable Technology Gwent SQL Training Courses
We offer intensive two and three days SQL courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive SQL training materials and practice files which are theirs to refer to after the course. 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.
Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL courses at your site. We also offer the option of scheduling of SQL course at a venue near you in Gwent. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Wolverhampton City Council, Boots UK Limited, Birmingham City Council, Shell UK Oil Products Ltd, Birmingham Heartlands Hospital, Royal Air Force, Carillion PLC and Royal & Sun Alliance Group PLC.
Transact SQL
- 2 day course
- Location: Gwent
- 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 ... Update Data
- See Training Course Details...
Work with Variables and Batches
Configure Indexes
Manage Views
Combine Data Using Simple Joins
Perform Advanced Filtering Querying Data from Multiple Tables
Work with Window Functions
Write CASE Expressions Working with SQL Data Types
Manage SQL Server Constraints Writing SELECT Queries
Work with SSPs and SMOs
Work with Data Access Technologies Implementing Stored Procedures
Write SELECT Statements
Insert Data
Work with String and Numeric Data Types
Create Queries Using Built-in Functions
Group and Aggregate Data Programming in T-SQL
Work with SSMS Working with T-SQL
Work with Grouping Sets Managing Error Handling and Transactions
Work with System Catalog Views Optimizing Query Performance
Work with Predicates
Manage Query Plans
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Gwent
- 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...
Change Granularity Creating Fact Tables and Columnstore Indexes
Securing Packages and Databases
Add Packages to an SSIS Project Managing Control Flow
Create Package Templates Implementing Data Flow
Add Data Flow Components to a Data Flow Task
Examine Data Warehousing Concepts
Work with Windows Azure
Examine MSI Packages
Secure Packages
Install Integration Services Working with Integration Services
Debugging and Troubleshooting Packages
Secure Databases Working with MDS and Windows Azure
Execute Packages from Different Control Flow Working with Dynamic Variables
Create an SSIS Project
Work with MDS Databases
Deploy a Control Flow
Deploy SSIS Packages
Add Script Tasks and Script Components to an SSIS Package
Cleanse Data Using DQS Managing SSIS Package Execution
Oracle PL/SQL
- 3 day course
- Location: Gwent
- 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 ... Privileges for Stored Programs
- See Training Course Details...
Iterating Through Collections
Stored Functions and SQL
Stored Subprograms
Collection Methods
The Cursor FOR Loop
Structure of a Package
FOR UPDATE Cursors
Conditional Statements CASE
Triggers
User-Defined Exceptions
Cursor Parameters
Anchored Types
Maintaining PL/SQL Code
System Triggers
Assignment and Conversions
The DBMS_METADATA Package
Generating an Error
External LOBs
Dates and Timestamps
SQL
- 2 day course
- Location: Gwent
- 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 ... The WHERE Clause and Operator Words
- See Training Course Details...
Datatypes
Relationships
Selecting Distinct Records
Creating Tables
The BETWEEN Operator
Primary Keys
Selecting Specific Columns
Creating and Modifying Tables
Data Types
Using CASE Inserting, Updating and Deleting Records
Selecting All Columns in All Rows
Common Math Functions
The LIKE Operator
Foreign Keys
Mathematical Calculations
Oracle SQL
- 2 day course
- Location: Gwent
- 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 ... Synonyms
- See Training Course Details...
Deleting a Table Definition
Self Joins
The EXISTS Operator
Joining Tables
Using Oracle SQL*Plus
Graphical Clients
Aggregate Functions and Advanced Techniques
The SQL Buffer
Transaction Management
Introduction to SQL
Oracle Versioning and History
Data Inconsistencies
Other Database Objects
Selecting from Multiple Tables
Inline Constraints
SQL*Plus LOB Support
Combining SELECT Statements
Email us about this courses
Other Gwent Enable Technology Training Courses
Access Gwent Training Courses
Access VBA Gwent Training Courses
JavaScript - Gwent JavaScript Training Courses
DAX - Gwent Excel Training Courses
Power BI Gwent Training Courses
JQuery Mobile - Gwent JavaScript Training Courses
JQuery - Gwent JavaScript Training Courses
SSIS - Gwent SQL Server Integration Services Training Courses
Excel Power Pivot - Gwent Excel Training Courses
Report Builder Gwent Training Courses
SSRS Gwent Training Courses
VBA - Gwent Excel Training Courses
Excel 365 Intermediate - Gwent Excel Training Courses
Power Query Gwent Training Courses
SSAS Tabular - Gwent SQL Server Analysis Services Training Courses