Search results

A Guide to MySQL, by Philip Pratt and Mary Last, is yet another step into the open-source arena, which is rapidly growing in the technology industry. Topics include design techniques, data definition, commands to query a database, updates, administration and client tools, and finally, MySQL special topics.

The only Oracle Press exam guide for Oracle OCP MySQL certification OCP MySQL 5.6 Database Administrator Exam Guide covers all of the exam objectives on the OCP level exam for MySQL DBAs in detail. You can become MySQL certified by passing OCP Exam 1Z0-883. This book prepares you for this highly technical exam and focuses on practitioner-level skills, covering a broad set of topics, including security, backup, replication, and optimization. Ideal as both an exam guide and on-the-job reference, e...

Expand your PL/SQL knowledge to the next level by using hundreds of PL/SQL tips and techniques provided in this one-of-a-kind reference, designed for every Oracle developer and database administrator. This book highlights many solutions that are either hidden, undocumented, or can only be discovered through many years of experience.

In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices" - rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors - and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues...

This book is the first introduction to someone learning the new query language called SPARQL, the approved standard language (comparable to SQL in the relational database world) for querying Semantic Web data. It includes numerous real-life examples of varying complexity, which make it easy for the reader to take away ready expressions to software projects they will be working on. Basically a tutorial, however, the book is organized as a well-indexed reference to support the early users who will...

DESCRIPTION Hadoop queries in Pig or Hive can be too slow for real-time data analysis. Impala, an ultra-speedy query engine from Cloudera, supercharges Hadoop by avoiding the typical Map-Reduce overhead and parallelizing queries so that they can run on multiple nodes. This is a big deal for big data, because with Impala, querying Hadoop takes seconds rather than minutes. Impala's dialect is close to standard SQL, and Impala seamlessly accesses HBase and HDFS (Hadoop Distributed File Sys...

This programmer's resource explains how to optimize SQL statements and procedures and create a customized SQL debugging environment for error-free applications. You'll get programming tips, best practices, plus coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server.

Even if you've never used MySQL before, this Visual QuickStart Guide will have you up and running with the world’s most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology authorLarry Ullman uses his trademark crystal-clear instructions and friendly prose to introduce you to everything that’s new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to...

The ultimate beginning-to-end guide for SQL developers building Web-enabled database applications. Contains data tools to help make building Web applications easier for developers. Includes coverage of security issues and building N-tier Web solutions, an important topic in web development today.

Need to know PHP scripting right now, but don’t want a 1,000-page tome? Check out the Peachpit’s new Short Cuts!  Quick PDF guides that are...Smart...Handy...Concise. This mini guide covers exactly what you need to know about writing basic PHP scripts, and nothing more. Never programmed before? No problem. You’ll get all the fundamentals, techniques, and information you need to master standard terms and language syntax so you can build on the basics and truly start PHP programming. You’ll lea...

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence-one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features a...