About This Chapter
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Other chapters within the Analytics 103: Intro to Relational Databases & SQL course
- Introduction to General & Relational Databases
- Relational Database Management Systems
- Relational Database Design Fundamentals
- Database Table Design & SQL Data Types
- Using SQL to Populate & Retrieve Data
- Modifying Data in Databases With SQL
- Using SQL to Remove Data
- Joins & Subqueries Using SQL
- Using Views, Indexes & Triggers in SQL