About This Chapter
Views, Indexes & Triggers in SQL - Chapter Summary
Get a quality understanding of views, indexes and triggers in SQL by studying the entertaining lessons in this self-paced chapter. We can help you get up to speed with SQL views, the CREATE index and much more! Explore the lessons during the timeframes that suit your schedule, and check your comprehension using our multiple-choice quizzes and chapter exam. If you need to clarify concepts presented in this chapter, be sure to submit questions to our subject-matter experts via the Dashboard. In no time, you will be ready and able to do the following:
- Define and provide an example of SQL views
- Share the meaning of a database index
- Describe the CREATE index
- Provide an explanation of indexes and triggers in SQL
- Exhibit your practical knowledge of views in SQL
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.
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.
3. 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.
4. 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.
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.
6. 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.
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.