Copyright

Ch 4: Introduction to SQL Syntax & Queries

About This Chapter

We've made it easy to finish your homework or prepare for an upcoming exam by creating this engaging and professionally designed chapter on SQL queries and syntax. You can review the lessons and self-assessment quizzes provided here on any computer or mobile device 24/7.

Introduction to SQL Syntax & Queries - Chapter Summary

Our chapter on SQL syntax and queries provides you with an easy-to-use resource you can use to study at your convenience. Just a few of the subjects covered here include the history of SQL, dynamic SQL and the tools used in a database query. Take your time as you move through the chapter at your own pace, going back to review any of the topics that need more focus. Each lesson is accompanied by a self-assessment quiz you can use at any time to test your knowledge. After completing these lessons, you should be able to:

  • Outline the history of SQL
  • Detail the design used for databases and SQL
  • Define T-SQL and PL/SQL
  • Differentiate between SQL and NOSQL databases
  • Give a definition for database query
  • Explain basic and advanced SQL query syntax

10 Lessons in Chapter 4: Introduction to SQL Syntax & Queries
Test your knowledge with a 30-question chapter practice test
History of SQL

1. History of SQL

In this lesson, we'll take a look at SQL, what it is, how it's related to databases, and its history. At the end, you should have a good understanding of this common capability.

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.

What is T-SQL?

3. What is T-SQL?

The ability to organize and access information is as important as collecting it. In this lesson, we'll take a look at SQL, the variation T-SQL, what they are used for, and some examples.

What is PL/SQL?

4. What is PL/SQL?

In order to communicate with Oracle databases, we use a language known as Procedural Language/Structured Query Language or PL/SQL. In this lesson we will learn about the syntax and format of PL/SQL.

What is Dynamic SQL?

5. What is Dynamic SQL?

If only SQL statements could write themselves! Dynamic SQL lets us get close: statements are created when the query runs. This lesson will cover dynamic SQL and provide examples of this powerful concept.

NoSQL Databases: Design & Types

6. NoSQL Databases: Design & Types

There are alternatives to SQL databases and relational databases in general. This lesson covers these alternate database management systems, referred to as NoSQL databases.

SQL vs. NoSQL Databases

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

Database Query: Definition & Tools

8. Database Query: Definition & Tools

This lesson will cover the concept of a database query. Database queries will be defined, and some basic examples will be explained. An example of query design using the Microsoft Access tool is described.

Basic SQL Query Syntax

9. Basic SQL Query Syntax

In this lesson, we will describe SQL queries and how these queries are used to access data stored in a relational database. We will also discuss SQL statements and the SQL clauses used to construct these statements.

Advanced SQL Query Syntax

10. Advanced SQL Query Syntax

This lesson will explore the use of the SQL SELECT command in more complex situations where the output results need further manipulation and processing before being displayed. We will learn how to use wildcards in queries, how to sort the data using ORDER BY, how to aggregate the data using GROUP BY, and other advanced functions in SQL.

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