Instructor Led Indexes Training
Indexes Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United States
India
United Arab Emirates
United Kingdom
Canada
South Africa
Pakistan
From The Career Center
Fundamentals Of Databases Using MySQL
... database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database. Using features such as Enterprise Monitor and MySQL Administrator, you can manage users and administer and monitor a database. Upon successful completion of this course, students will be able to: identify the fundamental concepts of databases and
more...
Fundamentals Of Databases Using MySQL
SQL Level 2
In the course SQL: Fundamentals of Querying (Second Edition), you examined the fundamentals of SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables. In this course, SQL: Advanced Querying, you will create advanced SQL queries, and manipulate
more...
SQL - Structured Query Language
...d how to add, update, and delete data,
tables, views, and indexes.
During this course, including computer lab time, students will be provided with the information
necessary to complete the following objectives:
Recognize proper syntax for an SQL statement.
Use aggregate functions, column aliases, and mathematical expressions in a query statement.
Use the WHERE clause to select specific
more...
SQL Database Design & Implementation
This course teaches you how to use the Transact-SQL language to query and program Microsoft
SQL Server 2000 in a Windows Server Server environment. This course also assists you in preparing
for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator
Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise
Edition.
Upon successful
more...
From Wintrac Inc.
PageMaker 7.0 Level 3 (Windows)
Although PageMaker offers fine control over typography, page layout, colors, and printing, not all of its features are on the surface, so you may be missing out on the best ways to create professional-caliber publications. At its core, this course teaches you how to manage complicated layouts more efficiently. This includes learning more effective ways to work with graphics and type, as well as
more...
Introduction to Oracle9i - Advanced SQL
... SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as such is applicable even for SQL
more...
Oracle9i Database Administration - DBA I
This course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical
more...
Oracle9i Data Warehouse Administration
This course considers how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are
more...
PROGRAMMING IN MICROSOFT ACCESS
...ding database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. Youa ll learn how to programmatically display and manipulate data on forms and reports, and youa ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages. You can get a complete list of other MS ACCESS classes
more...
From L'Obel IT-Palaestra
ZITT ET Certified Data Warehousing Training Courses









...ntifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica
more...
L'Obel Certified Erwin Training
...y and check constraint definition and naming. Support for indexes, views, stored procedures and triggers is also included.
* Logical to Physical Transformation: Includes an abbreviation/ naming dictionary called "Naming Standards Editor" and logical to RDBMS data type mapping facility called "Datatype Standards Editor", each customizable with entries and basic rule enforcement.
*
more...
L'Obel Certified Oracle DBA Training in Bangalore





...ining UNDO tablespaces
a Managing Tables
a Managing Indexes
a Identifying unused indexes
Oracle Fundamentals II
a Networking Overview
a Basic Oracle Net Architecture
a Basic Oracle Net Services Server-Side Configuration
a Basic Oracle Net Services Client-Side Configuration
a Usage and Configuration of the Oracle Shared Server
a Backup and Recovery Overview
a
more...
L'Obel Certified Oracle Training in Bangalore





...ining UNDO tablespaces
a Managing Tables
a Managing Indexes
a Identifying unused indexes
Oracle Fundamentals II
a Networking Overview
a Basic Oracle Net Architecture
a Basic Oracle Net Services Server-Side Configuration
a Basic Oracle Net Services Client-Side Configuration
a Usage and Configuration of the Oracle Shared Server
a Backup and Recovery Overview
a
more...
L'Obel Data Warehousing Training







...g
* Non-identifying
* Display Levels
* Subject Area
* Indexes
INFORMATICA
* Introduction to Informatica
* Products of Informatica
* Difference between Power mart and Power center
* Installation of Informatica
* Configuring Informatica
* Configuring Informatica Repository Server
* Creating & Configuring Repository
* Configuration Informatica Server
* Configuration Temp
more...
From Meirc Training and Consulting
Certified HR Manager - Human Resources Management
By the end of the program, participants will be able to: Define Human Resources and list its main functions and responsibilities. Write an HR strategy while ensuring its alignment with the overall one. Measure the contribution of HR to the bottom line in profit and non-profit organizations. Assess the effectiveness of the Human Resources function through the use of smart key performance indicators
more...
Certified HR Professional


Define Human Resources and list its main functions and responsibilities. Write an HR strategy while ensuring its alignment with the overall one. Measure the contribution of HR to the bottom line in profit and non-profit organizations. Assess the effectiveness of the Human Resources function through the use of smart key performance indicators (KPIs) and indexes. Prepare for the management of a
more...
Masterclass Microsoft Office Professional 2007 Developing Smart Work Skills


...rt Art diagrams and charts, insert references, footnotes, indexes, and table of contents. Excel: create formulas, calculate values, analyze data, present information visually with graphics and charts, analyze data, work with databases, share spreadsheets for review and manage changes. PowerPoint: learn how to create memorable presentations, create great-looking slides, charts, and diagrams,
more...
From Mullan Training
Business Objects Universe Designer



...lying Aggregate Awareness To Objects
Derived Tables And Indexes
Using Derived Tables
Applying Index Awareness
Linking Universes
Creating Links Between Universes
Securing Universes
Setting Access Restrictions On A Universe
Managing Universes
Documenting Universes
Deploying & Maintaining Universes
Creating Universes From Metadata
Creating A Universe From An Xml
more...
From Software Training Academy, Inc
SQL Server 2008 Transact SQL (T-SQL)



...nd design principles.
Create constraints, triggers, and indexes.
Use Transact-SQL INSERT, UPDATE and DELETE statements.
Configure and use SQL Server Management Studio (SSMS).
Use Transact-SQL with data types, delimiters and variables.
Understand the differences between views, stored procedures, triggers, and user-defined functions.
How to write and use stored procedures to provide a
more...
Oracle 10g Administration



...ating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing; Security; creating &
more...
Oracle 10g 11g Introduction to SQL



...s such as tables, temporary tables, nested tables, views, indexes, synonyms and sequences
Grant and Revoke object privileges
Prerequisites: No mandatory prerequisites exist for this course.
Audience: The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:
a
more...
From Digital Training & Designs
Adobe InDesign CS5 Advanced
Our Adobe InDesign Advanced course furthers your Adobe InDesign education. In this two-day class you will learn more advanced concepts used in page layout and production. Production shortcuts are discussed and exercises are used extensively to reinforce the skills learned. You will learn how to create long documents, create indexes and table of contents. Whether you enroll in our public classes,
more...
From Hands On Technology Transfer, Inc.
Microsoft SQL Server 2008 Administration


This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server
more...
From NobleProg - IT training courses
Oracle Database 11g New Features for Administrators DBA Release 2





...ry
* Partitioning Enhancements
* System-Managed Indexes for List Partitioning
Module 5: SQL Performance Analyzer
* SQL Performance Analyzer: Overview
* Using SQL Performance Analyzer
* Using Enterprise Manager to Access SQL Performance Analyzer
* SQL Performance Analyzer: Data Dictionary Views
Module 6: Database Replay
* Using Database Replay
*
more...
From London Financial Studies
Commodities and Commodity Derivatives


...kable growth of hybrids, structured notes and commodities indexes - makes this course essential for all those needing a thorough and detailed understanding of both spot and derivative transactions. The programme will cover fundamental issues such as volume risk, mean-reversion, the forward curve, and the theory of storage. Plain-vanilla and exotic options on commodities will be analysed, as
more...
From Last Minute Training
InDesign CS3 Large-Scale Publishing

Location: Ottawa Date: 2007-06-27
List Price: $395 Offered Price: $276.00
Seats Available: 2
brief review
working with multi-page documents
master items
styles
tabs
sections and numbering
libraries and snippets
creating/opening/editing/deleting libraries
adding/editing/deleting library items
setting library display
searching and sorting libraries
creating and using snippets
more...
Microsoft Word Training - Intermediate (French Instructions, French Language)
Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.
more...
SQL Advanced
...d how to add, update, and delete data, tables, views, and indexes.
Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins.
For more information please call 1-877-313-8881 or copy this link into your browser:
more...
Microsoft Word Training - Intermediate
Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.
more...
Microsoft Access 2003 - Level 3 - English
... Subforms, Subreports; Form techniques; ActiveX Controls; Indexes; Databases; Macros; Switchboards; Toolbars; Importing to other Office Suite applications such as Excel and Word; and much more. This course will run for one day, from 9:00 am to 4:00 pm, bilingual instructor-led, in which a training manual as well as a certificate of completion will be offered to participants who complete this
more...
Microsoft Word XP 2003 Level 3
Objectives
* Create AutoText Entries
* Create text boxes
* Use Graphics And Watermarks
* Use the Drawing Tools
* Create Outlines
* Generating Indexes And Tables Of Contents
* Use Styles And Templates
* Create Online Forms
* Create Macros
more...
Microsoft Word 2007 Level 3 - on track
Objectives
* Create AutoText Entries
* Create text boxes
* Use Graphics And Watermarks
* Use the Drawing Tools
* Create Outlines
* Generating Indexes And Tables Of Contents
* Use Styles And Templates
* Create Online Forms
* Create Macros
more...
Word Customization Long Documents and Macros
This course provides competency in customizing the Word environment; using Excel worksheets and XML documents; navigating long documents; summarizing document content; using endnotes, footnotes, tables of figures, tables of authorities, indexes and tables of contents; using master documents; and working with macros.
more...
Microsoft Access 2007 Level 2
After you complete this course you will be able to do the following:
* Understand When And How To Implement Full Or Partial Referential Integrity
* Create Single And Multiple Field Indexes And Tables
* Check The Integrity Of A Database
* Use The Toolbox To Design Forms From Scratch
* Use Calculated Fields
* ...among many other things
more...
Implementing a Microsoft SQL Server 2005 Database - nexient
...n Microsoft SQL Server 2005.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
Implement data integrity in Microsoft SQL Server 2005 by using triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service
more...
Microsoft Word 2000 2003 Level 3 - nexient
Who should attend?
This course is intended for participants who are familiar with Word 2000/ 2002/ 2003.
Performance Objectives
Upon completion of the course, participants will be able to accomplish the following:
Assign themes and insert graphics to add visual appeal to documents and use WordArt and text boxes to enhance document layout
Add columns, headers, and footers to enhance page
more...
Microsoft Word 2002 - 2003 Level 3 - on track
Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.
more...
Implementing a Microsoft SQL Server 2005 Database 5 day course - Nexient
Upon completion, students will: create databases & database files, data types & tables, use XML-related features in Microsoft SQL Server 2005, Plan, create, & optimize indexes, Implement data integrity in Microsoft SQL Server 2005 databases and more.
more...
Microsoft Access 20022003 Level 2- On Track
This course teaches the intermediate features of Access 2002/ 2003: Understanding When and How to implement full or partial referential integrity; Creating single and multiple field indexes and tables; Using the toolbox to design forms from scratch; ...
more...
Querying Microsoft SQL Server 2000 with Transact-SQL
Topics included in this 2-day course: Introduction to Transact-SQL; Using Transact-SQL Querying Tools; Retrieving Data; Grouping and Summarizing Data; Joining Multiple Tables; Working with Subqueries; Modifying Data; Querying Full-Text Indexes & more
more...
Microsoft Word 20022003 Level 3 - on track
Topics included in this 1 day course are : Styles and templates, online forms, bullets and numbering, outline, indexes and table of contents, macros, text boxes, graphics, drawing in word and more.
more...
Adobe InDesign CS4 Large Scale Publishing
Learn how to produce large-scale publishing projects using the industry-standard desktop publishing software Adobe InDesign CS4. This course will introduce you to large-scale publishing techniques such as libraries, books, table of contents, indexes...
more...
Microsoft Word 2003 Intermediate - compuease
Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.
more...
Microsoft Word 2007 Level 3 UOA
This course is intended for students with intermediate to advanced experience in Word. This course is designed for those students who manage long documents using tools such as master documents, indexes, table of contents, SmartArt, and Charts.
more...
Adobe FrameMaker 8 Dynamic Content
Now that you have mastered creating FrameMaker documents & templates, it s time to focus on the power of dynamic content such as tables of contents, indexes, lists & footnotes. Also learn how to use variables to create running headers & footers...
more...
Microsoft Word 2003 Intermediate French Instruction English Software
Upon completion you will be comfortable using the Mail Merge function with different data sources; able to apply various Styles, Templates and Forms that ensure document consistency; learn how to generate a Table of Contents and Indexes.
more...
From Saryx
SQL Server
...rches
Understanding Index Architecture
Creating Indexes
Using Primary Keys
Using Full-Text Searching
Introducing more Database Objects
a Introducing Stored Procedures
a Introducing Triggers
a Introducing Functions
a Introducing User-Defined Types
Implementing Security in SQL Server 2005
a Understanding Security Modes
a Understanding SQL Server
more...
From eVentureSolutions (EVS)
Certified SQL Server Specialist
SQL Server offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximize the benefits of SQL Server. Participants gain a solid ground on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL
more...
From AAZAM College of Technology
Oracle Database 11g One Year Diploma












...the object and system level.
This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to
create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate
data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
Students
more...
From LearnVirtual
Managing Building Schedules and LEED Requirements Using Schedules for LEED Tracking
LearnVirtual is an online training program that allows you to learn right from your desk!
This 3 part series will review the interactive schedule in ArchiCAD and how to customize its setup for building schedules, project indexes and LEED requirements. This will include an overview of the Interactive Schedule including editing and formatting as well as detailed steps to create a custom schedule
more...
Managing Building Schedules and LEED Requirements Creating Custom Building Schedules
LearnVirtual is an online training program that allows you to learn right from your desk!
This 3 part series will review the interactive schedule in ArchiCAD and how to customize its setup for building schedules, project indexes and LEED requirements. This will include an overview of the Interactive Schedule including editing and formatting as well as detailed steps to create a custom schedule
more...
Managing Building Schedules and LEED Requirements Using Interactive Schedules and Project Indexes
LearnVirtual is an online training program that allows you to learn right from your desk!
This 3 part series will review the interactive schedule in ArchiCAD and how to customize its setup for building schedules, project indexes and LEED requirements. This will include an overview of the Interactive Schedule including editing and formatting as well as detailed steps to create a custom schedule
more...
From NACE EDUCATION
My SQL



...rences from MyISAM
Optimising tables and queries
* Indexes in MySQL
* Primary keys and unique keys
* Creating primary keys
* Primary keys over multiple columns
* Creating tables with unique keys
* Non-unique indexes
* Adding an index while creating a table
* Adding indexes to existing tables
* Finding out how MySQL will execute a query
* Using explain to analyse queries
more...
From Terrateach
Adobe InDesign CS5 - Advanced
In this two-day course in New York, youa ll take your Adobe InDesign CS5 skills to the truly professional level with knowledge of many of this softwarea s advanced and little-known features.
For example, after revising Next Styles and Nested Styles wea ll look into Object Styles and combining styes. Wea ll master InDesigna s Books and see how to create tables of
more...
Adobe InDesign CS4 - Advanced
Adobe InDesign is the page layout application of choice whatever your skill level. And for users who get familiar with InDesign's advanced features, it offers almost unlimited possibilities for automation, advanced layout work and output. Take your skills in this great design tool to the highest possible level with this advanced training course.
In this two day course, you'll take your InDesign
more...
From BI Technologies
Teradata Training
...ich we are training in
Teradata Architecture
Teradata Indexes
Teradata Administrative Tools
Teradata objects
Logical Database Hierarchy
Teradata Load/ Unload Utilities
Teradata Specific Features
Teradata SQL
Teradata Query Optimization
Performance Tunning and Morea a ..
As we do even certifications oriented training, send us your requirement we would send you our course
more...
From iQrate Consulting Services
SQL Server 2008
The course starts with an introduction to client-server architecture. It introduces the Structured Query Language and builds on the complexity of query handling in SQL Server 2005 and administrative tasks of SQL server2005. In addition it also introduces the comparison between SQL server 2000 and SQL server 2005. It includes the manipulation of Extensible Markup Language data (XML Data). This
more...
From bigrockdesigns
Indesign CS 5 Advanced


Indesign CS 5 course covers detailed areas of indesign including dealing with books, indexes, and tables of contents, and teaches you how to use the automation tools like Scripts and Data Merge and to create complex amazing page layouts
more...
From MotivatedMinds, Inc
Team Synergy Workshop
The Kolbe System can be used to analyze existing as well as potential teams based on individual Kolbe Index results, giving managers and senior leaders the capability to predict and manage team performance.
This program includes individual Kolbe Indexes, A team Synergy Report, and a one-day workshop. It offers a cost-efficient means of debriefing the Kolbe Indexes.
more...
From Affinity IT Training, LLC
Introduction to IBM DB2 Universal Database for Sybase Developers
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction
more...
From Bigtec Pvt. Ltd.
Design & Implementation Of SQL Server 2000

The course starts with an introduction to client-server architecture. It introduces the Structured Query Language and builds on the complexity of query handling in SQL Server 2000.In addition it also introduces the comparison between SQL server 2000 and SQL server 2005. It includes the manipulation of Extensible Markup Language data (XML Data). This course covers data modeling, database objects,
more...
From Unirac Software Technologies
Oracle Database 10g Administrator Certified Associate 1Z0-042





...cating tables (7)
[ ] Create and use B-Tree and Bitmap indexes (8)
[ ] Create Views
[ ] Create sequences
[ ] Use data dictionary
Managing Data and Concurrency
[ ] Manipulate data through the use of SQL
[ ] Identify and administer PL/ SQL objects
[ ] Describe triggers and triggering events
[ ] Define levels of locking
[ ] List possible causes of lock conflict
[ ]
more...
Oracle Database 10g Database Administrator Oracle Certified Professional-1Z0-043




...lespace usage
[ ] Reclaim wasted space from tables and indexes using the segment shrink functionality
[ ] Estimate the size of new table and indexes
[ ] Use different storage options to improve the performance of queries
[ ] Rebuild indexes online
Automatic Storage Management
[ ] Set up initialization parameter files for ASM and database instances
[ ] Execute SQL commands
more...
From Performance Tuning Corporation
Oracle Physical Data Warehouse and Implementation
This four-day hands-on course covers the three stages of data warehouse physical design implementation: Staging, ETL (extraction, transformation, and loading), and Presentation. After a brief discussion of multi-dimensional design, this course will focus on the tasks and Oracle tools used to physically implement an Oracle data warehouse and present the data.
Upon completion of this course,
more...
From Intertech
Implementing a Microsoft SQL Server 2005 Database Training
... in Microsoft SQL Server 2005
Plan, create, and optimize indexes
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints
Implement data integrity in Microsoft SQL Server 2005 by using triggers
Implement views
Implement stored procedures
Implement functions
Implement managed code in the database
Manage transactions and locks
Use Service Broker to build a
more...
Implementing a Microsoft SQL Server 2008 Database Training
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
Learning Objectives
Create databases and database files
Create data types and tables
Use XML-related features in Microsoft
more...
From Aghreni Technologies Private Limited
MYSQL Trainning
The training is intended for programmers to learn basic and advanced concepts of Relational Databases using MySQL for building applications. The program enables programmers to understand the Basics of Relational databases, Client/ Server concepts, Data types, Creating databases, Basic Select statement, Selecting data from multiple tables using JOIN, Grouping and Sorting output, Sub-queries,
more...
From Microsys Technologies and Solutions Pvt. Ltd.,
SQL Server Programming

Module 1: SQL Server Overview
Module 2: Overview of Programming SQL Server
Module 3: Creating and Managing Databases
Module 4: Creating Data Types and Tables
Module 5: Implementing Data Integrity
Module 6: Planning Indexes
Module 7: Creating and Maintaining Indexes
Module 8: Implementing Views
Module 9: Implementing Stored Procedures
Module 10: Implementing Triggers
Module 11: Optimizing Query
more...
From Matrix Zeroone systems
Best institute to learn java in pune Java pune
Course Offers:
In-depth Training on
* C++
* Oracle
* Java technology.
Sun Certification exam vouchers for SCJP exam
* CX-310-065 Sun Certified Programmer for Java 2 Platform 6. 0 certification (SCJP)
Project
Placement Assistance
Course Syllabus
C
* Introduction to C, Compilation
Process, Basic Language
Constructs
* Operators &
more...
From Solutions2b
Growth Toolbar toolkit for a salesmarketing director training program
... asset. Productivity norms are not rate fixing of control indexes. Efforts benchmarking. Rough analysis of sales management system. Rough analysis of marketing effectiveness. Rough analysis of purchasing system. Competitive ability analysis of different divisions and asset involvement. The elimination of any barriers that can potentially interfere with growth;
2) Personality restraints
more...
From Peopleclick Technosolutions Pvt. Ltd
sap bo training in bangalore with realtime scenarios
...
-> Create a cascading LOV
* Creating Derived Tables and Indexes
-> Use derived tables
-> Apply index awareness
* Linking Universes
-> Understand linked universes
-> Create links between universes
* Applying Universe Access Restrictions
-> Set access restrictions on a universe
* Managing Universes
-> Document universes
-> Deploy universes
-> Maintain universes
-> Deploy universes
more...
From Mercury Solutions Limited
OCA OCP DBA 11g
The internationally recognized OCA DBA 11g and OCP DBA 11g certification validates deep knowledge and wide range of skills required to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, etc. Upon the completion of this course, the candidate, becomes proficient in the user and security administration, backup and
more...
MCTS SQL Server 2008 Database Development
The MCTS SQL Server2008 Database Development credential validates the studenta s expertise in working with databases, using SQL Server2008. The training in this certification course will help the students learn about creating tables and indexes, programming of objects implementation, query fundamentals, SQL Server 2008 managed code, XML data, and performance information.
more...
From Corporate Education Group
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
...tabase-level reasons for poor query performance, like bad indexes and outdated index column statistics. Students are provided with samples from a Profiler trace or a listing of poorly performing queries and directed to investigate possible reasons.
Lessons
The Methodology of Optimizing a Query Environment The Query Performance Troubleshooting Process
Lab: Optimizing
more...
From Victoria International College of Business and Technology
SQL Server 2005 DBA Certificate and Hands-on Training in Toronto
... Design (9 hrs)
6. 1. Tables
6. 2. Filegroups
6. 3. Indexes
6. 4. Views
6. 5. Procedures and Functions
6. 6. Database Conventions
Part 7. Recovery and Archive (4 hrs)
7. 1. Data Recovery Needs
7. 2. Backup Types
7. 3. Database Recovery
7. 4. Backup Media
7. 5. Data Archive Plan
7. 6. Partitions Archive
SQL Server 2005 DBA COOP Project (30 hours)
a Project
more...
From Corporate Education Group
Implementing a Microsoft SQL Server 2005 Database
...Microsoft SQL Server 2005. Plan, create, and optimize indexes. Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas. Implement views. Implement stored procedures and functions. Implement managed code in the database. Use Service Broker to build a messaging-based solution.
Prerequisites Before attending this
more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005
... Server metadata.
Module 5: Maintaining Databases and Indexes
This module explains the tools and utilities in Microsoft? SQL Server? 2005 that can help you implement database maintenance plans, manage database indexes, and tune databases.
Lessons
? Managing Indexes ? Using the Database Tuning Advisor
Lab 5: Maintaining a Database
? Defining Indexes ? Tuning a Database
more...
Linux Networking Services
... Control Backend Types Backend and Database Configuration Indexes and Replicas Replica Configuration Syntax Conformance
Lab 6 - Configure LDAP
Configure the LDAP server Create a new directory Add, modify, and delete entries in the LDAP server
Section 7 Using OpenLDAP
Managing slapd Online and Offline Data Manipulation Native LDAP authentication and Client Config
Lab 7 - Configure
more...
Oracle Database 10g Administration Workshop I
...tributes of a table View the contents of a table Create indexes and views
Managing Data Manipulating data through SQL Using Import Using Export Using SQL Loader
PL/SQL Identify PL/SQL objects Understand triggers and triggering events Idenfity configuration options that affect PL/SQL performance
Oracle Database Security Apply the principal of least privilege Manage default
more...
Oracle Database 10g Administration Workshop II
...ce Estimation Monitoring Index Space Identifying Unused Indexes
Automatic Storage Management
ASM Concepts ASM General Architecture Creating an ASM instance Creating tablespaces that use ASM storage Viewing ASM information Migrating a tablespace to use ASM storage
Monitoring and Managing Memory
Oracle Memory Structures Automatic PGA Memory Management Using the Memory
more...
Oracle Database 10g: New Features for Administrators
...tion Management in Enterprise Manager Global Partitioned Indexes - Hash Partitioning Local Partitioned Indexes Manageability Improvements Temporary tablespace groups
RMAN Enhancements
Flash Backup and Recovery Backup Compression Drop Database Automatic Channel Failover for Backup & Restore Incrementally Updated Backups Simplified Recovery Through Resetlogs
Flashback Any Error
more...
