Ch 10: Using Views, Indexes & Triggers in SQL

About This Chapter

Our chapter on using triggers, views, and indexes in SQL acts as a handy guide whether you're working to catch up in class or need help finishing your homework. Each professionally written lesson provided here covers these topics in an easy-to-understand way.

Using Views, Indexes & Triggers in SQL - Chapter Summary

In this chapter on SQL indexes, triggers, and views, we've included a series of lessons on topics including the CREATE index and the syntax used for triggers. Because this chapter is self paced, you can go back as many times as needed to review subjects that are proving to be more challenging. The lesson quizzes and comprehensive chapter test provide you with a helpful way to test your knowledge before moving on. If you need any help as you complete the lessons, feel free to reach out to one of our experts in the Dashboard. When this chapter has been completed, you should be able to:

  • Define SQL views with examples
  • Outline the purpose of a database index
  • Explain indexes in SQL
  • Discuss the SQL: CREATE index
  • Provide the syntax used for triggers in SQL
  • Give an example of referential integrity and constraints in databases
  • Use views in a practical way

7 Lessons in Chapter 10: Using Views, Indexes & Triggers in SQL
Test your knowledge with a 30-question chapter practice test
SQL Views: Definition & Example

1. SQL Views: Definition & Example

Overwhelmed by data? Find out how to see only what you want to see using SQL views! This lesson discusses the benefits of SQL views, how to create a view, and different commands you can use in a view followed by an example.

What is a Database Index? - Definition & Tutorial

2. What is a Database Index? - Definition & Tutorial

Have you ever wondered if there was tool to help you with finding information more quickly? We will explore the different types of database indexes and how they can help you save time in this lesson.

Indexes in SQL

3. Indexes in SQL

Storing information in a database is a common practice these days. In this lesson, we'll take a look at a database technology, SQL, and an organizational technology that goes along with it, indexes.

SQL: CREATE Index

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

Triggers in SQL: Example & Syntax

5. Triggers in SQL: Example & Syntax

When certain information is important, it is often useful to know when something happens that might affect that information. In this lesson, we'll take a look at SQL, what triggers are, where triggers are used, and their syntax.

Referential Integrity & Constraints in Databases: Definition & Example

6. Referential Integrity & Constraints in Databases: Definition & Example

Data and table relationships can be abruptly broken or introduction of ''dirty'' and unreliable data can occur if appropriate referential integrity and constraints are not implemented. Occurrences like having records of people who have negative weights or are alive and more than 1,000 years old can occur -these are issues related to referential integrity and constraints.

Practical Application for Introduction to SQL: Views

7. Practical Application for Introduction to SQL: Views

In this practical lesson, you will write SQL queries to create views in a MySQL database. You will be able to create, run and test your queries against a sample database.

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.

Support