gogo
Amazon cover image
Image from Amazon.com

Teach yourself SQL in 21 days / Ryan K. Stephens ... [et al.].

By: Contributor(s): Material type: TextTextPublication details: Indianapolis, Ind. : Sams, 1997.Edition: 2nd edDescription: xxviii, 586p. : ill. ; 24 cmISBN:
  • 9780672311109 (pbk.) :
  • 0672311100
Other title:
  • SQL in 21 days
Subject(s): DDC classification:
  • 005.73 STE
Contents:
Week 1:At a Glance. Day 1.Introduction to SQL -- Day 2.Introduction to Query: The SELECT Statement -- Day 3.Expressions, Conditions and Operators -- Day 4.Functions: Molding the Data You Retrieve -- Day 5.Clauses in SQL -- Day 6.Joining Tables -- Day 7.Subqueries: The Embedded SELECT Statement. Week 2:At a Glance. Day 8.Manipulating Data -- Day 9.Creating and Maintaining Tables -- Day 10.Creating Views and Indexes --Day 11.Controlling Transactions -- Day 12.Database Security -- Day 13.Advance SQL Topics -- Day 14.Dynamic Uses of SQL. Week 3:At a Glance. Day 15.Streamlining SQL Statements for Improved Peformance -- Day 16.Using Views to Retrieve Useful Information from the Data Dictionary -- Day 17.Using SQL to Generate SQL Statements -- Day 18 PL/SQL: An Introduction -- Day 19.Transact-SQL: An Introduction -- Day 20.SQL*Plus -- Day 21.Common SQL Mistakes/Errors and Resolutions.
Summary: Starting with a history lesson the book explains common database concepts, enabling the reader to retrieve data from a RDBMS in a week. The SQL functions are covered so that quickly, the reader can query the database without recourse to 'wizards'.
Holdings
Item type Current library Call number Copy number Status Date due Barcode
Long Loan TUS: Midlands, Main Library Athlone General Lending 005.73 STE (Browse shelf(Opens below)) 1 Available 110326

Includes index.

Text on inside covers.

Includes index.

Week 1:At a Glance. Day 1.Introduction to SQL -- Day 2.Introduction to Query: The SELECT Statement -- Day 3.Expressions, Conditions and Operators -- Day 4.Functions: Molding the Data You Retrieve -- Day 5.Clauses in SQL -- Day 6.Joining Tables -- Day 7.Subqueries: The Embedded SELECT Statement. Week 2:At a Glance. Day 8.Manipulating Data -- Day 9.Creating and Maintaining Tables -- Day 10.Creating Views and Indexes --Day 11.Controlling Transactions -- Day 12.Database Security -- Day 13.Advance SQL Topics -- Day 14.Dynamic Uses of SQL. Week 3:At a Glance. Day 15.Streamlining SQL Statements for Improved Peformance -- Day 16.Using Views to Retrieve Useful Information from the Data Dictionary -- Day 17.Using SQL to Generate SQL Statements -- Day 18 PL/SQL: An Introduction -- Day 19.Transact-SQL: An Introduction -- Day 20.SQL*Plus -- Day 21.Common SQL Mistakes/Errors and Resolutions.

Starting with a history lesson the book explains common database concepts, enabling the reader to retrieve data from a RDBMS in a week. The SQL functions are covered so that quickly, the reader can query the database without recourse to 'wizards'.

Powered by Koha