O'Reilly logo
live online training icon Live Online training

Database Design for Any IT Professional

Learn the fundamentals of relational database design

Topic: Data
Ryan Stephens

The Relational Database is one of the most widely used database models today and has dominated the market for several decades with no end in sight. Every organization, and individual, rely on data, and learning and perfecting the skills to effectively design a database will take you and your organization to the next level. Whether new to the IT field, a seasoned professional, or any stakeholder in an organization who works with data, this course is for you.

You will learn the basic fundamentals of the Relational Database, and how to effectively design a database to effectively store data, protect the integrity of data, increase functionality and relevancy of data for all users, and improve overall performance. The concepts learned and practiced in this class coincide with the SQL for Any IT professional class, although neither is a prerequisite to the other. After this interactive class, you will be able to begin applying skills learned immediately to work more effectively with databases and SQL, become more well-rounded as an IT professional, and ultimately contribute to your organization’s overall success.

What you'll learn-and how you can apply it

  • Understand the basic fundamentals of the relational database and its role in today’s organization
  • Understand how the database, applications, and key languages such as SQL work together to make you and your organization more competitive
  • Learn successful and proven processes for gathering requirements, then effectively designing a database through a combination of examples and interactive exercises
  • Understand the database life cycle and how to play your role in its management
  • Explore how to effectively store data
  • Learn the basic principles of normalization
  • Take advantage of built-in database features to manage the integrity of your data
  • Through detailed examples and interactive exercise, you will design and create your own relational database in this class, and should have confidence to immediately begin applying best practices

This training course is for you because...

Anyone early in their career or role in working with databases will benefit from taking this course. This course will be beneficial for an IT professional, functional user, manager, or any user or stakeholder in the business that works with data. Although this course focuses on many technical aspects of database design, it begins with the basic fundamentals and provides valuable knowledge and experience for professionals who may not be technical, but seek a better understanding of databases so they can provide maximum value within their organization. This course includes information from the following books the instructor has authored, including “Teach Yourself SQL in 24 Hours, 6th Edition,” and “Database Design.”

Prerequisites

  • No specific prerequisites are required.
  • An understanding of how the student will be using SQL will enable maximum interaction to address their specific needs, although not required. This course is adaptable to individuals with minimal IT knowledge, as well as more experienced IT professionals that are seeking a better understanding of Relational Database Design.

Resources

  • Book: SQL in 24 Hours, Sams Teach Yourself, 6th Ed by Ryan Stephens, Arie Jones, Ron Plew

About your instructor

  • Ryan Stephens is the President/CEO of Perpetual Technologies, Inc. (PTI) and Indy Data Partners, Inc. (IDP). PTI provides database and IT services to defense and federal government clients, and IDP specializes in database administration and development using mainly Oracle and SQL Server in the private sector. Ryan has been an entrepreneur for more than 21 years, and built his career around the SQL standard language and data management. Ryan has previously authored and taught 20 database-related classes for Indiana University-Purdue University in Indianapolis, and has authored several SQL, database, and Oracle-related books for Pearson Education, some of which are internationally published. The most current book, Teach Yourself SQL in 24 Hours, 6th Edition, was first published in 1998 and has been kept up to date with the evolving standard of SQL. Ryan has been nominated for the Ernst and Young Entrepreneur of the Year twice, and PTI was the first veteran-owned company to receive the Secretary of Defense Freedom Award in 2011. Ryan continues to strive to contribute his expertise to organizations seeking to improve competitive advantage by designing and using data more effectively.

Schedule

The timeframes are only estimates and may vary according to how the class is progressing

Building the Foundation (60 mins)

  • Understanding Relational Database Fundamentals
  • Databases, SQL, and Today’s Organization
  • Relational Database Key Elements
  • Database Users and Schemas
  • Database Design Process and Life Cycle
  • Designing a Database Very Well
  • Asking the Right Questions
  • Introducing the Test Organization and Data
  • Exercise
  • Exercise Review

Break (5 minutes)

Understanding Referential Integrity (60 mins)

  • Database Entities
  • Entity Relationships
  • Eliminating Redundant Data
  • Exercise
  • Exercise Review
  • Creating an Entity Relationship Diagram
  • Exercise
  • Exercise Review

Break (5 minutes)

Finalizing Your Database Design (60 mins)

  • Designing the Physical Database
  • Adapting Your Design for Improved Performance
  • Preparing for Implementation
  • Using the Design to Create the Physical Database
  • Exercise
  • Exercise Review
  • Populating Your Tables with Data
  • Exercise
  • Exercise Review
  • Stakeholder Roles in Implementation and Beyond
  • Managing Change Management
  • Final Q&A
  • Course wrap-up and next steps