SQL TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. All of our tutors are Microsoft Certified Professionals. We will issue each SQL training participant with learning resources which they can refer to post training. 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 offers instructor led training taught by technology specialists. Our SQL training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The SQL course could also be scheduled at a socially distanced site near you in Wednesbury. We are happy to discuss customising the course content should you have particular SQL training requirements.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Boots UK Limited, Loughborough University, EDF Energy PLC, Birmingham City Council, Countrywide Homes Limited, South Staffordshire Water PLC, Aston University and Cadbury PLC.
Oracle SQL
- 2 day course
- Location: Wednesbury
- 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 ... Compound Expressions
- See Training Course Details...
Buffer Manipulation Commands
SQL*Plus Substitution Variables
Constraints
IN and BETWEEN
Other Database Objects
Numeric Functions
Concurrency
Using Oracle SQL*Plus
Creating Views
SQL Functions
The INSERT Statement
Conversion Functions
Correlated Subqueries
Updatable Views
Grouping Rows
Defining Tables
Oracle Pseudocolumns
Intervals
Data Definition and Control Statements
Oracle PL/SQL
- 3 day course
- Location: Wednesbury
- 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 ... Declaring Variables
- See Training Course Details...
Triggers
Networking Packages
PL/SQL Variables and Datatypes
Collection Methods
Records and Collections
SQLCODE and SQLERRM
Passing Parameters and Default Arguments
FOR UPDATE Cursors
PL/SQL Blocks and Programs
Package Variables
Local Procedures and Functions
Cursor Parameters
Maintaining Stored Programs
System Triggers
Packages
Parameter Modes
REF CURSOR Variables
BULK COLLECT Clause
Conditional Statements CASE
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Wednesbury
- 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 ... Overview of Data Warehouses
- See Training Course Details...
Add Data Flow Components to a Data Flow Task
Add Script Tasks and Script Components to an SSIS Package
Track Changed Data Managing Data Flow
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Perform Transformation Tasks
Configure the Package Execution Strategy
Cleanse Data Using DQS Managing SSIS Package Execution
Secure Packages
Profile OLTP Data
Create Expressions with Variables
Deploy SSIS Packages
Securing Packages and Databases
Create Package Templates Implementing Data Flow
Install Integration Services Working with Integration Services
Create an SSIS Project
Execute Packages from Different Control Flow Working with Dynamic Variables
Examine Data Warehousing Concepts
Examine MSI Packages
SQL
- 2 day course
- Location: Wednesbury
- 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 ... Dropping Views
- See Training Course Details...
Comments
The IN Operator
Relational Databases
Common Date Functions Subqueries, Joins and Unions
Benefits of Stored Procedures
Foreign Keys
Mathematical Calculations
Dropping Tables
Simple SELECT Statements
The LIKE Operator
Checking for Inequality
Benefits of Views
CASE syntax
NULL Values
Creating Stored Procedures
Conditional Processing with CASE
Outer Joins
Stored Procedures
Transact SQL
- 2 day course
- Location: Wednesbury
- Telephone on 01952 938014
- Course Outline
-
This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.
The course id practical, hands on and does not assume prior SQL or programming experience.
- Some of the training topics covered include ... Work with Set Operators
- See Training Course Details...
Filter the Queried Results
Manage Stored Procedures
Work with Window Functions
Control Program Flow
Implement Error Handling
Manage SQL Server Constraints Writing SELECT Queries
Group and Aggregate Data Programming in T-SQL
Combine Data Using Simple Joins
Manage Views
Work with System Catalog Views Optimizing Query Performance
Perform Advanced Filtering Querying Data from Multiple Tables
Assign Aliases Using Queries
Manage Transactions Querying SQL Server System Metadata
Work with Grouping Sets Managing Error Handling and Transactions
Write CASE Expressions Working with SQL Data Types
Write SELECT Statements
Overview of SQL Server
Sort the Queried Data
Configure User-Defined Functions (UDF)
Work with Predicates
Email us about this courses
Other Wednesbury Enable Technology Training Courses
Access Wednesbury Training Courses
SSAS Tabular Wednesbury Training Courses
Report Builder Wednesbury Training Courses
Power Query Wednesbury Training Courses
Excel 365 Intermediate Wednesbury Training Courses
Power BI Wednesbury Training Courses
DAX - Wednesbury Excel Training Courses
VBA - Wednesbury Excel Training Courses
JavaScript Wednesbury Training Courses
Access VBA - Wednesbury Access Training Courses
Excel Power Pivot Wednesbury Training Courses
SSRS - Wednesbury SQL Server Reporting Services Training Courses
SSIS - Wednesbury SQL Server Integration Services Training Courses
Excel 365 Basic Wednesbury Training Courses
SSAS - Wednesbury SQL Server Analysis Services Training Courses