SQL TRAINING COURSES NUNEATON
About Enable Technology Nuneaton SQL Training Courses
We are company which specialises in short, two and three day intensive SQL technology training courses. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away SQL courseware which can be used as reference materials after the training. It is our company policy to provide SQL training participants with ongoing support from the course Tutor. People who attend a SQL course can contact the Tutor for as long as they need assistance after the training.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL courses onsite at your site. Another way we could deliver the SQL course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: TalkTalk Direct Limited, Nuclear Engineering Services, Yell Group PLC, Homeserve PLC, EDF Energy PLC, Halfords Group PLC, Birmingham City University and Countrywide Homes Limited.
Transact SQL
- 2 day course
- Location: Nuneaton
- 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 ... Write SELECT Statements
- See Training Course Details...
Assign Aliases Using Queries
Combine Data Using Simple Joins
Insert Data
Work with SSMS Working with T-SQL
Modifying Data
Filter the Queried Results
Create Queries Using Join Algorithms
Work with Subqueries
Work with System Databases
Work with T-SQL Statements
Overview of SQL Server
Work with Data Access Technologies Implementing Stored Procedures
Work with Dynamic SQL Working with Subqueries and Table Expressions
Manage Transactions Querying SQL Server System Metadata
Configure User-Defined Functions (UDF)
Work with Binary Data Types
Work with Set Operators
Implement Error Handling
Work with String and Numeric Data Types
Work with Window Functions
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Nuneaton
- 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...
Add Data Flow Components to a Data Flow Task
Secure Packages
Work with MDS Databases
Cleanse Data Using DQS Managing SSIS Package Execution
Perform Transformation Tasks
Create Dimensions
Overview of Data Warehouses
Deploy a Control Flow
Overview of Data Warehouse Components
Create Fact Tables
Execute Packages from Different Control Flow Working with Dynamic Variables
Execute SSIS Packages on the Server
Add Script Tasks and Script Components to an SSIS Package
Debugging and Troubleshooting Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Profile OLTP Data
Troubleshoot Package Failures Deploying Packages
Debug Package Execution Components
Introduction to Data Warehouses
Examine MSI Packages
SQL
- 2 day course
- Location: Nuneaton
- Telephone on 01952 938014
- Course Outline
-
This practical hands on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.
- Some of the training topics covered include ... Sorting By a Single Column
- See Training Course Details...
Mathematical Calculations
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Relationships
Creating and Modifying Tables
Creating Tables
Sorting By Multiple Columns
DELETE
Comments
Adding and Dropping Columns
Checking Multiple Conditions
Whitespace and Semi-colons
Dropping Tables
Creating Views
Stored Procedures
Conditional Processing with CASE
Creating Stored Procedures
The LIKE Operator
Table Aliases
Foreign Keys
Oracle SQL
- 2 day course
- Location: Nuneaton
- 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 INSERT Statement
- See Training Course Details...
Conversion Functions
Data Definition and Control Statements
Regular Expression Functions
Choosing Rows with the WHERE Clause
Views
Compound Expressions
Buffer Manipulation Commands
Oracle Versioning and History
Datatypes
Explicit Locking
Grouping Rows
Subqueries
Running SQL*Plus Scripts
Self Joins
Other Database Objects
Connecting to a SQL Database
Pattern Matching: LIKE and REGEXP_LIKE
Nulls and DISTINCT
Updatable Views
Oracle PL/SQL
- 3 day course
- Location: Nuneaton
- 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 ... BULK COLLECT Clause
- See Training Course Details...
Stored Functions and SQL
Scope and Name Resolution
Cursor Parameters
Cursors
Local Procedures and Functions
Exception Handling
Creating a Stored Function
System Triggers
Calling a Stored Procedure
Internal LOBs
Networking Packages
Datatypes
Triggers
Large Object Types
The UTL_FILE Package
Subtypes
The DBMS_LOB Package
XML Packages
Email us about this courses
Other Nuneaton Enable Technology Training Courses
Report Builder Nuneaton Training Courses
SSRS - Nuneaton SQL Server Reporting Services Training Courses
JavaScript Nuneaton Training Courses
JQuery - Nuneaton JavaScript Training Courses
SSAS Nuneaton Training Courses
Excel Power Pivot Nuneaton Training Courses
SSAS Tabular Nuneaton Training Courses
Access - Nuneaton Access Training Courses
DAX Nuneaton Training Courses
VBA Nuneaton Training Courses
Access VBA - Nuneaton Access Training Courses
SSIS Nuneaton Training Courses
Excel 365 Advanced - Nuneaton Excel Training Courses
JQuery Mobile - Nuneaton JavaScript Training Courses
Power Query - Nuneaton Excel Training Courses