You may have to Search all our reviewed books and magazines, click the sign up button below to create a free account.
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
A guide for protecting your wealth in an age of turbulent business cycles In Prosperity in the Age of Decline, Brian and Alan Beaulieu—the CEO and President of the Institute for Trend Research® (ITR)—offer an informed, meticulously-researched look at the future and the coming Great Depression. Drawing on ITR's 94.7% forecast accuracy rate, the book outlines specific, actionable strategies for capitalizing on cyclical opportunities and dodging economic danger. In this important resource, the authors reveal what it will take for individual investors and business leaders to prosper as the economy heats up prior to the predicted downturn, preserve wealth in the upcoming Great Depression, an...
As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work. Move quickly through SQL basics and several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints with SQL schema statements Learn how datasets interact with queries; understand the importance of subqueries Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements
If you work with Oracle in any capacity, whether as a Java programmer, Database Administrator, or PL/SQL programmer, chances are good that you write SQL statements to query for data within the database. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, authors Sanjay Mishra and Alan Beaulieu share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications. Book jacket.
A practical, action-oriented book that is packed with solutions to problems that hundreds of thousands of businesses regularly face. In clear, nontechnical language, it tells readers precisely what steps to take and when to take them.
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.
The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you ho...
An inside look at the early years of Prince, presented through both iconic and never-before-seen images taken by the photographer who was at his side through it all.
The Next Thing: Art in the Twenty-first Century is a highly visual collection of essays about the future of art and the art of the future. This anthology brings together writings by world-renown theorists, artists, critics, novelists and philosophers, all of them engaged in current discussions about new and emerging artistic trends and sensibilities. From “post-human” installations, to transgenic experimentations, from tele-presence performance, to nano design, digital-fiction, virtual urbanism or “guerilla art”, new tendencies, are redefining both the boundaries of Meaning and what it means to be Human. The essays comprising The Next Thing identify the impact of these new trends and...
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch. In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. You'll learn how to: Connect to a server, issue queries, and retrieve results Retrieve data from the MySQL Server Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Assess the characteristics of a dataset Write stored functions and procedures Use stored routines, triggers, and scheduled events Perform basic MySQL administration tasks Understand MySQL monitoring fundamentals