Ch 9: Manipulating Large Data Sets in Databases

About This Chapter

Understanding how to manipulate large data sets in databases is a snap with help from this informative and engaging chapter. You can work at your own pace as you study for an exam or work to finish a tough assignment using the lessons and quizzes here as your guide.

Manipulating Large Data Sets in Databases - Chapter Summary

We've put together this handy chapter on manipulating large data sets in databases so that you'll easily understand these subjects. Work through lessons on UNION vs. JOIN and grouping data in databases using ROLLUP and CUBE. If you have a hard time understanding any of the subjects, reach out to one of our experts through the Dashboard for assistance. The lesson quizzes and comprehensive chapter test are also a helpful way to ensure your understanding and readiness to move on. You can use any smartphone, tablet or computer to access these resources any time you'd like. This chapter has been designed to assist you in reaching these goals:

  • Define SET operators in database management
  • Use subqueries to manipulate data
  • Discuss the use of multi-table inserts in databases
  • Outline PIVOT and UNPIVOT in SQL
  • Manipulate sets in database programming

6 Lessons in Chapter 9: Manipulating Large Data Sets in Databases
Test your knowledge with a 30-question chapter practice test
SET Operators in Database Management: Definition & Use

1. SET Operators in Database Management: Definition & Use

The mathematical concept of a set applies to SQL databases too. All SQL implementations are able to treat tables as sets and to apply SET operators on them. Similarities between sets and tables and how SET operators act on tables will be discussed.

SQL: UNION vs. JOIN

2. SQL: UNION vs. JOIN

When you have to compare data from different tables, you have three choices. You can make a new table, or you can use either UNION or JOIN. This lesson shows you which of those two to use.

Grouping Data in Databases: ROLLUP & CUBE

3. Grouping Data in Databases: ROLLUP & CUBE

ROLLUP, CUBE and GROUPING are the features of SQL systems used extensively for numerical computations and analysis. They often act on large amounts of data to provide summarized data which can be used for predicting hidden trends or behaviors.

Multi-Table Inserts in Databases: Example & Use

4. Multi-Table Inserts in Databases: Example & Use

The INSERT SQL command is used to insert or add new records into a database tables. In this lesson, we learn how this INSERT command is used to enter data into multiple tables.

SQL: PIVOT & UNPIVOT

5. SQL: PIVOT & UNPIVOT

SQL is an important tool for manipulating information in today's world. In this lesson, we'll take a look at SQL, and two especially useful commands from the language, PIVOT and UNPIVOT.

Practical Application for Database Programming: Manipulating Sets

6. Practical Application for Database Programming: Manipulating Sets

This is a practical lesson which will give you the opportunity to work with and manipulate sets. In most SQL implementations, database tables can be treated as sets and the set operators can then act on the tables.

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 160 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.

Support