SQL TRAINING COURSES TROWBRIDGE
About Enable Technology Trowbridge SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive SQL training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
SQL training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a socially distanced venue near you in Trowbridge. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Norwich Union PLC, Vodafone Group Services, Yell Group PLC, Norfolk Police Constabulary, University of Birmingham, Royal & Sun Alliance Group PLC, Halfords Group PLC and National Power PLC.
Oracle SQL
- 2 day course
- Location: Trowbridge
- 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 ... Tailoring Your SQL*Plus Environment
- See Training Course Details...
SQL*Plus Substitution Variables
Compound Expressions
String Functions
The DELETE statement
Controlling Access to Your Tables
Loading Tables From External Sources
Connecting to a SQL Database
Concurrency
Sample Database
Introduction to SQL
The SQL Buffer
Graphical Clients
Data Manipulation and Transactions
Self Joins
The UPDATE Statement
NULL Values
Oracle PL/SQL
- 3 day course
- Location: Trowbridge
- 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 ... Row-Level Triggers
- See Training Course Details...
Triggers on Views
Date Intervals
Compile-Time Warnings
User-Defined Exceptions
Triggers
Local Procedures and Functions
XML Packages
Dates and Timestamps
The Implicit (SQL) Cursor
The DBMS_METADATA Package
Large Object Types
WHILE and FOR Loops
The DBMS_OUTPUT Package
The PL/SQL Execution Environment
PL/SQL Blocks and Programs
Exception Handlers
Subtypes
Associative Array Collections
Beyond Declarative Integrity
SQL
- 2 day course
- Location: Trowbridge
- 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 ... Benefits of Views
- See Training Course Details...
Sorting By a Single Column
Aliases
DELETE
Multi-table Joins
Sorting By Column Position
Renaming Tables
Sorting By Multiple Columns
Selecting Specific Columns
Common Math Functions
The LIKE Operator
Calculated Fields
NULL Values
Subqueries
Creating Views
Comments
CASE syntax
Selecting Distinct Records
Primary Keys
The WHERE Clause and Operator Words
Transact SQL
- 2 day course
- Location: Trowbridge
- 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 ... Overview of T-SQL
- See Training Course Details...
Manage Views
Work with System Catalog Views Optimizing Query Performance
Perform Advanced Filtering Querying Data from Multiple Tables
Analyze Data from Query Plans
Write CASE Expressions Working with SQL Data Types
Work with Dynamic SQL Working with Subqueries and Table Expressions
Insert Data
Work with Set Operators
Create Queries Using Join Algorithms
Update Data
Work with Binary Data Types
Work with Predicates
Manage SQL Server Constraints Writing SELECT Queries
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Assign Aliases Using Queries
Work with Subqueries
Work with Window Functions
Implement Error Handling
Work with Variables and Batches
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Trowbridge
- 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 ... Work with MDS Databases
- See Training Course Details...
Troubleshoot Package Failures Deploying Packages
Change Granularity Creating Fact Tables and Columnstore Indexes
Perform Transformation Tasks
Create an SSIS Project
Overview of Data Warehouses
Introduction to Data Warehouses
Cleanse Data Using DQS Managing SSIS Package Execution
Configure MDS
Execute SSIS Packages on the Server
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Fact Tables
Track Changed Data Managing Data Flow
Create Expressions with Variables
Examine MSI Packages
Create Dimensions
Examine Data Warehousing Concepts
Debug Package Execution Components
Deploy SSIS Packages
Secure Databases Working with MDS and Windows Azure
Profile OLTP Data
Email us about this courses
Other Trowbridge Enable Technology Training Courses
JavaScript - Trowbridge JavaScript Training Courses
Excel 365 Intermediate - Trowbridge Excel Training Courses
Excel 365 Advanced Trowbridge Training Courses
SSIS - Trowbridge SQL Server Integration Services Training Courses
SSRS - Trowbridge SQL Server Reporting Services Training Courses
SSAS Trowbridge Training Courses
Power BI - Trowbridge Microsoft Power BI Training Courses
JQuery Mobile Trowbridge Training Courses
Excel Power Pivot Trowbridge Training Courses
JQuery - Trowbridge JavaScript Training Courses
Report Builder Trowbridge Training Courses
Access VBA Trowbridge Training Courses
SSAS Tabular Trowbridge Training Courses
Access - Trowbridge Access Training Courses
DAX Trowbridge Training Courses