About This Chapter
SQL Variations: Chapter Summary
This chapter explains some of the common variations of the SQL programming language. Using short and concise instruction, our expert SQL teachers outline how and why these variations differ from SQL. Included are comprehensive explanations of Transact-SQL (T-SQL), Procedural Language/Structured Query Language (PL/SQL) and Dynamic SQL.
You can study these lessons on any computer or mobile device, which makes learning on-the-go easy and convenient. You can also be sure you understand the chapter material by completing the included self-assessment quizzes.
After finishing the lessons in the chapter, you'll be able to:
- Define T-SQL
- Understand PL/SQL
- Explain uses of Dynamic SQL
1. 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.
2. 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.
3. 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.
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.