Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Courses Computer Programming Programming Classes Introduction to Database Development
Return to Programming Classes
database-development

Introduction to Database Development

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.

6 Weeks / 24 Course Hrs
Starting October 18, 2017

Offered in Partnership with your Preferred School

Mission College Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Database Development

Learning Method

Instructor-led Confirm your Start Date in Cart

Introduction to Database Development Reviews

Introduction to Database Development Details + Objective

Course Code: idd

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 the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
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
Introduction to Database Development Outline
Expand All
Week 1

Learn where databases came from, explore the major types, and see how the various parts fit together. Then, learn about the System Development Life Cycle, which practically guarantees the success of any database system you produce.

Week 2

Learn how to build an Entity-Relationship model that is based on a consensus of what all the stakeholders need, and understand 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 discuss the pros and cons of either upgrading an existing system or building a new one from scratch.

Week 3

Learn the relational model: how to create relational databases that have the right combination of performance and reliability to meet your needs. Then, learn how to translate the Entity-Relationship model into a relational model that you can implement directly as a database.

Week 4

Take what you have learned so far to build an actual database, using the popular Microsoft Access database management system. Then, 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

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. Then, explore 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

Learn to create sophisticated database applications by combining code written with procedural languages such as Visual Basic, or C with SQL statements. Finally, you’ll learn important communication and interpersonal skills that will help you work with clients to give them what they want in a database project even if they are not sure exactly what that is.

View All Sections
Introduction to Database Development Instructors
Allen G. Taylor

Allen G. Taylor is a 30-year veteran of the computer industry and the author of 28 computer-related books, including "Crystal Reports 2008 For Dummies," "Database Development For Dummies" and "SQL For Dummies." He has been teaching computer courses for over ten years.

Introduction to Database Development Requirements / Prerequisites

There are no prerequisites for this course.

Any type of computer, and a database management system, including Microsoft Access, Microsoft SQL Server, Oracle, PostgreSQL, or MySQL.

Introduction to Database Development Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All