Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Sams Teach Yourself SQL in 24 Hours

Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information ...

Tutorial Details:

Copyright
About the Authors
Acknowledgments
Tell Us What You Think!
Introduction
Part I: A SQL Concepts Overview
Hour 1. Welcome to the World of SQL
Part II: Building Your Database
Hour 2. Defining Data Structures
Hour 3. Managing Database Objects
Hour 4. The Normalization Process
Hour 5. Manipulating Data
Hour 6. Managing Database Transactions
Part III: Getting Effective Results from Queries
Hour 7. Introduction to the Database Query
Hour 8. Using Operators to Categorize Data
Hour 9. Summarizing Data Results from a Query
Hour 10. Sorting and Grouping Data
Hour 11. Restructuring the Appearance of Data
Hour 12. Understanding Dates and Times
Part IV: Building Sophisticated Database Queries
Hour 13. Joining Tables in Queries
Hour 14. Using Subqueries to Define Unknown Data
Hour 15. Combining Multiple Queries into One
Part V: SQL Performance Tuning
Hour 16. Using Indexes to Improve Performance
Hour 17. Improving Database Performance
Part VI: Using SQL to Manage Users and Security
Hour 18. Managing Database Users
Hour 19. Managing Database Security
Part VII: Summarized Data Structures
Hour 20. Creating and Using Views and Synonyms
Hour 21. Working with the System Catalog
Part VIII: Applying SQL Fundamentals in Today's World
Hour 22. Advanced SQL Topics
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
Hour 24. Extensions to Standard SQL
Part IX: Appendixes
Appendix A. Common SQL Commands
Appendix B. Using MySQL for Exercises
Appendix C. Answers to Quizzes and Exercises
Appendix D. CREATE TABLE Statements for Book Examples
Appendix E. INSERT Statements for Data in Book Examples
Appendix F. Glossary
Appendix G. Bonus Exercises


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Sams Teach Yourself SQL in 24 Hours

View Tutorial:
Sams Teach Yourself SQL in 24 Hours

Related Tutorials:

Which Java VM scales best? - JavaWorld - August 1998
Which Java VM scales best? - JavaWorld - August 1998
 
Revolutionary RMI: Dynamic class loading and behavior objects - JavaWorld - December 1998
Revolutionary RMI: Dynamic class loading and behavior objects - JavaWorld - December 1998
 
Programming Java threads in the real world, Part 3 - JavaWorld - November 1998
Programming Java threads in the real world, Part 3 - JavaWorld - November 1998
 
SQLJ: The 'open sesame' of Java database applications
SQLJ: The 'open sesame' of Java database applications
 
An instrumentation network for weather data on the Web
An instrumentation network for weather data on the Web
 
Debug with jdb - JavaWorld June 2000
Debug with jdb - JavaWorld June 2000
 
Which JSP book serves up the best lesson?
Which JSP bookAs for Web servers/databases, just mentioning a server in the book is not sufficient to be listed here.
 
Accelerate your RMI programming
Accelerate your RMI programming
 
Working in Java time
Working in Java time
 
Generate JavaBean classes dynamically with XSLT
Generate JavaBean classes dynamically with XSLT
 
eva/3 Application Builder supports eclipse 3
What is eva/3 Application Builder? eva/3 Application Builder assumes responsibility for the design of forms and reports via an integrated GUI Builder, the execution of procedures and the handling of diverse relational SQL databases through JDBC int
 
JForumFusion
About jForumFusion JForumFusion is a platform independent discussion board program.
 
STRAP - Interactive alignment program for proteins
Structural Alignment Program for Proteins Welcome to STRAP, an editor for multiple sequence alignments of proteins. The computer program STRAP supports the analysis of hundreds of proteins and integrates amino acid sequence, secondary structure, 3D-struc
 
SQL Uniform
SQL Uniform is a general interface (GUI), a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert).
 
The eXo platform
The eXo platform The eXo platform™ software is a powerful Open Source corporate portal and content management system. Users of the platform have a customized single point of access to the company's information system and resources. The use of a corpora
 
StelsCSV - JDBC driver for text files
StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma separated, tab separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
Overview of JDBC and its use with Microsoft Access
JDBC provides a set of classes for Java with a standard SQL database access interface. Goal is uniform access to a wide range of relational databases.
 
Digital Clock developed in java
This digital clock displays the local time in 24-hour format. Hours, minutes and seconds are displayed as 7-segment BCD-LED digits with segments tapered at both ends.
 
Java Resources
There are all Java freebies. Some of these are old, and not under maintenance. Download and use them at your risk. In case of queries, mail subrahmanyam_avb@technologist.com or varalakshmi_a@techie.com.
 
StelsCSV v2.2 - JDBC driver for CSV files
*StelsCSV* is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, tab-separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.