Teach yourself SQL in 21 days /
Stephens, Ryan K.
Teach yourself SQL in 21 days / SQL in 21 days Ryan K. Stephens ... [et al.]. - 2nd ed. - Indianapolis, Ind. : Sams, 1997. - xxviii, 586p. : ill. ; 24 cm.
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'.
9780672311109 (pbk.) : £36.50 0672311100
SQL (Computer program language)
Relational databases.
Database management.
Computers and IT.
Programming & scripting languages: general
Database programming
Database software
005.73 STE
Teach yourself SQL in 21 days / SQL in 21 days Ryan K. Stephens ... [et al.]. - 2nd ed. - Indianapolis, Ind. : Sams, 1997. - xxviii, 586p. : ill. ; 24 cm.
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'.
9780672311109 (pbk.) : £36.50 0672311100
SQL (Computer program language)
Relational databases.
Database management.
Computers and IT.
Programming & scripting languages: general
Database programming
Database software
005.73 STE