Название: Oracle 19c SQL For Developers, Testers & Analyst
Автор: Tanveer A.
Издательство: Amazon.com Services LLC
Серия: Oracle simplified
Год: 2021
Страниц: 600
Язык: английский
Формат: pdf, azw3, mobi, epub
Размер: 10.1 MB

Oracle SQL is one of the most widely used database management system around the world. It's well suited to power primarily commercial and enterprise applications, and is particularly popular at large companies with mission-critical databases. Mastering Oracle SQL is therefore guaranteed to open exciting opportunities. In this book, you will get a complete introduction to Oracle SQL solving business problems. By the end of this course, you will understand how Oracle processes SQL queries and will have a solid foundation in Oracle SQL.

The strengths of SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Technically speaking, SQL is a data sublanguage. The purpose of SQL is to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database. In this SQL differs from general-purpose programming languages like C and BASIC.

Among the features of SQL are the following:
- It processes sets of data as groups rather than as individual units.
- It provides automatic navigation to the data.
- It uses statements that are complex and powerful individually, and that therefore stand alone.

SQL lets you work with data at the logical level. You need to be concerned with the implementation details only when you want to manipulate the data. All major relational database management systems support SQL, so you can transfer all skills you have gained with SQL from one database to another. In addition, all programs written in SQL are portable. They can often be moved from one database to another with very little modification.