Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Learning Relational Databases

via LinkedIn Learning

Overview

Learn how databases work and how you can start designing one of your own.

Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles.
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.

Syllabus

Introduction
  • Welcome
  • What you should know
  • Exercise files
1. Relational Database Basics
  • Database management systems (DBMS)
  • Relational structures
  • Get to know your RDBMS options
  • The database development lifecycle
2. Preventing Data Anomalies
  • Relational database advantages
  • Remove duplicate information
  • Eliminate inconsistent data
  • Break data down into its components
  • Prevent data conflicts
  • Require complete information
  • Maintain a consistent structure
3. Gathering Requirements
  • Understand the goal
  • Review the current system
  • Discover actors and tasks
  • Interview the client
  • Work with historical values
  • Identify exceptions and irregularities
4. Developing the Conceptual Data Model
  • Understand entities and tables
  • Develop relationships
  • Develop subtypes and supertypes
  • Utilize lookup tables
  • Draft the initial data model
5. Normalizing Your Data
  • Identify key fields
  • First normal form
  • Second normal form
  • Third normal form
  • Denormalization
6. Logical Design Considerations
  • Follow a naming convention
  • Data types and precision
  • Create junction tables
  • Apply integrity constraints
  • Enforce referential integrity
  • Build indexes
7. Developing the Physical Database
  • Move from planning to construction
  • Create the tables in Access
  • Establish relationships in Access
  • Write queries in Access
  • Create the tables in SQL Server
  • Establish relationships in SQL Server
  • Create views in SQL Server
Conclusion
  • Implement the plan
  • Next steps

Taught by

Adam Wilbert

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Learning Relational Databases

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free