Enable Technology

SQL LYTHAM URMSTON TRAINING COURSES 

SQL TRAINING COURSES LYTHAM URMSTON




About Enable Technology Lytham Urmston SQL Training Courses

We offer intensive two and three days SQL courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL training materials which they keep after the course. 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.

Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local venue in Lytham Urmston. The SQL syllabus can be modified to accommodate your specific 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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Nationwide Building Society Limited, Canadian High Commission, Royal & Sun Alliance Group PLC, Cadbury PLC, Shell UK Oil Products Ltd, Fujistu PLC, Aston University and Keele University.




Transact SQL

  • 2 day course
  • Location: Lytham Urmston
  • 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 ...
  • Implement Error Handling
    Analyze Data from Query Plans
    Work with T-SQL Statements
    Perform Advanced Filtering Querying Data from Multiple Tables
    Work with Grouping Sets Managing Error Handling and Transactions
    Configure User-Defined Functions (UDF)
    Work with PIVOT and UNPIVOT
    Manage SQL Server Constraints Writing SELECT Queries
    Work with SSMS Working with T-SQL
    Work with SSPs and SMOs
    Configure Indexes
    Overview of SQL Server
    Work with Subqueries
    Insert Data
    Combine Data Using Simple Joins
    Work with Variables and Batches
    Delete Data
    Create Queries Using Built-in Functions
    Assign Aliases Using Queries
    Work with String and Numeric Data Types
    Group and Aggregate Data Programming in T-SQL

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Lytham Urmston
  • 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 ...
  • Closing Cursors 
    Scope and Name Resolution 
    Exception Handlers 
    Declaring Variables 
    The PL/SQL Execution Environment 
    BULK COLLECT Clause
    Privileges for Stored Programs 
    Declaring and Opening Cursors 
    Types of Triggers 
    Maintaining Triggers 
    Subtypes 
    Loops 
    Networking Packages 
    The Cursor FOR Loop 
    Triggers 
    Stored Subprograms 
    Assignment and Conversions 
    Oracle Directories 
    Other Supplied Packages

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Lytham Urmston
  • Telephone on 01952 938014
  • Course Outline
  • This hands on SQL (Structured Query Language) course will equip participants the skills necessary to extract filtered data from all of the leading database platforms. No prior knowledge is assumed. Participants will learn how to extract data from a relational database, create aggregated grouped reports, update, insert and delete data, create tables, views and stored procedures.

  • Some of the training topics covered include ...
  • Columns
    Concatenation
    Sorting By a Single Column
    Outer Joins
    Using the WHERE clause to check for greater or less than
    Dropping Tables
    Checking for Equality
    Aliases
    Case Sensitivity
    Mathematical Calculations
    Tables
    Common Math Functions
    The BETWEEN Operator
    Using CASE Inserting, Updating and Deleting Records
    Checking for Inequality
    Creating Views

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Lytham Urmston
  • 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 ...
  • Introduction to SQL 
    Loading Tables From External Sources 
    Deleting a Table Definition 
    Inline Constraints 
    Running SQL*Plus Scripts 
    Aggregate Functions and Advanced Techniques 
    The Aggregate Functions 
    Creating Views 
    Data Manipulation and Transactions 
    Oracle Versioning and History 
    Joining Tables 
    Choosing Rows with the WHERE Clause 
    SQL Functions 
    Using Oracle SQL*Plus 
    Data Definition and Control Statements 
    Regular Expression Functions 
    Controlling Access to Your Tables 
    Numeric Functions 
    String Functions 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Lytham Urmston
  • 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 ...
  • Track Changed Data Managing Data Flow
    Examine Data Warehousing Concepts
    Debugging and Troubleshooting Packages
    Profile OLTP Data
    Create Package Templates Implementing Data Flow
    Create Dimensions
    Create an SSIS Project
    Perform Transformation Tasks
    Examine MSI Packages
    Overview of Data Warehouses
    Create Expressions with Variables
    Debug Package Execution Components
    Configure the Package Execution Strategy
    Configure MDS
    Cleanse Data Using DQS Managing SSIS Package Execution
    Troubleshoot Package Failures Deploying Packages
    Deploy SSIS Packages
    Work with Windows Azure
    Add Data Flow Components to a Data Flow Task

  • See Training Course Details...



Email us about this courses



Other Lytham Urmston Enable Technology Training Courses

Power BI Lytham Urmston Training Courses
SSRS Lytham Urmston Training Courses
Excel 365 Basic Lytham Urmston Training Courses
DAX Lytham Urmston Training Courses
Excel 365 Intermediate - Lytham Urmston Excel Training Courses
JQuery - Lytham Urmston JavaScript Training Courses
SSAS - Lytham Urmston SQL Server Analysis Services Training Courses
Power Query - Lytham Urmston Excel Training Courses
Excel Power Pivot Lytham Urmston Training Courses
JavaScript - Lytham Urmston JavaScript Training Courses
Excel 365 Advanced - Lytham Urmston Excel Training Courses
SSIS Lytham Urmston Training Courses
Access Lytham Urmston Training Courses
SSAS Tabular - Lytham Urmston SQL Server Analysis Services Training Courses
Access VBA - Lytham Urmston Access Training Courses