Sql : Introduction

Introduction to SQL

SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks." This became the foundation for the relational database system. This paper described a new way to structure data within a database and led to the relational database systems we use today. Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.

What is a Relational Databases?

• A Database in which all data is stored in Relations which (to the user) are tables with rows and columns.
• Read more about Relational Databases in details here.

The Structured Query Language (SQL) is the language of databases. All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block. In fact, it’s often the only way that you can truly interact with the database itself. All of the fancy graphical user interfaces that provide data entry and manipulation functionality are nothing more than SQL translators. They take the actions you perform graphically and convert them to SQL commands understood by the database.

Oracle : Database Introduction

Introduction to Oracle Database

The most powerful tool in the world today is information. The most powerful information tool in the world is the relational database. The leading relational database in the world is Oracle Database.

What is a Database?

• Database is a collection of Objects. Objects are the building blocks inside the database. A database consists of one or more database objects.
• Database is a structured set of data held in a computer, especially one that is accessible in various ways.
• Systematically organized or structured repository of indexed information (usually as a group of linked data files) that allows easy retrieval, updating, analysis, and output of data.
• A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects.
• A database is an organized collection of information treated as a unit. The purpose of a database is to collect, store, and retrieve related information for use by database applications.

What is a Database Application?

• A database application is a software program that interacts with a database to access and manipulate data.

What is a Relational Database?

• In 1970’s paper "A Relational Model of Data for Large Shared Data Banks," E. F. Codd defined a relational model based on mathematical set theory. Today, the most widely accepted database model is the relational model.