oracle tutorial - Courses UK

Affordable Online Computer Courses
 
 
 
 
MCSE 2003 Training
MCSA Training
MCDBA Training
MCAD Training
MCSD Training
Mous Certification
CompTIA A+ Training
CompTIA Network+
CompTIA Security+ CompTIA Server+
CompTIA Linux+
Cisco CCNA Training
Cisco CCDA Training
CCNP BSCI Training
CCNP BCMSN Training
CCNP BCRAN Training
CCNP CIT Training
Lotus Notes Training
Novell CNE Training
Solaris 8 Training
Sybase Training
CIW Foundations
Internet Marketing
ICDL Training
ECDL Training
Quickbooks Training
Groupwise Training
Data Warehousing
Project Server 2003
 
 
Windows 2003 Training
Windows XP Help
Windows Training
Windows NT4 Help
UNIX Tutorial
V.Studio .NET/ ASP
C++ Tutorial
SQL Server 2000
Visual Basic Tutorial
Visual C Training
Visual C# XML Training
Visual Studio .NET
Visual interdev
Oracle Training
Powerbuilder Tutorial
SAP Training
SAS Training
Crystal Reports Training
OOP Training Course
Focus Training
 

 
 
"Realistic Simulations"
So you can see how the application really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.
The course provides students with a comprehensive examination of PL/SQL. PL/SQL offers procedural integrity, security enhancements, and performance gains in a client-server environment. PL/SQL is also used to code triggers in Oracle Forms and Reports. PL/SQL will be of particular interest to individuals developing applications in a client-server environment.
Too Busy to Train?
You can Login 24 hours/day -7 days/week. Learn before bed, first thing in the morning, or in the middle of the night. It's always available. You're always in control.
   
 The Instant Mentoring window appears directly within your courses. Instant Mentoring allows you to type a question and receive a immediate response from a subject matter expert available 24/7 to help you succeed! MORE...
 
 

Oracle 9 i Database Fund 1Z1-031 Training

 
Oracle9i Database Fund 1Z1-031 Training
 
Try a
Demo
 
Usual Price
£245
Our
Price
12 Months Access:
UK:149
US:$261
Eur:€219
 
 
 
  65%  
This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z1-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles. Certification: Oracle 9i Database Fundamentals 1Z1-031
  • EASY.....start your online training course within the hour
  • Available 24 hrs/day 7 days/week
  • High quality Web-based Training / e-Learning
  • Train ALL YEAR for 1 low price
             
Click the "Sign up Button" (above) to sign up for 12 months access to this course or buy our Technical General Value pack (this Course plus 34 other courses), if bought separately £5,066. Value Pack price:
Only £399! Save £4,667
MORE...  

 
Oracle9i Database Fund 1Z1-031 Modules Outline:  
Oracle9i Database Fundamentals 1Z1-031- Oracle Architecture and Tools
  • Explain the Oracle server architecture
  • Identify how users connect to the Oracle server
  • List tools used by DBAs to administer Oracle
  • Describe the benefits of Optimal Flexible Architecture
  • Install Oracle using Oracle Universal Installer
Oracle9i Database Fundamentals 1Z1-031- Managing Instances and Creating Databases
  • Create and manage an initialization parameter file
  • Configure Oracle-managed files
  • Use the startup command
  • List the different options available for starting Oracle
  • Shut down an Oracle instance
  • Describe the two types of diagnostic files used in Oracle
  • List the prerequisites necessary for database creation
  • List values that must be set in the parameter file
  • Use the Database Configuration Assistant
  • Create a database with the create database command
  • Define a character set for your database
  • Configure language-dependent behavior for the your database
  • Retrieve NLS information from the your database
Oracle9i Database Fundamentals 1Z1-031- Managing the Database Structure
  • Use data dictionary views
  • Query the data dictionary
  • Use control files
  • Work with redo logs
Oracle9i Database Fundamentals 1Z1-031- Managing Tablespaces and Datafiles
  • Describe the logical structure of Oracle databases
  • Create tablespaces
  • Manage temporary segments
  • Take tablespaces online and offline
  • Change tablespace storage settings
  • Use Oracle-Managed Files (OMF) with tablespaces
Oracle9i Database Fundamentals 1Z1-031- Managing Storage Structures and Undo Data
  • Identify storage needs for different segment types
  • Control the size allocation of extents and segments
  • Acquire extents in dictionary-managed tablespaces
  • Use multiple extents when using parallel processors
  • List the keywords that control block space usage
  • Obtain information about storage from the data dictionary
  • Describe the purpose of undo data
  • Implement automatic undo management
  • Create and configure undo segments
  • Size OLTP and batch undo segments
  • Maintain undo segments manually
Oracle9i Database Fundamentals 1Z1-031- Managing Tables
  • Explain how tables can store data
  • Create permanent and temporary tables
  • Manage storage structures
  • Relocate tables
  • Drop unused columns
Oracle9i Database Fundamentals 1Z1-031- Managing Indexes and Data Integrity
  • Describe the different types of indexes and their uses
  • Create various types of indexes
  • Reorganize and drop indexes
  • Monitor index usage
  • Implement data integrity constraints
  • Maintain integrity constraints
  • Obtain index and constraint information from the data dictionary
Oracle9i Database Fundamentals 1Z1-031- Managing Users and Profiles
  • Manage existing users
  • Monitor information about existing users
  • Control resource use with profiles
  • Administer profiles
  • Manage passwords using profiles
  • Obtain profile information from the data dictionary
Oracle9i Database Fundamentals 1Z1-031- Managing Privileges and Roles
  • Identify system and object privileges
  • Grant and revoke privileges
  • Identify auditing capabilities
  • Create and modify roles
  • Control availability of roles
  • Remove roles
  • Use predefined roles
  • Display role information from the data dictionary
Oracle9i Database Fundamentals 1Z1-031- Exam Preparation
  • After completing this course, the user should be familiar with all the exam objectives for the Oracle 1Z1-031- Oracle9i DBA Fundamentals I exam
 
           2006 © Sandline Learning Training Tutorials - e-Learning - Distance Learning - Self paced - Courses