Enable Technology

SQL HARTLEPOOL TRAINING COURSES 

SQL TRAINING COURSES HARTLEPOOL




About Enable Technology Hartlepool SQL Training Courses

Enable Technology specialise in succinct skills based SQL training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended SQL post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

SQL courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Hartlepool. We are more than happy to incorporate additional topics to accommodate your organisations SQL 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

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Carillion PLC, Dollond & Aitchison Limited, Keele University, Canadian High Commission, Cadbury PLC, Boots UK Limited, Capita Group PLC and GKN PLC.




Oracle SQL

  • 2 day course
  • Location: Hartlepool
  • Telephone on 01952 305730
  • 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 ...
  • The SELECT Statement 
    Regular Expression Functions 
    Nulls and DISTINCT 
    SQL*Plus LOB Support 
    The DELETE statement 
    Logical and Physical Storage Structures 
    Deleting a Table Definition 
    Connecting to a SQL Database 
    Constraints 
    Joining Tables 
    SQL*Plus 
    Other Database Objects 
    Numeric Functions 
    Oracle Pseudocolumns 
    SQL*Plus Substitution Variables 
    Defining Tables 
    Using Oracle SQL*Plus 
    Correlated Subqueries 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Hartlepool
  • Telephone on 01952 305730
  • 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 ...
  • Debugging and Troubleshooting Packages
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Troubleshoot Package Failures Deploying Packages
    Work with MDS Databases
    Execute SSIS Packages on the Server
    Create Package Templates Implementing Data Flow
    Add Packages to an SSIS Project Managing Control Flow
    Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Overview of Data Warehouse Components
    Introduction to Data Warehouses
    Work with Windows Azure
    Deploy SSIS Packages
    Create an SSIS Project
    Secure Packages
    Examine MSI Packages
    Create Dimensions
    Overview of Data Warehouses
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Perform Transformation Tasks
    Create Fact Tables

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Hartlepool
  • Telephone on 01952 305730
  • 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 ...
  • Modifying Data
    Work with System Databases
    Overview of SQL Server
    Work with T-SQL Statements
    Work with Binary Data Types
    Insert Data
    Work with Subqueries
    Combine Data Using Simple Joins
    Delete Data
    Sort the Queried Data
    Work with Set Operators
    Work with Variables and Batches
    Perform Advanced Filtering Querying Data from Multiple Tables
    Implement Error Handling
    Manage Query Plans
    Work with Dynamic SQL Working with Subqueries and Table Expressions
    Merge Data Working with SQL Server Built-in Functions
    Manage Triggers
    Work with System Catalog Views Optimizing Query Performance
    Write SELECT Statements
    Create Queries to Test Nullability

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Hartlepool
  • Telephone on 01952 305730
  • 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 
    Maintaining PL/SQL Code 
    Triggers 
    Large Object Types 
    Local Procedures and Functions 
    Internal LOBs 
    Calling a Stored Procedure 
    XML Packages 
    Exception Handling
    Package Variables 
    Cascading Triggers and Mutating Tables 
    Using Packages 
    Passing Parameters and Default Arguments 
    Maintaining Stored Programs
    WHILE and FOR Loops 
    Networking Packages 
    Maintaining Triggers 
    The PL/SQL Execution Environment 
    Collection Methods 

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Hartlepool
  • Telephone on 01952 305730
  • 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 ...
  • Foreign Keys
    Creating Tables
    Creating Tables
    Relational Database Management System
    Dropping Tables
    Table Aliases
    Sorting By Column Position
    Data Types
    The BETWEEN Operator
    Benefits of Views
    Checking for Inequality
    The IN Operator
    Aggregate Functions
    Subqueries
    Dropping Views
    Checking Multiple Conditions
    Tables

  • See Training Course Details...



Email us about this courses



Other Hartlepool Enable Technology Training Courses

Excel Intermediate Hartlepool Training Courses
Crystal 2013 Hartlepool Training Courses
Crystal XI Hartlepool Training Courses
SSIS 2014 - Hartlepool SQL Server Integration Services Training Courses
Power BI - Hartlepool Microsoft Power BI Training Courses
Excel Basic Hartlepool Training Courses
Excel Power Pivot Hartlepool Training Courses
JQuery Mobile - Hartlepool JavaScript Training Courses
DAX - Hartlepool Excel Training Courses
PowerPoint Basic Hartlepool Training Courses
SSRS 2014 - Hartlepool SQL Server Reporting Services Training Courses
SSAS 2008 - Hartlepool SQL Server Analysis Services Training Courses
Microsoft Project Level 2 Hartlepool Training Courses
Oracle BI - Hartlepool Data Analytics Training Courses
Visio 2013 - Hartlepool Visio Training Courses



North - Possible SQL Training Course Locations


Wakefield SQL Training Courses
Leeds SQL Training Courses
Hartlepool SQL Training Courses
Scarborough SQL Training Courses
Scunthorpe SQL Training Courses
York SQL Training Courses
Huddersfield SQL Training Courses
Newcastle Upon Tyne SQL Training Courses
Keighley SQL Training Courses
Doncaster SQL Training Courses
Wetherby SQL Training Courses
Sunderland SQL Training Courses
Gateshead SQL Training Courses
Castleford SQL Training Courses
Batley SQL Training Courses
Yorkshire SQL Training Courses
Halifax SQL Training Courses
South Shields SQL Training Courses
Hexham SQL Training Courses
Pudsey SQL Training Courses
North East SQL Training Courses
Dewsbury SQL Training Courses
Rotherham SQL Training Courses
Sheffield SQL Training Courses
Harrogate SQL Training Courses
Grimsby SQL Training Courses
Normanton SQL Training Courses
Bridlington SQL Training Courses
Durham SQL Training Courses
Barnsley SQL Training Courses
Middlesbrough SQL Training Courses

Wakefield, Leeds, Hartlepool, Scarborough, Scunthorpe, York, Huddersfield, Newcastle Upon Tyne, Keighley, Doncaster, Wetherby, Sunderland, Gateshead, Castleford, Batley, Yorkshire, Halifax, South Shields, Hexham, Pudsey, North East, Dewsbury, Rotherham, Sheffield, Harrogate, Grimsby, Normanton, Bridlington, Durham, Barnsley, Middlesbrough