SQL TRAINING COURSES UK
SQL Server Data Warehouse Implementation
- 3 day course
- Location: Uk
- 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 ... Configure the Package Execution Strategy
- See Training Course Details...
Execute SSIS Packages on the Server
Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
Examine Data Warehousing Concepts
Change Granularity Creating Fact Tables and Columnstore Indexes
Add Packages to an SSIS Project Managing Control Flow
Create Package Templates Implementing Data Flow
Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
Examine MSI Packages
Work with MDS Databases
Overview of Data Warehouses
Troubleshoot Package Failures Deploying Packages
Track Changed Data Managing Data Flow
Perform Transformation Tasks
Work with Windows Azure
Create an SSIS Project
Deploy SSIS Packages
Securing Packages and Databases
Debug Package Execution Components
SQL
- 2 day course
- Location: Uk
- 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 ... Benefits of Stored Procedures
- See Training Course Details...
Selecting Specific Columns
Checking for NULL
Popular Databases
WHERE and ORDER BY
Selecting All Columns in All Rows
Relationships
Sorting By Column Position
Subqueries
Conditional Processing with CASE
CASE syntax
The WHERE Clause and Operator Words
Common String Functions
Benefits of Views
Creating Tables
Oracle SQL
- 2 day course
- Location: Uk
- 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 ... Creating Views
- See Training Course Details...
Review of Relational Database Terminology
Connecting to a SQL Database
Using SQL Functions
Compound Expressions
Synonyms
Inline Constraints
Defining Tables
SQL Queries - Joins
Loading Tables From External Sources
Combining SELECT Statements
Relational Database Management Systems
Tailoring Your SQL*Plus Environment
Interactive SQL*Plus Scripts
Logical and Physical Storage Structures
Concurrency
The UPDATE Statement
Updatable Views
Oracle PL/SQL
- 3 day course
- Location: Uk
- 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 ... External LOBs
- See Training Course Details...
The DBMS_OUTPUT Package
Row-Level Triggers
The Implicit (SQL) Cursor
Closing Cursors
Package Variables
Triggers
Record Variables
Iterating Through Collections
Maintaining Triggers
PL/SQL Stored Program Compilation
Oracle-Supplied Packages
PL/SQL Variables and Datatypes
PL/SQL Syntax and Logic
Using Nested TABLEs
The Cursor FOR Loop
Triggers
Stored Subprograms
Maintaining Stored Programs
Compile-Time Warnings
Transact SQL
- 2 day course
- Location: Uk
- 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 Grouping Sets Managing Error Handling and Transactions
- See Training Course Details...
Configure User-Defined Functions (UDF)
Work with Set Operators
Work with Binary Data Types
Group and Aggregate Data Programming in T-SQL
Work with Window Functions
Work with Date and Time Data Types
Manage Stored Procedures
Implement Error Handling
Sort the Queried Data
Write SELECT Statements
Filter the Queried Results
Work with System Catalog Views Optimizing Query Performance
Work with T-SQL Statements
Update Data
Modifying Data
Work with SSPs and SMOs
Configure Indexes
Manage Transactions Querying SQL Server System Metadata
Work with String and Numeric Data Types
Control Program Flow
Email us about this courses
Other Uk Enable Technology Training Courses
DAX Uk Training Courses
JQuery - Uk JavaScript Training Courses
Access VBA Uk Training Courses
SSAS Tabular - Uk SQL Server Analysis Services Training Courses
Excel 365 Advanced - Uk Excel Training Courses
Power Query - Uk Excel Training Courses
Excel Power Pivot Uk Training Courses
Access - Uk Access Training Courses
Excel 365 Basic Uk Training Courses
JavaScript - Uk JavaScript Training Courses
SSAS Uk Training Courses
SSIS Uk Training Courses
VBA Uk Training Courses
SSRS Uk Training Courses
Power BI - Uk Microsoft Power BI Training Courses