Copyright

Ch 4: SQL Databases

About This Chapter

This tutorial chapter educates you on SQL databases. Study these short and engaging lessons to develop a thorough understanding of database concepts such as indexes, normalization, trigger syntax and more.

SQL databases: Chapter Summary

This collection of SQL (Structured Query Language) tutorial lessons offers a comprehensive view of SQL databases. You'll begin by becoming familiar with SQL's database terminology and then explore concepts such as SQL indexes, primary and foreign keys, index fragmentation and SQL constraint types.

Our expert SQL instructors break down database vocabulary with easy-to-follow lessons and illustrative examples that demonstrate the functions of these topics. Following each lesson is a short quiz you can take to make sure you fully understand the material. You can study these lessons at any time that fits your schedule and access them on any computer, smartphone or tablet.

The lessons in this chapter help you:

  • Understand SQL's database terminology
  • Define a SQL database and Microsoft SQL server
  • Differentiate between SQL and NOSQL databases
  • Know what indexes do in SQL
  • Explain primary and foreign keys
  • Recognize clustered and nonclustered SQL indexes
  • Describe index fragmentation
  • Comprehend the rules of SQL normalization
  • Analyze SQL collation
  • Identify schemas in SQL
  • Make sense of trigger syntax
  • Assess SQL constraint types and stored procedures

15 Lessons in Chapter 4: SQL Databases
Test your knowledge with a 30-question chapter practice test
Database Terminology

1. Database Terminology

This is a lesson that covers basic terminology needed to navigate and understand a database. From the definition of what a database itself is to the various relationships between the tables therein, this gives an overview of the language needed to get started.

Design for Databases & SQL

2. Design for Databases & SQL

An SQL database is a relational database that makes uses of the Structured Query Language (SQL) to query or communicate with the database. In this lesson, we will learn more about SQL databases.

SQL vs. NoSQL Databases

3. SQL vs. NoSQL Databases

SQL is not the only database that you can use. In this lesson, we'll compare SQL to NoSQL, a challenger format that has a number of important differences.

What is Microsoft SQL Server?

4. What is Microsoft SQL Server?

This lesson will provide an overview of Microsoft SQL Server. A brief history of the tool is provided, the different products explained, and Microsoft's own flavor of SQL (T-SQL) will be explained.

Indexes in SQL

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

What is a Primary Key in SQL?

6. What is a Primary Key in SQL?

When searching for a specific record within a database, nothing can be as useful as a primary key. Primary keys act as the identity markers within a database. In this lesson, we'll learn how to implement a primary key in SQL.

What is a Foreign Key in SQL?

7. What is a Foreign Key in SQL?

If you want to link SQL tables to individual records, making your database much more efficient and responsive, then you will need knowledge of foreign keys. We'll be comparing primary and foreign keys and looking at an example of the latter.

SQL Index Types: Clustered & Nonclustered

8. SQL Index Types: Clustered & Nonclustered

Databases are used everywhere these days, and the ability to find things quickly within them is a must. In this lesson, we'll take a look at SQL, and both clustered and non-clustered indexes.

Index Fragmentation in SQL

9. Index Fragmentation in SQL

Maintaining quick access to information is rather important these days. In this lesson, we'll take a look at SQL, indexes, and the fragmentation that can occur within indexes.

SQL Normalization: Example & Rules

10. SQL Normalization: Example & Rules

The amount of information we capture these days is staggering, so removing duplication is important. In this lesson, we'll take a look at SQL, normalization, and the rules associated with them.

SQL Collation: SQL Server & MySQL

11. SQL Collation: SQL Server & MySQL

There are rules involved when we sort information, particularly, if we want it to have some meaning. In this lesson, we'll take a look at SQL collation, what it is, and how it differs from SQL Server to MySQL.

What is a Schema in SQL? - Definition & Design

12. What is a Schema in SQL? - Definition & Design

SQL provides an organized and systematic approach to accessing information. In this lesson, we'll take a look at SQL, what a schema is in relation to SQL, and how to go about creating one.

Triggers in SQL: Example & Syntax

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

SQL: Constraints

14. SQL: Constraints

Do you want to make sure that the data entered into your SQL database meets certain criteria? This lesson on constraints will help make sure that each record has the required minimums to be recorded.

SQL: Stored Procedures

15. SQL: Stored Procedures

Who said you can't write a program in SQL? A stored procedure is a powerful tool for creating a program that carries out SQL commands. This lesson will define the concept and provide 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.

Support