Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

SQL etc

Posted Jun 28, 2001

Beginning SQL Programming: Pt. 1

By DatabaseJournal.com Staff

Book overview

Structured Query Language is the industry standard for querying data held in relational databases. SQL can be used to create and alter the structure of databases, add new data, and access or modify existing data. Beginning SQL Programming begins by looking at what SQL is, then moves on to teach you the fundamentals of ANSI SQL, using the familiar Northwind database that comes with versions of Microsoft Access and SQL Server.

The book gives step-by-step instructions, alerts readers to common pitfalls, tricks and traps, and uses real-world examples, including two extensive case studies, to create a thorough tutorial. It will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.

Included with this book is a 120-day evaluation enterprise edition of Microsoft's SQL Server 2000. An end user license agreement is contained in this licensed software.

What does this book cover?

  • Database structure from Tables to Normalisation
  • Basic SQL, including DDL, DCL, DML
  • The only tutorial that is comprehensive and up-to-date with coverage of SQL '99
  • Tutorial exercises tied into each element of database structure - as it appears

Who is this book for?

  • Novice database programmers and administrators
  • Highly suitable for Visual Basic novices
  • Highly suitable for web developers who have wandered into the world of dynamic page creation from databases

Wrox provides on-line discussion for the above title and surrounding technologies on P2P.

Title: Beginning SQL Programming
ISBN: 1861001800
US Price: $ 49.99
Canadian Price: C$ 74.95
UK Price: £ 38.99
Publication Date: March 2001
Pages: 723
Wrox Press Limited, US and UK.

SQL etc Archives

Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM