SQL TRAINING COURSES KIRKBY
About Enable Technology Kirkby SQL Training Courses
We have a twenty year history of providing skills based SQL industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training SQL resources which they can continue to use 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.
SQL courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver SQL courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Kirkby. We are happy to modify the SQL syllabus to match your teams training requirements.
We can also deliver SQL courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Nuclear Engineering Services, Countrywide Homes Limited, South Staffordshire Water PLC, Total Telecommunications Limited, Aston University, Royal & Sun Alliance Group PLC, Capita Group PLC and West Bromwich Building Society.
Transact SQL
- 2 day course
- Location: Kirkby
- 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 ... Control Program Flow
- See Training Course Details...
Create Queries Using Built-in Functions
Work with T-SQL Statements
Create Queries Using Join Algorithms
Merge Data Working with SQL Server Built-in Functions
Work with Set Operators
Write SELECT Statements
Getting Started with SQL Server 2012
Manage Triggers
Update Data
Manage Stored Procedures
Manage Views
Manage Query Plans
Work with Dynamic SQL Working with Subqueries and Table Expressions
Manage Transactions Querying SQL Server System Metadata
Assign Aliases Using Queries
Work with String and Numeric Data Types
Work with PIVOT and UNPIVOT
Group and Aggregate Data Programming in T-SQL
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Configure Indexes
Oracle PL/SQL
- 3 day course
- Location: Kirkby
- 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 ... Fetching Rows
- See Training Course Details...
Exception Handlers
The DBMS_LOB Package
Conditional Statements CASE
Collection Methods
Cascading Triggers and Mutating Tables
Assignment and Conversions
Generating an Error
Overloading Package Functions and Procedures
Exception Handling
Large Object Types
Other Supplied Packages
Using Nested TABLEs
Maintaining Stored Programs
PL/SQL Variables and Datatypes
Dates and Timestamps
The Cursor FOR Loop
Nesting Blocks
System Triggers
SQLCODE and SQLERRM
Creating a Stored Function
SQL
- 2 day course
- Location: Kirkby
- Telephone on 01952 938014
- Course Outline
-
This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.
- Some of the training topics covered include ... Concatenation
- See Training Course Details...
Case Sensitivity
Selecting Specific Columns
Primary Keys
Conditional Processing with CASE
Common Math Functions
Aliases
Mathematical Calculations
Outer Joins
The IN Operator
Table Aliases
Grouping and Aggregating Data
Checking Multiple Conditions
NULL Values
Tables
CASE syntax
Benefits of Stored Procedures
The NOT Operator
Selecting All Columns in All Rows
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Kirkby
- 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 Windows Azure
- See Training Course Details...
Troubleshoot Package Failures Deploying Packages
Install Integration Services Working with Integration Services
Profile OLTP Data
Perform Transformation Tasks
Deploy SSIS Packages
Debug Package Execution Components
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Secure Databases Working with MDS and Windows Azure
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Add Script Tasks and Script Components to an SSIS Package
Create Package Templates Implementing Data Flow
Deploy a Control Flow
Change Granularity Creating Fact Tables and Columnstore Indexes
Overview of Data Warehouse Components
Create Fact Tables
Work with MDS Databases
Introduction to Data Warehouses
Create Dimensions
Examine Data Warehousing Concepts
Add Data Flow Components to a Data Flow Task
Oracle SQL
- 2 day course
- Location: Kirkby
- 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 ... SQL*Plus
- See Training Course Details...
Selecting from Multiple Tables
Datatypes
Review of Relational Database Terminology
Introduction to SQL
Conversion Functions
Sequences
Data Manipulation and Transactions
SQL*Plus LOB Support
Creating Views
Constraints
Buffer Manipulation Commands
Oracle Pseudocolumns
Combining SELECT Statements
Literal Values
SQL Functions
Logical and Physical Storage Structures
Sample Database
SQL*Plus Substitution Variables
Loading Tables From External Sources
Email us about this courses
Other Kirkby Enable Technology Training Courses
Power BI Kirkby Training Courses
SSAS Tabular Kirkby Training Courses
Excel 365 Intermediate Kirkby Training Courses
DAX Kirkby Training Courses
Excel 365 Advanced Kirkby Training Courses
JQuery Kirkby Training Courses
Power Query - Kirkby Excel Training Courses
SSIS Kirkby Training Courses
SSRS Kirkby Training Courses
Access - Kirkby Access Training Courses
Report Builder - Kirkby SQL Server Reporting Services Training Courses
Access VBA Kirkby Training Courses
JavaScript - Kirkby JavaScript Training Courses
Excel 365 Basic - Kirkby Excel Training Courses
SSAS Kirkby Training Courses