SQL TRAINING COURSES NORMANTON
About Enable Technology Normanton SQL Training Courses
Enable Technology SQL courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training SQL resources which they can continue to use 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver SQL training courses onsite at your premises. If you prefer we can offer an offsite socially distanced training location in Normanton. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations training requirements.
SQL courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Dollond & Aitchison Limited, Nuclear Engineering Services, Norfolk Police Constabulary, Halfords Group PLC, University of Birmingham, Shell UK Oil Products Ltd, TalkTalk Direct Limited and Yell Group PLC.
SQL
- 2 day course
- Location: Normanton
- Telephone on 01952 938014
- Course Outline
-
This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.
- Some of the training topics covered include ... Foreign Keys
- See Training Course Details...
The NOT Operator
The LIKE Operator
The IN Operator
Whitespace and Semi-colons
WHERE and ORDER BY
Popular Databases
Common Date Functions Subqueries, Joins and Unions
Benefits of Views
Creating Views
Selecting Specific Columns
Subqueries
Columns
Grouping and Aggregating Data
Multi-table Joins
Aliases
Concatenation
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Normanton
- 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 ... Troubleshoot Package Failures Deploying Packages
- See Training Course Details...
Debugging and Troubleshooting Packages
Configure MDS
Cleanse Data Using DQS Managing SSIS Package Execution
Add Script Tasks and Script Components to an SSIS Package
Create Fact Tables
Deploy a Control Flow
Secure Packages
Debug Package Execution Components
Deploy SSIS Packages
Create Dimensions
Overview of Data Warehouses
Create Expressions with Variables
Work with MDS Databases
Create an SSIS Project
Change Granularity Creating Fact Tables and Columnstore Indexes
Add Packages to an SSIS Project Managing Control Flow
Profile OLTP Data
Execute SSIS Packages on the Server
Oracle SQL
- 2 day course
- Location: Normanton
- 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 ... Sequences
- See Training Course Details...
Defining Tables
Oracle Pseudocolumns
Combining SELECT Statements
Self Joins
Grouping Rows
Review of Relational Database Terminology
The CASE...WHEN Expression
The DELETE statement
SQL*Plus Substitution Variables
Data Inconsistencies
The Aggregate Functions
Oracle Versioning and History
Conversion Functions
Buffer Manipulation Commands
Datatypes
Constraints
Pattern Matching: LIKE and REGEXP_LIKE
Date Formats
Oracle PL/SQL
- 3 day course
- Location: Normanton
- 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 ... Comments and Labels
- See Training Course Details...
Passing Parameters and Default Arguments
Temporary LOBs
The DBMS_OUTPUT Package
Maintaining Triggers
Loops
Nesting Blocks
Anchored Types
WHILE and FOR Loops
Conditional Statements IF/THEN
Cursor Parameters
Large Object Types
Triggers on Views
Multi-Row Queries
Stored Procedures and Functions
Stored Functions and SQL
Transact SQL
- 2 day course
- Location: Normanton
- 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 ... Delete Data
- See Training Course Details...
Configure Indexes
Work with Date and Time Data Types
Group and Aggregate Data Programming in T-SQL
Combine Data Using Simple Joins
Work with PIVOT and UNPIVOT
Work with Subqueries
Control Program Flow
Work with Dynamic SQL Working with Subqueries and Table Expressions
Insert Data
Work with System Catalog Views Optimizing Query Performance
Work with Set Operators
Write SELECT Statements
Sort the Queried Data
Analyze Data from Query Plans
Work with T-SQL Statements
Work with System Databases
Work with SSMS Working with T-SQL
Manage Triggers
Create Queries to Test Nullability
Perform Advanced Filtering Querying Data from Multiple Tables
Email us about this courses
Other Normanton Enable Technology Training Courses
Excel 365 Advanced Normanton Training Courses
SSAS - Normanton SQL Server Analysis Services Training Courses
Access VBA - Normanton Access Training Courses
Power Query Normanton Training Courses
Access - Normanton Access Training Courses
Report Builder - Normanton SQL Server Reporting Services Training Courses
Excel Power Pivot Normanton Training Courses
DAX - Normanton Excel Training Courses
Excel 365 Intermediate Normanton Training Courses
SSAS Tabular - Normanton SQL Server Analysis Services Training Courses
JQuery Mobile Normanton Training Courses
Excel 365 Basic - Normanton Excel Training Courses
SSRS - Normanton SQL Server Reporting Services Training Courses
JavaScript Normanton Training Courses
Power BI Normanton Training Courses