Database Administration courses Birmingham

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

...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...

...students will be able to: Plan how to implement a database that meets an organization's requirements Create aSQLServer database Manage aSQLServer database Module...

...of Operators Aggregate Functions (3 topics) Overview of Built In Aggregate Functions The GROUP BY Clause The HAVING Clause Joining Tables... Learn about: Oracle Application Server 10g, Database training, Oracle 10g...

...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...

...Change startup properties to hide the database Window, and to remove the built-In toolbar and...

...Debugging and Troubleshooting SSIS Packages This module describes how you can debug packages to find the cause of errors that occur during execution...

...query totals and crosstab queries, using action queries to enable repetitive updates or deletions in tables. Using name autocorrect to track and manage...

...Qualification and Table Aliases Outer Joins Self Joins Alternative Join Syntax Practical Exercises Additional SQL Features Combining Queries The Union...

...Visual Basic syntax. The structure of procedures, the declaration section, comments, keywords, indenting code, navigating code using the keyboard...

...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...

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

...On completion of the course, the delegate will have a basic understanding of the structure of a relational database and the functions of a... Learn about: Creating SQL statements to query a database table...

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

...Create and use stored routines Create and use triggers Obtain database metadata Debug MySQL applications Understand basic optimisations Topics Covered... Learn about: Performing complex joins to access multiple tables...

...tables, indexes, views Write complex SQL query statements Use advanced SQL expressions and functions Modify, Import and export data Perform complex joins... Learn about: Performing advanced Insert, Replace and Truncate Operations...

...the structure of databases and tables Manage and use indexes Write complex SQL query statements Use advanced SQL expressions and functions Modify data Topics Covered... Learn about: Performing advanced Insert, Replace and Truncate Operations...

...Expressions and LOOP Constructs Declare and use Cursors Use record types and PL/SQL Tables Handle Errors and Exceptions within PL/SQL Scripts... Learn about: Using PL/SQL Index-By table built-in functions...

...and Labelled Loops Using Cursors Parameterised Cursors Handling Named and UnNamed Exceptions Generating User Defined Exceptions Nested and Labelled Block...