SQL TRAINING COURSES BUCKLEY
About Enable Technology Buckley SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given SQL courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. SQL courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can supply all of the equipment necessary to deliver SQL courses onsite at your offices. You simply need to provide a suitable room. We also offer the option of scheduling of SQL course at a socially distanced venue near you in Buckley. We are happy to discuss customising the course content should you have particular SQL 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. Some of our clients are DHL Express, National Power PLC, South Staffordshire Water PLC, Total Telecommunications Limited, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, Halfords Group PLC and Shell UK Oil Products Ltd.
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 ... Types of Triggers
- See Training Course Details...
Generating an Error
Datatypes
Temporary LOBs
Date Intervals
FOR UPDATE Cursors
The Cursor FOR Loop
Maintaining Stored Programs
User-Defined Exceptions
Loops
Local Procedures and Functions
Exception Handlers
XML Packages
External LOBs
Conditional Statements CASE
SQLCODE and SQLERRM
Internal LOBs
Using the %ROWTYPE Attribute
Triggers on Views
Cascading Triggers and Mutating Tables
Stored Functions and SQL
SQL
- 2 day course
- Location: Buckley
- 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 ... Relational Database Management System
- See Training Course Details...
Tables
Mathematical Calculations
Adding and Dropping Columns
Renaming Tables
Common Date Functions Subqueries, Joins and Unions
Subqueries
Comments
Sorting By Column Position
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Creating Stored Procedures
Concatenation
CASE syntax
Sorting By a Single Column
Checking for Equality
The BETWEEN Operator
Relationships
Transact SQL
- 2 day course
- Location: Buckley
- 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 ... Perform Advanced Filtering Querying Data from Multiple Tables
- See Training Course Details...
Overview of SQL Server
Work with System Databases
Work with Binary Data Types
Sort the Queried Data
Work with Predicates
Work with System Catalog Views Optimizing Query Performance
Configure User-Defined Functions (UDF)
Work with Subqueries
Create Queries Using Join Algorithms
Work with Date and Time Data Types
Write SELECT Statements
Work with Variables and Batches
Manage Triggers
Create Queries to Test Nullability
Configure Indexes
Work with Data Access Technologies Implementing Stored Procedures
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Manage Transactions Querying SQL Server System Metadata
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Update Data
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 ... Debug Package Execution Components
- See Training Course Details...
Create Package Templates Implementing Data Flow
Execute SSIS Packages on the Server
Profile OLTP Data
Configure MDS
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Execute Packages from Different Control Flow Working with Dynamic Variables
Create Dimensions
Secure Packages
Create Fact Tables
Overview of Data Warehouse Components
Add Packages to an SSIS Project Managing Control Flow
Create Expressions with Variables
Cleanse Data Using DQS Managing SSIS Package Execution
Securing Packages and Databases
Work with MDS Databases
Troubleshoot Package Failures Deploying Packages
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Configure the Package Execution Strategy
Add Data Flow Components to a Data Flow Task
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 Manipulation and Transactions
- See Training Course Details...
Connecting to a SQL Database
Constraints
Creating Views
Using Oracle SQL*Plus
IN and BETWEEN
Date Functions
Choosing Rows with the WHERE Clause
Interactive SQL*Plus Scripts
Relational Database Management Systems
Sample Database
Self Joins
Introduction to SQL
Datatypes
Transaction Management
Review of Relational Database Terminology
NULL Values
Data Definition and Control Statements
Nulls and DISTINCT
Combining SELECT Statements
Email us about this courses
Other Buckley Enable Technology Training Courses
JQuery Buckley Training Courses
Excel Power Pivot Buckley Training Courses
VBA - Buckley Excel Training Courses
Excel 365 Basic - Buckley Excel Training Courses
Access Buckley Training Courses
Excel 365 Advanced Buckley Training Courses
Power Query - Buckley Excel Training Courses
SSRS Buckley Training Courses
Power BI Buckley Training Courses
Access VBA - Buckley Access Training Courses
Report Builder - Buckley SQL Server Reporting Services Training Courses
SSAS - Buckley SQL Server Analysis Services Training Courses
SSAS Tabular Buckley Training Courses
JavaScript - Buckley JavaScript Training Courses
JQuery Mobile - Buckley JavaScript Training Courses