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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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