> > > >

Instructor Led Database Design Training

Database Design Training Provider? - Tell us about your Training!

Please select the location nearest to you: United Kingdom United States India Canada China

online course

instructor-led class

learn at home

group study

self-directed study

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 Human Resource & Organisational Development Consultancy (HRODC) Postgraduate Training Institute

Computing and Information Technology Course

CONTENTS, CONCEPTS AND ISSUES: - Computer Platforms - Systems Analysis - Programming Concepts - Database Design Concepts - Information Systems Projects - Information Systems - Human Computer Interface - Data Analysis and Design - Website Design - Project Management - Networking Concepts - Personal Skills Development - Visual Programming - Hands-on - more...

From Wise Owl Business Solutions Ltd

Basic Querying in Access 2007

Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered. For a full list of course topics, see our more...

Access 2010 Introduction for Developers

Have you got to create a new Access database, or make changes to an existing one? This is the course for you! Beginning with the oh-so-important principles of database design, the course explains step by step how to create a database, create queries, design forms and reports and write the Visual Basic code that you need to link all of this together. Note that it takes a long time to learn Access, more...

Basic Querying in Access 2003 Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered. For a full list of course topics, see our more...

From The Career Center

Fundamentals Of Databases Using MySQL

...fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational 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 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 iWare Logic

Oracle BI 10g Analytics Overview ...ence in business intelligence, data warehouse design, and database design Course Objectives: a Enable students to gain a foundational understanding of the prebuilt components of Oracle Business Intelligence Applications. a Enable students to gain a foundational understanding of business intelligence concepts, Oracle BI Enterprise Edition architecture and user interfaces more...

Oracle BI Suite EE 10g R3 Build Repositories

...g a Basic SQL a Data warehouse design a Database design a Oracle BI Suite EE 10g R3: Create Reports and Dashboards a Oracle BI 10g: Analytics Overview - Course Objectives: a Use time series functions to support historical time comparison analyses a Build the Physical, Business Model and Mapping, and Presentation layers of a repository a Use more...

From L'Obel IT-Palaestra

L'Obel Certified Erwin Training ...tware tool for data modeling (data requirements analysis, database design etc) of custom developed information systems, including databases of transactional systems and data marts. ERwin's data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well. Distinguishing features * Logical Data Modeling: more...

From Mullan Training

Database Design & Development

DATABASE DEVELOPMENT Mullan Training specialise in design & development of databases - we use the technology best suited to the Client (including Access, VB/ VBA, FoxPro, FileMaker, SQL Server, etc). We sit down with the client and identify their needs, develop a prototype based on the initial specification, then refine the system as necessary. Please contact us if you would like to more...

From Ecologic Corporation

Oracle SQL Certification Training in Baddi and Chandigarh Syllabus of the Oracle SQL 9i Test * SQL Data types * SQL Functions * SQL Operators * SQL Joins * Creating tables * Data Dictionary * Inline Views * Data Manipulation * Data Retrieval * Group Functions * NULL Values * SubQueries * Constraints * Restricting Data * SQL*PLUS * Transactions * Creating Tables * more...

DataWareHousing

With SQL Server 2005 and 2008, Microsoft provides a complete suite of tools for you to build data warehouse and business intelligence systems using software from a single vendor. This course prepares you to deal with the many facets of developing, deploying, operating, and growing your Microsoft data warehouse system and Great Enterprise Applications more...

From Maverick Enterprises

Get on Track with MS Access Basics

Understand the Fundamentals of a Relational Database, Learn Database Design Tricks and Shortcuts, Build Tables and Learn How to Use Predesigned Templates. Understand the Functions of the Queries, Design Forms and Build Reports more...

Get on Track with MS Access Intermediate

Students will learn how to create table relationships, Set up input mask properties, work with look-up fields and subdatasheets, create multiple table queries and join queries, create Pivot Tables and Pivot Charts, and use hyperlink fields and data access pages. Basic knowledge of database design and Microsoft Access software is required. more...

From Software Training Academy, Inc

SQL Server 2005 Transact SQL T-SQL with Additional Topics

...ing with XML. LEARNING OBJECTIVES Understand basic database design principles and how to implement them in SQL Server. Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data. Understand the differences between view, stored procedures, triggers, and user-defined functions. Use the new Common Table Expressions for creating hierarchical queries. more...

SQL Server 2008 for developers

...onfiguring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to more...

From MeritForge Infotech

DB2 9.7 Administration on Unix, Linux and Windows

This course is designed to teach you how to perform database administration tasks using DB2 9. 7. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Please contact info@meritforge. com for further queries. After completing this course, you should be able to: * Administer a DB2 database more...

From RAMCO Software Training

Access 200710 Level 1

The focus of this course is to learn how to use Access more efficiently and productively through commands and an awareness of multiple table database design. It is intended to not only show the student the wide range of problem solving that is available in Access, but to allow them to gain techniques that master database processes. Students learn to view, edit, and print data in the tabular more...

From Hands On Technology Transfer, Inc.

SQL Programming

... Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful more...

Microsoft Transact-SQL Programming

... Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, use of cursors, creating and using Views and user-defined functions, and transaction locking. This class is intended for analysts, more...

From Open Source Training

SQL Programming ... Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful more...

From Skills Matter

Robert Schneiders Mission Critical Service Testing Using soapUI Pro ... Oriented Architecture (SOA), open source, and relational database design/ optimization. Robert will be at Skills Matter this spring to deliver an engaging seminar on Mission Critical Service Testing. This two day course will teach you how to use the powerful capabilities of soapUI Pro to answer important questions prior to placing these services into production. In an effort to more...

From Last Minute Training

Access 2007 New Features In addition to the new user interface, Access 2007 offers several new features that make creating a new database and its objects easier, even for people with little knowledge of database design. This course is designed to help you get the most out of these new features. more...

Microsoft Access 2000 - 2003 Level 1 Database Design nexient Who should attend? This course is intended for new users of Access 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Identify the components of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it more...

Microsoft Access 2000 - 2003 Level 1 Database Design - nexient Who should attend? This course is intended for new users of Access 2000/ 2002/ 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Identify the components of a database, and work with those components Open a table, find information stored there, and enter data Create a table design from a template, and customize it more...

Microsoft Access 2000 2003 Level 2 Advanced Database Design Who should attend This course is intended for participants who are familiar with Access 2000 - 2003. Performance Objectives Upon completion of the course, participants will be able to accomplish the following: Enhance tables by creating lookups Create various types of advanced queries Create advanced forms by adding controls, subforms, calculations, and graphic images Create more...

Microsoft Access 2000 2003 Level 2 Advanced Database Design- Nexient Upon completion, participants will : enhance tables by creating lookups, create various types of advanced queries, create advanced forms, create relationships between tables to ensure data accuracy, work with & create web-based objects. more...

Microsoft Access 2007 Level 1 Database Design Topics included in this 2 day course: The basics, table data, table design, data entry, relationships, creating & using forms, queries, reports, importing & Exporting data, printing and more more...

Microsoft Access 2007 Level 2 Advanced Database Design Upon completion, participants will be able to : overview databases, edit documents, enhance tables by creating lookups, create advanced forms & reports, work with & create web-based objects. more...

Relational Database Design Technical - ctc Students will learn the general principles involved in designing a database that complies with the relational database model. more...

Microsoft Access 2007 Database Design Learn to identify the components of a database, open a table & find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between tables to ensure data accuracy... more...

Microsoft Access 2007 Advanced Database Design Level 2 Upon completion, students will understand inserting & deleting text into a document, enhancing tables by creating lookups, creating advanced forms by adding controls, subforms, calculations, & graphic images, working with & creating web-based objects. more...

Microsoft Access 2000 - 2003 Level 1 Database Design 2 day course Upon completion, you will : Identify & work with the components of a database, open a table, create a table design from a template, enter data into tables, create relationships between tables, create several query & report types, Import & export data. more...

From NR Computer Learning Center

Advanced Website Development with MySQL, PHP and Ajax (5 Days)

Fundamentals of Databases Using MySQL (1 Day)

Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5. 1. In the Fundamentals of Databases Using MySQL course, you will work with the databases utilizing MySQL. This course will also help students who are more...

Database Design Specialist Training (3 Days)

This is a three-day course that teaches students how to plan, design and implement a relational databases using MySQL. You will learn about the theory behind relational databases, relational database nomenclature, and relational algebra. The course includes sections on Structured Query Language (SQL) and optimizing databases through normalization. You will apply your knowledge with hands-on labs more...

Fundamentals of Databases Using MySQL 1 Day

From E-Tek Computer Training

Adobe Dreamweaver CS5 Level 3

Course Description You know to create professional looking web pages. Now, you may need to vary the content on the pages dynamically. In this course, you will use Adobe ® Dreamweaver ® CS5 to create and administer database-driven sites. Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Professional more...

From Modulus

T-SQL 2008

In this course, you will learn about the features that are available in SQL Server such as how to design and create a database, and how to build basic queries using Transact-SQL, the language of SQL Server. Then you will learn how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You will learn how to use the Transact-SQL programming language for more...

SQL Server 2008 for Developers

Oracle 10g SQL Programming Training In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. Students will go on to develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning more...

Oracle 10g Advanced SQL Programming Training

In this class, students will develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses. Prerequisites Oracle 10g SQL Programming. more...

From AspenTech Consulting Group, Inc

ACT Customization and Administration Training Class ...elds and layout) and productivity. This class will review database design principles, as well as tips & tricks for easy customization. Installation and maintenance of ACT on a network will also be covered. This class is very interactive with hands-on instruction, using state-of-the-art laptops in our custom designed-classroom. You will receive a manual for reference, a quick reference sheet more...

From FOSVA Training

Microsoft Access 2003 Level 3 ...anaging Relational Databases a Database Concepts a Database Design a Normalisation a Database Integrity a Types of Relationship a Creating Table Links a Referential Integrity Optimising and Administering Access a Optimising Performance a The Performance Analyser a The Add-in Manager a Compacting your Database a The Database Documentor a The Database Splitter a more...

Microsoft Access 2007 Level 1 ... Closing a Database a Opening a Database Tables a Database Design. a Creating Tables Using the Table Wizard a Creating Tables In The Datasheet View a Creating Tables in the Design View a Data Types a Field Properties a Data Display Format vs Input Mask a The Input Mask a Data Entry Problems a Moving and Copying Records Working with Tables a Pasting Records a more...

Microsoft Access 2007 Level 3 ...naging Relational Databases a Database Concepts. a Database Design a Normalisation a Database Integrity a Types of Relationship a Creating Table Links a Referential Integrity Optimising and Administering Access a Optimising Performance a The Performance Analyzer a The Add-in Manager a Compacting your Database a The Database Documentor a The Database Splitter a more...

Microsoft Access 2003 Level 1

...database design concepts and gives you the ability to create the core objects of a database and covers an introduction to data manipulation and extraction. Target Audience People who intend to design databases from scratch or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases. Pre Requisites No more...

From NACE EDUCATION

PHP - Open Source Scripting Language

...pabilities * Review of relational database concepts * Database design tips * Creating database and users * Users and Privileges * Setting up a user for the web * Creating tables * Mysql Identifiers * Column Data Types * Inserting, Retrieving, Updating and Deleting data in the Database. Accessing Mysql from PHP * PHP's database APIs * Error-handling strategies * more...

My SQL

...s / Software Engineer / Business Intelligence Developer / Database DesignersForms Developer / Portal Developer / Support Engineer Duration :: 32 Hrs Introduction MySql * Overview of MySql tools and capabilities * Review of relational database concepts * Database design tips * Creating database and users * Users and Privileges * Setting up a user for the web * Creating more...

From Webucator

Oracle Designer Data Modeling

This Oracle training course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous real-world' problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented more...

From Sonic Training

Microsoft Access 2003 - Introduction / Intermediate

Course Description Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational more...

From Aspect Training

SQL Introduction for SQL Server

...ntranet Web site. Aspecta ™s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is MySQL, an open source product that is gaining in popularity in the industry. However, more...

SQL Advanced for SQL Server

Building upon the skills mastered in Aspect Traininga ™s Introduction to SQL and Database Design course, Advanced SQL and Database Programming teaches the development techniques needed to take full advantage of powerful and flexible data-driven applications. We'll turn from the prior course's concern with data modelling and database design to how to use data in extensive, enterprise-class more...

From Affinity IT Training, LLC

Relational Database Design

This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. Audience:The target audience for this course is all database professionals concerned about the design and implementation of databases. Among the more...

From New Skilz Corporate Training (Shanghai)

IT Software Developers Training ...ding Standards Project Management Database Design Bugs and Enhancement Reusability & Modularization Deadlines & Resources Implementation Strategy User Acceptance Testing User Interface Design Software Application Client Requirements Skills Development Focus -Business English skills more...

From IT Updates Inc

Datawarehouse Informatica 8x Datastage 8 classroom and online Training

...id Design. Extract, transform, and load (ETL) Database Design (OLAP- MOLAP, ROLAP & HOLAP) Informatica 8. x Tool PowerCenter Architecture Informatica Server, Repository and Client Installation & Configuration Security, Server & Repository Management Production Migration & Performance Tuning Source Qualifier/ File Lists/ Workflow Scheduler/ Reusable more...

From Knowledge Source Inc

Access 2007 Level I Introduction ... Lesson 2: Designing a Database Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships Lesson 3: Building a Database Create a New Database Create a Table Manage Tables Create a Table Relationship Save a more...

From The Bridge Media Training Limited

Adobe Dreamweaver Intermediate Want to master Dreamweaver to create data-driven web applications? On completion you will know how to connect to a database, search and display results, and build a page to update the database. Youa ™ll know all about the basics of Dynamic App Dev, overview of ColdFusion Administrator, basics of Drill-Down Interface, Building Recordsets and Binding Data to a Pages, Server Debug Options, SQL - more...

From Tensor Infotech

AS400 Training in Chennai

Tensor Infotech is a premier services company located in Chennai, India with various service offerings in the field of Engineering, Technology & Training verticals. Our IT training success relies in creating Employable youths. Thus we conduct course streams, which have high Job Requirements in the Industry. AS 400 Training The IBM Application System/ 400 popularly known as AS/ 400 is a more...

From Microsys Technologies and Solutions Pvt. Ltd.,

Oracle 9i Admin

Oracle Concepts Database design Querying PL/SQL tables Dynamic SQL in PL/SQL Nested blocks in PL/SQL Triggers in PL/SQL Tunning more...

From Binepal Technology

Oracle APEX

Hands on Oracle Application Express XE one on one instructor led course 1. Installation of Oracle XE on Windows Or Linux 2. Configuration 3. Upgrade to latest version of APEX 4. Hands on application development using APEX 5. JavaScript jquery plsql use in APEX 6. Backup restore of database using apex tools 7. 101 of database design 8. report design using apex more...

From TrainerQuest

Microsoft Access - Intermediate

A hands-on course that will help participants enhance database designs by using the principles of data normalization and table relationships, querying multiple tables for data used in customized forms and reports more...

Microsoft Access - Introduction

Students will learn the basic skills necessary to begin using MS Access. They will design and create databases, tables, queries, forms, and reports. more...

From Mercury Solutions Limited

Data Warehouse Database Design ...Database Design certification are fully knowledgeable of the relational database design & data modeling. This certification course provides them with a complete knowledge of the basic concepts, features and various techniques for the data warehouse architecture. By the end of the Oracle Data Warehouse Database Design training, the candidate knows the complete data warehouse design process, more...

From Koenig Solutions

Data Warehouse Database Design In this course, students are presented with the basic concepts, fundamental issues and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the data warehouse design process, including business modeling, entity relationship diagramming, dimensional modeling, physical modeling and warehouse meta data management. more...

From Corporate Education Group

Maintaining a Microsoft SQL Server 2005 Database

...ge of relational databases. Some experience with database design. In addition, it is recommended, but not required, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server Transact-SQL. Course 2779, Implementing a Microsoft SQL Server Database. Course Outline Module 1: Installing and Configuring SQL Server 2005 This more...

From Wintrac Inc.

Paradox 10 - Level 1 Students will learn what a relational-database management system is; how to create tables, forms, queries, and reports; and data-entry techniques. They will also learn good database design techniques. You can get a complete list of other Desktop Application Software classes at http://www.wintrac.com/courses/coursesdesktop.asp more...

Relational Database Design & Data Modeling This courseware training guide book will teach students relational database design and data modeling concepts. This is a common starting point for the entire database curriculum. In addition to receiving the print copy of this course book, all students will receive the two e-Learning modules described at the right. You can get a complete list of other Oracle classes at more...

Oracle Database 10g - Data Modeling This Oracle 10g courseware training guide book will consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. (This same course is also known by the name RELATIONAL DATABASE DESIGN). This course is one common starting point for the entire database curriculum. You can get a complete list of other Oracle classes more...

Relational Database Design This courseware training guide book will teach students relational database design and data modeling concepts. This is a common starting point for the entire database curriculum. In addition to receiving the print copy of this course book, all students will receive the two e-Learning modules described at the right. You can get a complete list of other Oracle classes at more...

Oracle Designer Data Modeling Oracle9i DS Designer This course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous a real-worlda ™ problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented more...

Relational Database Design Oracle9i Architecture Design This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Relational Database Design (Second Edition) For many new or intermediate database developers, it's difficult to know where to start when designing a relational database. It's easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases. You can more...

MICROSOFT SQL SERVER 7.0 - LEVEL 1 ...n some of the issues with installation and configuration, database design issues, how to import non-Jet data, and how to either share data between SQL Server and Jet, or completely upsize data to SQL Server. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 7. 0. You can get a complete list of other Sql server classes at more...

DB2 Concepts and Facilities ...and/ or SPUFI are used to execute SQL statements. DB2 database design and Referential Integrity (RI) are discussed. An overview of DB2 (SQL) programming concepts are presented and discussed. DB2 performance guidelines are discussed. Optionally, the use of the SQL statement EXPLAIN PLAN is used to help to evaluate the efficiency of SQL statements. The following "Release more...

Relational Database Design ( Enterprise Architecture) This course is one common starting point for the entire Sideris database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. You can get a complete list of other Enterprise Architecture classes at more...

Microsoft SQL Server 2008 for Developers ...onfiguring the server. You will see how the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to more...

From Mind Chemistry Inc

SQL Server Database Design SQL Server Database Design more...

From Victoria International College of Business and Technology

SQL Server 2005 DBA Certificate and Hands-on Training in Toronto ...plication - Failover and Failback Part 6. Physical Database 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 more...

From Training Connection

PHP MySQL Training

... and MySQL Publish MySQL Data on the Web Relational Database Design Build a Content Management System Content Formatting and Submission MySQL Administration Advabced SQL Queries Binary Data Cookies and Sessions in PHP Structured PHP programming MySQL Syntax Outline Setting Up Shop The Basic Tools you Need Windows v Mac Beyond the Basic Tools more...

From Corporate Education Group

Implementing a Microsoft SQL Server 2005 Database

...owledge of relational databases. � Some experience with database design. � In addition, it is recommended, but not required, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. � Course Outline Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005

...abase. � ? Use the Database Tuning Advisor to assist with database design. � ? Maintain SQL Server 2005 databases. � Module 6: Securing SQL Server 2005 This module explains the changes and enhancements to the Microsoft? SQL Server? security model in SQL Server 2005. Lessons ? SQL Server 2005 Security Overview � ? Managing SQL Server 2005 Security � ? Managing Permissions � ? Managing more...

Oracle9i Database Performance Tuning

... introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning, rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, participants will learn to recognize, troubleshoot more...

Enterprise JavaBean Programming

This course offers the Java programmer a grounding in the Enterprise JavaBeans (EJB) architecture and the skills to develop EJBs effectively for enterprise development efforts. EJB s position at the heart of the Java Enterprise platform and the use of EJB application servers as the backbone of large-scale distributed systems are studied. We consider the advantages of the application server more...

Administering a Microsoft SQL Server 2000 Database

...ional database concepts, including: Logical and physical database design. � Data integrity concepts. � Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many). � How data is stored in tables (rows and columns). � For students who do not meet these prerequisites, the following course provides students with the necessary knowledge more...

From StarJourney Training & Seminars

Modeling Business Requirements to Create a Database Using Visual Studio .NET

This intensive, three-day course provides students with the knowledge and skills to model business requirements in order to create a baseline database design. It focuses on the use of Object Role Modeling (ORM) and the ORM modeling tool in Microsoft Visual Studio .NET Enterprise Architect. Students will also learn the database modeling process and how ORM relates to Entity Relationship (ER) more...