1 - Introduction to databases
Introduction to relational databasesOther types of databaseData analysisDatabase languagesLab : Querying SQ Server
2 - Data Modelling
Data modellingANSI/SPARC database modelEntity relationship modellingLab : Entity relationship modelling
3 - Normalization
Why normalize data?Normalization termsLevels of normalizationDe-normalizationLab : Normalizing raw data
4 - Relationships
Schema mappingReferential integrityLab : Designing relationships
5 - Performance
IndexingQuery performanceConcurrencyLab : Query performance
6 - Database Objects
TablesViewsStored Procedures, Triggers and FunctionsLab : Using SQL Server
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.