SQL TRAINING COURSES MILFORD HAVEN
About Enable Technology Milford Haven SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with SQL training materials which they keep after the course. 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.
Delegates are taught by an experienced Microsoft professional. SQL courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver SQL training courses onsite at your premises. Another way we could deliver the SQL course is at a local socially distanced training site. The SQL syllabus can be modified to accommodate your specific training needs.
SQL courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Keele University, Royal Air Force, Loughborough University, Nuclear Engineering Services, University of Birmingham, Birmingham City University, Halfords Group PLC and Aston University.
SQL
- 2 day course
- Location: Milford Haven
- Telephone on 01952 938014
- Course Outline
-
This hands on SQL (Structured Query Language) course will equip participants the skills necessary to extract filtered data from all of the leading database platforms. No prior knowledge is assumed. Participants will learn how to extract data from a relational database, create aggregated grouped reports, update, insert and delete data, create tables, views and stored procedures.
- Some of the training topics covered include ... Creating and Modifying Tables
- See Training Course Details...
Benefits of Stored Procedures
Dropping Views
Creating Tables
Data Types
Calculated Fields
Subqueries
Primary Keys
Stored Procedures
Sorting Records
Multi-table Joins
Mathematical Calculations
The BETWEEN Operator
Checking for NULL
Using the WHERE clause to check for greater or less than
Selecting Distinct Records
Common Date Functions Subqueries, Joins and Unions
Adding and Dropping Columns
The WHERE Clause and Operator Words
Transact SQL
- 2 day course
- Location: Milford Haven
- 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 ... Manage SQL Server Constraints Writing SELECT Queries
- See Training Course Details...
Create Queries to Test Nullability
Work with Set Operators
Delete Data
Work with Subqueries
Configure Indexes
Getting Started with SQL Server 2012
Write CASE Expressions Working with SQL Data Types
Perform Advanced Filtering Querying Data from Multiple Tables
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Work with the XML Data Type Sorting and Filtering Data
Overview of SQL Server
Insert Data
Work with Predicates
Manage Views
Manage Query Plans
Manage Stored Procedures
Manage Transactions Querying SQL Server System Metadata
Analyze Data from Query Plans
Merge Data Working with SQL Server Built-in Functions
Update Data
Oracle SQL
- 2 day course
- Location: Milford Haven
- 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 ... Introduction to SQL
- See Training Course Details...
SQL*Plus LOB Support
Date Formats
Running SQL*Plus Scripts
Buffer Manipulation Commands
Views
Relational Database and SQL Overview
Creating Views
SQL Functions
Conversion Functions
Modifying Table Definitions
SQL Queries - Joins
Viewing Table Characteristics
Pattern Matching: LIKE and REGEXP_LIKE
Data Definition and Control Statements
The DELETE statement
Concurrency
Constraints
The SQL Buffer
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Milford Haven
- 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 ... Overview of Data Warehouse Components
- See Training Course Details...
Execute Packages from Different Control Flow Working with Dynamic Variables
Add Script Tasks and Script Components to an SSIS Package
Examine MSI Packages
Deploy a Control Flow
Create Package Templates Implementing Data Flow
Overview of Data Warehouses
Create Expressions with Variables
Examine Data Warehousing Concepts
Debugging and Troubleshooting Packages
Configure the Package Execution Strategy
Perform Transformation Tasks
Secure Databases Working with MDS and Windows Azure
Introduction to Data Warehouses
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Create Fact Tables
Add Packages to an SSIS Project Managing Control Flow
Configure MDS
Secure Packages
Oracle PL/SQL
- 3 day course
- Location: Milford Haven
- 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 ... Scope and Name Resolution
- See Training Course Details...
Declaring Variables
PL/SQL Syntax and Logic
Parameter Modes
Cascading Triggers and Mutating Tables
Fetching Rows
Triggers
Calling a Stored Function
Closing Cursors
Maintaining PL/SQL Code
Procedures and Functions
Conditional Statements IF/THEN
Stored Procedures and Functions
Datatypes
Named Parameter Notation
WHILE and FOR Loops
The Package Interface and Implementation
FOR UPDATE Cursors
The Cursor FOR Loop
Email us about this courses
Other Milford Haven Enable Technology Training Courses
JQuery Milford Haven Training Courses
SSIS Milford Haven Training Courses
VBA Milford Haven Training Courses
Access VBA - Milford Haven Access Training Courses
Power Query Milford Haven Training Courses
DAX - Milford Haven Excel Training Courses
Excel 365 Basic Milford Haven Training Courses
SSAS Tabular - Milford Haven SQL Server Analysis Services Training Courses
SSAS Milford Haven Training Courses
Report Builder - Milford Haven SQL Server Reporting Services Training Courses
Access - Milford Haven Access Training Courses
Excel Power Pivot - Milford Haven Excel Training Courses
JavaScript Milford Haven Training Courses
SSRS - Milford Haven SQL Server Reporting Services Training Courses
Excel 365 Intermediate - Milford Haven Excel Training Courses