Foundations of Databases

collapse

Course Details

  • Location: Online
  • Duration: 10 - 11 weeks
  • Times: Flexible
  • Cost : $949

Next Start Date:

October 1, 2018

Get Details & Register

About this Course


In this course, you'll get a broad and general understanding of the technical concepts underlying databases. You'll learn about relational database management systems (RDBMS) and design and implement a basic relational database from scratch. You'll also explore the Structured Query Language (SQL) used to create, manipulate and operate a relational database.

You can take this course on its own or use it to prepare for one of these programs:

Designed For

Anyone interested in developing fundamental database and SQL skills.

See Requirements

WHAT YOU’LL LEARN

  • The database development life cycle (spec, design, build, operate)
  • The differences between transactional databases and decision support databases
  • Techniques for designing a basic database using entity relationship diagram (ERD) modeling and an introduction to normalization
  • Data integrity principles for every level of design
  • Basic database security and administration

GET HANDS-ON EXPERIENCE

  • Write increasingly complex queries to extract answers from data
  • Interview a client and create an entity relationship diagram (ERD) for a real-world business problem
  • Complete a final database project that applies all the skills of the course

Learning Format

Online, Group-Paced

Start and finish your course with the same group of students, with frequent opportunities to interact with your instructors and classmates along the way. This course is 100 percent online, with set due dates for assignments but no class meetings. Learn More »

Course Sessions

Online, Group-Paced

This course will run from October 1 to December 14, 2018. Instructors hold regular online office hours. These sessions are optional but recommended; they may be recorded for those who can’t attend.

Online

Meet your instructor

NONCREDIT COURSE

You'll earn 3 continuing education units (CEUs) for successfully completing this course. Learn more about noncredit courses.

This course will run from April 1 to June 7, 2019. Instructors hold regular online office hours. These sessions are optional but recommended; they may be recorded for those who can’t attend.

Online

NONCREDIT COURSE

You'll earn 3 continuing education units (CEUs) for successfully completing this course. Learn more about noncredit courses.

Closed Sessions

This course will run from June 21 to August 23, 2018. Instructors hold regular online office hours. These sessions are optional but recommended; they may be recorded for those who can’t attend.

Online

Meet your instructor

Randal Root

Senior Consultant and Technical Instructor

NONCREDIT COURSE

You'll earn 3 continuing education units (CEUs) for successfully completing this course. Learn more about noncredit courses.