SQL TRAINING COURSES BRIDLINGTON
About Enable Technology Bridlington SQL Training Courses
Enable Technology provides practical SQL skills based technology training. The tutor delivering the course will be a Microsoft certified expert. We provide every candidate with SQL training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL queries.
Enable Technology SQL courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide SQL courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Bridlington. Every SQL course can be modified to meet your bespoke requirements.
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 Keele University, Queen's Medical Centre Nottingham, West Bromwich Building Society, Birmingham City Council, Halfords Group PLC, National Power PLC, Norwich Union PLC and Nuclear Engineering Services.
SQL
- 2 day course
- Location: Bridlington
- Telephone on 01952 938014
- Course Outline
-
This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.
- Some of the training topics covered include ... Checking Multiple Conditions
- See Training Course Details...
Data Types
Sorting By Multiple Columns
Benefits of Stored Procedures
Relational Database Management System
Renaming Tables
The WHERE Clause and Operator Words
Checking for Inequality
Order of Evaluation Advanced SELECTs
CASE syntax
Datatypes
The NOT Operator
Case Sensitivity
Ascending and Descending Sorts The WHERE Clause and Operator Symbols
Selecting Distinct Records
Simple SELECT Statements
Checking for NULL
Relational Databases
Oracle PL/SQL
- 3 day course
- Location: Bridlington
- 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 ... Named Parameter Notation
- See Training Course Details...
Assignment and Conversions
Records and Collections
Structure of a Package
The Cursor FOR Loop
Using VARRAYs
Declaring Variables
Types of Triggers
PL/SQL Variables and Datatypes
PL/SQL Blocks and Programs
Date Intervals
User-Defined Exceptions
Passing Parameters and Default Arguments
Overloading Package Functions and Procedures
Cursor Parameters
Dates and Timestamps
Other Supplied Packages
Calling a Stored Function
Transact SQL
- 2 day course
- Location: Bridlington
- 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 ... Delete Data
- See Training Course Details...
Work with PIVOT and UNPIVOT
Combine Data Using Simple Joins
Work with Dynamic SQL Working with Subqueries and Table Expressions
Work with Variables and Batches
Work with Data Access Technologies Implementing Stored Procedures
Configure Indexes
Write CASE Expressions Working with SQL Data Types
Update Data
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Overview of T-SQL
Implement Error Handling
Work with Predicates
Manage Triggers
Create Queries Using Join Algorithms
Analyze Data from Query Plans
Work with SSMS Working with T-SQL
Sort the Queried Data
Work with Set Operators
Work with Binary Data Types
Work with the XML Data Type Sorting and Filtering Data
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Bridlington
- 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
Configure MDS
Examine MSI Packages
Execute Packages from Different Control Flow Working with Dynamic Variables
Examine Data Warehousing Concepts
Create Dimensions
Execute SSIS Packages on the Server
Add Data Flow Components to a Data Flow Task
Change Granularity Creating Fact Tables and Columnstore Indexes
Deploy a Control Flow
Introduction to Data Warehouses
Perform Transformation Tasks
Track Changed Data Managing Data Flow
Debugging and Troubleshooting Packages
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Securing Packages and Databases
Overview of Data Warehouses
Create Package Templates Implementing Data Flow
Oracle SQL
- 2 day course
- Location: Bridlington
- 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 ... Compound Expressions
- See Training Course Details...
Grouping Rows
SQL Queries - Joins
Conversion Functions
Graphical Clients
Combining SELECT Statements
The CASE...WHEN Expression
Oracle Versioning and History
Datatypes
Deleting a Table Definition
Subqueries
Sequences
The DELETE statement
Data Definition and Control Statements
The INSERT Statement
Views
Intervals
Relational Database and SQL Overview
Defining Tables
Email us about this courses
Other Bridlington Enable Technology Training Courses
Excel 365 Intermediate Bridlington Training Courses
Access Bridlington Training Courses
SSAS Bridlington Training Courses
Power Query - Bridlington Excel Training Courses
JQuery - Bridlington JavaScript Training Courses
SSRS - Bridlington SQL Server Reporting Services Training Courses
SSAS Tabular Bridlington Training Courses
Excel Power Pivot Bridlington Training Courses
JQuery Mobile Bridlington Training Courses
Report Builder Bridlington Training Courses
JavaScript - Bridlington JavaScript Training Courses
VBA - Bridlington Excel Training Courses
Excel 365 Advanced - Bridlington Excel Training Courses
Access VBA Bridlington Training Courses
Excel 365 Basic - Bridlington Excel Training Courses