SQL TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with SQL training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL courses. Delegates can contact the course tutor with specific SQL questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL onsite. Alternatively we could schedule a course at a local socially distanced venue in Sheffield. The SQL syllabus can be modified to accommodate your specific training needs.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are University of Birmingham, Royal Air Force, Shell UK Oil Products Ltd, Norfolk Police Constabulary, Cadbury PLC, Nuclear Engineering Services, Royal & Sun Alliance Group PLC and Fujistu PLC.
Oracle SQL
- 2 day course
- Location: Sheffield
- 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 ... Datatypes
- See Training Course Details...
Controlling Access to Your Tables
Oracle Pseudocolumns
Datatypes
The Aggregate Functions
Constraints
Graphical Clients
Relational Database Management Systems
Modifying Table Definitions
Grouping Rows
NULL Values
Using Oracle SQL*Plus
Pattern Matching: LIKE and REGEXP_LIKE
Choosing Rows with the WHERE Clause
Deleting a Table Definition
Conversion Functions
Updatable Views
Literal Values
Data Definition and Control Statements
Transact SQL
- 2 day course
- Location: Sheffield
- 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 ... Filter the Queried Results
- See Training Course Details...
Sort the Queried Data
Delete Data
Work with the XML Data Type Sorting and Filtering Data
Manage Transactions Querying SQL Server System Metadata
Work with T-SQL Statements
Create Queries to Test Nullability
Combine Data Using Simple Joins
Getting Started with SQL Server 2012
Work with System Catalog Views Optimizing Query Performance
Manage Stored Procedures
Merge Data Working with SQL Server Built-in Functions
Implement Error Handling
Work with SSPs and SMOs
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with PIVOT and UNPIVOT
Control Program Flow
Configure Indexes
Write SELECT Statements
Work with Binary Data Types
Work with SSMS Working with T-SQL
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Sheffield
- 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 ... Perform Transformation Tasks
- See Training Course Details...
Create Dimensions
Cleanse Data Using DQS Managing SSIS Package Execution
Execute SSIS Packages on the Server
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Change Granularity Creating Fact Tables and Columnstore Indexes
Add Data Flow Components to a Data Flow Task
Securing Packages and Databases
Add Script Tasks and Script Components to an SSIS Package
Debug Package Execution Components
Create Fact Tables
Create Expressions with Variables
Work with MDS Databases
Profile OLTP Data
Track Changed Data Managing Data Flow
Install Integration Services Working with Integration Services
Add Packages to an SSIS Project Managing Control Flow
Create Package Templates Implementing Data Flow
Examine MSI Packages
Oracle PL/SQL
- 3 day course
- Location: Sheffield
- 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 ... Cursors
- See Training Course Details...
Datatypes
VARRAY and Nested TABLE Collections
Anchored Types
The PL/SQL Execution Environment
Scope and Name Resolution
Row-Level Triggers
The Implicit (SQL) Cursor
Dependencies and Validation
Maintaining Triggers
REF CURSOR Variables
Declaring and Opening Cursors
Internal LOBs
Calling a Stored Procedure
Stored Procedures and Functions
Types of Triggers
Collection Methods
The UTL_FILE Package
SQL
- 2 day course
- Location: Sheffield
- 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 ... Creating Views
- See Training Course Details...
The BETWEEN Operator
Mathematical Calculations
CASE syntax
Relational Databases
Grouping and Aggregating Data
Dropping Tables
Stored Procedures
The WHERE Clause and Operator Words
Concatenation
DELETE
Benefits of Stored Procedures
Dropping Views
Popular Databases
Selecting Distinct Records
Common String Functions
Multi-table Joins
Email us about this courses
Other Sheffield Enable Technology Training Courses
SSRS - Sheffield SQL Server Reporting Services Training Courses
Access Sheffield Training Courses
Power Query Sheffield Training Courses
DAX - Sheffield Excel Training Courses
SSAS Tabular Sheffield Training Courses
Access VBA Sheffield Training Courses
Power BI Sheffield Training Courses
JQuery - Sheffield JavaScript Training Courses
Excel Power Pivot Sheffield Training Courses
Excel 365 Basic Sheffield Training Courses
Excel 365 Advanced Sheffield Training Courses
Excel 365 Intermediate Sheffield Training Courses
Report Builder - Sheffield SQL Server Reporting Services Training Courses
SSAS - Sheffield SQL Server Analysis Services Training Courses
SSIS - Sheffield SQL Server Integration Services Training Courses