SQL TRAINING COURSES MALVERN
About Enable Technology Malvern SQL Training Courses
We are a company that provides short intensive SQL training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
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. Another option is we can organise a local training site in Malvern. We will work with you prior to the course to tailor the SQL syllabus to match your requirements.
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 Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Birmingham Heartlands Hospital, Nationwide Building Society Limited, Barclays Bank PLC, Total Telecommunications Limited, Unipart Group, Royal & Sun Alliance Group PLC, Fujistu PLC and Boots UK Limited.
Oracle SQL
- 2 day course
- Location: Malvern
- 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 Queries - Joins
- See Training Course Details...
Buffer Manipulation Commands
The EXISTS Operator
Data Inconsistencies
Oracle Pseudocolumns
Literal Values
Interactive SQL*Plus Scripts
Explicit Locking
Creating Views
Self Joins
Synonyms
Correlated Subqueries
Views
Combining SELECT Statements
Graphical Clients
Numeric Functions
Logical and Physical Storage Structures
Oracle Versioning and History
Controlling Access to Your Tables
Joining Tables
Oracle PL/SQL
- 3 day course
- Location: Malvern
- 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 ... Generating an Error
- See Training Course Details...
Creating a Stored Function
Stored Procedures and Functions
Exception Handling
Stored Functions and SQL
Creating Packages
Assignment and Conversions
The Implicit (SQL) Cursor
Datatypes
Using VARRAYs
Named Parameter Notation
Triggers
Loops
Nesting Blocks
Selecting into a Variable
Using Packages
Internal LOBs
Dependencies and Validation
Triggers on Views
Declaring and Opening Cursors
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Malvern
- 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 ... Troubleshoot Package Failures Deploying Packages
- See Training Course Details...
Deploy a Control Flow
Change Granularity Creating Fact Tables and Columnstore Indexes
Work with Windows Azure
Create an SSIS Project
Add Data Flow Components to a Data Flow Task
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Execute Packages from Different Control Flow Working with Dynamic Variables
Create Dimensions
Perform Transformation Tasks
Introduction to Data Warehouses
Deploy SSIS Packages
Add Packages to an SSIS Project Managing Control Flow
Secure Databases Working with MDS and Windows Azure
Securing Packages and Databases
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Configure MDS
Execute SSIS Packages on the Server
Create Fact Tables
Debug Package Execution Components
Transact SQL
- 2 day course
- Location: Malvern
- Telephone on 01952 938014
- Course Outline
-
In this two day intensive course you will learn how to create queries to retrieve, add, update, and report from your SQL Server database. You will sort and aggregate data, use built-in functions, create stored procedures, subqueries, table operators, set operators, conditional operators, views, indexes, and explore SQL Server error handling features.
The course is particularly suitable for Data Analysts or candidates involved in retrieving and reporting business and management information. No prior SQL knowledge is assumed.
- Some of the training topics covered include ... Work with Variables and Batches
- See Training Course Details...
Analyze Data from Query Plans
Work with Predicates
Modifying Data
Work with SSPs and SMOs
Write CASE Expressions Working with SQL Data Types
Overview of SQL Server
Manage Query Plans
Update Data
Work with Date and Time Data Types
Manage Transactions Querying SQL Server System Metadata
Overview of T-SQL
Work with the XML Data Type Sorting and Filtering Data
Work with SSMS Working with T-SQL
Work with Set Operators
Create Queries Using Join Algorithms
Work with Subqueries
Work with Data Access Technologies Implementing Stored Procedures
Work with PIVOT and UNPIVOT
Merge Data Working with SQL Server Built-in Functions
Write SELECT Statements
SQL
- 2 day course
- Location: Malvern
- Telephone on 01952 938014
- Course Outline
-
This practical hands on course assumes no prior SQL knowledge. Participants will learn how to query a relational database. At the end and the course delegates will be able to extract filtered information, group and aggregate data, write update, insert and delete SQL statements, create and edit tables, views and stored procedures.
- Some of the training topics covered include ... Renaming Tables
- See Training Course Details...
Foreign Keys
Mathematical Calculations
Aliases
Checking Multiple Conditions
Conditional Processing with CASE
Comments
Sorting Records
Sorting By a Single Column
The IN Operator
Table Aliases
Checking for NULL
Primary Keys
Data Types
Simple SELECT Statements
Common Math Functions
Columns
Email us about this courses
Other Malvern Enable Technology Training Courses
Power BI Malvern Training Courses
Excel 365 Intermediate - Malvern Excel Training Courses
Excel 365 Basic Malvern Training Courses
Access Malvern Training Courses
SSIS - Malvern SQL Server Integration Services Training Courses
SSRS - Malvern SQL Server Reporting Services Training Courses
Power Query - Malvern Excel Training Courses
Excel Power Pivot Malvern Training Courses
Access VBA Malvern Training Courses
VBA - Malvern Excel Training Courses
JavaScript - Malvern JavaScript Training Courses
SSAS Tabular - Malvern SQL Server Analysis Services Training Courses
JQuery Mobile - Malvern JavaScript Training Courses
JQuery - Malvern JavaScript Training Courses
Excel 365 Advanced Malvern Training Courses