SQL TRAINING COURSES SWANSEA
About Enable Technology Swansea SQL Training Courses
We offer intensive two and three days SQL courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the SQL course can contact the tutor for as long as they like if they encounter SQL problems.
We provide instructor led training coupled with hands on training. 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 Swansea. We are happy to discuss customising the course content should you have particular SQL training requirements.
We also deliver this course online. Delegates participate in a virtual SQL class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Barclays Bank PLC, Yell Group PLC, Royal & Sun Alliance Group PLC, Total Telecommunications Limited, GKN PLC, Birmingham City University, Dollond & Aitchison Limited and Queen's Medical Centre Nottingham.
Transact SQL
- 2 day course
- Location: Swansea
- 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 ... Configure User-Defined Functions (UDF)
- See Training Course Details...
Create Queries Using Built-in Functions
Overview of T-SQL
Manage SQL Server Constraints Writing SELECT Queries
Work with Window Functions
Work with SSPs and SMOs
Work with Data Access Technologies Implementing Stored Procedures
Configure Indexes
Modifying Data
Work with Predicates
Implement Error Handling
Create Queries to Test Nullability
Insert Data
Write CASE Expressions Working with SQL Data Types
Filter the Queried Results
Work with T-SQL Statements
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Getting Started with SQL Server 2012
Manage Views
Work with String and Numeric Data Types
Work with System Catalog Views Optimizing Query Performance
Oracle SQL
- 2 day course
- Location: Swansea
- 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 ... Inline Constraints
- See Training Course Details...
Date Functions
Choosing Rows with the WHERE Clause
Correlated Subqueries
Concurrency
Combining SELECT Statements
Views
Oracle Pseudocolumns
Tailoring Your SQL*Plus Environment
Viewing Table Characteristics
Buffer Manipulation Commands
Date Formats
SQL Queries - Joins
Review of Relational Database Terminology
The SQL Buffer
SQL*Plus LOB Support
The SELECT Statement
Graphical Clients
SQL Functions
Aggregate Functions and Advanced Techniques
Synonyms
Oracle PL/SQL
- 3 day course
- Location: Swansea
- 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 ... Oracle-Supplied Packages
- See Training Course Details...
Compile-Time Warnings
Fetching Rows
Declaring Variables
PL/SQL Syntax and Logic
Calling a Stored Function
Cursor Parameters
The DBMS_OUTPUT Package
Package Variables
Cascading Triggers and Mutating Tables
Character Data
Large Object Types
Using VARRAYs
Types of Triggers
Packages
Iterating Through Collections
Datatypes
Triggers
The PL/SQL Execution Environment
Local Procedures and Functions
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Swansea
- 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 Expressions with Variables
- See Training Course Details...
Introduction to Data Warehouses
Configure MDS
Overview of Data Warehouse Components
Execute Packages from Different Control Flow Working with Dynamic Variables
Debug Package Execution Components
Examine MSI Packages
Secure Packages
Debugging and Troubleshooting Packages
Profile OLTP Data
Create an SSIS Project
Add Script Tasks and Script Components to an SSIS Package
Add Packages to an SSIS Project Managing Control Flow
Examine Data Warehousing Concepts
Securing Packages and Databases
Deploy SSIS Packages
Perform Transformation Tasks
Create Package Templates Implementing Data Flow
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Data Flow Components to a Data Flow Task
SQL
- 2 day course
- Location: Swansea
- 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 ... Mathematical Calculations
- See Training Course Details...
Tables
Checking for Equality
Dropping Tables
Common Date Functions Subqueries, Joins and Unions
CASE syntax
Primary Keys
Sorting By Column Position
Columns
Checking for Inequality
Adding and Dropping Columns
Concatenation
The LIKE Operator
Email us about this courses
Other Swansea Enable Technology Training Courses
SSRS - Swansea SQL Server Reporting Services Training Courses
JQuery Swansea Training Courses
JavaScript Swansea Training Courses
Excel 365 Intermediate - Swansea Excel Training Courses
SSAS Tabular - Swansea SQL Server Analysis Services Training Courses
Access VBA Swansea Training Courses
SSAS - Swansea SQL Server Analysis Services Training Courses
Excel 365 Advanced - Swansea Excel Training Courses
VBA Swansea Training Courses
Power Query Swansea Training Courses
DAX Swansea Training Courses
SSIS - Swansea SQL Server Integration Services Training Courses
Excel 365 Basic - Swansea Excel Training Courses
JQuery Mobile - Swansea JavaScript Training Courses
Excel Power Pivot Swansea Training Courses