SQL TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given SQL courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL for as long as they need.
SQL courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of SQL course at a socially distanced venue near you in Black Country. All SQL courses can be customised to meet your particular requirements.
SQL courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Queen's Medical Centre Nottingham, Canadian High Commission, Countrywide Homes Limited, Royal Air Force, Loughborough University, GKN PLC, Dollond & Aitchison Limited and Vodafone Group Services.
Transact SQL
- 2 day course
- Location: Black Country
- 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 ... Modifying Data
- See Training Course Details...
Work with Window Functions
Group and Aggregate Data Programming in T-SQL
Manage Transactions Querying SQL Server System Metadata
Work with Variables and Batches
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Create Queries to Test Nullability
Implement Error Handling
Work with T-SQL Statements
Overview of T-SQL
Insert Data
Work with Date and Time Data Types
Create Queries Using Join Algorithms
Write CASE Expressions Working with SQL Data Types
Control Program Flow
Work with Predicates
Create Queries Using Built-in Functions
Combine Data Using Simple Joins
Manage SQL Server Constraints Writing SELECT Queries
Manage Triggers
Configure User-Defined Functions (UDF)
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Black Country
- 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 Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
- See Training Course Details...
Create Expressions with Variables
Deploy a Control Flow
Perform Transformation Tasks
Secure Databases Working with MDS and Windows Azure
Debugging and Troubleshooting Packages
Add Script Tasks and Script Components to an SSIS Package
Examine MSI Packages
Profile OLTP Data
Change Granularity Creating Fact Tables and Columnstore Indexes
Overview of Data Warehouses
Troubleshoot Package Failures Deploying Packages
Configure MDS
Create Fact Tables
Introduction to Data Warehouses
Add Data Flow Components to a Data Flow Task
Examine Data Warehousing Concepts
Track Changed Data Managing Data Flow
Deploy SSIS Packages
Oracle PL/SQL
- 3 day course
- Location: Black Country
- 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 ... REF CURSOR Variables
- See Training Course Details...
Oracle-Supplied Packages
Cascading Triggers and Mutating Tables
Declaring and Opening Cursors
FOR UPDATE Cursors
The DBMS_METADATA Package
External LOBs
WHILE and FOR Loops
Associative Array Collections
Internal LOBs
The Implicit (SQL) Cursor
LOB Locators
Character Data
Using Packages
Stored Functions and SQL
Privileges for Stored Programs
XML Packages
Creating Packages
Structure of a Package
The DBMS_UTILITY Package
SQL
- 2 day course
- Location: Black Country
- Telephone on 01952 938014
- Course Outline
-
This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.
- Some of the training topics covered include ... Tables
- See Training Course Details...
Mathematical Calculations
Benefits of Views
Case Sensitivity
WHERE and ORDER BY
Relational Databases
Creating Tables
NULL Values
Calculated Fields
Adding and Dropping Columns
Benefits of Stored Procedures
Table Aliases
Creating Views
Conditional Processing with CASE
Using CASE Inserting, Updating and Deleting Records
Concatenation
Aliases
Oracle SQL
- 2 day course
- Location: Black Country
- 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 ... Data Definition and Control Statements
- See Training Course Details...
Defining Tables
Selecting from Multiple Tables
Outer Joins
Viewing Table Characteristics
Datatypes
Choosing Rows with the WHERE Clause
Date Functions
Sequences
SQL Queries
Oracle Pseudocolumns
The EXISTS Operator
Grouping Rows
The SELECT Statement
Views
Using SQL Functions
Buffer Manipulation Commands
Constraints
Email us about this courses
Other Black Country Enable Technology Training Courses
Power Query - Black Country Excel Training Courses
Report Builder - Black Country SQL Server Reporting Services Training Courses
Excel 365 Advanced - Black Country Excel Training Courses
SSIS - Black Country SQL Server Integration Services Training Courses
SSRS Black Country Training Courses
Access VBA Black Country Training Courses
Access Black Country Training Courses
Power BI Black Country Training Courses
SSAS Black Country Training Courses
Excel 365 Intermediate Black Country Training Courses
Excel Power Pivot - Black Country Excel Training Courses
DAX Black Country Training Courses
SSAS Tabular - Black Country SQL Server Analysis Services Training Courses
JQuery Mobile Black Country Training Courses
JavaScript - Black Country JavaScript Training Courses