Free Database and SQL Training

Best New Free Computer IT Training Tutorial Resources

Blog Roll:

- Web Dev - Adobe/MM - MS Office

Top Links:

June 23, 2005

Here are two excellent free training sites for learning to use and adminster databases and program with SQL (Structured Query Language).

This first site focuses on online database learning, where you can learn how to administer and program a relational database. It provides an online database textbook. Topics covered by the chapters in this book are listed below.

Database eLearning:
" title="http://db.grussell.org/" target="_blank">db.grussell.org/

* Introduction
* Database Analysis and ER Modelling
* Database Analysis
* Entity Relationship Modelling - 2
* Mapping ER Models into Relations
* Advanced ER Mapping
* SQL
* Simple SELECT statements
* Logical Operators and Aggregation
* JOINs and VIEWs
* Subqueries and Schema
* Normalisation
* Relational Algebra
* Concurrency, Transactions, and Implementations
* Concurrency using Transactions
* Concurrency
* Recovery
* DBMS Implementation
* Programming with SQL
* Metadata, Security, and the DBA

Lecture Slides are available here:
db.grussell.org/resources/lectures.html

SQL Tutorials on this site are here:
" title="http://db.grussell.org/sql/" target="_blank">db.grussell.org/sql/

*****************************************************

This second site hosts a great Interactive SQL Tutorial, from which you can learn how to use SQL with: SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access. Topics covered include those below.

A Gentle Introduction to SQL:
" title="http://sqlzoo.net/" target="_blank">sqlzoo.net/

Select:
* Select in Select
* Sum and Count
* The Join operation
* More Join operations
* The Outer Join

Reference Section: How To:
* Create and Drop
* Insert and Delete
* Dates and times
* Functions
* Users
* Meta Data

Popularity: 6% [?]

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.