Learn & Network
- Events Calendar
  Check out upcoming NERCOMP events & workshops.
- Annual Conference
  Our community of faculty, researchers, learners, and institutions come together to advance innovation and leadership in higher education.
- Submit A Session Idea
  Do you have an interesting idea or hot topic in the academic information technology field you can share with the NERCOMP community?
- On-Demand Content
  View a large library of previously recorded webinars and access presentations & handouts from past in-person workshops.
- New Horizons
  NERCOMP members save 30% off the list price for all New Horizons classes. This is a great opportunity to take advantage of numerous training and certifications at deeply discounted prices.
- Moodle
  NERCOMP members save 15% on the Moodle Educator Certification (MEC) program. It is a comprehensive teaching and learning curriculum designed to help you develop transferable knowledge and skills to be effective educators in today’s growing digital workplace.
- Canvas
  NERCOMP members save hundreds of dollars on the Canvas Certified Educator (CCE) program. Learn about best practices through this flexible, asynchronous facilitated 36-week program geared toward individuals in teaching roles, instructional design, and professional development/training positions at their institutions with basic familiarity with Canvas.
Membership
- Join Now
  Complete the application for Institutional Membership to start using NERCOMP member benefits now!
- Member Benefits
  Learn why so many institutions have taken advantage of NERCOMP membership for over 60 years.
- Fees & Information
  Discover more about membership requirements and fees.
- Member List
  See all the current participating member schools.
- IR Resources
  Use this Resource page to access information about your important role as an Institutional Representative.
Community
- Job Board
  Find new higher education positions and post jobs for free as a benefit of your NERCOMP membership!
- Leadership Ecosystem
  Learn more about what is happening with NERCOMP's Leadership community including past and upcoming webinars
- Mentorship Program
  The Mentorship Program offers members a platform to engage in ongoing learning and professional growth and highlighting our commitment to providing quality professional development opportunities and fostering a vibrant community of IT professionals.
- NERCOMP Awards
  The NERCOMP Awards Program recognizes the professional accomplishments of individual NERCOMP members.
Partners
- Solutions Partner Agreements
  NERCOMP schools leverage their buying power for deep discounts and valuable warranties and protections.
- Become a Solutions Partner
  Interested in being considered for a three-year partnership agreement with NERCOMP?
- Corporate Associates
  Learn more about NERCOMP partnerships that bring professional development and other valuable expertise to our organization.
About Us
- Who We Are
  We are a professional society for University and Collegiate Information Technology professionals.
- Our Mission
  NERCOMP advances innovation and leadership in educational institutions across the Northeastern United States.
- Strategic Plan
  NERCOMP continually refines its strategic goals to remain relevant to higher education.
- News & Blog
  Featuring information and technology, strategic partnerships, innovation advances and leadership in educational institutions across the Northeast.
- Our History
  NERCOMP has been a pioneer in information technology and professional development for colleges and universities since the 1950’s.
- Our Board & Staff
  NERCOMP is governed by a Board of Trustees elected from NERCOMP member institutions.
- Bylaws
  NERCOMP’s bylaws outline the terms and conditions that govern the NERCOMP Inc. Corporation and its Board of Trustees.
- Committees
  Interested in volunteering your time and energy to help cultivate communities of practice?

Meetings Stub Page [mx-stub]

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

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