SQL TRAINING COURSES BROMSGROVE
About Enable Technology Bromsgrove SQL Training Courses
We are a company that offers short, practical, SQL hands on technology courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a SQL course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended SQL post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Courses are instructor led and groups sizes small. Enable Technology SQL training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the SQL course is at a local socially distanced training site. The SQL syllabus can be adjusted and additional topics incorporated if helpful.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Keele University, Birmingham City University, University of Birmingham, Norfolk Police Constabulary, Vodafone Group Services, South Staffordshire Water PLC, Shell UK Oil Products Ltd and Nationwide Building Society Limited.
Oracle PL/SQL
- 3 day course
- Location: Bromsgrove
- 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 ... Loops
- See Training Course Details...
LOB Locators
WHILE and FOR Loops
Multi-Row Queries
Collection Methods
Assignment and Conversions
The DBMS_METADATA Package
Anchored Types
The PL/SQL Execution Environment
Creating Packages
Creating a Stored Procedure
The Implicit (SQL) Cursor
Procedures and Functions
Row-Level Triggers
Iterating Through Collections
FOR UPDATE Cursors
PL/SQL Blocks and Programs
Transact SQL
- 2 day course
- Location: Bromsgrove
- 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 ... Sort the Queried Data
- See Training Course Details...
Modifying Data
Analyze Data from Query Plans
Work with System Databases
Work with Binary Data Types
Manage Views
Manage Query Plans
Work with Window Functions
Work with T-SQL Statements
Configure Indexes
Combine Data Using Simple Joins
Insert Data
Overview of SQL Server
Work with Grouping Sets Managing Error Handling and Transactions
Work with the XML Data Type Sorting and Filtering Data
Manage Transactions Querying SQL Server System Metadata
Work with PIVOT and UNPIVOT
Assign Aliases Using Queries
Merge Data Working with SQL Server Built-in Functions
Write SELECT Statements
Work with Variables and Batches
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Bromsgrove
- 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 ... Create Fact Tables
- See Training Course Details...
Create Expressions with Variables
Deploy SSIS Packages
Cleanse Data Using DQS Managing SSIS Package Execution
Work with Windows Azure
Work with MDS Databases
Examine Data Warehousing Concepts
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Dimensions
Track Changed Data Managing Data Flow
Securing Packages and Databases
Execute Packages from Different Control Flow Working with Dynamic Variables
Overview of Data Warehouse Components
Create Package Templates Implementing Data Flow
Perform Transformation Tasks
Secure Packages
Secure Databases Working with MDS and Windows Azure
Profile OLTP Data
Configure the Package Execution Strategy
Oracle SQL
- 2 day course
- Location: Bromsgrove
- 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 ... Choosing Rows with the WHERE Clause
- See Training Course Details...
SQL*Plus LOB Support
Scalar Functions
Aggregate Functions and Advanced Techniques
Numeric Functions
Self Joins
Date Functions
The INSERT Statement
Joining Tables
Regular Expression Functions
Sample Database
Graphical Clients
Nulls and DISTINCT
The EXISTS Operator
Loading Tables From External Sources
Running SQL*Plus Scripts
Connecting to a SQL Database
Modifying Table Definitions
NULL Values
Introduction to SQL
SQL
- 2 day course
- Location: Bromsgrove
- 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 ... Columns
- See Training Course Details...
Dropping Tables
Table Aliases
Dropping Views
Conditional Processing with CASE
Primary Keys
Using the WHERE clause to check for greater or less than
Common Date Functions Subqueries, Joins and Unions
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Selecting Distinct Records
Selecting All Columns in All Rows
WHERE and ORDER BY
Adding and Dropping Columns
Popular Databases
DELETE
Checking Multiple Conditions
The NOT Operator
Checking for Inequality
Email us about this courses
Other Bromsgrove Enable Technology Training Courses
VBA Bromsgrove Training Courses
SSAS Tabular - Bromsgrove SQL Server Analysis Services Training Courses
SSIS Bromsgrove Training Courses
Excel 365 Advanced Bromsgrove Training Courses
JQuery Bromsgrove Training Courses
JavaScript Bromsgrove Training Courses
Power BI Bromsgrove Training Courses
SSRS Bromsgrove Training Courses
JQuery Mobile - Bromsgrove JavaScript Training Courses
Excel Power Pivot Bromsgrove Training Courses
Power Query - Bromsgrove Excel Training Courses
DAX - Bromsgrove Excel Training Courses
Report Builder - Bromsgrove SQL Server Reporting Services Training Courses
Access VBA - Bromsgrove Access Training Courses
Excel 365 Basic Bromsgrove Training Courses