SQL TRAINING COURSES BRYN PYDEW
About Enable Technology Bryn Pydew SQL Training Courses
We are a company that offers short, practical, SQL hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training SQL resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL course. The ongoing support by a Microsoft expert is an important part of the service we offer.
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 you prefer we can offer an offsite socially distanced training location in Bryn Pydew. We are more than happy to incorporate additional topics to accommodate your organisations SQL training needs.
SQL courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have operated primarily in the West Midlands for twenty years. Our clients include: Wolverhampton City Council, Fujistu PLC, National Power PLC, Keele University, Boots UK Limited, University of Birmingham, Norwich Union PLC and Aston University.
Transact SQL
- 2 day course
- Location: Bryn Pydew
- 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 Dynamic SQL Working with Subqueries and Table Expressions
Manage Transactions Querying SQL Server System Metadata
Overview of T-SQL
Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
Perform Advanced Filtering Querying Data from Multiple Tables
Work with System Catalog Views Optimizing Query Performance
Work with SSPs and SMOs
Work with the XML Data Type Sorting and Filtering Data
Write SELECT Statements
Work with Subqueries
Assign Aliases Using Queries
Manage Views
Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
Write CASE Expressions Working with SQL Data Types
Work with Variables and Batches
Manage SQL Server Constraints Writing SELECT Queries
Filter the Queried Results
Analyze Data from Query Plans
Combine Data Using Simple Joins
Modifying Data
Oracle SQL
- 2 day course
- Location: Bryn Pydew
- 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 ... Constraints
- See Training Course Details...
Date Functions
Inline Constraints
Other Database Objects
Nulls and DISTINCT
Graphical Clients
Combining SELECT Statements
The SELECT Statement
The SQL Buffer
Using Oracle SQL*Plus
The EXISTS Operator
Date Formats
Data Inconsistencies
Datatypes
Controlling Access to Your Tables
Modifying Table Definitions
Synonyms
Concurrency
Oracle Versioning and History
Oracle PL/SQL
- 3 day course
- Location: Bryn Pydew
- 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 ... XML Packages
- See Training Course Details...
Fetching Rows
Nesting Blocks
Iterating Through Collections
Oracle Directories
Maintaining PL/SQL Code
SQLCODE and SQLERRM
Parameter Modes
Associative Array Collections
Assignment and Conversions
VARRAY and Nested TABLE Collections
LOB Locators
Large Object Types
Collection Methods
Using Packages
Creating a Stored Procedure
Named Parameter Notation
Maintaining Stored Programs
Privileges for Stored Programs
Cursors
SQL
- 2 day course
- Location: Bryn Pydew
- 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 ... Data Types
- See Training Course Details...
Creating Stored Procedures
Primary Keys
Creating and Modifying Tables
Benefits of Stored Procedures
Renaming Tables
Checking for Inequality
Sorting Records
Primary Keys
Common Date Functions Subqueries, Joins and Unions
Common String Functions
Simple SELECT Statements
Popular Databases
Sorting By a Single Column
Sorting By Multiple Columns
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Bryn Pydew
- 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 ... Create an SSIS Project
- See Training Course Details...
Work with MDS Databases
Add Data Flow Components to a Data Flow Task
Debugging and Troubleshooting Packages
Examine MSI Packages
Execute SSIS Packages on the Server
Create Dimensions
Configure the Package Execution Strategy
Deploy a Control Flow
Cleanse Data Using DQS Managing SSIS Package Execution
Deploy SSIS Packages
Overview of Data Warehouses
Change Granularity Creating Fact Tables and Columnstore Indexes
Create Package Templates Implementing Data Flow
Debug Package Execution Components
Configure MDS
Overview of Data Warehouse Components
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Introduction to Data Warehouses
Email us about this courses
Other Bryn Pydew Enable Technology Training Courses
SSRS - Bryn Pydew SQL Server Reporting Services Training Courses
Access VBA - Bryn Pydew Access Training Courses
SSAS Tabular - Bryn Pydew SQL Server Analysis Services Training Courses
JQuery Mobile Bryn Pydew Training Courses
JavaScript Bryn Pydew Training Courses
Excel Power Pivot - Bryn Pydew Excel Training Courses
DAX - Bryn Pydew Excel Training Courses
Excel 365 Basic Bryn Pydew Training Courses
Excel 365 Intermediate - Bryn Pydew Excel Training Courses
VBA - Bryn Pydew Excel Training Courses
SSAS Bryn Pydew Training Courses
Excel 365 Advanced - Bryn Pydew Excel Training Courses
Report Builder Bryn Pydew Training Courses
Power Query - Bryn Pydew Excel Training Courses
SSIS - Bryn Pydew SQL Server Integration Services Training Courses