Meetings Stub Page [mx-stub]
10985 Introduction to SQL Databases - Bloomfield, CT
Course Outline
1 - Introduction to databases
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages
2 - Data Modelling
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
3 - Normalization
- Why normalize data?
- Normalization terms
- Levels of normalization
- Denormalization
4 - Relationships
- Schema mapping
- Referential integrity
5 - Performance
- Indexing
- Query performance
- Concurrency
6 - Database Objects
- Tables
- Views
- Stored procedures
- Other database objects