SC - 1306 | Beginning SQL Queries

Clare Churcher

This book is for anyone who has a well-designed relational database and needs to extract information from it.
You might have noticed in the previous sentence that the database must be “well designed.”
I can’t overemphasize this point. If your database is badly designed, then it will not be able to store accurate and consistent data, and so the information your queries retrieve will always be prone to inaccuracies.

Read More

SC - 1305 | Access 2019 for Dummies

Laurie Ulrich Fuller, Ken Cook

Easy steps to practical databases.

People who really know how to build, populate, and simplify databases are few and far between. Access 2019 For Dummiesis here to help you join the ranks of office heroes who possess these precious skills.

Read More

SC - 1304 | Practical guide to Oracle SQL, T-SQL and MySQL

Preston Zhang

SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users to write queries that apply complex conditions on a table. The book's unique side by side approach makes it easy for the reader to learn three major query languages in the IT industry. The author has over 20 years of experience in database design.

Read More

SC - 1303 | SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

John L. Viescas

The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions

Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.
Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.

Read More

SC - 1302 | Beginning Apache Spark 2: With Resilient Distributed Datasets, Spark SQL, Structured Streaming and Spark Machine Learning library

Hien Luu

Develop applications for the big data landscape with Spark and Hadoop. This book also explains the role of Spark in developing scalable machine learning and analytics applications with Cloud technologies. Beginning Apache Spark 2 gives you an introduction to Apache Spark and shows you how to work with it.

Read More

SC - 1301 | Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement

Luc Perkins, Eric Redmond, Jim Wilson

Data is getting bigger and more complex by the day, and so are your choices in handling it. Explore some of the most cutting-edge databases available - from a traditional relational database to newer NoSQL approaches - and make informed decisions about challenging data storage problems. This is the only comprehensive guide to the world of NoSQL databases, with in-depth practical and conceptual introductions to seven different technologies: Redis, Neo4J, CouchDB, MongoDB, HBase, Postgres, and DynamoDB. This second edition includes a new chapter on DynamoDB and updated content for each chapter.

Read More

SC - 1300 | PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

Regina O. Obe, Leo S. Hsu

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.

Read More

SC - 1299 | MySQL Cookbook: Solutions for Database Developers and Administrators

Paul DuBois

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. 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 solve MySQL problems from scratch.

Read More

SC - 1298 | SQL Primer: An Accelerated Introduction to SQL Basics

Rahul Batra

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter.

Read More

SC - 1297 | Real SQL Queries: 50 Challenges

Brian Cohen, Neil Pepi, Neerja Mishra, Haley DeLeon

Sharpen your SQL Skill with Real-World Practice. 

Queries improve when challenges are authentic. This book sets your learning on the fast track with realistic problems to solve. Topics span sales, marketing, human resources, purchasing, and production. Real SQL Queries: 50 Challenges is perfect for analysts, report writers, or anyone searching for a hands-on approach to learning SQL Server.

Read More