Introduction to Database Development

This course will guide you step-by-step through all the phases of a database system development project to guarantee that the resulting product will not only work as it is designed to work, but also that the design truly responds to user needs.
SHARE
6 Weeks / 24 Course Hrs
Starting  August 18, 2021
Offered in partnership with your preferred school

ed2go

Why this school?The school has been chosen based on your location or if you've visited this school's website.Change School
Learning method

Course code: idd

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.

What you will learn

  • Learn the major components of a database system
  • Understand how to find out what it really needed in a database development project
  • Learn the relational model of database development
  • Master how to design a database with the E-R Model
  • Learn how to build a database with Microsoft Access and SQL
  • Explore the importance of database security and integrity

How you will benefit

  • Gain hands-on experience building a database
  • Master the techniques to understand what your client organization needs and how best to provide it
  • Open the door to new opportunities as a database developer

How the course is taught

  • Instructor-led or self-paced online course
  • 6 Weeks or 3 Months access
  • 24 course hours

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.

This lesson will 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.

In this lesson, 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.

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! You'll review the pros and cons of upgrading an existing system versus building a new one from scratch

Relational databases are by far the most commonly used database type. 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.

This lesson is the pivot point of the course; you'll 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.

In this lesson, you'll 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.

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.

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. In this lesson, 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.

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. It will also cover how to protect your data if your hardware fails or if some other unexpected disaster occurs.

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. It will go on to discuss how to make databases and database applications available on an organization's network and on the web.

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 you 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.

Allen G. Taylor is a 30-year veteran of the computer industry. He has authored 28 books about computer-related subjects, including "Crystal Reports 2008 For Dummies," "Database Development For Dummies" and "SQL For Dummies." He has also taught computer courses for more than 10 years.

Requirements:

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • A database management system, such as Microsoft Access, Microsoft SQL Server, Oracle, PostgreSQL, or MySQL (not included in enrollment).
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites:

There are no prerequisites to take this course.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Instructor-Led: A new session of each course begins each month. Please refer to the session start dates for scheduling.
Self-Paced: You can start this course at any time your schedule permits.

Instructor-Led: Once a course session starts, two lessons will be released each week for the 6 week duration of your course. You will have access to all previously released lessons until the course ends.
Self-Paced: You have 3 month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.

Instructor-Led: The interactive discussion area for each lesson automatically closes two weeks after each lesson is released, so you're encouraged to complete each lesson within two weeks of its release.
Self-Paced: There is no time limit to complete each lesson, other than completing all lessons within the allotted access period.

Instructor-Led: The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks plus 10 days (24 days total) to complete the final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.
Self-Paced: Because this course is self-paced, no extensions will be granted after the start of your enrollment.