Oracle SQL: A Beginner's Tutorial, Second Edition
- 1h 33m
- Djoni Darmawikarta
- Brainy Software Corp.
- 2016
Initially developed at IBM in the early 1970s, SQL was formalized by the American National Standards Institute (ANSI) in 1986. Since then the SQL standard has been revised seven times.
SQL consists of a data definition language (DDL) and a data manipulation language (DML). The DDL is used to create, delete, and alter the structure of a table and other database objects. The DML is used to insert, retrieve, and update data in a table or tables.
Many database vendors implement a version of SQL that is not 100% compliant with the standard. They often add unique features to their SQL, resulting in an SQL dialect.
This book is for you if you want to learn SQL the easy way.
About the Author
Djoni Darmawikarta specializes in database, data modeling, data warehousing, and data analysis. He is a former systems engineer, consultant, customer support manager, and country computing center head at IBM. Djoni is currently a senior data analyst at a Toronto-based insurance company.
In this Book
-
Introduction
-
Storing and Maintaining Data
-
Basic Queries
-
Query Output
-
Grouping
-
Joins
-
Subqueries
-
Compound Queries
-
Views
-
Built-in Functions
-
Regular Expressions
-
PL/SQLPL/SQL
-
Granting Permissions
-
The Data Dictionary
