SQL TRAINING COURSES SCUNTHORPE
About Enable Technology Scunthorpe SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a SQL course receives learning resources which also serves as a reference source after the course. It is our company policy to provide SQL training participants with ongoing support from the course Tutor. People who attend a SQL course can contact the Tutor for as long as they need assistance after the training.
SQL courses are taught by a Microsoft Certified Solutions Expert. Our SQL training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The SQL course could also be scheduled at a socially distanced site near you in Scunthorpe. Every SQL course can be modified to meet your bespoke 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: National Power PLC, Nuclear Engineering Services, TalkTalk Direct Limited, Loughborough University, Shell UK Oil Products Ltd, Royal Air Force, Countrywide Homes Limited and Boots UK Limited.
Oracle SQL
- 2 day course
- Location: Scunthorpe
- 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 ... Connecting to a SQL Database
- See Training Course Details...
String Functions
IN and BETWEEN
Conversion Functions
SQL Functions
Scalar Functions
Viewing Table Characteristics
Correlated Subqueries
Updatable Views
The UPDATE Statement
Explicit Locking
SQL Queries - Joins
Controlling Access to Your Tables
SQL Queries
Data Inconsistencies
Using Oracle SQL*Plus
Tailoring Your SQL*Plus Environment
The CASE...WHEN Expression
Review of Relational Database Terminology
SQL
- 2 day course
- Location: Scunthorpe
- Telephone on 01952 938014
- Course Outline
-
SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.
- Some of the training topics covered include ... Selecting Specific Columns
- See Training Course Details...
WHERE and ORDER BY
DELETE
Calculated Fields
Simple SELECT Statements
The NOT Operator
Relationships
Creating Views
Relational Databases
Order of Evaluation Advanced SELECTs
Creating Tables
NULL Values
The IN Operator
CASE syntax
Checking Multiple Conditions
Checking for Inequality
Data Types
Transact SQL
- 2 day course
- Location: Scunthorpe
- 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 ... Merge Data Working with SQL Server Built-in Functions
- See Training Course Details...
Configure Indexes
Create Queries to Test Nullability
Configure User-Defined Functions (UDF)
Analyze Data from Query Plans
Control Program Flow
Create Queries Using Built-in Functions
Write SELECT Statements
Getting Started with SQL Server 2012
Create Queries Using Join Algorithms
Write CASE Expressions Working with SQL Data Types
Delete Data
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Implement Error Handling
Insert Data
Manage Views
Work with Data Access Technologies Implementing Stored Procedures
Work with System Catalog Views Optimizing Query Performance
Manage Query Plans
Modifying Data
Work with Dynamic SQL Working with Subqueries and Table Expressions
Oracle PL/SQL
- 3 day course
- Location: Scunthorpe
- 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 ... Records and Collections
- See Training Course Details...
Creating a Stored Function
Other Supplied Packages
Stored Procedures and Functions
Datatypes
Beyond Declarative Integrity
The Package Interface and Implementation
Anchored Types
The PL/SQL Execution Environment
Triggers
Closing Cursors
Date Intervals
Triggers on Views
REF CURSOR Variables
Working with LOBs
Oracle Directories
Package Variables
Using VARRAYs
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Scunthorpe
- 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 Warehouses
- See Training Course Details...
Troubleshoot Package Failures Deploying Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Add Data Flow Components to a Data Flow Task
Execute SSIS Packages on the Server
Create Package Templates Implementing Data Flow
Perform Transformation Tasks
Overview of Data Warehouse Components
Examine Data Warehousing Concepts
Overview of Data Warehouses
Cleanse Data Using DQS Managing SSIS Package Execution
Secure Packages
Create Expressions with Variables
Work with MDS Databases
Profile OLTP Data
Deploy SSIS Packages
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Install Integration Services Working with Integration Services
Configure the Package Execution Strategy
Track Changed Data Managing Data Flow
Email us about this courses
Other Scunthorpe Enable Technology Training Courses
Excel 365 Basic Scunthorpe Training Courses
Power BI Scunthorpe Training Courses
VBA Scunthorpe Training Courses
SSIS Scunthorpe Training Courses
JQuery Scunthorpe Training Courses
SSAS Tabular - Scunthorpe SQL Server Analysis Services Training Courses
Excel 365 Advanced - Scunthorpe Excel Training Courses
DAX - Scunthorpe Excel Training Courses
Access VBA - Scunthorpe Access Training Courses
JQuery Mobile Scunthorpe Training Courses
Access Scunthorpe Training Courses
SSRS - Scunthorpe SQL Server Reporting Services Training Courses
Excel 365 Intermediate - Scunthorpe Excel Training Courses
SSAS - Scunthorpe SQL Server Analysis Services Training Courses
JavaScript - Scunthorpe JavaScript Training Courses