SQL Weekend Crash Course - Softcover

Taylor, Allen G.

 
9780764549014: SQL Weekend Crash Course
Softcover
ISBN 10: 0764549014 ISBN 13: 9780764549014
Verlag: Hungry Minds Inc,U.S., 2002

Inhaltsangabe

Get up to Speed on SQL in a Weekend! The big day is Monday. The day you get to show off what you know about SQL. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL. Or maybe you just like a challenge. In any event, we've got a solution for you SQL Weekend Crash Course. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused lessons, you'll be able to dive right in and start manipulating databases with SQL. It's as simple as that. THE CURRICULUM FRIDAY Evening: 4 Sessions, 2 Hours Introduction to Databases and SQL; Retrieving Data; Data Types; Representing Data Values SATURDAY Morning: 6 Sessions, 3 Hours Retrieving Specific Data; Retrieving Not-So-Specific Data; Retrieving Data Based on What Exists; Retrieving Data Based on How It Matches Other Data; Advanced Value Expressions; Ordering and Grouping of Retrieved Data Afternoon: 6 Sessions, 3 Hours Session 11: Retrieving Data from Multiple Tables with Relational Operators; Retrieving Data from Multiple Tables Using Joins; Nested Queries; Adding, Updating, and Deleting Data; Using SQL within an Application; Using SQL: 1999 Flow of Control Structures within an Application Evening: 4 Sessions, 2 Hours Connecting to a Remote Database; Triggers and Stored Procedures; Database Structure; Normalization SUNDAY Morning: 6 Sessions, 3 Hours Null Values, Integrity, and Constraints; Establishing Relationships among Tables; Controlling Access to a Database; Protecting the Contents of a Database; Performance Tuning; Accessing Databases over the Internet Afternoon: 4 Sessions, 2 Hours Cursors; SQL in Common Development Environments; Error Handling; Dynamic SQL CD-ROM INCLUDES: MySQL Code examples from the book Assessment software to help gauge your progress

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Allen G. Taylor (Oregon City, OR)is a database consultant and national speaker. He is a 30-year veteran of the computer industry and the author of many books. He has held the following titles at various companies: E-Business Technical Services Director; Programming Group Manager; and Assistant Professor in Pacific University's Computer Science Department. He is the author of many books, including HMI's SQL For Dummies (1st-4th eds).

Von der hinteren Coverseite

Get up to Speed on SQL -- in a Weekend!
The big day is Monday. The day you get to show off what you know about SQL. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL. Or maybe you just like a challenge. In any event, we've got a solution for you -- SQL Weekend Crash Course. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused lessons, you'll be able to dive right in and start manipulating databases with SQL. It's as simple as that.

THE CURRICULUM
FRIDAY
Evening: 4 Sessions, 2 Hours
Introduction to Databases and SQL; Retrieving Data; Data Types; Representing Data Values

SATURDAY
Morning: 6 Sessions, 3 Hours
Retrieving Specific Data; Retrieving Not-So-Specific Data; Retrieving Data Based on What Exists; Retrieving Data Based on How It Matches Other Data; Advanced Value Expressions; Ordering and Grouping of Retrieved Data

Afternoon: 6 Sessions, 3 Hours
Session 11: Retrieving Data from Multiple Tables with Relational Operators; Retrieving Data from Multiple Tables Using Joins; Nested Queries; Adding, Updating, and Deleting Data; Using SQL within an Application; Using SQL: 1999 Flow of Control Structures within an Application

Evening: 4 Sessions, 2 Hours
Connecting to a Remote Database; Triggers and Stored Procedures; Database Structure; Normalization

SUNDAY
Morning: 6 Sessions, 3 Hours
Null Values, Integrity, and Constraints; Establishing Relationships among Tables; Controlling Access to a Database; Protecting the Contents of a Database; Performance Tuning; Accessing Databases over the Internet

Afternoon: 4 Sessions, 2 Hours
Cursors; SQL in Common Development Environments; Error Handling; Dynamic SQL

CD-ROM INCLUDES:
* MySQL
* Code examples from the book
* Assessment software to help gauge your progress

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
Hungry Minds Inc,U.S.
Erscheinungsdatum
2002
Sprache
Englisch
ISBN 10 
0764549014
ISBN 13 
9780764549014
Einband
Tapa blanda
Anzahl der Seiten
360
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar