Data Analysis( WT-1031-180 )
| Course Description |  |
This course introduces students to techniques of data analysis involved in designing relational databases and how to apply them effectively. Students will learn how to design an efficient relational database by creating relational constructs, normalizing tables, creating joins and views, optimizing the database's physical design, and avoiding common database design mistakes.
This course requires a word processing application. It also requires a computer running Windows, Macintosh, or UNIX.
eMentoring Services are included with this course.
Course length: 8 hours
| Course details |
| id:
WT-1031-180 |
| subscription duration:
180 days
| | list price: $
325.00 |
|
Languages Offered |
|
This course is currently available in English only.
|
Prerequisites |
|
To succeed fully in this course, students should be able to:
None
|
Skills Gained |
|
Upon completion of this course, you should be able to:
Create relational constructsNormalize tables to first, second, and third normal formsCreate joins and viewsOptimize a database's physical designIdentify and avoid common design mistakes
|
Related Courses |
|
Before: Data Modeling
|
Course Content |
|
Course introductionPrerequisitesWhat you needCourse resourcesYour learning communityMeet your instructorThe course project
Relational constructsA quick recap of the database life cycleRelational theoryCharacteristics of tablesRules for columnsRules for rowsColumn domainsCalculations and domain typesNull valuesKeys for tablesPrimary keysConcatenated primary keysAll-key relationsForeign keysReferential integrityModule wrap-up
|
Module 3: First, second, and third normal forms |
Back To Top
|
First, second, and third normal formsNormalization, part 1Normalization, part 2First normal formAchieving 1NFLimitations of 1NFSecond normal formFunctional dependencies, part 1Functional dependencies, part 2Achieving 2NFLimitations of 2NFModule wrap-up
Third normal formThe limitations of second normal formTransitive dependenciesTransitive dependencies, part 2Achieving 3NFNormalization and Codd's 12 criteriaNormalization beyond 3NFDenormalizationModule wrap-up
Table joins and user viewsTable joinsTypes of joins, part 1Types of joins, part 2User viewsStoring user viewsBenefits of user viewsPermissionsPermissions and requirements analysisModule wrap-up
Physical designIndexingThe downside to indexingClusteringThe downside to clusteringPartitioningHorizontal partitioningThe downside to horizontal partitioningVertical partitioningThe downside to vertical partitioningUsing SQL to create a databaseUsing SQL to create tablesBuilding the databaseThe data dictionaryData dictionary tablesModule wrap-up
Common design mistakesCommon relational database design mistakesBusiness objects and rulesColumnsConstraints and keysPrimary and foreign keysRelationships and referential integrityInternational issuesEvaluating a relational databaseModule wrap-up
Course conclusionWhere do you go from here?We'd love your feedbackCourse survey |
