Database Development Fundamentals

Picture of Database Development Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 7136 Students

An experienced professional guides you through a structured approach to database design and 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.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

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.

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.

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.

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

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.

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.

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.

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

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.

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.

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.

Allen Taylor

Allen 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 course... Read more

Read Allen Taylor's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the Database Development Fundamentals you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to Database Development Fundamentals:

C# Programming Fundamentals Online Course | Vibe Learning
 

C# Programming Fundamentals

Picture of C# Programming Fundamentals
Now Only
$389
AUD
35% off
$599 AUD
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 10503 Students

Learn the fundamentals of computer programming with the new C# programming language.

Learn the fundamentals of computer programming with C#, the in-demand and incredibly useful programming language that incorporates the best features of Visual Basic, C++, and Java.

You'll first develop your understanding of programming fundamentals: input/output operations, decision making, and looping. Then, we'll explore the many benefits of object oriented programming, with plenty of vivid, real-life examples.

Then, you'll gain hands-on experience with sequential data files, and you'll be able to build a professional-looking and intuitive Graphical User Interface (GUI) application on your very own computer.

Because there is no better way to learn programming than hands-on practice, almost every lesson includes practical examples and assignments you can use to develop your knowledge of programming.

Learn to program the right way: by using a state-of-the-art language to build impressive applications on your schedule and on your very own computer.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

C# is a fantastic programming language that combines the best parts of C++, Java, and Visual Basic all into one language. In our first lesson, you'll get an idea of where we've come from by taking a look at a brief history of programming languages. We'll then explore the .NET framework and get a better feeling for what makes C# so special.

Armed with some background, you'll now proceed to installing the C# compiler, and then we'll write, compile, and run our first C# program. Although we'll start with a small program, you'll see that even small C# programs can be a bit tricky. Today's lesson gives you a great opportunity to practice working with the compiler, something that you'll be using for the remainder of the course.

Now that you're comfortable with compiling and running simple programs, we can take a look at math. Don't worry, we won't be running calculations for launching the Space Shuttle. But you will be learning about the basic math operators that C# provides. And because we'll need some place to save the results of our calculations, we'll also talk about variables and their data types.

Today's lesson is our first step into modular programming with methods. Methods are a helpful tool because they allow us to break up big programs into smaller, more manageable parts. We'll start by looking at a few built-in methods that are available to us to use in our programs. But then you'll learn how to write your own methods and call them in your program. Hopefully you'll agree that this way of programming makes it easier to tackle large problems.

In today's lesson, we'll continue building on the concept of methods by discussing methods that don't return any value. While these methods may not seem as important, they still help in making your program more modular. We'll also talk about method overloading, which can help improve the readability of your programs by reusing method names within the same code file.

By this point in the course, you'll be comfortable doing the basics of C#: working with variables, math, and methods. So now we'll turn our attention to the first programming structure: decisions. In this lesson, you'll learn about the if statement and how you can use it to let the computer choose which set of statements to execute based on some condition.

We'll continue our investigation of the decision structure in today's lesson by taking a look at more complex if statements. You'll also learn how to use the switch statement to make decisions in your programs as well. This ability to have multiple programming structures is sort of like having another tool in your tool belt. Sometimes a job is far easier to do if you just use the right tool. You may not always need to use every tool, but it's good to know what tools are there and how to use them. You'll find the same is true in programming.

Keeping with the theme of programming structures, we'll now take a look at the repetition structure. Just as there were different ways to implement the decision structure, there are a couple of ways to work with loops. Specifically in this lesson, we'll talk about the while loop, the for loop, and the do loop. Each structure works the same in that they allow you to repeat statements, but each one is a little different. Here you'll learn their differences and add to the tools in your tool belt.

One of the most useful applications of loops is arrays, so it makes sense for us to build on your knowledge of loops and explore array variables in this lesson. You'll learn how to create and access array variables. We'll also see how to work with arrays and methods.

Object-oriented programming is a big topic, and C# is an object-oriented language. We'll spend some time in this lesson going over exactly what an object is and how it relates to a class. Then you'll write a class that will store the data necessary to keep track of the time. Since you're writing this class, you'll have the ability to take this code and add it to any program that needs to store information about the time, such as appointment books and scheduling programs.

Obviously, computer programs are big time savers and really help us to automate things. But in order for a program to be really useful, it needs to be able to save data for use later. That's why we'll go over data files in this lesson. Today, you'll learn how to read from and write to external data files so you can store your user data forever.

For our final lesson, we'll look at programs with a Graphical User Interface (GUI). While C# has an Integrated Development Environment (IDE) that gives you the ability to easily create GUI applications, the code that's generated is buried deep in the file structure. So to show you that there's no magic going on, today I'll show you how to build your own GUI without an IDE. By doing this, you'll be far better prepared for working with IDEs in the future because you'll know exactly what's going on behind the scenes.

Mike Orsega

Mike Orsega

Mike Orsega has a Bachelor's Degree in Physics from Pennsylvania State University and a Master's Degree in Applied Math from the University of Georgia. He is currently working on a Ph.D. in Computer Science at the University of Tennessee. Mike tea... Read more

Read Mike Orsega's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

The Learning Environment

From the moment that you enrol in the C# Programming Fundamentals you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to C# Programming Fundamentals: