Andy Oppel

Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.

Databases DeMYSTiFieD, 2nd Edition

This fully revised, self-paced learning tool lays out all the necessary steps to quickly and easily start writing SQL programs Thoroughly updated to reflect the most recent ANSI/ISO standard, SQL: A Beginner's Guide, Fourth Edition will get you up-and-running with SQL programming right away. Clear tutorials, annotated code, and proven instructional tools guide you to easily performing queries and modifications, building databases, creating and reviewing embedded statements, troubleshooting system- and data-related problems, and much more. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. The book also covers new features, including SQL/XML and the long-awaited temporal support. Code examples are provided throughout along with notes on using them with the latest RDBMS software versions such as MySQL 5.7, SQL Server 2014, and Oracle Database 12c. Platform-neutral coverage; all skills can be applied to any database product, and any SQL version Features hands-on exercises and self-tests that reinforce basic knowledge ”Ask the Expert” sections throughout are filled with bonus information and useful tips

SQL: A Beginner's Guide, Fourth Edition

Robert Sheldon

Essential Skills--Made Easy! Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skills Notes--Extra information related to the topic being covered Self-Tests--Chapter-ending quizzes to test your knowledge Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Andy Oppel

About

Books

Join the club