Oracle SQL: A Beginner's Tutorial

  • 1h 10m
  • Djoni Darmawikarta
  • Brainy Software Corp.
  • 2014

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. This book uses the free edition of the Oracle database to show how SQL works.

In this Book

  • Storing and Maintaining Data
  • Basic Queries
  • Query Output
  • Grouping
  • Joins
  • Subqueries
  • Compound Queries
  • Views
  • Built-in Functions
  • PL/SQL
  • The Data Dictionary
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Book MySQL Crash Course: A Hands-on Introduction to Database Development
Book Oracle on Docker: Running Oracle Databases in Linux Containers

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Cross-Cultural Management
Book Oracle SQL: A Beginner's Tutorial, Second Edition
Book Expert Oracle SQL: Optimization, Deployment, and Statistics