SQL works with databases to insert and extract data and is an
international standard for manipulating data in databases. This
hands-on resource covers everything from a review of SQL basics and
database design to creating your own databases and using the SQL
language 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 will
have you quickly designing your own databases and writing SQL code
sufficient for many real-world situations. Practice exercises in
each chapter help speed up your comprehension. By the end of the
book, you''ll be prepared to handle any surprise that SQL might
throw your way.
What you will learn from this book
- How to get the answers you want from a database
- Procedures for using and manipulating data with SQL''s built-in
functions
- Ways to retrieve data from numerous and diverse tables
- How to create various levels of security in a database so you
can edit data or change the database''s structure
- Theories and practical applications of normalization
- Advanced database design
Who this book is for
This book is for programmers with some prior programming
experience who are seeking to develop their database programming
skills using SQL. The book assumes no previous programming
experience, so it is also suitable for database programming
beginners including database administrators.
Wrox Beginning guides are crafted to make learning programming
languages and technologies easier than you think, providing a
structured, tutorial format that will guide you through all the
techniques involved.