Database Administration Courses Greater Manchester

...This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focusses on implementing Entity and Referential Integrity...

...and yse SQL run time parameters. Delegates will also be able to use aggregate functions, use numeric, character, date, conversion and miscellaneous functions...

...•Understanding the difference between fields and records Report Design •Entering and editing data •Creating a new report •Moving and copying data •Modifying...

...will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Database Files Configuring the Buffer Pool Extension Planning and Implementing a Backup Strategy Understanding SQL Server Recovery Models Planning a Backup...

...This course is suitable for anyone intending to sit the Oracle Database 11g: SQL Fundamentals (IZ0-051) examination. Together with the Oracle SQL Advanced course... Learn about: Updating and deleting rows in database tables...

...The SELECT and FROM Clauses Conditions and the WHERE Clause Other Conditional Operators Logical Operators The ORDER BY Clause Column Aliases Arithmetic...

...This course covers the main topics of the Oracle exam #1Z0-053 Oracle. Oracle Database 11g Release 2 DBA - Part II Course Overview This Oracle Database 11g Release 2...

...Cursors Exceptions and Nested Blocks The EXCEPTION Section Types of Exception Handling Named System-Raised Exceptions Handling Un-named System-Raised Exceptions...

...data from multiple tables Using standard aggregate functions Implementing Subqueries Who will the Course Benefit? Anyone who needs to understand and... Learn about: Creating SQL statements to query a database table...

...Features Review of basic grouping concepts The ROLLUP and CUBE extensions The GROUPING SETS extension Using the GROUPING and GROUPING_ID functions Manage...

...Select data from an Oracle Database using SQL*Plus and SQL Developer Create SQL statements to select data from an Oracle Database Use SQL run time parameters... Learn about: Using PL/SQL Index-By table built-in functions...

...Components Create an Application Create an Application from a Spreadsheet Create Reports Create Reports Using Wizards Edit Report Attributes Add Links...

...intending to sit the Oracle examination #1Z0-147: Program with PL/SQL . Note: Exams are not included as part of the course. Before taking any...

...Dictionary Information Concerning Procedures The Call Statement Functions What is a Function? The CREATE FUNCTION Statement Executing Functions Invoker's...

...They will also be able to describe and use some of the Oracle-supplied packages. Together with the PL/SQL course, this course is suitable for delegates... Learn about: Stored program units and packages, To provide the skills needed to develop, Write and maintain triggers...

...and introduces concepts such as predicates and set-based operations. Writing SELECT Queries This module introduces the fundamentals of the SELECT statement...

...It also introduces some of the Oracle-supplied packages. Skills Gained The delegates will practise: Writing and running PL/SQL programs from SQL*Plus... Learn about: Stored program units and packages, To provide the skills needed to develop, Write and maintain PL/SQL scripts...

...for the logical design of a data warehouse, and then discusses best practices for its physical implementation. Creating an ETL Solution with SSIS...

...in reports •Creating relationships •Grouping and sorting data •Importing data •Creating and formatting labels •Modifying field properties Query Design...