SQL TRAINING COURSES BIRMINGHAM
About Enable Technology Birmingham SQL Training Courses
We are a company that offers short, practical, SQL hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL courses at your site. We are also more than happy to organise a local course at a training location in Birmingham. We are happy to discuss customising the course content should you have particular SQL training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Royal & Sun Alliance Group PLC, Aston University, Norfolk Police Constabulary, Norwich Union PLC, Fujistu PLC, Capita Group PLC and TalkTalk Direct Limited.
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Birmingham
- 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 ... Install Integration Services Working with Integration Services
- See Training Course Details...
Change Granularity Creating Fact Tables and Columnstore Indexes
Secure Packages
Create Dimensions
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Track Changed Data Managing Data Flow
Debug Package Execution Components
Work with Windows Azure
Create Package Templates Implementing Data Flow
Troubleshoot Package Failures Deploying Packages
Perform Transformation Tasks
Execute SSIS Packages on the Server
Create Expressions with Variables
Securing Packages and Databases
Secure Databases Working with MDS and Windows Azure
Configure the Package Execution Strategy
Deploy SSIS Packages
Examine MSI Packages
Profile OLTP Data
Overview of Data Warehouses
Transact SQL
- 2 day course
- Location: Birmingham
- 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 ... Overview of T-SQL
- See Training Course Details...
Work with System Databases
Implement Error Handling
Work with Data Access Technologies Implementing Stored Procedures
Write CASE Expressions Working with SQL Data Types
Insert Data
Sort the Queried Data
Work with Set Operators
Filter the Queried Results
Work with System Catalog Views Optimizing Query Performance
Overview of SQL Server
Modifying Data
Merge Data Working with SQL Server Built-in Functions
Configure User-Defined Functions (UDF)
Manage Stored Procedures
Create Queries to Test Nullability
Analyze Data from Query Plans
Control Program Flow
Manage Views
Work with SSMS Working with T-SQL
Manage Transactions Querying SQL Server System Metadata
SQL
- 2 day course
- Location: Birmingham
- Telephone on 01952 938014
- Course Outline
-
SQL (Structured Query Language) is central to working with any form of database. In this practical hands on course participants learn how to use the full potential of SQL to write complex queries. The course covers select statements, grouping and aggregating data, joins, subqueries and unions. Participants will also learn how to insert, update and delete data and how to create and alter Views and Stored Procedures. The course will significantly help anyone who needs to retrieve or manipulate information in a relational database. No prior knowledge of SQL is required.
- Some of the training topics covered include ... Table Aliases
- See Training Course Details...
Order of Evaluation Advanced SELECTs
Creating Views
Benefits of Views
Calculated Fields
Checking for NULL
Aliases
Selecting Specific Columns
Grouping and Aggregating Data
Checking Multiple Conditions
Common Date Functions Subqueries, Joins and Unions
Popular Databases
Selecting Distinct Records
Checking for Inequality
Sorting Records
Outer Joins
Case Sensitivity
Sorting By a Single Column
Dropping Tables
Oracle SQL
- 2 day course
- Location: Birmingham
- 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 ... Datatypes
- See Training Course Details...
SQL Queries - Joins
Data Definition and Control Statements
Datatypes
NULL Values
The SQL Buffer
Date Functions
The INSERT Statement
Defining Tables
Interactive SQL*Plus Scripts
Regular Expression Functions
Concurrency
Connecting to a SQL Database
Intervals
Sequences
SQL*Plus LOB Support
Data Manipulation and Transactions
Oracle Pseudocolumns
Oracle PL/SQL
- 3 day course
- Location: Birmingham
- 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 ... WHILE and FOR Loops
- See Training Course Details...
Assignment and Conversions
Using Packages
Oracle Directories
The UTL_FILE Package
Cascading Triggers and Mutating Tables
BULK COLLECT Clause
PL/SQL Stored Program Compilation
Cursor Parameters
The Package Interface and Implementation
Cursors
Procedures and Functions
Datatypes
The PL/SQL Execution Environment
Package Variables
Creating a Stored Function
PL/SQL Variables and Datatypes
Email us about this courses
Other Birmingham Enable Technology Training Courses
Power Query - Birmingham Excel Training Courses
DAX Birmingham Training Courses
SSRS Birmingham Training Courses
SSAS - Birmingham SQL Server Analysis Services Training Courses
JQuery Mobile Birmingham Training Courses
Access - Birmingham Access Training Courses
SSIS - Birmingham SQL Server Integration Services Training Courses
Excel Power Pivot Birmingham Training Courses
Excel 365 Advanced Birmingham Training Courses
Access VBA - Birmingham Access Training Courses
Power BI - Birmingham Microsoft Power BI Training Courses
Excel 365 Intermediate Birmingham Training Courses
VBA - Birmingham Excel Training Courses
JQuery - Birmingham JavaScript Training Courses
SSAS Tabular Birmingham Training Courses