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 CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
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

Course Your Role in Workplace Diversity
Rating 4.4 of 7730 users Rating 4.4 of 7730 users (7730)
Book Beginning Oracle SQL: For Oracle Database 12c, Third Edition
Book CI/CD Pipeline with Docker and Jenkins: Learn How to Build and Manage Your CI/CD Pipelines Effectively