Andy Oppel – författare

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,  authenticity, or access to any online entitlements included with the product.

The Definitive Guide to SQL

Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. 

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

Build SQL-based relational databases and applicationsCreate, load, and modify database objects using SQLConstruct and execute simple, multitable, and summary queriesImplement security measures with authentication, privileges, roles, and viewsHandle database optimization, backup, recovery, and replicationWork with stored procedures, functions, extensions, triggers, and objectsExtend functionality using APIs, dynamic SQL, and embedded SQLExplore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL

The Definitive Guide to SQL

Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today''s mobile, handheld, and wireless devices are included in this in-depth volume.

Build SQL-based relational databases and applicationsCreate, load, and modify database objects using SQLConstruct and execute simple, multitable, and summary queriesImplement security measures with authentication, privileges, roles, and viewsHandle database optimization, backup, recovery, and replicationWork with stored procedures, functions, extensions, triggers, and objectsExtend functionality using APIs, dynamic SQL, and embedded SQLExplore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Essential Database Skills--Made Easy!

Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases.

Designed for Easy Learning

Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter Ask the Expert--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show you how to apply your skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge

Essential Database Skills--Made Easy!

Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner''s Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you''ll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You''ll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases.

Designed for Easy Learning

Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter Ask the Expert--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show you how to apply your skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Essential Skills--Made Easy!

Learn how to create data models that allow complex data to be analyzed, manipulated, extracted, and reported upon accurately. Data Modeling: A Beginner's Guide teaches you techniques for gathering business requirements and using them to produce conceptual, logical, and physical database designs. You'll get details on Unified Modeling Language (UML), normalization, incorporating business rules, handling temporal data, and analytical database design. The methods presented in this fast-paced tutorial are applicable to any database management system, regardless of vendor.

Designed for Easy Learning

Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapterAsk the expert--Q&A sections filled with bonus information and helpful tipsTry This--Hands-on exercises that show you how to apply your skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge

Andy Oppel has taught database technology for the University of California Extension for more than 25 years. He is the author of Databases Demystified, SQL Demystified, and Databases: A Beginner's Guide, and the co-author of SQL: A Beginner's Guide, Third Edition, and SQL: The Complete Reference, Third Edition.

Essential Skills--Made Easy!

Learn how to create data models that allow complex data to be analyzed, manipulated, extracted, and reported upon accurately. Data Modeling: A Beginner''s Guide teaches you techniques for gathering business requirements and using them to produce conceptual, logical, and physical database designs. You''ll get details on Unified Modeling Language (UML), normalization, incorporating business rules, handling temporal data, and analytical database design. The methods presented in this fast-paced tutorial are applicable to any database management system, regardless of vendor.

Designed for Easy Learning

Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapterAsk the expert--Q&A sections filled with bonus information and helpful tipsTry This--Hands-on exercises that show you how to apply your skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge

Andy Oppel has taught database technology for the University of California Extension for more than 25 years. He is the author of Databases Demystified, SQL Demystified, and Databases: A Beginner''s Guide, and the co-author of SQL: A Beginner''s Guide, Third Edition, and SQL: The Complete Reference, Third Edition.

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 AccessWrite SQL statements and queriesUse entity relationship diagrams (ERDs) for data modelingDesign physical tablesConnect databases to users, computer systems, and applicationsSecure database dataHandle cursor processing, transaction management, and performance tuningIntegrate 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.

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 versionFeatures hands-on exercises and self-tests that reinforce basic knowledge”Ask the Expert” sections throughout are filled with bonus information and useful tips