Intelligentedu Best New Free Computer IT Training Tutorial Resources

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:
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:
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:
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: 7% [?]

Related Posts:

Free Computer and Programming Training Videos

Free Training for Oracle 10g and 9i

Free training for ASP .NET with VB .NET

Free Computer Training from LearnKey Direct

Free Training in Python, Java, VB.Net, Web Dev, and Oracle Manuals