Skip to Main Content

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

Become a Member

Complete the application for Institution Membership to start using NERCOMP member benefits now!

Get Started

You are using an unsupported version of Internet Explorer. To ensure security, performance, and full functionality, please upgrade to an up-to-date browser.