This online course is 6 weeks long, followed by a 2-week period to complete the final exam (online, open book). Lessons are released on Wednesdays and Fridays of each week. You are not required to be online at any specific time. You register and pay on our website and instructions on how to access your course will be emailed to you immediately after registration.

The actual time commitment involved in completing any given lesson can vary significantly based on a number of factors including reading speed, familiarity with the topic, related experience, the amount of time spent completing optional assignments, and involvement with discussion board. For planning purposes we suggest setting aside 1 hour per lesson as a starting point.


Introduction to Database Development

Introduction to Database Development

$190 + applicable tax

A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.

Week 1 Wednesday - Lesson 1

Databases and Why We Need Them
Who can benefit from a database? Anyone who needs to store data and later retrieve meaning from that data. In this lesson, you'll see where databases came from, explore the major types, and see how the various parts fit together.

Week 1 Friday - Lesson 2

Developing a Database System
In this lesson, we'll define and describe the major components of a database system. You'll learn about the System Development Life Cycle, which practically guarantees the success of any database system you produce.

Week 2 Wednesday - Lesson 3

Building a Database Model
Today, you will learn how important the non-technical portions of a development project are. You'll see why it's not enough to build a system that meets design goals--it also needs to satisfy the people who will use it. You'll learn how to build an Entity-Relationship model that is based on a consensus of what all the stakeholders need.

Week 2 Friday - Lesson 4

Practical Considerations
This lesson will teach you how to find out what the client organization really needs from the development project--it may be very different from what they originally asked for! We'll discuss the pros and cons of either upgrading an existing system or building a new one from scratch

Week 3 Wednesday - Lesson 5

The Relational Model
Relational databases are by far the most commonly used database type today. They're the most likely type of database that you will find yourself designing and using. In this lesson, you'll learn the relational model: how to create relational databases that have the right combination of performance and reliability to meet your needs.

Week 3 Friday - Lesson 6

Using the E-R Model to Design a Database
This lesson is the pivot point of our course: Today, you will learn how to translate the Entity-Relationship model into a relational model that you can implement directly as a database. A model that accurately describes the system you are modeling is your best guarantee that the system you deliver will perform as you need it to.

Week 4 Wednesday - Lesson 7

Implementing a Database Design with Access
Today, we move to the hands-on portion of the course. You will take what you have learned so far to build an actual database, using the popular Microsoft Access database management system. The database will track important information for a fictitious nonprofit organization.

Week 4 Friday - Lesson 8

Implementing a Database Design with SQL
In this lesson, you will learn how to build a database with the SQL language--a language that is supported by all relational database management systems. You'll also learn how to protect it from accidental or intentional harm.

Week 5 Wednesday - Lesson 9

Building a Database Application Using Access
Databases store data. That's important, but it's not worth much if you can't pick and choose the information you want to retrieve from the database. Today you will learn how to create a database application that will give users a turnkey tool for retrieving exactly the information they want with a minimum of hassle.

Week 5 Friday - Lesson 10

Database Security and Integrity
It's more important than ever to ensure that your company's organizational data does not fall into the wrong hands. This lesson teaches you how to control who accesses your data. We'll also cover how to protect your data if your hardware fails or if some other unexpected disaster occurs.

Week 6 Wednesday - Lesson 11

Building a More Sophisticated Database Application
This lesson takes you to the next level--creating sophisticated database applications by combining code written with procedural languages such as Visual Basic, or C with SQL statements. We'll go on to discuss how to make databases and database applications available on an organization's network and on the World Wide Web.

Week 6 Friday - Lesson 12

Database Development Essentials
This lesson emphasizes the critically important (but often overlooked) human aspect of a database development project. Your client may not have a clear idea of what they want at the outset of your database project. That means your communication and interpersonal skills are going to be just as important as your technical expertise. After we complete this final piece of the database puzzle, you'll be ready to create database systems that truly meet the needs of your client organization.
Any type of computer, and a database management system, including Microsoft Access, Microsoft SQL Server, Oracle, PostgreSQL, or MySQL.
Course Details
This course is fully online, you require internet access and an email account. The course duration is 6 weeks, followed by a 2-week period to complete the final exam (online, open book). Lessons are released on Wednesdays and Fridays of each week, for a total of 12. You are not required to be online at any specific time.

In addition to the specific lesson content, there is a discussion board with each lesson and often there is an optional assignment to apply the learning.

Following each lesson, there is a short multiple choice quiz. Your score on these quizzes does not count towards the final mark but completing these helps solidify your learning as well as prepare you for the final exam.

The final exam is an open-book, multiple choice exam and you need to achieve a minimum of 65% on the final exam to pass the course. There is only one opportunity to pass the exam. A certificate of completion from Ed2Go is available for printing immediately upon successful completion of the course and a certificate from the University of Waterloo will be emailed typically 1-2 weeks later.

Certificates
Many of the Ed2Go courses are eligible towards the various online certificates offered by Professional Development.

Choose your course start date:

Aug 12, 2020Sep 16, 2020Oct 14, 2020Nov 11, 2020Dec 09, 2020