SQL TRAINING COURSES DEVON
About Enable Technology Devon SQL Training Courses
Enable Technology provides practical SQL skills based technology training. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away SQL courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the SQL course can contact the tutor for as long as they like if they encounter SQL problems.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. The SQL course could also be scheduled at a socially distanced site near you in Devon. The SQL syllabus can be modified to accommodate your specific 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Halfords Group PLC, Norwich Union PLC, West Bromwich Building Society, Royal Air Force, Homeserve PLC, Dollond & Aitchison Limited, Queen's Medical Centre Nottingham and Countrywide Homes Limited.
Oracle SQL
- 2 day course
- Location: Devon
- 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 ... Loading Tables From External Sources
- See Training Course Details...
The INSERT Statement
SQL Queries
The SQL Buffer
Date Functions
Synonyms
Introduction to SQL
SQL Functions
Data Inconsistencies
Defining Tables
Review of Relational Database Terminology
Viewing Table Characteristics
Using Oracle SQL*Plus
Deleting a Table Definition
NULL Values
The Aggregate Functions
Relational Database Management Systems
String Functions
Data Manipulation and Transactions
Transact SQL
- 2 day course
- Location: Devon
- 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 ... Manage Transactions Querying SQL Server System Metadata
- See Training Course Details...
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Manage Stored Procedures
Assign Aliases Using Queries
Manage Triggers
Configure User-Defined Functions (UDF)
Work with SSPs and SMOs
Work with Variables and Batches
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Work with Predicates
Getting Started with SQL Server 2012
Modifying Data
Overview of T-SQL
Work with the XML Data Type Sorting and Filtering Data
Configure Indexes
Manage Views
Overview of SQL Server
Work with Set Operators
Manage SQL Server Constraints Writing SELECT Queries
Write CASE Expressions Working with SQL Data Types
Insert Data
SQL
- 2 day course
- Location: Devon
- 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 ... Creating Tables
- See Training Course Details...
Relational Database Management System
Multi-table Joins
Aggregate Functions
Whitespace and Semi-colons
Conditional Processing with CASE
Aliases
Stored Procedures
Relational Databases
Foreign Keys
Benefits of Stored Procedures
DELETE
The NOT Operator
The BETWEEN Operator
Concatenation
Columns
Sorting By Column Position
Using CASE Inserting, Updating and Deleting Records
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Devon
- 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 ... Secure Packages
- See Training Course Details...
Overview of Data Warehouse Components
Create Package Templates Implementing Data Flow
Examine MSI Packages
Profile OLTP Data
Perform Transformation Tasks
Install Integration Services Working with Integration Services
Configure MDS
Create Fact Tables
Change Granularity Creating Fact Tables and Columnstore Indexes
Work with MDS Databases
Debugging and Troubleshooting Packages
Troubleshoot Package Failures Deploying Packages
Overview of Data Warehouses
Create Expressions with Variables
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Deploy SSIS Packages
Add Data Flow Components to a Data Flow Task
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Create an SSIS Project
Oracle PL/SQL
- 3 day course
- Location: Devon
- 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 ... Maintaining Triggers
- See Training Course Details...
The UTL_FILE Package
Selecting into a Variable
Local Procedures and Functions
Subtypes
Conditional Statements IF/THEN
Nesting Blocks
Records and Collections
Associative Array Collections
Named Parameter Notation
System Triggers
Temporary LOBs
PL/SQL Stored Program Compilation
Structure of a Package
Passing Parameters and Default Arguments
Triggers
REF CURSOR Variables
Privileges for Stored Programs
Overloading Package Functions and Procedures
Email us about this courses
Other Devon Enable Technology Training Courses
Excel 365 Advanced Devon Training Courses
SSAS Tabular Devon Training Courses
SSIS - Devon SQL Server Integration Services Training Courses
Access VBA - Devon Access Training Courses
JavaScript - Devon JavaScript Training Courses
Excel 365 Basic Devon Training Courses
Excel 365 Intermediate - Devon Excel Training Courses
JQuery - Devon JavaScript Training Courses
SSAS - Devon SQL Server Analysis Services Training Courses
JQuery Mobile Devon Training Courses
VBA - Devon Excel Training Courses
Report Builder - Devon SQL Server Reporting Services Training Courses
SSRS Devon Training Courses
Access Devon Training Courses
Power BI - Devon Microsoft Power BI Training Courses