SQL TRAINING COURSES YOEVIL
About Enable Technology Yoevil SQL Training Courses
Enable Technology specialise in succinct skills based SQL training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL course resources that can be referenced post 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.
Enable Technology offers instructor led training taught by technology specialists. We are delivering this instructor led SQL training online during the current crisis. Participants can se the tutors screen, ask questions and share their screen with the tutor. The SQL syllabus can be modified to accommodate your specific training needs.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are EDF Energy PLC, Vodafone Group Services, Shell UK Oil Products Ltd, Birmingham Heartlands Hospital, Capita Group PLC, Carillion PLC, TalkTalk Direct Limited and Birmingham City University.
SQL
- 2 day course
- Location: Yoevil
- Telephone on 01952 305730
- 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 ... Renaming Tables
- See Training Course Details...
Adding and Dropping Columns
Checking for Equality
Checking for NULL
Creating Views
Sorting By a Single Column
Relationships
Aggregate Functions
Concatenation
Common Math Functions
Conditional Processing with CASE
Case Sensitivity
Multi-table Joins
Checking for Inequality
Sorting By Column Position
Dropping Tables
Oracle SQL
- 2 day course
- Location: Yoevil
- Telephone on 01952 305730
- 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 Aggregate Functions
- See Training Course Details...
Date Functions
Outer Joins
Literal Values
Date Formats
Logical and Physical Storage Structures
The UPDATE Statement
Buffer Manipulation Commands
Using Oracle SQL*Plus
Defining Tables
Review of Relational Database Terminology
Updatable Views
Self Joins
Views
IN and BETWEEN
The SQL Buffer
Using SQL Functions
Creating Views
Concurrency
SQL*Plus LOB Support
Transact SQL
- 2 day course
- Location: Yoevil
- Telephone on 01952 305730
- 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 Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
- See Training Course Details...
Work with Data Access Technologies Implementing Stored Procedures
Write CASE Expressions Working with SQL Data Types
Work with System Databases
Manage Transactions Querying SQL Server System Metadata
Combine Data Using Simple Joins
Implement Error Handling
Work with Grouping Sets Managing Error Handling and Transactions
Manage SQL Server Constraints Writing SELECT Queries
Work with Binary Data Types
Assign Aliases Using Queries
Work with Window Functions
Work with String and Numeric Data Types
Insert Data
Manage Views
Sort the Queried Data
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Configure User-Defined Functions (UDF)
Control Program Flow
Work with PIVOT and UNPIVOT
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Yoevil
- Telephone on 01952 305730
- 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 ... Overview of Data Warehouse Components
- See Training Course Details...
Configure the Package Execution Strategy
Create Dimensions
Configure MDS
Perform Transformation Tasks
Introduction to Data Warehouses
Work with Windows Azure
Execute SSIS Packages on the Server
Add Data Flow Components to a Data Flow Task
Deploy a Control Flow
Profile OLTP Data
Work with MDS Databases
Change Granularity Creating Fact Tables and Columnstore Indexes
Debugging and Troubleshooting Packages
Create Fact Tables
Create Expressions with Variables
Troubleshoot Package Failures Deploying Packages
Cleanse Data Using DQS Managing SSIS Package Execution
Examine Data Warehousing Concepts
Securing Packages and Databases
Oracle PL/SQL
- 3 day course
- Location: Yoevil
- Telephone on 01952 305730
- 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 ... Using VARRAYs
- See Training Course Details...
Row-Level Triggers
Parameter Modes
Conditional Statements IF/THEN
Associative Array Collections
The Implicit (SQL) Cursor
Scope and Name Resolution
System Triggers
Calling a Stored Procedure
Internal LOBs
Passing Parameters and Default Arguments
Comments and Labels
VARRAY and Nested TABLE Collections
Local Procedures and Functions
Using Nested TABLEs
Using the %ROWTYPE Attribute
Procedures and Functions
PL/SQL Stored Program Compilation
Email us about this courses
Other Yoevil Enable Technology Training Courses
Visio 2013 Yoevil Training Courses
SSRS 2005 Yoevil Training Courses
PowerPoint Basic Yoevil Training Courses
SSAS 2017 - Yoevil SQL Server Analysis Services Training Courses
Excel Power Pivot Yoevil Training Courses
VBA - Yoevil Excel Training Courses
SSRS 2016 - Yoevil SQL Server Reporting Services Training Courses
Microsoft Project Level 2 Yoevil Training Courses
SSRS 2008 Yoevil Training Courses
Data Mining - Yoevil Data Analytics Training Courses
Project 2016 Yoevil Training Courses
JavaScript Yoevil Training Courses
SSRS 2014 - Yoevil SQL Server Reporting Services Training Courses
SSIS 2014 - Yoevil SQL Server Integration Services Training Courses
Crystal 2016 - Yoevil Crystal Reports Training Courses
South West - Possible SQL Training Course Locations
Chippenham, South West, Trowbridge, Plymouth, Bath, Cheltenham, Poole, Devon, Somerset, Gloucestershire, Bournemouth, Taunton, Wiltshire, Wells, Bristol, Yoevil, Exeter, Dorset, Tewkesbury, Cirencester, Swindon, Weymouth, Gloucester, Dorchester, Torquay, Christchurch, Stroud, Salisbury