Copyright

Ch 18: Database Management & Security

About This Chapter

Let us help you boost your knowledge on the subject of database management and security in this chapter. These lessons and quizzes can be used as a convenient, mobile way to study for an upcoming exam or professional certification test.

Database Management & Security - Chapter Summary

Our instructors explain database management, its concepts and structures and how the use of databases helps organizations and businesses. You will review the different types of database management systems (DBMS), their purpose and functions, as well as specific details about the most common type of DBMS. The types of data you'd expect to find in a database, including numbers, multimedia and text, is also presented.

Your study continues with an overview of structured query language (SQL) and how it is used to modify databases. The concepts of data mining and data warehousing are discussed, along with how they help businesses make better decisions. The role of the database administrator and how a database is secured is introduced, as well as how cloud computing affects database management. After you have reviewed this chapter, you should understand how to:

  • Explain the structure and fundamental elements of a database
  • Describe the purpose, functions and types of DBMS
  • Identify the most widely used DBMS and explain how it works
  • Outline the basic data used in databases
  • Manipulate a database using SQL
  • Understand the role of a database administrator
  • Define the ways cloud computing affects database management

Use the lesson quizzes and chapter tests to gauge how well you've understood the lesson material and where you may need to focus further study. Our mobile-friendly study materials are available for you to review 24 hours a day, seven days a week. If you would like to review just one portion of a video lesson, use the video tabs in the Timeline to jump straight to that section. If you need further assistance as you work through the lessons, contact an instructor for help.

10 Lessons in Chapter 18: Database Management & Security
Test your knowledge with a 30-question chapter practice test
What is Database Management? - How Databases Help Organizations

1. What is Database Management? - How Databases Help Organizations

Organizations use large amounts of data. Database management makes it possible to organize and analyze these data. Learn why database management is important to support business operations.

Database Concepts and Structures: The Elements That Make Up a Database

2. Database Concepts and Structures: The Elements That Make Up a Database

Learn the fundamental elements of databases and how they are structured. One common data structure is a database table, which uses records and fields to organize data.

What is a Database Management System? - Purpose and Function

3. What is a Database Management System? - Purpose and Function

In this lesson, we will describe the purpose and functions of a database management system, as well as the advantages and disadvantages of using a database management system in an organization.

Models of Database Management Systems (DBMS)

4. Models of Database Management Systems (DBMS)

Get to know the different models of database management systems and learn how each one is used to systematically organize large amounts of data in a logical manner.

What is a Relational Database? - Elements, Design & Advantages

5. What is a Relational Database? - Elements, Design & Advantages

The relational database is the most widely used type of database management system. Learn how the relational database organizes data using tables, keys and associations.

Types of Data: Text, Numbers & Multimedia

6. Types of Data: Text, Numbers & Multimedia

Discuss the basic types of data found in databases. These include character strings, integers, decimals, images, audio, video and other multimedia types.

Structured Query Language: Manipulating Databases Using SQL

7. Structured Query Language: Manipulating Databases Using SQL

Describe how to manipulate a database using the logic of Structured Query Language. Learn the basic syntax to write database queries in SQL using the SELECT statement.

Data Warehousing and Data Mining: Information for Business Intelligence

8. Data Warehousing and Data Mining: Information for Business Intelligence

Collections of databases that work together are called data warehouses. This makes it possible to integrate data from multiple databases. Data mining is used to help individuals and organizations make better decisions.

Database Administration and Security: Definition and Purpose

9. Database Administration and Security: Definition and Purpose

A database administrator, or DBA, plays a critical role in managing the databases of an organization. Learn about the various roles of a DBA and the tools used to keep data safe and secure.

Cloud Computing and Databases: Technology to Improve Database Management

10. Cloud Computing and Databases: Technology to Improve Database Management

Cloud computing uses a network of computers to provide services that otherwise would be provided by a single computer or computer server. Learn how cloud computing works and how it allows you to use the same database on multiple devices in this video lesson.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

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.

Other Chapters

Other chapters within the IAAP CAP Exam Study Guide - Certified Administrative Professional course

Support