Database Administration courses Bristol

...2. Course description Database is a widely used tool in modern offices today and the course will enable you to learn substantial skills and provide efficient office support... Learn about: Database training...

...use inner joins and outer joins write non-correlated and correlated subqueries use DB2 functions and the CASE statement Course Details INTRODUCTION...

...Configuring Shared Servers Creating and Managing Database Storage Structures Managing Redo Log Files and Control Files Managing Schema Objects Managing Users...

...hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies...

...2. Course description Excel is a widely used spreadhseets tool in modern offices today and the course will enable you to learn substantial skills and provide... Learn about: MS Excel...

...Program with PL/SQL. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience...

...Managing Redo Log Files and Control Files Managing Schema Objects Managing Users, Profiles, Privileges and Roles Managing Undo Data and Temporary Segments...

...and Exporting Data Copying or Moving a Database Monitoring SQL Server 2014 Introduction to Monitoring SQL Server Dynamic Management Views and Functions...

...independent and theoretically informed studies. It also fosters the development of essential professional skills to enhance your employability... Learn about: Part Time, Full Time...

...Delegates: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for anyone intending to...

...Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager...

...Using the Table dual to try out Functions Numeric Functions Character Functions String Concatenation Date Arithmetic and Date Functions Conversion...

...Installing and Configuring Oracle Creating and Managing an Oracle Database Administering an Oracle Database Configuring the Oracle Network Environment... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...IFTHENELSIFELSEStatements CASEExpressions Basic Loops TheWHILEandFORLoops Nested and Labelled Loops Using Cursors Parameterised Cursors Handling Named...

...or Associative Arrays PL/SQL Table Built-in Functions Manipulating PL/SQL Tables or Associative Arrays...

...of a Relational Database UsingSQL*Plus UsingSQLDeveloper The BasicSQLSelect Statement Selecting Data from Multiple Tables Inner Joins, Outer Joins...

...Timestamp and Interval datatypes Handling dates and times Handling intervals Date, timestamp and interval functions and literals Related NLS parameters...

...out performance monitoring and tuning. This Oracle Database 11g Release 2 DBA - Part II course is suitable for both users of Release 1 and Release...

...explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The module also discusses...

...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... Learn about: Updating and deleting rows in database tables...