Enable Technology

SQL BLACKBURN TRAINING COURSES 

SQL TRAINING COURSES BLACKBURN




About Enable Technology Blackburn SQL Training Courses

We offer intensive two and three days SQL courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a SQL course will be provided with training materials and practice files to retain after the course. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.

We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Another way we could deliver the SQL course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.

Taught SQL courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: National Power PLC, Canadian High Commission, Nationwide Building Society Limited, Birmingham City University, West Bromwich Building Society, Cadbury PLC, Dollond & Aitchison Limited and Shell UK Oil Products Ltd.




Oracle SQL

  • 2 day course
  • Location: Blackburn
  • 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 ...
  • Synonyms
    Deleting a Table Definition 
    Intervals 
    Nulls and DISTINCT 
    Datatypes 
    NULL Values 
    Data Manipulation and Transactions 
    Oracle Pseudocolumns 
    Modifying Table Definitions 
    SQL Queries 
    Outer Joins 
    Selecting from Multiple Tables 
    Conversion Functions 
    The INSERT Statement 
    Inline Constraints 
    Correlated Subqueries 
    Grouping Rows 
    Numeric Functions 
    Review of Relational Database Terminology 
    Tailoring Your SQL*Plus Environment 

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Blackburn
  • 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 ...
  • Mathematical Calculations
    Calculated Fields
    Creating and Modifying Tables
    Subqueries
    Grouping and Aggregating Data
    CASE syntax
    Relational Databases
    WHERE and ORDER BY
    Foreign Keys
    Dropping Stored Procedures
    Creating Stored Procedures
    Relational Database Management System
    Selecting Specific Columns
    Benefits of Stored Procedures
    Columns
    Comments
    The BETWEEN Operator
    Common Math Functions

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Blackburn
  • 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 System Databases
    Analyze Data from Query Plans
    Manage SQL Server Constraints Writing SELECT Queries
    Create Queries to Test Nullability
    Group and Aggregate Data Programming in T-SQL
    Write CASE Expressions Working with SQL Data Types
    Configure Indexes
    Control Program Flow
    Overview of SQL Server
    Work with PIVOT and UNPIVOT
    Work with SSMS Working with T-SQL
    Work with the XML Data Type Sorting and Filtering Data
    Manage Transactions Querying SQL Server System Metadata
    Work with Variables and Batches
    Perform Advanced Filtering Querying Data from Multiple Tables
    Merge Data Working with SQL Server Built-in Functions
    Configure User-Defined Functions (UDF)
    Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
    Sort the Queried Data
    Work with Grouping Sets Managing Error Handling and Transactions
    Work with Date and Time Data Types

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Blackburn
  • 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 ...
  • Structure of a Package 
    Stored Subprograms 
    Multi-Row Queries 
    FOR UPDATE Cursors 
    Subtypes 
    Exception Handlers 
    Maintaining Triggers 
    Associative Array Collections 
    Types of Triggers 
    The Implicit (SQL) Cursor
    The DBMS_UTILITY Package 
    Creating a Stored Procedure 
    Calling a Stored Function 
    WHILE and FOR Loops 
    Using Packages 
    LOB Locators 
    Iterating Through Collections 
    Cursors 
    Large Object Types 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Blackburn
  • 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 Data Flow Components to a Data Flow Task
    Cleanse Data Using DQS Managing SSIS Package Execution
    Troubleshoot Package Failures Deploying Packages
    Secure Packages
    Introduction to Data Warehouses
    Profile OLTP Data
    Debugging and Troubleshooting Packages
    Create an SSIS Project
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Configure the Package Execution Strategy
    Install Integration Services Working with Integration Services
    Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Create Dimensions
    Configure MDS
    Work with Windows Azure
    Debug Package Execution Components
    Create Package Templates Implementing Data Flow
    Add Script Tasks and Script Components to an SSIS Package
    Add Packages to an SSIS Project Managing Control Flow
    Examine MSI Packages

  • See Training Course Details...



Email us about this courses



Other Blackburn Enable Technology Training Courses

SSIS - Blackburn SQL Server Integration Services Training Courses
SSAS Tabular - Blackburn SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Blackburn Excel Training Courses
SSRS Blackburn Training Courses
Power BI - Blackburn Microsoft Power BI Training Courses
Excel 365 Advanced - Blackburn Excel Training Courses
Access Blackburn Training Courses
JavaScript Blackburn Training Courses
SSAS - Blackburn SQL Server Analysis Services Training Courses
Excel 365 Basic Blackburn Training Courses
JQuery Mobile Blackburn Training Courses
Access VBA - Blackburn Access Training Courses
JQuery - Blackburn JavaScript Training Courses
Excel Power Pivot - Blackburn Excel Training Courses
Power Query Blackburn Training Courses