Ch 3: Populating & Retrieving Data in Databases

About This Chapter

Take a look at this chapter on populating and retrieving data in databases to help you catch up after missing class or to refresh and build your professional knowledge. The short lessons and self-assessment quizzes you'll find here have been created by professional instructors.

Populating & Retrieving Data in Databases - Chapter Summary

It's easy to review information about populating and retrieving data in databases using this helpful chapter. Here you'll study basic SQL query syntax, advanced SQL query syntax, INSERT statements and limiting the results of a SELECT SQL query. We've made these subjects easy to understand so your study experience is sure to be enjoyable and fruitful. If you're getting ready for an exam, the lesson quizzes and chapter test will be especially helpful in your preparations. We've made these resources accessible to you on any smartphone, tablet or computer so you can study at your convenience any time of day. After working through this chapter, you should be ready to:

  • Detail the ISNULL function of SQL
  • Manipulate databases using SQL
  • Sort the results of an SQL query
  • Discuss the use for SQL functions
  • Outline the NVL function and CASE statement in SQL
  • Define GROUP BY clause
  • Identify the advanced use of the GROUP BY clause in SQL
  • Retrieve data in databases

7 Lessons in Chapter 3: Populating & Retrieving Data in Databases
Test your knowledge with a 30-question chapter practice test
Basic SQL Query Syntax

1. Basic SQL Query Syntax

In this lesson, we will describe SQL queries and how these queries are used to access data stored in a relational database. We will also discuss SQL statements and the SQL clauses used to construct these statements.

SQL: INSERT Statement

2. SQL: INSERT Statement

The SQL INSERT statement, which is used to add new records in a database table, is one of the most basic commands in the language. In this lesson, we'll learn the syntax of this command and examine examples of the statement.

SQL: ISNULL Function

3. SQL: ISNULL Function

Not every field in a database has a value: Sometimes we want to show something other than NULL or empty. The ISNULL function in SQL is perfect for these situations. This lesson will cover the syntax and provide examples of the function.

Structured Query Language: Manipulating Databases Using SQL

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

SQL: NVL Function

5. SQL: NVL Function

We're off to NVL-land: an option available only in Oracle databases, it is a useful function that can replace a blank value with some other value. This lesson will cover the syntax of the function and provide examples.

SQL: CASE Statement

6. SQL: CASE Statement

The SQL CASE statement acts like a switchboard: based on a value, a specific line of processing will be followed. This lesson covers the syntax of the statement as well as some examples.

SQL: GROUP BY Clause

7. SQL: GROUP BY Clause

When we go online shopping, we might have a favorite color for clothing, and perhaps we'd like to arrange them by color. The group by statement performs this function in SQL. In this lesson, we'll learn what the statement is and how it is used.

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