SQL TRAINING COURSES POOLE
About Enable Technology Poole SQL Training Courses
We offer intensive two and three days SQL courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued SQL training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL courses onsite at your site. Another way we could deliver the SQL course is at a local training site. We are happy to modify the SQL syllabus to match your teams training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, Queen's Medical Centre Nottingham, Total Telecommunications Limited, GKN PLC, Unipart Group, Yell Group PLC, TalkTalk Direct Limited and Birmingham City University.
Transact SQL
- 2 day course
- Location: Poole
- 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 ... Work with the XML Data Type Sorting and Filtering Data
- See Training Course Details...
Work with System Catalog Views Optimizing Query Performance
Insert Data
Work with T-SQL Statements
Assign Aliases Using Queries
Manage Triggers
Analyze Data from Query Plans
Work with Predicates
Configure User-Defined Functions (UDF)
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with SSPs and SMOs
Manage SQL Server Constraints Writing SELECT Queries
Work with Data Access Technologies Implementing Stored Procedures
Getting Started with SQL Server 2012
Work with Binary Data Types
Work with System Databases
Merge Data Working with SQL Server Built-in Functions
Overview of T-SQL
Work with PIVOT and UNPIVOT
Perform Advanced Filtering Querying Data from Multiple Tables
Delete Data
SQL
- 2 day course
- Location: Poole
- Telephone on 01952 938014
- Course Outline
-
This practical hands on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.
- Some of the training topics covered include ... Multi-table Joins
- See Training Course Details...
Checking for NULL
The IN Operator
WHERE and ORDER BY
Dropping Tables
Dropping Stored Procedures
Creating Tables
Sorting By Multiple Columns
NULL Values
Common Math Functions
Outer Joins
Case Sensitivity
Checking for Equality
Sorting By Column Position
Relational Databases
Relational Database Management System
Dropping Views
Benefits of Views
Data Types
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Poole
- 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 ... Add Script Tasks and Script Components to an SSIS Package
- See Training Course Details...
Overview of Data Warehouse Components
Create an SSIS Project
Securing Packages and Databases
Perform Transformation Tasks
Install Integration Services Working with Integration Services
Examine Data Warehousing Concepts
Introduction to Data Warehouses
Create Package Templates Implementing Data Flow
Configure the Package Execution Strategy
Deploy SSIS Packages
Troubleshoot Package Failures Deploying Packages
Add Data Flow Components to a Data Flow Task
Execute SSIS Packages on the Server
Work with MDS Databases
Secure Databases Working with MDS and Windows Azure
Debugging and Troubleshooting Packages
Cleanse Data Using DQS Managing SSIS Package Execution
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Change Granularity Creating Fact Tables and Columnstore Indexes
Oracle SQL
- 2 day course
- Location: Poole
- 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 ... Controlling Access to Your Tables
- See Training Course Details...
Deleting a Table Definition
Creating Views
The Aggregate Functions
Datatypes
Relational Database and SQL Overview
Tailoring Your SQL*Plus Environment
Review of Relational Database Terminology
Introduction to SQL
Compound Expressions
Sequences
String Functions
Outer Joins
Intervals
SQL Queries - Joins
Datatypes
Loading Tables From External Sources
Logical and Physical Storage Structures
Concurrency
Using SQL Functions
Oracle PL/SQL
- 3 day course
- Location: Poole
- 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 ... Packages
- See Training Course Details...
Collection Methods
Using VARRAYs
Character Data
Date Intervals
Declaring Variables
Types of Triggers
Triggers
The DBMS_UTILITY Package
Creating Packages
Conditional Statements IF/THEN
The DBMS_OUTPUT Package
Subtypes
Maintaining Stored Programs
Records and Collections
FOR UPDATE Cursors
Loops
Local Procedures and Functions
Parameter Modes
Email us about this courses
Other Poole Enable Technology Training Courses
SSAS Tabular - Poole SQL Server Analysis Services Training Courses
SSRS - Poole SQL Server Reporting Services Training Courses
Power BI Poole Training Courses
Excel 365 Basic Poole Training Courses
JQuery Mobile Poole Training Courses
Report Builder - Poole SQL Server Reporting Services Training Courses
Excel 365 Intermediate Poole Training Courses
VBA Poole Training Courses
Access VBA - Poole Access Training Courses
Access - Poole Access Training Courses
JavaScript Poole Training Courses
SSAS Poole Training Courses
DAX Poole Training Courses
SSIS - Poole SQL Server Integration Services Training Courses
Excel 365 Advanced - Poole Excel Training Courses