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

Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Book Practical SQL: A Beginner's Guide to Storytelling with Data, 2nd Edition
Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Expert Oracle SQL: Optimization, Deployment, and Statistics
Course Getting Started with Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Skills of a Successful Software Engineer