Search results

MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and UNIX systems. Both products are free for non-profit use and cost a small amount for commercial use. Even a small organization or Web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your Web site's visitors for their interests and preferences and put up a fr...

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of "Oracle PL/SQL Programming" covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examp...

Regular expressions are a powerful tool for manipulating text and data. They are now standard features in a range of languages and popular tools, including Perl, Java, VB.NET and C# (and any language using the .NET Framework), PHP, Python, Ruby, Tcl, MySQL, awk, and Emacs. This volume has been updated to include all the new features of Perl 5, 8, as well as several other languages, including Java, VB. NET, C#, Python, JavaScript, Tcl, and Ruby. It offers solutions to complex real-world problems...

SQL Server is a relational database management system (DBMS) used for large corporate databases. Jim and Mary Panttajja here run through the do's and don'ts of installing the Sybase SQL system. This guidebook should help the reader to avoid the usual stumbling blocks that developers run into. For those already familiar with the system, this book focuses on the day-to-day troubles that SQL Server presents to programmers and developers. The reader may solve problems from administration and perform...

How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in cl...

　 For developers working with big data, it's not enough to have a theoretical understanding of Hadoop. They need to solve real challenges like analyzing real-time streams, moving data securely between storage systems, and managing large-scale clusters. The Hadoop ecosystem is constantly growing, and it's important they keep up with the new technologies and practices to stay productive and future-proof data systems.   Hadoop in Practice, Second Edition provides over 100 tested, instantly-usef...

Object-oriented databases were originally developed as an alternative to relational database technology for the representation, storage, and access of non-traditional data forms that were increasingly found in advanced applications of database technology. After much debate regarding object-oriented versus relational database technology, object-oriented extensions were eventually incorporated into relational technology to create object-relational databases. Both object-oriented databases and obje...

Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, "Learning SQL on SQL Server 2005" is an id...

Churn is the bane of any subscription business, such as content subscriptions, software as a service, and even ad-supported freemium apps. You can improve customer retention through product changes and targeted engagement campaigns based on data-driven interventions.   This hands-on guide is packed with techniques for converting raw data into measurable metrics, testing hypotheses, and presenting findings that are easily understandable to non-technical decision makers.   Don’t let your hard-won...

Tap into the wisdom of experts to learn what every programmer should know, no matter what language you use. With the 97 short and extremely useful tips for programmers in this book, you'll expand your skills by adopting new approaches to old problems, learning appropriate best practices, and honing your craft through sound advice. With contributions from some of the most experienced and respected practitioners in the industry--including Michael Feathers, Pete Goodliffe, Diomidis Spinellis, Cay H...

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through d...

Written in an easy-to-follow, example-driven format, there are plenty of step by step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It's assumed that you will have some experience in databases systems...

Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joe's columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL pers...

SQL Server Security provides in-depth coverage of the installation, administration, and programming of secure Microsoft SQL Server environments and applications. It includes expert advice on how to defend against network-based attacks as well as little-known security holes such as SQL-injection. Implementation techniques are covered for multiple security methods such as authentication, encryption, authorisation, auditing and intrusion detection.

Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. With this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's Hive, Cassandra, a relational database, or a proprietary data store. Analysts, software engineers, and production engineers will learn how to manage, use, and even develop with Trino. Initially developed by Facebook, open source Trino is now used by Netflix, Airbnb, L...