About This Chapter
Data Management & Database Management Systems - Chapter Summary
Database management systems and data management are covered thoroughly by our expert instructors in the lessons you'll find here. Review topic like data management tools, types of data and different types of databases as well as explore concepts in data mining and data warehousing. Help is available if you need assistance. Simply submit your questions through the Dashboard as you track your progress there as well. Each video lesson features video tabs you can use to quickly and easily navigate to a specific topic or section. Once you are finished with this chapter, you should be able to meet these objectives:
- Define data management and list common tools
- Outline the advantages and design of a relational database
- Explain how organizations are helped by databases
- Discuss database management system (DBMS) models
- Detail the purpose of database administration and security
- Identify commonly used database and spreadsheet software
- Describe how structured query language (SQL) can be used to manipulate databases
- Give examples of data mining
1. What is Data Management? - Definition & Tools
Data management encompasses the ways in which data is stored and shared by an organization. The tools used to carry out data management are defined in this lesson.
2. 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.
3. What are Databases? - Examples & Types
In this lesson, we'll be looking at databases, which are computer mechanisms for storing and retrieving data. Test your knowledge following the lesson with a quiz.
4. 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.
5. 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.
6. 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.
7. 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.
8. Database and Spreadsheet Software: Excel, Access, dBase & Lotus 1-2-3
Spreadsheet software and database software are both used to organize and manipulate data. Each application has its own unique strengths. Learn about the functionality of both types of software.
9. 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.
10. 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.
11. 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.
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 Business 303: Management Information Systems course
- Management Information Systems Concepts
- Business Analysis & Process Models
- Knowledge Management in MIS
- Ethical Issues in MIS
- Computer Hardware in MIS
- Computer Software in MIS
- Networks & Telecommunications
- Developing Business Information Systems Processes
- Electronic Commerce Information Systems
- Global Business & Marketing Information Systems
- Required Assignments for Business 303
- Studying for Business 303