Take Introduction to Relational Databases online at your own pace

  • ACE Credit®-recommended for 3.0 semester credits

  • 2004 students successfully completed

Course description

Sophia's Introduction to Relational Databases course will build mastery of foundational commands in SQL, with a focus on Postgresql. Students will actively practice writing SQL queries in a modifiable database. Their hands-on work will build their understanding of the key aspects of operating a database. Students will also get an introduction to challenges in administering and designing databases.

Assessments and grading

This is a pass/fail course. You must complete 19 Challenges (formative assessments) and 6 Milestones (summative assessments) with an overall score of 70% or better.

Learning outcomes

<p>Upon completion of the course, the student will be able to:<br></p> <ul><li>Use Select-From-Where queries to collect information from a single table database.</li><li>Form a single table database using Create and Insert commands.</li><li>Use Group By, Order By, and aggregate functions.</li><li>Alter and update the database table by adding, deleting, or modifying columns.</li><li>Use Select-From-Where queries to combine information from multiple tables in a database using Joins.</li><li>Form a database with multiple tables using primary keys and foreign keys.</li><li>Demonstrate awareness of sub-queries, views, indices, and unions.</li><li>Summarize the importance of backing up data.</li><li>Evaluate multiple approaches to securing relational data.</li><li>Explore other methods of enhancing relational table design.</li><li>Explain the purpose and utility of a database.</li><li>Identify the most common database models used today.</li><li>Distinguish between several commercial relational DBMS.</li><li>Explain the purpose of an ERD.</li><li>Explain the purpose of normalization with respect to the relational data model.</li><li>Given an ERD depicting non-normalized data, normalize the data model.</li><li>Adapt RDMS use to business considerations.</li></ul>

Start your free trial today

  • Take the first Challenge of any course
  • Go at your own pace
  • Access anytime, anywhere
  • Confirm your completed courses will transfer

*All fields are required.


Access the course content through the first Challenge of any of Sophia’s 50+ courses.

Check Sophia’s list of partner schools to see if your school is on the list. If not, contact your registrar to learn about your school’s transfer credit policy and if Sophia coursework can be submitted for transfer.

Sophia course completions do not expire and will be available to submit for transfer when you’re ready. At that time, check with your school’s registrar for their credit transfer policies.

If you’ve completed the first Challenge during your free trial, you can pick up right where you left off after you become a Sophia member.

Don’t worry. Your completed courses won’t disappear if you cancel your membership. Those courses will be there for you when you’re ready to submit for transfer.

If you have an education benefit through your employer, it may cover your subscription to Sophia. Check with your benefits administrator to find out if you qualify.

Earn college-level credit

With Sophia, you can take up to two courses at a time – accessible anytime, anywhere – for only $99 a month.

Inside the Sophia courseroom