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.
Quantitative Corpus Linguistics with R: A Practical Introduction
The first textbook of its kind, Quantitative Corpus Linguistics with R demonstrates how to use the open source programming language R for corpus linguistic analyses. Computational and corpus linguists doing corpus work will find that R provides an enormous range of functions that currently require several programs to...
Peachtree for Dummies
Handle the financial parts of your business like a pro
Set up Peachtree to do what you need, and even have a backup plan
If you have a business, you have financial management needs. With Peachtreeand this book, you can manage inventory, bill customers and collect money, pay...
100 Strangest Mysteries THE BEAST OF BODMIN: whether it is a native cat, previously thought extinct, or an escaped exotic pet, the Beast of Bodmin is a creature that refuses to disappear. Indeed, sightings of the panther-like creature continue apace and, unlike other mysterious beasts, modern technology is actually helping to prove its existence. Bodmin Moor is an area of...
E-Training and Development (Training & Development) ExpressExec is a completely up-to-date resource of current business practice, accessible in a number of ways – anytime, anyplace, anywhere. ExpressExec combines best practice cases, key ideas, action points, glossaries, further reading, and resources.
Each module contains 10 individual titles that cover all the key aspects of...
Adobe Dreamweaver CS6 Digital Classroom
Learn Dreamweaver CS6 at your own speed with this complete training package
Dreamweaver is the industry standard software for professional website design, with more than 90 percent of the market. In this book-and-DVD package, expert instructors provide a complete course in basic Dreamweaver that you can access at your own...