SQL TRAINING COURSES OSWESTRY
About Enable Technology Oswestry SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. We guarantee the training will be delivered by a Microsoft certified expert. We provide every candidate with SQL training materials which they keep after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
SQL training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL courses onsite at your site. We also offer the option of scheduling of SQL course at a venue near you in Oswestry. All SQL courses can be customised to meet your particular requirements.
SQL courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Countrywide Homes Limited, Dollond & Aitchison Limited, EDF Energy PLC, Canadian High Commission, DHL Express, Keele University and Queen's Medical Centre Nottingham.
Transact SQL
- 2 day course
- Location: Oswestry
- 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 Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
- See Training Course Details...
Implement Error Handling
Manage Views
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Overview of T-SQL
Update Data
Delete Data
Manage SQL Server Constraints Writing SELECT Queries
Work with Window Functions
Manage Stored Procedures
Manage Transactions Querying SQL Server System Metadata
Work with SSMS Working with T-SQL
Filter the Queried Results
Sort the Queried Data
Work with System Catalog Views Optimizing Query Performance
Create Queries Using Built-in Functions
Write SELECT Statements
Manage Triggers
Analyze Data from Query Plans
Work with Subqueries
Create Queries to Test Nullability
Oracle PL/SQL
- 3 day course
- Location: Oswestry
- 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 ... Package Variables
- See Training Course Details...
Generating an Error
PL/SQL Variables and Datatypes
LOB Locators
Beyond Declarative Integrity
Triggers
Creating a Stored Function
FORALL Statement
Other Supplied Packages
Large Object Types
Creating a Stored Procedure
Stored Procedures and Functions
Iterating Through Collections
Calling a Stored Procedure
Fetching Rows
FOR UPDATE Cursors
Oracle-Supplied Packages
Stored Subprograms
Multi-Row Queries
Maintaining Triggers
Oracle SQL
- 2 day course
- Location: Oswestry
- 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 ... Connecting to a SQL Database
- See Training Course Details...
String Functions
Data Manipulation and Transactions
SQL Queries
Concurrency
Inline Constraints
The EXISTS Operator
Logical and Physical Storage Structures
Selecting from Multiple Tables
Date Functions
Data Definition and Control Statements
Sequences
Literal Values
Buffer Manipulation Commands
Oracle Pseudocolumns
Aggregate Functions and Advanced Techniques
Pattern Matching: LIKE and REGEXP_LIKE
Relational Database and SQL Overview
Synonyms
The SELECT Statement
SQL
- 2 day course
- Location: Oswestry
- 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 ... The WHERE Clause and Operator Words
- See Training Course Details...
Mathematical Calculations
Checking for NULL
The NOT Operator
Foreign Keys
Adding and Dropping Columns
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Dropping Stored Procedures
Relational Database Management System
Creating and Modifying Tables
WHERE and ORDER BY
Grouping and Aggregating Data
The LIKE Operator
Using CASE Inserting, Updating and Deleting Records
Checking Multiple Conditions
The BETWEEN Operator
Primary Keys
Checking for Inequality
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Oswestry
- 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 ... Execute Packages from Different Control Flow Working with Dynamic Variables
- See Training Course Details...
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Work with MDS Databases
Create Expressions with Variables
Perform Transformation Tasks
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Add Script Tasks and Script Components to an SSIS Package
Create Fact Tables
Overview of Data Warehouse Components
Track Changed Data Managing Data Flow
Add Data Flow Components to a Data Flow Task
Securing Packages and Databases
Overview of Data Warehouses
Examine Data Warehousing Concepts
Configure MDS
Deploy SSIS Packages
Deploy a Control Flow
Add Packages to an SSIS Project Managing Control Flow
Configure the Package Execution Strategy
Troubleshoot Package Failures Deploying Packages
Email us about this courses
Other Oswestry Enable Technology Training Courses
SSRS Oswestry Training Courses
SSAS Oswestry Training Courses
JQuery Mobile - Oswestry JavaScript Training Courses
JavaScript Oswestry Training Courses
DAX - Oswestry Excel Training Courses
JQuery Oswestry Training Courses
Power BI Oswestry Training Courses
SSAS Tabular - Oswestry SQL Server Analysis Services Training Courses
Report Builder Oswestry Training Courses
Excel 365 Basic - Oswestry Excel Training Courses
Power Query - Oswestry Excel Training Courses
SSIS Oswestry Training Courses
Excel Power Pivot Oswestry Training Courses
Access VBA Oswestry Training Courses
VBA Oswestry Training Courses