Beginning SQL
24%
off

Beginning SQL

3.15 (20 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?

Description

Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
show more

Product details

  • Paperback | 520 pages
  • 191 x 235 x 28mm | 926g
  • WROX PRESS
  • Indianapolis, IN, United States
  • English
  • 1. Auflage
  • 0764577328
  • 9780764577321
  • 1,351,965

Back cover copy

SQL works with databases to insert and extract data and is aninternational standard for manipulating data in databases. Thishands-on resource covers everything from a review of SQL basics anddatabase design to creating your own databases and using the SQLlanguage in a variety of database applications.

Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text willhave you quickly designing your own databases and writing SQL codesufficient for many real-world situations. Practice exercises ineach chapter help speed up your comprehension. By the end of thebook, you'll be prepared to handle any surprise that SQL mightthrow your way.

What you will learn from this book

How to get the answers you want from a databaseProcedures for using and manipulating data with SQL's built-infunctionsWays to retrieve data from numerous and diverse tablesHow to create various levels of security in a database so youcan edit data or change the database's structureTheories and practical applications of normalizationAdvanced database design

Who this book is for

This book is for programmers with some prior programmingexperience who are seeking to develop their database programmingskills using SQL. The book assumes no previous programmingexperience, so it is also suitable for database programmingbeginners including database administrators.

Wrox Beginning guides are crafted to make learning programminglanguages and technologies easier than you think, providing astructured, tutorial format that will guide you through all thetechniques involved.
show more

Table of contents

Introduction; Introduction to SQL; Entering Information; Extracting Information; Advanced Database Design; Manipulating Data; Grouping and Aggregating Data; Selecting Data from Different Tables; Queries Within Queries; Advanced Queries; Views; Transactions; SQL Security; Database Tuning; Appendix A: Answers; Appendix B: Setting up and Using the Five Database Systems; Appendix C: Initial Data Setup; ; ; ;
show more

About Paul Wilton

Paul Wilton has been working professionally as a programmer for over 6 years. He is experienced with SQL, database design, development and deployment, as well as RDBMS systems including SQL Server and Access. He is currently working freelance developing functionality for websites database driven web sites including e-commerce, message boards, chat applications, and more. His most recent work includes a case tracking system for a law firm and an online booking system for a holiday cottage rental company. John Colby is database consultant providing database analysis and design as well as Access, SQL Server, and Visual Foxpro programming to companies in the United States, Mexico, and Europe.
show more

Rating details

20 ratings
3.15 out of 5 stars
5 5% (1)
4 30% (6)
3 45% (9)
2 15% (3)
1 5% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X