Database Training        

DurgaTech.Com : Technology Solution & e-Market

                     Home Up News Privacy Policy FAQ Products Services

 

                

 

Training
Products
Services

  

Enter Keyword (s) to Search:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Database Training

        DAY 1:       Database Fundamentals.  

  • Database

  • Database Environments.

  • Business Rules. Business Processes. Information and Data. Requirements Analysis.

  • Entities. Attributes. Business Process Reengineering.

  • Database Schema. Table. Data Types.

  • Primary Keys. Foreign Keys. Relationships.

  • Key Database Design Concepts.

  • Design Methodology. Converting the Business Model to Design. Application Design.

  • Performance. Redundant Data Is Minimized.

DAY 2:       Database Models.  

  • Types of Databases.

  • Flat-File Database Model. Hierarchical Database Model. Network Database Model.

  • Relational Database Model.

  • Relational Database Characteristics.

  • Relational Database Objects.

  • SQL: The Relational Database Language.

  DAY 3.       Design Planning. 

  • What Is a Database Design?

  • Importance of Database Design.

  • Planning Database Design.

  • The Mission Statement.

  • Devising a Work Plan.

  • Setting Milestones and Making Deadlines.

  • Establishing the Design Team and Assigning Tasks.

  • Logical Versus Physical Modeling.

  • Automated Design Tools. 

DAY 4: Design Life Cycle. 
  • The System Development Process.

  • Traditional Method.

  • The Barker Method.

  • Adapted Design Methods.

  • Overview of Design Processes.

  • Redesign of an Existing Database.

  • Overview of the Database Life Cycle.

DAY 5:       Requirements Analysis.

  • Types of Requirements.

  • Business Requirements. System Requirements.

  • Overview of Requirements Analysis. Determining Business Requirements.

  • Interviewing Management. Interviewing the Customer. Interviewing the End User.

  • Studying the Existing Processes in Place.

  • Analyzing Business Requirements. Determining System Requirements.

  • Establishing Relationships.  

DAY 6: Entities and Relationships.

  • Overview of Entities and Entity Relationships.

  • One-to-One Relationship. One-to-Many Relationship. Many-to-Many Relationship.

  • Transformation of the Entity in Design. 

  • Data Retrieval 

  • Avoiding Poor Relationship Constructs.

  • Understanding Relationships and Table Joins.  

DAY 7: Normalization and De-Normalization

  • Overview of Normalization.

  • Advantages of Normalization. Disadvantages of Normalization.

  • Overview of the NORMAL FORMS.

  • FIRST NORMAL FORM: The Key. SECOND NORMAL FORM: The Whole Key. THIRD

  • NORMAL FORM: And Nothing but the Key. Boyce-Codd NORMAL FORM. FOURTH

  • NORMAL FORM. FIFTH NORMAL FORM.  

DAY 8: Review of Examples and Advance Topics

 

 

Free 2004 Calendar Download

Free 2005 Calendar

 

 

 

 

 

 

 

 

Home ] Up ]

Send mail to webmaster@durgatech.com with questions or comments about this web site.
Copyright 2003 DurgaTech.Com