Navigation

Custom Search

> > > >

Online Database Design eLearning Training

Matching Training Programs

online course

instructor led class

learn at home

group study

self directed training

cd based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer based learning

discount pricing

online tutorial

Database Design Training Seminars and Classes

From Online Training Directory

Database Design Concepts

During this course you will learn the basic concepts of database design, the SQL language and how to design and implement a simple relational database. more...

Microsoft Access 2002 Expert

This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Various maintenance and security features are also covered, teaching students ways to better manage multi-user databases. more...

Access 2000

This course teaches students the basic database elements, good database design, Microsoft Access tools, and database maintenance and security, among many other skills. more...

Access 2000 Expert

This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. more...

From Serebra Learning Corporation

Microsoft Access 2000 Proficient User

This course is intended for end users that are looking to use the intermediate skills of Microsoft Access 2000. At the completion of this course, students will learn how to use Access 2000 to maintain tables and table data; manage Access 2000 data; create and modify forms; and create and modify report formats. more...

Relational Database Design and Administration

This course covers the design methodologies and techniques utilized when building an application based on a Relational Database Management System (RDBMS), using Structured Query Language (SQL). The course is based on RDBMS technology and will identify and explain the details and implementation. Designed for individuals in the design and administration of relational databases. more...

Data Modeling

...ning a database is data modeling. Data modeling enables a database designer to create a model that represents the way in which information is likely to be organized in the database. This data model is then reviewed by the people who are expected to use the final database. Subsequent steps in database designing are performed only after the data model is approved. Individuals wishing to learn more...

Managing Database Access in a DB2 UDB

To describe database access management in DB2 UDB Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator more...

Advanced Database Design in Access 2002

To provide an overview of advanced database design in Access 2002 Anyone wishing to become familiar with Microsoft Access 2002 at an advanced level; students seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at advanced level more...

ECDL ICDL 4 Module 5 Database - Getting Started with Access 2003

To outline the concepts and processes for creating and navigating an Access 2003 database. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain more...

ECDL ICDL 4 Module 5 Database - Basic Access 2003 Tables

To outline the processes for creating and modifying tables. Note: the exercise items included with this ECDL-approved training are not ECDL certification tests. See www.ecdl.com for further details. End users wanting to attain competency in using a database application; end users wanting to become familiar with database concepts; end users wanting to attain competency in using Microsoft Access more...

IBM DB2 UDB Essentials Part 2 - System and Database Administration

Following on from the first course in this curriculum this course focuses on the roles and principal tasks of the System Administrator and Database Administrators in IBM DB2. Administrative utilities and security are covered. The course also provides comprehensive introduction to the areas of database modelling database design and distributed data processing all core concepts within IBM DB2 UDB. more...

SQL Server 7.0 Introduction

This course presents an overview of the features and benefits of SQL Server 7.0 a major update to Microsoft's SQL Server database product. It describes the major differences between versions 6.5 and 7.0 and examines core components data warehousing application development tools and SQL management tools. This course provides an excellent foundation for advanced courses on upgrade and more...

SQL Server 7.0 Installing and Upgrading

This course presents a comprehensive view of upgrading and installation process and its installation types and requirements. Students will learn the procedures for installing and upgrading to SQL Server 7.0. The course describes setup options that must be determined before installing SQL Server 7.0 and covers logon accounts the Windows NT User Account network protocols management tools and sort more...

SQL Server 7.0 Web Integration

This course introduces several new or enhanced technologies procedures and tools for increased dependence on the Web for business applications. The course presents a comprehensive view of Web applications with SQL Server 7.0. The course outlines Microsoft's overall Web strategy including reasons for linking the databases to Web clients possible tasks that can be accomplished through Web more...

Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus

...course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You more...

Oracle9i Performance Tuning: Managing Memory and Disk I/O

This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. more...

CIW Database Specialist Part 1: Introduction to Database Design

This is the first course in a four part series that teaches students about relational databases and database planning and design. It introduces relational databases Codd's rules relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology including the creation of ER models. more...

CIW Database Specialist Part 2: Logical and Physical Design

This is the second course in a four part series that teaches students about normalization and logical and physical database design. This course will cover the normalization about the first second and third normal forms and also about Boyce-Codd Normal Form logical database design resolving relationships creating a logical data model and the various integrity constraints physical database design more...

Microsoft Access 2000 Designing and Implementing Database Applications Part 1 - Database Design

This is the first course in a five-part series that will provide IT professionals with the knowledge and skills necessary to design and implement database solutions using Microsoft Access 2000. At the completion of this course students will learn to identify the guidelines for selecting database architecture; create the key objects in a database application and generate outputs; identify the more...

Oracle9i Performance Tuning: Managing Memory and Disk I/O

This course introduces students to the importance of good initial database design and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize troubleshoot and resolve common performance-related problems in administering an Oracle database. more...

Database Technologies Part 1: Relational Database Fundamentals

...o the fundamentals of relational databases and relational database design including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what' and 'why' of relational more...

MS SQL Server 6.5: Design & Management

...database design on Microsoft SQL Server 6.5. Specific topics include: SQL Server implementor roles and responsibilities; data modeling and data definition concepts; database object creation, such as tables; and basic data retrieval, manipulation, and modification. This course, together with MS SQL Server 6.5 DB Design Il, prepares students for the Implementing a Database Design on Microsoft more...

MS SQL Server 6.5: Advanced Retrieval Structures

...database design on Microsoft SQL Server 6.5. Specific topics include: summarizing and modifying data; database object creation, such as stored procedures and triggers; data referential integrity; the implementation of distributed data in a client/server environment; and the extensibility of SQL Server. This course, together with MS SQL Server 6.5 DB Design I , prepares students for the more...

From 123-CBT Computer Based Training

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention

...ct the advantages of incorporating large extents into the database design. o Reclaim the space from the high water mark by using an ALTER TABLE command. o Query the results of an ANALYZE command to evaluate Oracle data block usage. o Match the actions for recovering space with their description. o Identify the characteristics of the Oracle block size. o Identify the advantages and more...

Oracle9i Peformance Tuning Managing Memory and Disk I O

...rse introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the more...

Oracle9i Database Admin Create a Database

...ting a database, the guidelines for planning the physical database design, the registry entries that must be specified for proper database functionality, and create a password file. • Identify the types of parameter files, create a parameter file by editing settings in the init.ora file, and start an instance in the NOMOUNT mode. • Identify the command options of the CREATE more...

Oracle Designer 6i First Class Design Generation

...tions. o Identify how to refine, generate and build the database design. o Identify how to design and generate an application system that includes an Oracle Developer form and an Oracle WebServer application. Audience Targeted audiences for this course are Business Analysts; Project Leaders; Designer/Developers; Web Application Developers; Data Administrators, and Database more...

Oracle Designer 6i First Class Analysis

...pplications Design Transformer. Identify the uses of the Database Design Transformer. Identify the uses of the Design Editor. Identify the characteristics of the techniques involved in system development. Identify the components of a Process Model. Identify the components of a Function Hierarchy Diagram. Identify the components of an Entity Relationship Diagram. Identify the components more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

...ct the advantages of incorporating large extents into the database design. Identify the characteristics of the Oracle block size. Identify the advantages and disadvantages of small data block and large data block sizes. Identify the functions of the PCTFREE and PCTUSED parameters. Identify the guidelines for setting the PCTFREE parameter. Calculate and set the PCTFREE parameter when more...

Oracle8i Database Admin Create Databases

...ify the guidelines to be followed for planning a physical database design. Identify the steps involved in manually creating a database. Identify the registry entries that have to be specified for proper database functionality. Create a specified password file for a given instance by using the ORADIM80 utility. Create a specified parameter file by editing specific settings in the default more...

Lotus Domino R5 Development Part 8 Application Architecture

...actors that affect application performance. Identify the database design considerations for optimum application performance. Identify the form design considerations for optimum application performance. Identify the view design considerations for optimum application performance. Identify the shared resources considerations to achieve optimum performance. Identify the application programming more...

SQL Server 7 0 Database Design Curriculum

...Database Design Curriculum consists of the following courses: SQL Server 7.0 Implementing a Database - Part 1 SQL Server 7.0 Implementing a Database - Part 2 SQL Server 7.0 Implementing a Database - Part 3 SQL Server 7.0 Implementing a Database - Part 4 SQL Server 7.0 Implementing a Database - Part 5 To review individual course descriptions, please return to the previous page and more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...Choose the advantages of incorporating large extents into database design. Identify characteristics of Oracle data block size. Identify characteristics of small data block and large data block sizes. Run scripts to create and view the report.txt. Identify characteristics of PCTFREE and PCTUSED parameters. Calculate and set the PCTFREE parameter when creating a table. Calculate and set the more...

Oracle8 Database Administration - Create Databases

SQL and PL SQL Basic SELECT

...y relational database concepts and properties. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write SQL SELECT queries. Customize SQL queries when selecting data from a table. Identify SQL*Plus environment, features, and commands. Restrict rows more...

CIW Enterprise Specialist Part 1 CORBA Intro IDL Clients

...RBA), synthesize knowledge of system architecture design, database design and connectivity, create complete software solutions using the Java programming language and API. CIW Java Programming, Object-Oriented Analysis and Design, and Database Specialist certification is necessary or equivalent experience for those students not seeking Master CIW Enterprise Developer Certification. This course more...

Database Technologies Relational Database Fundamentals

...o the fundamentals of relational databases and relational database design, including an in-depth look at data modeling and data design. This course will also cover the evolution of data access and the role that databases and associated enabling technologies play in today's corporate environments. Students should leave this course with a solid foundation in the 'what' and 'why' of relational more...

Lotus Domino R5 Development Part 2 Application Devel Fundamentals

... Create an image resource set in a database. Unit 2: Database Design: Advanced Concepts Duration: 3 - 4 Hour(s) Match the components used to automate a database with their uses. Match the predefined tasks that can be performed by an action in Domino Designer with their purposes. Create an action in a database form. Match the types of hotspots with their uses. Create an action more...

Lotus Domino R5 Development Part 5 Adv Application Development

Course Overview This is the fifth course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the functions more...

CIW Database Specialist Curriculum

The CIW Database Specialist Curriculum includes the following courses: CIW Database Specialist: Part 1(Introduction to Database Design) CIW Database Specialist: Part 2(Logical & Physical Design) CIW Database Specialist: Part 3(Database Interaction and JDBC) CIW Database Specialist: Part 4(Advanced JDBC) To review individual course descriptions, please return to the previous page and more...

CIW Database Specialist Part 1 Introduction to Database Design

...so covers the various phases in the design life cycle and database design methodology, including the creation of ER models. Learn To: o Identify features of a database. o Identify disadvantages of a flat-file database. o Identify the problems that relational databases were developed to overcome. o Identify requirements and scope for the analysis phase. o Identify guidelines for more...

CIW Database Specialist Part 2 Logical Physical Design

...es students about normalization, and logical and physical database design. This course will cover the normalization about the first, second, and third normal forms, and also about Boyce-Codd Normal Form, logical database design resolving relationships, creating a logical data model, and the various integrity constraints, physical database design which introduces physical design, creating more...

From The Virtual Training Company

FileMaker Pro 8 Intermediate

...res and techniques including interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys and deleting duplicate records. Examples of the invoice file are provided at every stage of the creation process so the user can easily more...

Microsoft Access 2002

Virtual Training Company author Dave Mercer teaches database users the fundamentals of Microsoft Access 2002. Whether an advanced, or first time database user, Access 2002 delivers powerful tools for managing and analyzing data. Learn efficient database design, how to create effective tables, and the secrets of querying. Learn the logistics of datatypes and Auto-number fields. Also, learn how to more...

From Teach Me IT

Data Modeling

The Data Modeling WBT aims to teach the basic concepts of data modeling and the various components involved in creating a logical data model. It extensively covers the process of data modeling, from identification of entities, relationships, and attributes, to the process of normalization, and finally the transition from a logical to a physical data model. At the end of this course, the user will more...

Advanced Programming in Java 2 - Part I

The Advanced Programming in Java 2 - Part I WBT is the first of two courses in the Advanced Programming in Java 2 curriculum. It is designed to teach programmers the advanced features of the Java programming language, such as use of JDK, Exception classes, and multithreading. After completing this course, the student will be able to: Configure JDK for running Java programs both at the local and more...

From Skillspride Online Training

Lotus Notes 5.0 Advanced User

This course is an advanced course of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use remote working, database replication, mail rules and agents. The course also covers application integration topics such as importing, exporting, linking and more...

Lotus Notes 4.6 Advanced User

This course is an advanced presentation of some of the more technical user features of Lotus Notes. Users who appreciate a challenging experience will enjoy venturing into Notes database design and automation features. Readers will learn to use and create queries, full text indexes, agents and SmartIcons. To import & export data, link & embed objects and write basic formulas, plus understand more...

Lotus Notes 4.5 Advanced User

Lotus Notes 4.5 Application Developer

This course enables readers to design a Notes application, creating main and response forms, views, folders, navigators, actions and hotspots: apply @functions in field, view columns, windows titles and selection formulas: design help documents: implement security and maintain the database design. more...

Lotus Approach Millennium Edition Introduction

Lotus Approach Millennium Edition is a relational database forming part of the SmartSuite office applications suite. This course is designed to allow readers to get to grips with the basic features of Approach. Readers will be able to create databases; view data, design data queries and produce reports. The course also provides an introduction to database theory and practice, plus hints and tips more...

Lotus Approach 97 Introduction

Approach 97 for Windows 95/98 is a database from Lotus designed specifically for graphical Smartsuite products. This course is designed to teach the essential skills required to start using Approach to a level of competence sufficient for readers to produce their own database application; to be able to view data, query files and produce simple reports. An introduction to database theory and more...

Corel Paradox 8.0 Introduction

This course is designed to teach the basic skills required to start using Paradox 8.0 to a level of competence sufficient for readers to produce their own database application; to be able to view data, query files and produce simple reports. An introduction to database theory and practice, plus hints and tips on good database design techniques is also given. more...

Microsoft SQL Server 2000 Programming Part 1

...SQL Server 2000. The key focus of the course is on server database design and implementation using SQL Server 2000, but it also covers some client development including Access 2000's ADP format, Visual Basic using ADO, and ASP with XML. The course will help readers to design and implement a server-side database, implement all the tables and indexes, implement server-side validation through more...

Microsoft SQL Server 2000 Programming Part 2

Microsoft Access 2000 Advanced

This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations. more...

Microsoft Access 97 Essentials

MS Access 97 is the latest database from Microsoft designed specifically for a graphical environment. This course is designed to give you an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. An introduction to database theory and practice, plus hints and tips on good database design techniques are also more...

Microsoft Access 97 Introduction

Microsoft Access 97 Advanced

This intensive course is designed to give existing users of Access for Windows 97 an insight into some of the more advanced features in Access. This entirely 'hands on' course will give readers a further understanding of database design principles, advanced forms, reports and query design, including using calculations. It will also show customisation of the database through command buttons, macros more...

Microsoft Access 97 Database and Filing Systems

This course is designed to give you an understanding of some of the major features and functions within Access 7.0 and the advantages of using a relational database running under Windows. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given. more...

Microsoft Access 97 Expert User Part 1

Microsoft Access 97 Expert User Part 2

This intensive course is designed to give existing users of Access 97 an insight into some of the more advanced features in Access. This entirely 'hands on' course will give readers a further understanding of database design principles, advanced forms, reports and query design, including using calculations. It will also show customisation of the database through command buttons, macros and more...

Microsoft Access XP 2002 Level 1; Introduction

To give an introduction to database design concepts. This course offers a grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. more...

Microsoft Access XP 2002 Level 2; Intermediate

To build on some existing database design and/or user experience that may have been gained from our " Access XP 2002 Level 1; Introduction course. The reader will learn about action queries, formatting text, printing a document, reports, web publishing, database replication and data access pages. Microsoft more...

Microsoft Access XP 2002 Level 3; Advanced

To build on a reasonable level of database design experience that may have been gained from our " Access XP 2002 Level 1; Introduction course and/or Microsoft Access XP 2002 Level 2; Intermediate course. Readers will learn about managing relational databases, customising forms, optimising Access, administering Access and database security. Microsoft more...

Microsoft Access 2000 Level 1; Introduction

To give an introduction to database design concepts using Access 2000. This course offers a grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. more...

Microsoft Access 2000 Level 2; Intermediate

To build on some existing database design and/or user experience that may have been gained from our " Access 2000 Level 1; Introduction course. Microsoft more...

Microsoft Access 2000 Level 3; Advanced

To build on a reasonable level of database design experience that may have been gained from our " Access 2000 Level 1; Introduction and/or Microsoft Access 2000 Level 2; Intermediate courses. Microsoft more...

Microsoft Access 2000 Introduction

MS Access 2000 is the popular database from Microsoft designed specifically for a graphical environment. This course is designed to give readers an understanding of some of the major features and functions within Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given. more...