SQL TRAINING COURSES BATH
About Enable Technology Bath SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL courseware which they can refer to after the training. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL onsite. If delivery onsite is an issue we will organise a venue near you in Bath. We are more than happy to incorporate additional topics to accommodate your organisations SQL 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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are Fujistu PLC, Birmingham Heartlands Hospital, University of Birmingham, Royal Air Force, Vodafone Group Services, Cadbury PLC, Homeserve PLC and Boots UK Limited.
Oracle SQL
- 2 day course
- Location: Bath
- 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 ... Literal Values
- See Training Course Details...
Transaction Management
Regular Expression Functions
Grouping Rows
Buffer Manipulation Commands
Date Formats
Other Database Objects
Self Joins
Introduction to SQL
Combining SELECT Statements
SQL*Plus
Viewing Table Characteristics
SQL*Plus Substitution Variables
Inline Constraints
Concurrency
SQL Queries - Joins
Review of Relational Database Terminology
Creating Views
Intervals
The INSERT Statement
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Bath
- 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 ... Profile OLTP Data
- See Training Course Details...
Deploy a Control Flow
Troubleshoot Package Failures Deploying Packages
Secure Databases Working with MDS and Windows Azure
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Execute SSIS Packages on the Server
Create Dimensions
Examine Data Warehousing Concepts
Configure the Package Execution Strategy
Create Package Templates Implementing Data Flow
Create Fact Tables
Execute Packages from Different Control Flow Working with Dynamic Variables
Work with Windows Azure
Create an SSIS Project
Configure MDS
Install Integration Services Working with Integration Services
Track Changed Data Managing Data Flow
Securing Packages and Databases
Perform Transformation Tasks
Oracle PL/SQL
- 3 day course
- Location: Bath
- 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 ... Closing Cursors
- See Training Course Details...
Cursor Parameters
The DBMS_METADATA Package
Oracle Directories
Associative Array Collections
The DBMS_OUTPUT Package
System Triggers
Triggers
Fetching Rows
Anchored Types
Named Parameter Notation
Local Procedures and Functions
Stored Subprograms
Networking Packages
The PL/SQL Execution Environment
Beyond Declarative Integrity
Stored Procedures and Functions
Other Supplied Packages
SQL
- 2 day course
- Location: Bath
- 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 ... WHERE and ORDER BY
- See Training Course Details...
Benefits of Stored Procedures
Primary Keys
Concatenation
DELETE
Creating Tables
Creating Tables
Selecting Specific Columns
Foreign Keys
Selecting All Columns in All Rows
Comments
The NOT Operator
Datatypes
Stored Procedures
Relationships
Sorting By Column Position
Relational Database Management System
Transact SQL
- 2 day course
- Location: Bath
- 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 ... Create Queries Using Join Algorithms
- See Training Course Details...
Delete Data
Work with Date and Time Data Types
Work with SSMS Working with T-SQL
Create Queries Using Built-in Functions
Work with Subqueries
Manage Query Plans
Work with the XML Data Type Sorting and Filtering Data
Work with Variables and Batches
Work with T-SQL Statements
Work with System Catalog Views Optimizing Query Performance
Getting Started with SQL Server 2012
Control Program Flow
Insert Data
Perform Advanced Filtering Querying Data from Multiple Tables
Combine Data Using Simple Joins
Work with System Databases
Manage SQL Server Constraints Writing SELECT Queries
Configure Indexes
Write CASE Expressions Working with SQL Data Types
Work with Window Functions
Email us about this courses
Other Bath Enable Technology Training Courses
Access VBA - Bath Access Training Courses
DAX - Bath Excel Training Courses
SSRS - Bath SQL Server Reporting Services Training Courses
Report Builder Bath Training Courses
SSAS Tabular - Bath SQL Server Analysis Services Training Courses
JQuery Mobile - Bath JavaScript Training Courses
VBA - Bath Excel Training Courses
JQuery Bath Training Courses
Excel Power Pivot - Bath Excel Training Courses
SSIS Bath Training Courses
Excel 365 Advanced Bath Training Courses
Excel 365 Basic Bath Training Courses
JavaScript - Bath JavaScript Training Courses
SSAS - Bath SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Bath Excel Training Courses