Learn SQL in a Weekend

  • 6h 31m
  • Deanna Dicken
  • Cengage Course PTR
  • 2002

Create powerful databases using SQL

With this book as your guide, you can progress from basic database design to more advanced techniques of database communication in just one weekend! When your weekend begins on Friday evening, you'll start with the basics of SQL as you set up a sample database. On Saturday, practice database communication as you cover queries, the SELECT command, and relational database creation. Pull it all together on Sunday with optimization techniques and security triggers. End the weekend with a practical look at how programmers use SQL to make their jobs easier and how popular programming languages can access your database.

In Just One Weekend You'll Learn:

  • Data retrieval techniques
  • Database design concepts
  • Data storage and manipulation commands
  • Complex query creation
  • Database security concepts
  • How to use SQL with various software packages and programming languages

About the Authors

Deanna Dicken is a Microsoft Certified Solution Developer (MCSD). She has over 10 years experience in the computer industry, including six years as a consultant. During this time, she has worked on many large-scale, critical applications and has been involved in all phases of the lifecycle. She has also contributed to three SQL Server books for MCSE study guides and technical edited many other titles.

Kevin Thompson is an independent contract developer in the Indianapolis area. He specializes in n-tier Internet/intranet and client/server application development. He has worked with SQL relational databases for the last 13 years. He has obtained several technical certifications including Microsoft SQL Server and Sybase Adaptive Server. He has also worked on several books on the topics of database development, database administration, and client/server programming.

In this Book

  • Learn SQL in a Weekend
  • Introduction
  • Introduction to SQL—Let the Weekend Begin!
  • Selecting Data—How to See What’s in There
  • Selecting Data—Bigger and Better
  • Building a Home for Your Data
  • Optimization—Feel the Need for Speed?
  • Security—Putting the Padlocks on
  • SQL and the Application Developer