About This Chapter
Database Management & Data Analytics - Chapter Summary
Whether you want to refresh your understanding of data management and data analytics or hope to fill in some gaps in your knowledge of this subject, this chapter can help. Our instructors have developed engaging lessons that can help you grasp topics like data mining, cloud computing and database administration. After completing these lessons, you will be able to:
- List and describe different types of data
- Identify and discuss the elements that make up a database
- Define database management and explain how databases help organizations
- Explain the purpose, function and models of database management systems
- Describe the elements, design and advantages of relational databases
- Point out tools used in data analytics
- Provide details about intrusion detection systems (IDS) in data security
Feel free to review as many or as few lessons as you need to gain full comprehension of database management and data analytics. Check your understanding of those lessons by taking multiple-choice quizzes. If you develop questions about specific topics while studying this chapter, feel free to submit them to our experts. To get a comprehensive review of this chapter before the day of your test, be sure to take our practice exam.
1. 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.
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 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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.
9. Data Mining: Applications & Examples
Data mining has a number of applications that can help companies make the most out of the information that they already have. This lesson demonstrates that as well as provides examples.
10. What is Data Analytics? - Definition & Tools
In this lesson, we'll learn about data analytics. We'll define it and learn about some of the many tools used for data analytics. The lesson is followed by a quiz.
11. Intrusion Detection Systems (IDS) in Data Security
In this lesson, we'll take a look at data security, what it is, what intrusion detection systems are, some types of intrusion detection systems, and some methods used for intrusion detection.
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 DSST Computing and Information Technology: Study Guide & Test Prep course
- Introduction to Computer Hardware
- Overview of Operating Systems
- Basics of Systems Software
- Application Software Overview
- Internet Infrastructure & Communication
- Telecommunications & Network Architecture
- Programming & Software Methodology
- History of Computing & Societal Impacts
- DSST Informational Resources
- DSST Computing and Information Technology Flashcards