About This Chapter
Database Basics - Chapter Summary
Using this chapter provides you with the opportunity to ensure your knowledge of data storage and structures and learn what material you might need to review. The chapter covers basic database terminology, query methods and languages, and hierarchical data storage. Lessons cover relevant term definitions and provide examples.
Experienced instructors guide you through easy-to-follow text lessons. Text lesson transcripts are printable so you can have them handy for quick reference. You can also use self-assessment quizzes found in each lesson to gauge how much you know or have learned before moving on to the next topic.
How It Helps
You cannot begin a career in IT without knowing basic database querying tools and data storage methods. After ensuring that you have a working knowledge of this material, you can show potential employers that you possess the skills needed to manage company data.
By the end of this chapter, you'll be able to:
- Understand basic database terminology
- Use database querying tools
- Apply programs for storing data
- Enter database records
1. Database Terminology
This is a lesson that covers basic terminology needed to navigate and understand a database. From the definition of what a database itself is to the various relationships between the tables therein, this gives an overview of the language needed to get started.
2. Database Query: Definition & Tools
This lesson will cover the concept of a database query. Database queries will be defined, and some basic examples will be explained. An example of query design using the Microsoft Access tool is described.
3. Database Record: Definition & Explanation
This lesson will cover the concept of a database record in a database application. In this lesson, the concept of a record will be defined, and an example will be provided for a database record.
4. Storing Hierarchical Data in a Database
Hierarchical databases are some of the most intuitive for us to understand. In this lesson, we see how data fits into a hierarchical database typical to many organizations.
Earning College Credit
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.