SQL TRAINING COURSES CASTLEFORD
About Enable Technology Castleford SQL Training Courses
We are company which specialises in short, two and three day intensive SQL technology training courses. All of our tutors are Microsoft Certified Professionals. We provide every candidate with SQL training materials which they keep after the course. Our policy is to provide open ended SQL post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver SQL courses onsite at your site. We are also more than happy to organise a local course at a training location in Castleford. All SQL courses can be customised to meet your particular requirements.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Vodafone Group Services, Countrywide Homes Limited, Loughborough University, Dollond & Aitchison Limited, Queen's Medical Centre Nottingham, Shell UK Oil Products Ltd, Halfords Group PLC and Boots UK Limited.
SQL
- 2 day course
- Location: Castleford
- 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 ... Relationships
- See Training Course Details...
Benefits of Stored Procedures
Selecting Specific Columns
Simple SELECT Statements
The WHERE Clause and Operator Words
Sorting Records
The LIKE Operator
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Grouping and Aggregating Data
Mathematical Calculations
DELETE
Columns
Creating Views
Common Math Functions
Dropping Tables
The BETWEEN Operator
Oracle SQL
- 2 day course
- Location: Castleford
- 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 ... SQL Functions
- See Training Course Details...
SQL Queries - Joins
Constraints
Relational Database Management Systems
Logical and Physical Storage Structures
Synonyms
Connecting to a SQL Database
Sample Database
Date Functions
SQL*Plus LOB Support
Introduction to SQL
The UPDATE Statement
The CASE...WHEN Expression
Graphical Clients
Explicit Locking
Loading Tables From External Sources
Regular Expression Functions
The Aggregate Functions
String Functions
Oracle PL/SQL
- 3 day course
- Location: Castleford
- 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 ... Generating an Error
- See Training Course Details...
Beyond Declarative Integrity
Package Variables
Selecting into a Variable
The Package Interface and Implementation
Date Intervals
Dependencies and Validation
Internal LOBs
Creating a Stored Function
Creating a Stored Procedure
Working with LOBs
Records and Collections
Oracle Directories
Passing Parameters and Default Arguments
PL/SQL Stored Program Compilation
System Triggers
LOB Locators
Cascading Triggers and Mutating Tables
Maintaining PL/SQL Code
Anchored Types
The Cursor FOR Loop
Transact SQL
- 2 day course
- Location: Castleford
- 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 ... Work with Data Access Technologies Implementing Stored Procedures
- See Training Course Details...
Manage Views
Sort the Queried Data
Write SELECT Statements
Delete Data
Manage Transactions Querying SQL Server System Metadata
Work with System Catalog Views Optimizing Query Performance
Filter the Queried Results
Implement Error Handling
Control Program Flow
Work with Set Operators
Perform Advanced Filtering Querying Data from Multiple Tables
Getting Started with SQL Server 2012
Assign Aliases Using Queries
Analyze Data from Query Plans
Work with Binary Data Types
Work with Predicates
Configure Indexes
Work with Variables and Batches
Configure User-Defined Functions (UDF)
Write CASE Expressions Working with SQL Data Types
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Castleford
- 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 ... Install Integration Services Working with Integration Services
- See Training Course Details...
Secure Databases Working with MDS and Windows Azure
Work with MDS Databases
Configure the Package Execution Strategy
Create Expressions with Variables
Change Granularity Creating Fact Tables and Columnstore Indexes
Debug Package Execution Components
Deploy SSIS Packages
Add Packages to an SSIS Project Managing Control Flow
Add Data Flow Components to a Data Flow Task
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create an SSIS Project
Execute SSIS Packages on the Server
Securing Packages and Databases
Configure MDS
Create Package Templates Implementing Data Flow
Create Fact Tables
Overview of Data Warehouses
Profile OLTP Data
Deploy a Control Flow
Email us about this courses
Other Castleford Enable Technology Training Courses
Report Builder - Castleford SQL Server Reporting Services Training Courses
Excel Power Pivot - Castleford Excel Training Courses
Excel 365 Intermediate Castleford Training Courses
JQuery Mobile Castleford Training Courses
Power Query - Castleford Excel Training Courses
Access VBA Castleford Training Courses
SSRS - Castleford SQL Server Reporting Services Training Courses
SSAS Tabular - Castleford SQL Server Analysis Services Training Courses
Access Castleford Training Courses
SSIS - Castleford SQL Server Integration Services Training Courses
JavaScript Castleford Training Courses
JQuery Castleford Training Courses
Excel 365 Advanced - Castleford Excel Training Courses
DAX Castleford Training Courses
SSAS Castleford Training Courses