SQL courses Greater Manchester

...By the end of this course, the delegate will be able to: Describe the basic structure of a relational database, Use the command line features of SQL*Plus, Use SQL Developer to access an Oracle Database, Create SQL statements to select data from an Oracle Database, Use SQL run time parameters...

...suggested follow-on Oracle and MySQL/MariaDB courses. You may wish to review the content of the three day Oracle SQL course, the three day Introduction...

...Rows Updating Rows Deleting Rows Verifying Updates Transaction Control Commit and Rollback Savepoints Commits and Constraints Amending Data in SQL Developer...

...Construct WHILE and FOR Loops Nested and Labeled Loops The GOTO Statement The CONTINUE Statement Using Cursors What is a Cursor? Implicit and Explicit...

...Privileges and Roles Create Users Alter User Details Grant and Revoke Object Privileges...

...Tabular Data Model This module describes Analysis Services tabular data models and explains how to develop a tabular data model by using the SQL Server... Learn about: Skills and Training...

...Using Built-In Functions This module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion...

...Merging Inline Views Using Hints Using Hints to Influence Execution Plan Optimization Mode and Goals Access Methods Query Transformations Join Orders... Learn about: Oracle 10g...

...Attributes Pass Cursor Variables as Parameters Refcursor Datatype Managing Dependencies Dependent and Referenced Objects Invalidation and Recompilation...

...Indexes Automating Routine Database Maintenance Automating SQL Server 2014 Management Automating SQL Server Management Implementing SQL Server Agent...

...of the use of stored procedures along with guidelines on creating them. Designing and Implementing User-Defined Functions This module explains how to design...

...Package Using the SQL Tuning Advisor with SQL Developer Sequences and Views Sequence Caching Views View Merging Inline Views Using Hints Using Hints... Learn about: Database training...

...This course describes how to implement a data warehouse platform to support a BI solution. Delegates will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services...

...data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio. Introduction to DAX This module explains the fundamentals of the DAX language...

...SQL Server Table Structures Working with Clustered Indexes Designing Effective Clustered Indexes Lab : Implementing Table Structures in SQL Server Creating... Learn about: Database training...

...students will learn how to automate routine administrative tasks using jobs, operators, and alerts. Automating Administrative Tasks in SQL Server Using... Learn about: Database training...

...Package Using the SQL Tuning Advisor with SQL Developer Sequences and Views Sequence Caching Views View Merging Inline Views Using Hints Using Hints... Learn about: Database training...

...This course focus on creating insightful visual reports using MS SQL SSRS. we cover the various features and capabilities of SSRS and practice to create different visual with parameters and interactivity. The Target Audience for this course would ideally be end-users who need to present data... Learn about: Data Collection, SQL Server, Database Design...

...Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture... Learn about: Database Design, Relational Model, Conceptual Data Models...

...statements Using variables in DML queries Locking tables and rows Updating data in many tables IGNORE clause REPLACE clause DELETE versus TRUNCATE... Learn about: Database Design, Technology skills, Data Management...