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.
Parsing Techniques: A Practical Guide (Monographs in Computer Science) Parsing, also referred to as syntax analysis, has been and continues to be an essential part of computer science and linguistics. Today, parsing techniques are also implemented in a number of other disciplines, including but not limited to, document preparation and conversion, typesetting chemical formulae, and chromosome recognition.
Magnetics, Dielectrics, and Wave Propagation with MATLAB® Codes
Because future microwave, magnetic resonance, and wave propagation systems will involve miniature devices, nanosize structures, multifunctional applications, and composites of various types of materials, their development requires distinctly multidisciplinary collaborations. That means specialized approaches will not be sufficient to...
Modular Design Frameworks: A Projects-based Guide for UI/UX Designers
Learn the basic principles of modular design, and then put them into action to create sites that are easy to use, look great, and can be adapted within the context of your business needs.
With author James Cabreraâone of the thought leaders in the modular-design movementâyou'll create a single, scalable project for...
Discover Signal Processing: An Interactive Guide for Engineers
Signal processing is now a multidisciplinary topic, and one that has applications in many fields including, but not limited to, science, engineering, medicine, finance and the behavioural sciences. Modern software libraries that include dedicated languages and packages designed to simplify the development and application of signal processing...
Schaum's Easy Outlines: Intermediate Algebra
What could be better than the bestselling Schaum's Outline series? For students looking for a quick nuts-and-bolts overview, it would have to be Schaum's Easy Outline series. Every book in this series is a pared-down, simplified, and tightly focused version of its predecessor. With an emphasis on clarity and brevity, each new title...
Schaum's Outline of Data Structures with Java, Second Edition Like other Schaum’s Outlines, this book is intended to be used primarily for self study. It is suitable as a study guide in a course on data structures using the Java programming language. In American universities, this is typically the second course in the computer science major. The book is also serves well as a reference on data structures...