About This Chapter
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
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.
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.
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.
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.
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.
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.
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.
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.
Other chapters within the Computer Science 204: Database Programming course
- Intro to Relational Database Management Systems
- Creating & Managing Database Tables
- Manipulating Data in Databases
- Data Queries in Multiple Tables Using Joins
- Data Queries in Multiple Tables Using Subqueries
- Views & Indexes in Databases
- Modifying Tables in Databases
- Manipulating Large Data Sets in Databases
- Database Security