Chapter 1 - SQL and Data - Chapter Objectives and Lab 1.1 Overview

Oct 25, 2026

Chapter 1 introduces SQL and the foundations of data and databases, explaining SQL as a standardized language for accessing and manipulating data. It traces SQL’s development alongside relational database concepts, including relational database management systems and Codd’s Twelve Rules. The chapter clarifies why relational databases matter in real-world applications and outlines learning outcomes, then begins Lab 1.1 with objectives for identifying and grouping data, defining SQL, and understanding RDBMS structures such as tables, columns, rows, and keys.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages50

Reading Time2 h 6 min

AccessFree to download

Chapter Objectives

What is SQL?

Data, Databases, and Relational Databases

Codd’s Twelve Rules

Learning SQL and Relational Concepts

Lab 1.1: Data, Databases, and the Definition of SQL

Lab Objectives

C H A P T E R 1 SQL AND DATA CHAPTER OBJECTIVES In this chapter, you will learn about: ✔ Data, Databases, and the Definition of SQL Page 3 ✔ Table Relationships Page 15 ✔ The STUDENT Schema Diagram Page 37 hat is SQL? SQL (pronounced sequel) is an acronym for Structured Query Lan Wguage, a standardized language used to access and manipulate data. The history of SQL corresponds closely with the development of relational databases concepts published in a paper by Dr. E. F. Codd at IBM in 1970. He applied mathematical concepts to the specification of a method for data storage and access; this specification, which became the basis for relational databases, was intended to overcome the physical dependencies of the then-available database systems. The SQL language (originally called “System R” in the prototype and later called“SEQUEL”) was developed by the IBM Research Laboratory as a standard language to use with relational databases. In 1979 Oracle, then called Relational Software, Inc., introduced the first commercially available implementation of a relational database incorporating the SQL language. The SQL language evolved with many additional syntax expansions incorporated into the American National Standards Institute (ANSI) SQL standards developed since. Individual database vendors continuously added extensions to the language, which eventually found their way into the latest ANSI standards used by relational databases today. Large-scale commercial implementations of relational database applications started to appear in the mid to late 1980s as early implementations were 2 Chapter 1: SQL and Data hampered by poor performance. Since then, relational databases and the SQL language have continuously evolved and improved. Before you begin to use SQL, however, you must know about data, databases, and relational databases. What is a database? A database is an organized collection of data. A database management system (DBMS) is software that allows the creation, retrieval, and manipulation of data. You use such systems to maintain patient data in a hospital, bank accounts in a bank, or inventory in a warehouse. A relational database management system (RDBMS) provides this functionality within the context of the relational database theory and the rules defined for relational databases by Codd. These rules, called “Codd’s Twelve Rules,” later expanded to include additional rules, describe goals for database management systems to cope with ever-challenging and demanding database requirements. Compliance with Codd’s Rules has been a major challenge for database vendors and early versions of relational databases and many desktop databases complied with only a handful of the rules. Today, SQL is accepted as the universal standard database access language. Databases using the SQL language are entrusted with managing critical information affecting many aspects of our daily lives. Most applications developed today use a relational database and Oracle continues to be one of the largest and most popular database vendors. Although relational databases and the SQL language are already over 30 years old, there seems to be no slowing down of the popularity of the language. Learning SQL is probably one of the best long-term investments you can make for a number of reasons: • SQL is used by most commercial database applications. • Although the language has evolved over the years with a large array of syntax enhancements and additions, most of the basic functionality has remained essentially unchanged. • SQL knowledge will continue to be a fundamental skill as there is currently no mature and viable alternative language that accomplishes the same functionality. • Learning Oracle’s specific SQL implementation provides you with great insight into the feature-rich functionality of one of the largest and most successful database vendors. Understanding relational database concepts provides you with the foundation for und

FAQs

What is SQL and what is it used for?

SQL is a standardized language used to access and manipulate data. It serves as the universal database access language for many commercial applications.

How do databases and DBMSs relate to SQL?

A database is an organized collection of data, while a DBMS is software that enables creation, retrieval, and manipulation of that data. SQL is used to work with data managed by such systems.

What are Codd’s Twelve Rules in relational database theory?

Codd’s Twelve Rules define goals for database management systems under relational database requirements. Compliance has been a major challenge for vendors and influenced how relational database systems evolved.

Oct 25, 2026

Upload by Helloiii