SQL TRAINING COURSES BUCKLEY
About Enable Technology Buckley SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a SQL course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL queries. This support is open ended.
SQL training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL courses onsite at your site. Another option is we can organise a local training site in Buckley. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations training requirements.
SQL courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Aston University, EDF Energy PLC, University of Birmingham, Homeserve PLC, Lloyds TSB Bank PLC, Barclays Bank PLC, Halfords Group PLC and DHL Express.
SQL
- 2 day course
- Location: Buckley
- 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 ... Popular Databases
- See Training Course Details...
Foreign Keys
Common String Functions
Using CASE Inserting, Updating and Deleting Records
Using the WHERE clause to check for greater or less than
Simple SELECT Statements
Data Types
Dropping Views
Selecting All Columns in All Rows
Creating Views
Datatypes
Checking for Equality
Comments
Common Math Functions
Tables
The WHERE Clause and Operator Words
Creating Tables
Relational Databases
Oracle PL/SQL
- 3 day course
- Location: Buckley
- 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 ... Creating a Stored Function
- See Training Course Details...
Exception Handlers
XML Packages
Date Intervals
Datatypes
The UTL_FILE Package
Dependencies and Validation
Records and Collections
Stored Functions and SQL
Compile-Time Warnings
Structure of a Package
Oracle Directories
Oracle-Supplied Packages
The DBMS_UTILITY Package
Scope and Name Resolution
Stored Subprograms
Triggers on Views
Nesting Blocks
Associative Array Collections
Triggers
SQLCODE and SQLERRM
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Buckley
- 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 ... Examine MSI Packages
- See Training Course Details...
Deploy SSIS Packages
Add Packages to an SSIS Project Managing Control Flow
Create Fact Tables
Deploy a Control Flow
Perform Transformation Tasks
Overview of Data Warehouses
Add Script Tasks and Script Components to an SSIS Package
Overview of Data Warehouse Components
Cleanse Data Using DQS Managing SSIS Package Execution
Create Expressions with Variables
Debug Package Execution Components
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Work with MDS Databases
Work with Windows Azure
Create Package Templates Implementing Data Flow
Create an SSIS Project
Add Data Flow Components to a Data Flow Task
Profile OLTP Data
Execute SSIS Packages on the Server
Transact SQL
- 2 day course
- Location: Buckley
- 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 ... Manage Transactions Querying SQL Server System Metadata
- See Training Course Details...
Configure User-Defined Functions (UDF)
Work with System Catalog Views Optimizing Query Performance
Create Queries Using Built-in Functions
Implement Error Handling
Manage Query Plans
Work with String and Numeric Data Types
Sort the Queried Data
Overview of SQL Server
Filter the Queried Results
Update Data
Work with Variables and Batches
Overview of T-SQL
Work with Subqueries
Group and Aggregate Data Programming in T-SQL
Manage Triggers
Write CASE Expressions Working with SQL Data Types
Assign Aliases Using Queries
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Work with Set Operators
Work with Date and Time Data Types
Oracle SQL
- 2 day course
- Location: Buckley
- 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 ... Data Inconsistencies
- See Training Course Details...
Pattern Matching: LIKE and REGEXP_LIKE
Modifying Table Definitions
Sample Database
Synonyms
Logical and Physical Storage Structures
Graphical Clients
Date Formats
Correlated Subqueries
The SQL Buffer
Grouping Rows
The SELECT Statement
Transaction Management
Scalar Functions
Introduction to SQL
Connecting to a SQL Database
Nulls and DISTINCT
SQL Functions
Email us about this courses
Other Buckley Enable Technology Training Courses
JQuery - Buckley JavaScript Training Courses
VBA Buckley Training Courses
Power Query - Buckley Excel Training Courses
SSAS Tabular Buckley Training Courses
JQuery Mobile - Buckley JavaScript Training Courses
Power BI - Buckley Microsoft Power BI Training Courses
SSRS Buckley Training Courses
SSIS - Buckley SQL Server Integration Services Training Courses
Access - Buckley Access Training Courses
DAX Buckley Training Courses
Excel 365 Intermediate Buckley Training Courses
Report Builder - Buckley SQL Server Reporting Services Training Courses
SSAS - Buckley SQL Server Analysis Services Training Courses
Excel 365 Advanced Buckley Training Courses
Access VBA - Buckley Access Training Courses