Database Design school training courses in Dallas, TX (public, in-house or online)

You Will Learn How To

Design, build and query a relational database
Capture the structure of an existing database with a CASE tool
Develop a data model to describe an application’s data
Apply normalization to data for effective, stable database design
Build a relational database from the logical database design
Access data in a relational database using simple SQL queries

Course Benefits

Relational databases often drive company-critical and Web-enab...

Full archival course description>>

Learn how to plan and implement Adaptive Server Enterprise (ASE) tables, indexes, and data integrity to satisfy the data and processing requirements of an enterprise. Gain exposure to all major physical design principles needed to create optimal database designs on the ASE 12.0 platform. Study a formal design methodology that starts with a logical data model, and translate that into a relational representation. Both local and distributed requirements are used to design the most optimal physical ...

Full archival course description>>

Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of the relational data model and how to apply its principles to produce a fully normalized logical data m...

Full archival course description>>

1.Data Modeling Concepts A.Introduction to Data Modeling
B.Relational Database Components
C.Data and Process Modeling
D.Organizing Database Project Work

2.Data Modeling Details A.Conceptual Data Modeling
B.Logical Database Design Using Normalization
C.Beyond Third Normal Form
D.Physical Database Design

3.Design Alternatives A.Alternatives for Incorporating Business Rules
B.Alternatives for Handling Temporal Data
C.Modeling for Analytical Databases
D.Ent...

Full archival course description>>

This database design training class 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 modeling principles are presented providing state-of-the-art modeling skills to ...

Full archival course description>>