SQL TRAINING COURSES CARMARTHEN
About Enable Technology Carmarthen SQL Training Courses
Enable Technology has twenty year track record of providing short intensive SQL skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued SQL training manuals they can refer to after the course. If delegates have have questions about SQL after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver SQL courses onsite at your site. Alternatively we could schedule a SQL course at an alternative training site in Carmarthen. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL course to some extent is bespoke and tailored to your needs.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Unipart Group, Nuclear Engineering Services, Lloyds TSB Bank PLC, University of Birmingham, Keele University, Carillion PLC, Loughborough University and Boots UK Limited.
Oracle SQL
- 2 day course
- Location: Carmarthen
- 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 ... Scalar Functions
- See Training Course Details...
IN and BETWEEN
Data Inconsistencies
Aggregate Functions and Advanced Techniques
The Aggregate Functions
Modifying Table Definitions
Viewing Table Characteristics
Subqueries
Regular Expression Functions
Creating Views
Updatable Views
Transaction Management
Combining SELECT Statements
Sequences
Oracle Versioning and History
Relational Database Management Systems
Intervals
Date Formats
Graphical Clients
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Carmarthen
- 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 Warehouses
- See Training Course Details...
Create Dimensions
Troubleshoot Package Failures Deploying Packages
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Deploy a Control Flow
Overview of Data Warehouse Components
Add Data Flow Components to a Data Flow Task
Work with Windows Azure
Debugging and Troubleshooting Packages
Execute Packages from Different Control Flow Working with Dynamic Variables
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Securing Packages and Databases
Secure Packages
Profile OLTP Data
Work with MDS Databases
Perform Transformation Tasks
Change Granularity Creating Fact Tables and Columnstore Indexes
Track Changed Data Managing Data Flow
Add Script Tasks and Script Components to an SSIS Package
Deploy SSIS Packages
Oracle PL/SQL
- 3 day course
- Location: Carmarthen
- 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 ... PL/SQL Stored Program Compilation
- See Training Course Details...
Other Supplied Packages
WHILE and FOR Loops
Records and Collections
Packages
Creating a Stored Function
Creating a Stored Procedure
The DBMS_LOB Package
Assignment and Conversions
Overloading Package Functions and Procedures
Selecting into a Variable
The PL/SQL Execution Environment
External LOBs
Privileges for Stored Programs
Character Data
Cursor Parameters
The DBMS_OUTPUT Package
Stored Subprograms
The UTL_FILE Package
Structure of a Package
Closing Cursors
SQL
- 2 day course
- Location: Carmarthen
- 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 ... Dropping Stored Procedures
- See Training Course Details...
Calculated Fields
Concatenation
Dropping Views
The NOT Operator
Using the WHERE clause to check for greater or less than
Subqueries
Selecting Specific Columns
Comments
Adding and Dropping Columns
Creating Tables
Multi-table Joins
Outer Joins
Relationships
Popular Databases
Transact SQL
- 2 day course
- Location: Carmarthen
- 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 ... Perform Advanced Filtering Querying Data from Multiple Tables
- See Training Course Details...
Work with Date and Time Data Types
Work with Grouping Sets Managing Error Handling and Transactions
Modifying Data
Create Queries to Test Nullability
Group and Aggregate Data Programming in T-SQL
Manage SQL Server Constraints Writing SELECT Queries
Overview of T-SQL
Manage Stored Procedures
Getting Started with SQL Server 2012
Write SELECT Statements
Implement Error Handling
Work with System Databases
Work with SSPs and SMOs
Work with T-SQL Statements
Manage Query Plans
Work with Predicates
Configure User-Defined Functions (UDF)
Filter the Queried Results
Merge Data Working with SQL Server Built-in Functions
Write CASE Expressions Working with SQL Data Types
Email us about this courses
Other Carmarthen Enable Technology Training Courses
Report Builder Carmarthen Training Courses
JQuery Mobile - Carmarthen JavaScript Training Courses
SSIS - Carmarthen SQL Server Integration Services Training Courses
DAX - Carmarthen Excel Training Courses
SSAS Tabular - Carmarthen SQL Server Analysis Services Training Courses
Excel 365 Basic - Carmarthen Excel Training Courses
JavaScript Carmarthen Training Courses
SSAS - Carmarthen SQL Server Analysis Services Training Courses
JQuery Carmarthen Training Courses
Access - Carmarthen Access Training Courses
Excel Power Pivot - Carmarthen Excel Training Courses
Access VBA - Carmarthen Access Training Courses
Excel 365 Intermediate - Carmarthen Excel Training Courses
VBA Carmarthen Training Courses
Excel 365 Advanced Carmarthen Training Courses