Database Education

All managed information is stored into something called a database. Managed information is everywhere so - basically, data is everywhere and databases are everywhere.


Your bank information - a database. Your medical information - a database. Your educational records - a database. Your tweets, your Facebook posts, your Instagrams, your videos... you guessed it, stored in a database.

Our educational plan for this year's database lessons will go hand-in-hand with our ColdFusion lessons. We will be analyzing a social website and recreate our own database to hold all of the information. Our lessons will not only teach you how to analyze and select data types, it will show you details on how to create tables and queries or views.

We will also teach you a little about defaults, database functions and some stored procedures. We will also discuss users and roles as related to databases even though they will not be a big part of our project. Finally, we will discuss data schemas and relationships as they related to most database projects.

During our search to bring this all to you for free, we discovered the amazing site of GCF LearnFree.org. Our organization truly believes that Knowledge is Power. We encourage you to visit their site. They have a plethora of learning material and provide it all for free. Please visit their site at http://www.gcflearnfree.org.

Video Comments & Author Notes

This video is produced by http://www.gcflearnfree.org/access2010. We are not affiliated with this organization but highly recommend their use. Please take a look at their amazing collection of videos!!

Author Notes:

Access 2010 is a database creation and management program in the Microsoft Office suite. In order to understand Access, you must first understand databases. Essentially a database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easy.

This video introduces you to the concepts of an Access database. It also distinguishes between an Access database and Excel's spreadsheets which are also useful for data.

If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/access2010 to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

We also have instructor supported online classes that are completely free and will earn you accredited Continuing Education Units and a Certificate of Completion. Register today! http://www.gcflearnfree.org/classes/access2010

Goliath Development is a for-profit organization. We do believe that our videos and information have great value. If you feel the same... if one of our videos have changed your lifestyle or if one of our solutions has saved you hours of development, feel free to let us know how much you appreciate us.


 

You can also fill out our contact form from the contact us page or drop us a testimonial via email to admin@goliathdevelopment.com


 

Upcoming Video Release Schedule

It will be an amazing future for Goliath Development and for you. This is the first time we will be providing educational videos.

As a first and amazing task, we are going to be breaking down a social website like Facebook® and we will be going through the processes of creating a similar site.

1

Analyzing Application Data

In this lesson, we will be going over the details of how to examine an application. In this educational project, we will be dissecting Facebook and re-creating a similar data structure. Our disclaimer should go here... we do not, nor have we ever worked or consulted with Facebook or its developers. Our application will not be intended to be the same or live nor have all of the elaborate details of an application that has been developed over several years. Our objective here is to look at all the intricacies an application has and how to better understand its elements.
2

Choosing a database program

In this lesson, we will be dicussing the different database engines available. We will discuss the reasons to choose one over another (or the preferences to choose one over another). We will also discuss the available options available to you (or those that matter) when you are programming a desktop application versus a web application.
3

Creating your database elements

This lesson will take you through creating and saving your tables. It will discuss backing up your data and creating scripts once you have finalized your structure.

You will also learn what indexes are and we will also be going through all the processes of data which include adding, deleting and updating information.