SQL TRAINING COURSES MANCHESTER
About Enable Technology Manchester SQL Training Courses
We are company which specialises in short, two and three day intensive SQL technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and SQL course resources that can be referenced post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Manchester. We are happy to modify the SQL syllabus to match your teams 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Yell Group PLC, South Staffordshire Water PLC, Vodafone Group Services, Loughborough University, Birmingham City University, Norwich Union PLC, Aston University and TalkTalk Direct Limited.
Transact SQL
- 2 day course
- Location: Manchester
- 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 ... Sort the Queried Data
- See Training Course Details...
Modifying Data
Write CASE Expressions Working with SQL Data Types
Work with PIVOT and UNPIVOT
Group and Aggregate Data Programming in T-SQL
Insert Data
Work with SSMS Working with T-SQL
Write SELECT Statements
Create Queries Using Join Algorithms
Work with Predicates
Manage Query Plans
Create Queries Using Built-in Functions
Control Program Flow
Manage Stored Procedures
Create Queries to Test Nullability
Merge Data Working with SQL Server Built-in Functions
Work with Dynamic SQL Working with Subqueries and Table Expressions
Perform Advanced Filtering Querying Data from Multiple Tables
Overview of T-SQL
Work with System Catalog Views Optimizing Query Performance
Work with the XML Data Type Sorting and Filtering Data
Oracle PL/SQL
- 3 day course
- Location: Manchester
- 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 ... Using the %ROWTYPE Attribute
- See Training Course Details...
Calling a Stored Procedure
Stored Functions and SQL
Triggers
The DBMS_LOB Package
Record Variables
Privileges for Stored Programs
Closing Cursors
Creating a Stored Procedure
PL/SQL Stored Program Compilation
Dependencies and Validation
The Package Interface and Implementation
Selecting into a Variable
Using Nested TABLEs
Networking Packages
The Implicit (SQL) Cursor
Declaring Variables
Oracle SQL
- 2 day course
- Location: Manchester
- 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 ... NULL Values
- See Training Course Details...
Review of Relational Database Terminology
Views
Compound Expressions
The UPDATE Statement
Sample Database
Tailoring Your SQL*Plus Environment
Introduction to SQL
Oracle Versioning and History
Using Oracle SQL*Plus
Logical and Physical Storage Structures
Oracle Pseudocolumns
The Aggregate Functions
Viewing Table Characteristics
Aggregate Functions and Advanced Techniques
Datatypes
Self Joins
Datatypes
Interactive SQL*Plus Scripts
Data Definition and Control Statements
Regular Expression Functions
SQL
- 2 day course
- Location: Manchester
- Telephone on 01952 938014
- Course Outline
-
This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.
- Some of the training topics covered include ... CASE syntax
- See Training Course Details...
Relationships
Foreign Keys
Sorting Records
Adding and Dropping Columns
Common Date Functions Subqueries, Joins and Unions
Outer Joins
Common String Functions
NULL Values
Datatypes
Checking for Equality
Conditional Processing with CASE
Checking Multiple Conditions
Dropping Tables
Order of Evaluation Advanced SELECTs
Data Types
Selecting Distinct Records
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Manchester
- 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 ... Execute Packages from Different Control Flow Working with Dynamic Variables
- See Training Course Details...
Examine Data Warehousing Concepts
Configure the Package Execution Strategy
Work with MDS Databases
Cleanse Data Using DQS Managing SSIS Package Execution
Securing Packages and Databases
Configure MDS
Execute SSIS Packages on the Server
Overview of Data Warehouses
Introduction to Data Warehouses
Troubleshoot Package Failures Deploying Packages
Create Fact Tables
Secure Packages
Create Expressions with Variables
Overview of Data Warehouse Components
Track Changed Data Managing Data Flow
Secure Databases Working with MDS and Windows Azure
Create Package Templates Implementing Data Flow
Perform Transformation Tasks
Change Granularity Creating Fact Tables and Columnstore Indexes
Email us about this courses
Other Manchester Enable Technology Training Courses
SSAS Manchester Training Courses
Excel 365 Intermediate Manchester Training Courses
Power Query - Manchester Excel Training Courses
Power BI - Manchester Microsoft Power BI Training Courses
Excel 365 Advanced Manchester Training Courses
Access Manchester Training Courses
DAX Manchester Training Courses
VBA - Manchester Excel Training Courses
Excel Power Pivot - Manchester Excel Training Courses
SSIS - Manchester SQL Server Integration Services Training Courses
Access VBA Manchester Training Courses
Excel 365 Basic Manchester Training Courses
JQuery Mobile - Manchester JavaScript Training Courses
JavaScript Manchester Training Courses
SSRS Manchester Training Courses