Copyright

Ch 5: SQL Statements & Functions

About This Chapter

In this set of informative lessons, you can gain a deeper understanding of SQL statements and functions, including how to use SQL in database management. Use our easy-to-follow guides to become more knowledgeable about the applications of SQL.

SQL Statements & Functions: Chapter Summary

If part of your job includes pulling from a lot of pools of data to make reports, then learning about SQL could make you more efficient in the workplace. SQL statements and functions help you manipulate, organize, and control databases to produce the types of reports you want, and these lessons guide you through some of the most important statements and functions. Not only will this chapter instruct you on the purpose of these statements and functions, but the lessons also give you examples on how to incorporate SQL into your professional routine.

Our instructors break up this chapter into multiple lessons, and each lesson addresses a different aspect of SQL. As you master each type of statement and function, verify how much you've learned by taking lesson quizzes. Remember that you can always ask our experts for help if you have any questions.

SQL topics addressed in this chapter prepare you to do the following:

  • Describe the CREATE Index
  • Identify the INSERT statement
  • Analyze the UPDATE statement
  • Check out the FORMAT statement
  • Define the NVL function
  • Examine the ISNULL function
  • Explain the CASE statement

7 Lessons in Chapter 5: SQL Statements & Functions
Test your knowledge with a 30-question chapter practice test
SQL: CREATE Index

1. SQL: CREATE Index

Like an index in a reference book, the SQL Index points to a spot in the database. This lesson will cover the syntax of using CREATE INDEX to create an index, and provide examples.

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: UPDATE Statement

3. SQL: UPDATE Statement

The SQL update statement allows us to manipulate data in a relational database. It is a powerful statement that lets us make multiple changes simultaneously. In this lesson, we'll learn the syntax for this command and also look at an example of it in use.

SQL: FORMAT Statement

4. SQL: FORMAT Statement

Sometimes data in databases needs to be presented differently than how it is stored in the database. This lesson will cover the FORMAT statement, covering methods for making output more meaningful.

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: ISNULL Function

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

SQL: CASE Statement

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

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

Other chapters within the SQL Tutorial & Training course

Support