Great course! This week I was able to contribute in a conversation about ODBC and API in a 3-tier environment. I couldn't do that before taking this course. Thanks!"
Great illustrations of user data model, E-R model, MS Access, SQL, and Database Application using Access."
I am a very busy professional and I found this course to be EXACTLY what I needed to expand my knowledge areas. The instructor is very knowledgeable and was in-step 100% with the current industry leaders opinions and best practice recommendations."
I liked the course very much and it has changed my view (in a positive and constructive manner), on how to approach building a database. I especially liked the introduction to the course as it gave me an insight as to the background of students undertaking this course. This is especially interesting as students are from different parts of the world."
I thought the course was very interesting, and the way the course was formatted really got your attention. It shows that the instructor was very knowledgeable about the course. I would recommend it to anyone who is just learning Database Development, and even if you are familiar with the Developmental areas it can help you look at the process differently."
The course was very useful. I was designing a database when I took the course. With this information, I went back through the porcess and re-designed the database. It was greatly improved."
This course helped me to better understand the database software and how the components relate. The additional reading was very helpful."
This course was very beneficial to me in developing my professional skills."
This course was very helpful to me. It gave me a good start in developing a database of orders/parts/inventories. The lessons were well-written and easy to follow, but were also challenging."
Course Code: idd
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.
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.
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.
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.
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.
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.
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.
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.
A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!
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.
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.
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.