Basic SQL  «Prev  Next»

Lesson 3SQL Course Requirements
ObjectiveWhat do you need to learn SQL?

SQL Course Requirements for the Basic Structured Query Language

Software

Download MySQL from MySQL.com and run the database in localhost.
You should feel free to post a message to the forum regarding any challenges that you may have.
The following are examples of the most popular SQL-compliant databases:
  1. MySQL 5.1/5.6
  2. Microsoft SQL 2008/2012/2015
  3. Microsoft Access 2003/2007/2010/2013
  4. Oracle 9i, 10g. 11g,12c
  5. DB2 UDB Versions 7, 8, 9

Course download files

PUBS Database
The database we'll be using is the standard PUBS database. This database is a fairly standard demonstration database that ships with many of the database engines listed and supported by this course.
If you are using Microsoft Access, you will be able to download the PUBS database directly for Access.
If you are using Microsoft SQL Server or Oracle, you will need the scripts provided to populate the database with the required data. The Access database and the Microsoft SQL Server and Oracle scripts are available from the Resources page.

Online WebStore

The following textbook on SQL Queries will help you obtain a better understanding of SQL.
SQL Queries

So this course is aimed at database practitioners in general, and SQL practitioners in particular, who have had some exposure to the relational model but do not know as much about it as they would like to. It is definitely not meant for beginners and is not just a refresher course, either. To be more specific, I am sure you know something about SQL; but would like to apologize for the possibly offensive tone here if your knowledge of the relational model derives only from your knowledge of SQL, then I am afraid you will not know the relational model as well as you should. SQL and the relational model are not the same thing. Here by way of illustration are some relational issues that SQL is not too clear on (to put it mildly):

  1. What databases, relations, and tuples really are
  2. The difference between relation values and relation variables
  3. The relevance of predicates and propositions
  4. The importance of attribute names
  5. The crucial role of integrity constraints
  6. The Information Principle and its significance
and so on (this is not an exhaustive list). All of these issues, and many others, are addressed in this course. I say again: If your knowledge of the relational model derives only from your knowledge of SQL, then you might know.