Relational Database school training courses in Boston, MA (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>>

This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. During hands on lab sessions students are required to design multiple database models from business requirements and specifications. Through hands on experience using SQL programming code to create, populate and manage databases, stu...

Full archival course description>>

This course introduces students to the fundamental processes of developing, implementing and maintaining a database system in order to produce management information. The course focuses on the ACCESS XP (2003) database management system. Students learn to create, query and maintain a database and also create forms, reports, and combo boxes. Web features are used to publish to the Internet and an application system is created using Macros and Object Linking and Embedding (OLE). SQL and Visual Bas...

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>>