About This Chapter
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
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.
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: 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.
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.
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: 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.
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.
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.