SQL TRAINING COURSES SMETHWICK
About Enable Technology Smethwick SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each SQL training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Smethwick. We offer the option of working with you to develop a bespoke SQL programme which precisely matches your organisations training requirements.
We can also deliver SQL courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Cadbury PLC, Total Telecommunications Limited, Barclays Bank PLC, Homeserve PLC and Boots UK Limited.
Oracle PL/SQL
- 3 day course
- Location: Smethwick
- 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 ... Anchored Types
- See Training Course Details...
The Implicit (SQL) Cursor
Loops
System Triggers
The DBMS_LOB Package
PL/SQL Blocks and Programs
Structure of a Package
Triggers
VARRAY and Nested TABLE Collections
Generating an Error
Stored Subprograms
PL/SQL Variables and Datatypes
Privileges for Stored Programs
Scope and Name Resolution
Triggers on Views
Conditional Statements CASE
Using the %ROWTYPE Attribute
Parameter Modes
Maintaining PL/SQL Code
Row-Level Triggers
SQL
- 2 day course
- Location: Smethwick
- 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 ... Creating Views
- See Training Course Details...
Using the WHERE clause to check for greater or less than
The LIKE Operator
NULL Values
Table Aliases
Popular Databases
Dropping Tables
Dropping Views
Relational Database Management System
Comments
Aggregate Functions
Foreign Keys
Sorting By Multiple Columns
Checking for Inequality
Sorting By Column Position
Creating and Modifying Tables
Conditional Processing with CASE
Foreign Keys
Selecting Distinct Records
Transact SQL
- 2 day course
- Location: Smethwick
- 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 Catalog Views Optimizing Query Performance
- See Training Course Details...
Manage Triggers
Create Queries to Test Nullability
Work with Variables and Batches
Group and Aggregate Data Programming in T-SQL
Analyze Data from Query Plans
Manage Query Plans
Work with Date and Time Data Types
Modifying Data
Work with SSMS Working with T-SQL
Delete Data
Create Queries Using Built-in Functions
Insert Data
Work with Predicates
Configure User-Defined Functions (UDF)
Implement Error Handling
Work with String and Numeric Data Types
Perform Advanced Filtering Querying Data from Multiple Tables
Overview of SQL Server
Work with PIVOT and UNPIVOT
Manage Transactions Querying SQL Server System Metadata
Oracle SQL
- 2 day course
- Location: Smethwick
- 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 ... The DELETE statement
- See Training Course Details...
SQL Queries - Joins
SQL Functions
Transaction Management
Date Formats
Outer Joins
Modifying Table Definitions
The INSERT Statement
Updatable Views
Defining Tables
Creating Views
Loading Tables From External Sources
Using SQL Functions
Review of Relational Database Terminology
Connecting to a SQL Database
Sequences
Controlling Access to Your Tables
Interactive SQL*Plus Scripts
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Smethwick
- 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 ... Secure Databases Working with MDS and Windows Azure
- See Training Course Details...
Deploy a Control Flow
Debug Package Execution Components
Debugging and Troubleshooting Packages
Create Fact Tables
Add Data Flow Components to a Data Flow Task
Execute Packages from Different Control Flow Working with Dynamic Variables
Perform Transformation Tasks
Deploy SSIS Packages
Work with Windows Azure
Examine Data Warehousing Concepts
Profile OLTP Data
Execute SSIS Packages on the Server
Add Packages to an SSIS Project Managing Control Flow
Create an SSIS Project
Create Expressions with Variables
Secure Packages
Troubleshoot Package Failures Deploying Packages
Create Package Templates Implementing Data Flow
Introduction to Data Warehouses
Email us about this courses
Other Smethwick Enable Technology Training Courses
JavaScript Smethwick Training Courses
DAX Smethwick Training Courses
Power BI Smethwick Training Courses
SSAS Smethwick Training Courses
JQuery - Smethwick JavaScript Training Courses
SSIS Smethwick Training Courses
Excel 365 Advanced Smethwick Training Courses
Excel Power Pivot - Smethwick Excel Training Courses
SSRS Smethwick Training Courses
SSAS Tabular Smethwick Training Courses
Access VBA Smethwick Training Courses
Excel 365 Basic Smethwick Training Courses
VBA - Smethwick Excel Training Courses
Report Builder Smethwick Training Courses
Access - Smethwick Access Training Courses