SQL TRAINING COURSES THORNTON-CLEVELEYS
About Enable Technology Thornton-cleveleys SQL Training Courses
Enable Technology offer short intensive skills based SQL training courses. All Enable Technology tutors are Microsoft certified experts. Every person attending a SQL course will be provided with training materials and practice files to retain after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Courses are instructor led and groups sizes small. We are set up to deliver SQL training courses onsite at your premises. Alternatively we could schedule a SQL course at an alternative training site in Thornton-cleveleys. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL course to some extent is bespoke and tailored to your 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
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Nationwide Building Society Limited, EDF Energy PLC, Total Telecommunications Limited, Keele University, Cadbury PLC, Royal & Sun Alliance Group PLC, Homeserve PLC and Birmingham City Council.
SQL
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Ascending and Descending Sorts The WHERE Clause and Operator Symbols
- See Training Course Details...
DELETE
Relationships
Sorting Records
Benefits of Stored Procedures
Checking for Inequality
Dropping Views
Outer Joins
Table Aliases
Using CASE Inserting, Updating and Deleting Records
Foreign Keys
The NOT Operator
Relational Databases
Checking for Equality
Checking for NULL
Conditional Processing with CASE
Popular Databases
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Thornton-cleveleys
- 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 ... Create Expressions with Variables
- See Training Course Details...
Secure Databases Working with MDS and Windows Azure
Perform Transformation Tasks
Deploy SSIS Packages
Execute SSIS Packages on the Server
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Data Flow Components to a Data Flow Task
Secure Packages
Examine Data Warehousing Concepts
Overview of Data Warehouses
Create Package Templates Implementing Data Flow
Create Fact Tables
Introduction to Data Warehouses
Add Packages to an SSIS Project Managing Control Flow
Add Script Tasks and Script Components to an SSIS Package
Debugging and Troubleshooting Packages
Configure MDS
Troubleshoot Package Failures Deploying Packages
Track Changed Data Managing Data Flow
Create an SSIS Project
Oracle SQL
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Intervals
- See Training Course Details...
Using SQL Functions
Datatypes
SQL*Plus
Interactive SQL*Plus Scripts
The CASE...WHEN Expression
Literal Values
Logical and Physical Storage Structures
NULL Values
Synonyms
Joining Tables
Outer Joins
Conversion Functions
Combining SELECT Statements
Other Database Objects
SQL*Plus Substitution Variables
Constraints
Choosing Rows with the WHERE Clause
Date Formats
The INSERT Statement
Transact SQL
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Write SELECT Statements
- See Training Course Details...
Group and Aggregate Data Programming in T-SQL
Manage Views
Perform Advanced Filtering Querying Data from Multiple Tables
Configure Indexes
Work with Grouping Sets Managing Error Handling and Transactions
Create Queries to Test Nullability
Implement Error Handling
Work with Variables and Batches
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Manage Triggers
Work with PIVOT and UNPIVOT
Work with String and Numeric Data Types
Delete Data
Create Queries Using Join Algorithms
Getting Started with SQL Server 2012
Work with Date and Time Data Types
Work with SSPs and SMOs
Manage Query Plans
Work with T-SQL Statements
Work with Binary Data Types
Oracle PL/SQL
- 3 day course
- Location: Thornton-cleveleys
- 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 ... Named Parameter Notation
- See Training Course Details...
External LOBs
Closing Cursors
Using Packages
Conditional Statements CASE
Multi-Row Queries
Stored Functions and SQL
The UTL_FILE Package
Oracle-Supplied Packages
Privileges for Stored Programs
Maintaining PL/SQL Code
Exception Handling
Triggers
Stored Subprograms
LOB Locators
Large Object Types
XML Packages
The DBMS_UTILITY Package
Structure of a Package
Email us about this courses
Other Thornton-cleveleys Enable Technology Training Courses
Excel 365 Basic Thornton-cleveleys Training Courses
Report Builder - Thornton-cleveleys SQL Server Reporting Services Training Courses
DAX Thornton-cleveleys Training Courses
SSIS Thornton-cleveleys Training Courses
SSRS Thornton-cleveleys Training Courses
Power Query Thornton-cleveleys Training Courses
Excel 365 Advanced Thornton-cleveleys Training Courses
JQuery Mobile - Thornton-cleveleys JavaScript Training Courses
VBA Thornton-cleveleys Training Courses
JavaScript - Thornton-cleveleys JavaScript Training Courses
Access Thornton-cleveleys Training Courses
JQuery - Thornton-cleveleys JavaScript Training Courses
Excel Power Pivot - Thornton-cleveleys Excel Training Courses
Excel 365 Intermediate - Thornton-cleveleys Excel Training Courses
Power BI - Thornton-cleveleys Microsoft Power BI Training Courses