| Lesson 3 | SQL Course Requirements |
| Objective | What do you need to learn SQL? |
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:
Course download filesYou 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:
- MySQL 5.1
- Microsoft SQL Server 2005/2008
- Microsoft Access 2003/XP
- Oracle 9i, 10g. 11g
- DB2 UDB Versions 7 and 8
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 WebStoreIf 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.
Optional books for this course can be purchased through the online webstore.
RelationalDB WebStore
This book is highly recommend to take this course, but does contain helpful, additional information.
RelationalDB WebStore
This book is highly recommend to take this course, but does contain helpful, additional information.
