This work approaches teaching Structured Query Language the way most people learn it - by focusing on critical tasks first. Structured pedagogy enhances the learning experience: modules, goals, projects, mastery checks, one-minute drills enhance the learning experience. All coding is based on real-world scenarios. No hypothetical SQL statements. Projects include pre-built databases including: product tracking database, order entry for small business, patient tracking for medical facility and more. The book also includes quick-look up appendix of the most critical SQL commands and techniques, sample SQL code for both Access and SQL Server 2000, and syntax and information on the emerging new standard to SQL -SQL 3.
FREE Two-Day Shipping for Students. Learn more |
|
There is a newer edition of this item:
|
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Frequently Bought Together
Editorial Reviews
From the Back Cover
Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.
SQL: A Beginner's Guide teaches you how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. The examples throughout the book walk you through real-world database tasks. If you want to get started programming in SQL right away, this is the ideal self-paced learning tool for you.
This Beginner's Guide is Designed for Easy Learning:
- Modules - Each programming concept is divided into logical modules (chapters), ideal for individualized learning
- Goals - Each module opens with the specific programming skills you'll have by the end of the module
- Ask the Experts - Q&A sections throughout are filled with extra information and interesting commentary
- 1-Minute Drills - Quick self-assessment sections to check your progress
- Annotated Syntax - Example code annotated with commentary that points to the particular technique illustrated
- Projects - Coding exercises contained in each module show how to apply what you are learning
- Mastery Checks - End-of-module reviews that test your knowledge using short-answer, multiple-choice, fill-in-the-blank, and simple coding questions
About the Author
Forrest Houlette (Louisville, KY) is a computer writer and consultant and president of Write Environment, Inc., a consulting firm that specializes in Visual Basic software development, custom documentation, training, and software for both education and business. Forrest focuses on writing about computers and creating custom software. He is a former Learning Tree International instructor, for whom he taught courses Windows 95, Windows NT, Office 97, and Visual. He has authored or co-authored books for IDG, New Riders Publishing, Que, and Sybex. He is also a Microsoft Certified Product Specialist.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
15 of 17 people found the following review helpful:
4.0 out of 5 stars
A Clear and Consise Book,
By A Customer
This review is from: SQL: A Beginner's Guide (Paperback)
It's probably not really for people who want in-depth knowledge about SQL and relational database.But it delivers the concept clearly without using too many words or using too many code or pictures. It's a very clear and consise book that refresh the most basic concept for experienced programmers. The style and editing makes it very easy to find the topic you want and it's a very clean book.
1 of 1 people found the following review helpful:
5.0 out of 5 stars
SQL A Beginner's Guide,
By
This review is from: SQL: A Beginner's Guide (Paperback)
If you are just learning SQL this book is a MUST HAVE!! I highly recommend this book for beginners. This book teaches basic SQL commands with easy to read and understand instrucions.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
Learn how to connect to a database Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
multipart key, inner join titleauthor, portfolio database, best data type, inner join titles, truncate table, main query, query analyzer, bit data type, pubs database, union query, stored procedure, postal zone, data entry application, cursor variable, join syntax, temporary table, datetime value, select statement, row identifier, second normal form, delete statement, date expression, connection string, parameters collection Key Phrases - Capitalized Phrases (CAPs): (learn more)
Purpose Returns, Mastery Check, Visual Basic, Enterprise Manager, Private Sub, End With Set, End If End Sub, Initial Catalog, None Table, Microsoft Access, Command Timeout, John Smith, Arguments Sql, Connection Create, None Password, Persist Security Info, Burt Gringlesby, Command Dim, Microsoft Data Engine, Open Database Connectivity, Visual Studio, Arguments String-expression, Click Finish, None Last Name, Test Connection New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Learn how to connect to a database Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
multipart key, inner join titleauthor, portfolio database, best data type, inner join titles, truncate table, main query, query analyzer, bit data type, pubs database, union query, stored procedure, postal zone, data entry application, cursor variable, join syntax, temporary table, datetime value, select statement, row identifier, second normal form, delete statement, date expression, connection string, parameters collection Key Phrases - Capitalized Phrases (CAPs): (learn more)
Purpose Returns, Mastery Check, Visual Basic, Enterprise Manager, Private Sub, End With Set, End If End Sub, Initial Catalog, None Table, Microsoft Access, Command Timeout, John Smith, Arguments Sql, Connection Create, None Password, Persist Security Info, Burt Gringlesby, Command Dim, Microsoft Data Engine, Open Database Connectivity, Visual Studio, Arguments String-expression, Click Finish, None Last Name, Test Connection New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
Listmania!
So You'd Like to...
Look for Similar Items by Category
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Databases > SQL
- Books > Computers & Technology > Programming > Languages & Tools
- Books > New & Used Textbooks > Computer Science > Database Storage & Design
- Books > New & Used Textbooks > Computer Science > Programming Languages
- Books > Science & Math > Mathematics
