About This Chapter
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 within the IAAP CAP Exam Study Guide - Certified Administrative Professional course
- Hardware & Systems Technology Overview
- Computer & Peripheral Device Troubleshooting
- Systems Software & Management
- Using Software & Media to Communicate
- Introduction to Microsoft Word
- Microsoft Word Features
- Creating Worksheets & Workbooks in Excel
- Formatting Worksheets & Workbooks in Excel
- Format & Modify Text with Functions in Excel
- Introduction to the PowerPoint Tool Bar
- Create and Manage Presentations in PowerPoint
- PowerPoint Best Practices
- Design of Technical & Business Documents
- Working with Technical Reports
- Managing Physical Resources in Business
- Office Design & Ergonomics
- Business Records Management
- Framework for Business Communication
- Running Effective Business Meetings
- Group Communication Skills in the Workplace
- Business Messaging Fundamentals
- Communicating Electronically
- Effective Messaging for Workplace Communication
- Elements of Punctuation & Grammar
- Sentence Types & Components
- Planning & Managing Events
- Human Resource Management Basics
- HR in a Global Business Environment
- Employee Recruitment & Selection
- Compensation Methods
- Employee Training & Professional Development
- Employer Compliance & Regulations
- Accounting Basics Overview
- Financial Statements in Accounting
- Financial Statement Analysis in Accounting
- Effective Management & Leadership
- Managerial & Interpersonal Communication
- Understanding Diversity while Communicating
- Business Networking Basics
- IAAP CAP Exam Study Guide - Certified Administrative Professional Flashcards