SQL TRAINING COURSES SHREWSBURY
About Enable Technology Shrewsbury SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. All Enable Technology tutors are Microsoft certified experts. We will issue each SQL training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
SQL training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver SQL courses at your site. Alternatively we could schedule a SQL course at an alternative training site in Shrewsbury. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations training requirements.
We can also deliver SQL courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal & Sun Alliance Group PLC, Royal Air Force, Shell UK Oil Products Ltd, Wolverhampton City Council, Keele University, Boots UK Limited, Capita Group PLC and Birmingham Heartlands Hospital.
Oracle SQL
- 2 day course
- Location: Shrewsbury
- 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 ... Modifying Table Definitions
- See Training Course Details...
Scalar Functions
Creating Views
The SQL Buffer
SQL Queries
Datatypes
The INSERT Statement
Data Definition and Control Statements
Explicit Locking
Choosing Rows with the WHERE Clause
The SELECT Statement
Combining SELECT Statements
Datatypes
Using SQL Functions
Subqueries
Intervals
Relational Database and SQL Overview
The Aggregate Functions
Graphical Clients
SQL
- 2 day course
- Location: Shrewsbury
- Telephone on 01952 938014
- Course Outline
-
This hands on SQL (Structured Query Language) course will equip participants the skills necessary to extract filtered data from all of the leading database platforms. No prior knowledge is assumed. Participants will learn how to extract data from a relational database, create aggregated grouped reports, update, insert and delete data, create tables, views and stored procedures.
- Some of the training topics covered include ... Renaming Tables
- See Training Course Details...
Relationships
Outer Joins
WHERE and ORDER BY
Common Date Functions Subqueries, Joins and Unions
Selecting Specific Columns
Creating Views
Relational Databases
Multi-table Joins
Whitespace and Semi-colons
Common String Functions
Benefits of Stored Procedures
The BETWEEN Operator
Foreign Keys
Primary Keys
Foreign Keys
DELETE
Sorting By Column Position
Checking for NULL
NULL Values
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Shrewsbury
- 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 ... Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
- See Training Course Details...
Deploy a Control Flow
Create Fact Tables
Configure the Package Execution Strategy
Create Expressions with Variables
Cleanse Data Using DQS Managing SSIS Package Execution
Introduction to Data Warehouses
Debug Package Execution Components
Install Integration Services Working with Integration Services
Track Changed Data Managing Data Flow
Work with MDS Databases
Troubleshoot Package Failures Deploying Packages
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Secure Databases Working with MDS and Windows Azure
Work with Windows Azure
Create Dimensions
Create an SSIS Project
Execute SSIS Packages on the Server
Change Granularity Creating Fact Tables and Columnstore Indexes
Transact SQL
- 2 day course
- Location: Shrewsbury
- 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...
Getting Started with SQL Server 2012
Work with Binary Data Types
Perform Advanced Filtering Querying Data from Multiple Tables
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Create Queries to Test Nullability
Modifying Data
Work with T-SQL Statements
Work with Variables and Batches
Merge Data Working with SQL Server Built-in Functions
Work with Data Access Technologies Implementing Stored Procedures
Manage Triggers
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Manage SQL Server Constraints Writing SELECT Queries
Implement Error Handling
Analyze Data from Query Plans
Manage Views
Manage Transactions Querying SQL Server System Metadata
Work with Set Operators
Group and Aggregate Data Programming in T-SQL
Overview of T-SQL
Oracle PL/SQL
- 3 day course
- Location: Shrewsbury
- 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 ... Assignment and Conversions
- See Training Course Details...
PL/SQL Variables and Datatypes
WHILE and FOR Loops
Dates and Timestamps
The DBMS_METADATA Package
Associative Array Collections
Oracle-Supplied Packages
Overloading Package Functions and Procedures
XML Packages
Closing Cursors
The Package Interface and Implementation
The Implicit (SQL) Cursor
Declaring Variables
BULK COLLECT Clause
Stored Subprograms
REF CURSOR Variables
Local Procedures and Functions
Cursors
Records and Collections
Email us about this courses
Other Shrewsbury Enable Technology Training Courses
JQuery - Shrewsbury JavaScript Training Courses
JQuery Mobile Shrewsbury Training Courses
Power Query Shrewsbury Training Courses
SSIS - Shrewsbury SQL Server Integration Services Training Courses
DAX - Shrewsbury Excel Training Courses
Excel 365 Advanced - Shrewsbury Excel Training Courses
JavaScript Shrewsbury Training Courses
SSAS Shrewsbury Training Courses
Excel 365 Intermediate - Shrewsbury Excel Training Courses
Access VBA Shrewsbury Training Courses
Power BI Shrewsbury Training Courses
SSAS Tabular - Shrewsbury SQL Server Analysis Services Training Courses
VBA Shrewsbury Training Courses
SSRS Shrewsbury Training Courses
Access Shrewsbury Training Courses