SQL TRAINING COURSES BATLEY
About Enable Technology Batley SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific SQL queries. This support is open ended.
We provide instructor led training coupled with hands on training. Enable Technology SQL training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the SQL course at a local training venue in Batley. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations 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.
We have operated primarily in the West Midlands for twenty years. Our clients include: Canadian High Commission, Barclays Bank PLC, West Bromwich Building Society, Nationwide Building Society Limited, Carillion PLC, Lloyds TSB Bank PLC, Birmingham Heartlands Hospital and Birmingham City University.
SQL
- 2 day course
- Location: Batley
- 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 ... Columns
- See Training Course Details...
Foreign Keys
WHERE and ORDER BY
Renaming Tables
Common Date Functions Subqueries, Joins and Unions
Table Aliases
Subqueries
CASE syntax
The NOT Operator
Sorting By a Single Column
The BETWEEN Operator
Primary Keys
Creating Stored Procedures
The LIKE Operator
Common Math Functions
Popular Databases
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Batley
- 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 ... Troubleshoot Package Failures Deploying Packages
- See Training Course Details...
Add Packages to an SSIS Project Managing Control Flow
Configure MDS
Perform Transformation Tasks
Configure the Package Execution Strategy
Overview of Data Warehouses
Work with Windows Azure
Overview of Data Warehouse Components
Change Granularity Creating Fact Tables and Columnstore Indexes
Secure Databases Working with MDS and Windows Azure
Securing Packages and Databases
Debug Package Execution Components
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Work with MDS Databases
Create an SSIS Project
Profile OLTP Data
Add Data Flow Components to a Data Flow Task
Execute Packages from Different Control Flow Working with Dynamic Variables
Install Integration Services Working with Integration Services
Oracle PL/SQL
- 3 day course
- Location: Batley
- 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 ... Stored Subprograms
- See Training Course Details...
Maintaining Triggers
Triggers
Associative Array Collections
PL/SQL Stored Program Compilation
Package Variables
Calling a Stored Function
Conditional Statements IF/THEN
Other Supplied Packages
Beyond Declarative Integrity
Dates and Timestamps
The DBMS_OUTPUT Package
Declaring and Opening Cursors
Conditional Statements CASE
Declaring Variables
Using the %ROWTYPE Attribute
PL/SQL Syntax and Logic
Transact SQL
- 2 day course
- Location: Batley
- 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 ... Work with System Databases
- See Training Course Details...
Filter the Queried Results
Assign Aliases Using Queries
Create Queries Using Join Algorithms
Control Program Flow
Merge Data Working with SQL Server Built-in Functions
Configure User-Defined Functions (UDF)
Manage Query Plans
Write SELECT Statements
Work with Window Functions
Work with Predicates
Update Data
Work with SSPs and SMOs
Combine Data Using Simple Joins
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Insert Data
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Overview of SQL Server
Manage SQL Server Constraints Writing SELECT Queries
Work with PIVOT and UNPIVOT
Analyze Data from Query Plans
Oracle SQL
- 2 day course
- Location: Batley
- 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 ... Intervals
- See Training Course Details...
String Functions
Outer Joins
The UPDATE Statement
Tailoring Your SQL*Plus Environment
Inline Constraints
Datatypes
Selecting from Multiple Tables
Correlated Subqueries
Literal Values
Scalar Functions
Concurrency
Logical and Physical Storage Structures
NULL Values
SQL Queries - Joins
Review of Relational Database Terminology
Email us about this courses
Other Batley Enable Technology Training Courses
Excel 365 Basic - Batley Excel Training Courses
VBA - Batley Excel Training Courses
Access - Batley Access Training Courses
SSRS - Batley SQL Server Reporting Services Training Courses
Excel 365 Advanced Batley Training Courses
DAX Batley Training Courses
JQuery Batley Training Courses
Access VBA Batley Training Courses
SSIS Batley Training Courses
JQuery Mobile Batley Training Courses
JavaScript - Batley JavaScript Training Courses
Power BI - Batley Microsoft Power BI Training Courses
Excel Power Pivot Batley Training Courses
SSAS Batley Training Courses
Report Builder Batley Training Courses