SC - 1404 | The Modern Data Warehouse in Azure by Matt How

 

Gone are the days when data warehousing projects were lumbering dinosaur-style projects that took forever, drained budgets, and produced business intelligence (BI) just in time to tell you what to do 10 years ago. This book will show you how to assemble a data warehouse solution like a jigsaw puzzle by connecting specific Azure technologies that address your own needs and bring value to your business. 

You will see how to implement a range of architectural patterns using batches, events, and streams for both data lake technology and SQL databases. You will discover how to manage metadata and automation to accelerate the development of your warehouse while establishing resilience at every level. And you will know how to feed downstream analytic solutions such as Power BI and Azure Analysis Services to empower data-driven decision making that drives your business forward toward a pattern of success.

ID:  SC - 1404

Read More ...

SC - 1384 | Data Mashup with Microsoft Excel Using Power Query and M by Adam Aspin

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets.

Getting data into Excel is a prerequisite for using Excel’s analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources.

Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won’t want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world’s leading analytics tool.

 

What You Will Learn

• Connect to a range of external data, from databases to Azure sources
• Ingest data directly into your spreadsheets, or into PowerPivot data models
• Cleanse and prepare external data so it can be used inside Excel
• Refresh data quickly and easily to always have the latest information
• Transform data into ready-to-use structures that fit the spreadsheet format
• Execute M language functions for complex data transformations

 

Who This Book Is For

Excel users who want to access data from external sources―including the Microsoft Azure platform―in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs.

 

ID:  SC - 1384

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.

This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it's the book that holds all the secrets behind the mysteries of Access!

Build effective databases from the ground up
Simplify your data entry with forms and tables
Write queries that produce answers to your data questions
Simplify input with forms
There's no time like the present to get your hands on the insight that database beginners need to become Access gurus.

Categories: Computers\\Databases
Year: 2018
Edition: 1st
Publisher: For Dummies
Language: english
Pages: 432 / 435
ISBN 13: 9781119513261
ISBN: 111951326X

ID:  SC - 1305

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.

Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think “outside the box.”

In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation.
Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL.

Coverage includes:

• Getting started: understanding what relational databases are, and ensuring that your database structures are sound
• SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE
• Summarizing and grouping data with GROUP BY and HAVING clauses
• Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries
• Modifying data sets with UPDATE, INSERT, and DELETE statements
• Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more
• NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more
• NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data

Software-Independent Approach!

If you work with database software such as Access, MS SQL Server, Oracle, DB2, MySQL, Ingres, or any other SQL-based program, this book could save you hours of time and aggravation—before you write a single query!

Categories: Computers\\Databases
Year: 2018
Edition: 4
Publisher: Addison-Wesley Professional
Language: english
Pages: 960 / 959
ISBN 10: 0134858336
ISBN 13: 978-0134858333

ID:  SC - 1303

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.

Along the way, you’ll discover resilient distributed datasets (RDDs); use Spark SQL for structured data; and learn stream processing and build real-time applications with Spark Structured Streaming. Furthermore, you’ll learn the fundamentals of Spark ML for machine learning and much more.
After you read this book, you will have the fundamentals to become proficient in using Apache Spark and know when and how to apply it to your big data applications.

What You Will Learn

• Understand Spark unified data processing platform
• How to run Spark in Spark Shell or Databricks
• Use and manipulate RDDs
• Deal with structured data using Spark SQL through its operations and advanced functions
• Build real-time applications using Spark Structured Streaming
• Develop intelligent applications with the Spark Machine Learning library

Who This Book Is For

Programmers and developers active in big data, Hadoop, and Java but who are new to the Apache Spark platform.

Categories: Computers\\Databases
Year: 2018
Publisher: Apress
Language: english
Pages: 393 / 398
ISBN 10: 1484235789
ISBN 13: 9781484235782

ID:  SC - 1302

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.

While relational databases such as MySQL remain as relevant as ever, the alternative, NoSQL paradigm has opened up new horizons in performance and scalability and changed the way we approach data-centric problems. This book presents the essential concepts behind each database alongside hands-on examples that make each technology come alive.

With each database, tackle a real-world problem that highlights the concepts and features that make it shine. Along the way, explore five database models - relational, key/value, columnar, document, and graph - from the perspective of challenges faced by real applications. Learn how MongoDB and CouchDB are strikingly different, make your applications faster with Redis and more connected with Neo4J, build a cluster of HBase servers using cloud services such as Amazon's Elastic MapReduce, and more. This new edition brings a brand new chapter on DynamoDB, updated code samples and exercises, and a more up-to-date account of each database's feature set.

Whether you're a programmer building the next big thing, a data scientist seeking solutions to thorny problems, or a technology enthusiast venturing into new territory, you will find something to inspire you in this book.

What You Need:

You'll need a *nix shell (Mac OS or Linux preferred, Windows users will need Cygwin), Java 6 (or greater), and Ruby 1.8.7 (or greater). Each chapter will list the downloads required for that database.

Categories: Computers\\Databases
Year: 2018
Edition: 2
Publisher: Pragmatic Bookshelf
Language: english
Pages: 360 / 354
ISBN 10: 1680502530
ISBN 13: 9781680502534

ID:  SC - 1301

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.

Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results.

With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.

What You'll Learn:

• Create and populate your own database tables
• Read SQL queries and understand what they are doing
• Execute queries that get correct results
• Bring together related rows from multiple tables
• Group and sort data in support of reporting applications
• Get a grip on nulls, normalization, and other key concepts
• Employ subqueries, unions, and other advanced features

Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.

Categories: Computers\\Databases
Year: 2018
Edition: 1
Publisher: Apress
Language: english
Pages: 212 / 199
ISBN 10: 1484235754
ISBN 13: 9781484235751

ID:  SC - 1298

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.

Key features:

• Contains numerous practical screenshots of Oracle SQL, T-SQL, MySQL statements and results.
• Shows the differences between Oracle SQL, T-SQL and MySQL side by side.
• Gives a real world experience for SQL developers and database administrators.
• Sample data is available to work on (available on our website).

Categories: Computers\\Databases
Year: 2017
Edition: 1
Publisher: CRC Press
Language: english
Pages: 190 / 202
ISBN 10: 1351590375
ISBN 13: 9781351590372
ISBN: 113810518X

ID:  SC - 1304

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.

With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.

If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.

    Learn basic administration tasks such as role management, database creation, backup, and restore
    Apply the psql command-line utility and the pgAdmin graphical administration tool
    Explore PostgreSQL tables, constraints, and indexes
    Learn powerful SQL constructs not generally found in other databases
    Use several different languages to write database functions
    Tune your queries to run as fast as your hardware will allow
    Query external and variegated data sources with foreign data wrappers
    Learn how to use built-in replication to replicate data

Categories: Computers\\Databases
Year: 2017
Edition: 3
Publisher: O’Reilly Media
Language: english
Pages: 314 / 422
ISBN 10: 1491963417
ISBN 13: 9781491963418

ID:  SC - 1300

Read More ...

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.

If you are looking to design a database from scratch, you should read my first book Beginning Database Design .”

The final chapter in this book will outline a few common design problems you are likely to come across and give some advice about how to mitigate the impact or correct the problem.

Categories: Computers\\Databases
Year: 2017
Edition: 2
Publisher: apress
Language: english
Pages: 250
ISBN 10: 1484219546

ID:  SC - 1306

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.

Why this Book? Get Started Quickly. All challenges are based on AdventureWorks2012, Microsoft’s universally-accessible sample database. AdventureWorks is free to download and intuitive to explore. Solve Real Problems. Studying concepts is useful, but nothing accelerates skill faster than a hands-on, problem-solution approach. Learn by Example. Every challenge includes a fully documented solution. Lots of Helping Hands. Not sure how to begin? Each question includes a hint to set you in the right direction. Something for Everyone. Difficulty varies from challenge to challenge; it’s truly a mixed bag. Freshen your Technique. Solutions exhibit a wide range of functions and approaches, so you’re sure to find something new. Your Teaching Companion. Ready-to-go material for SQL tutors, trainers, and college professors. Preview of Challenges to Solve: Year over Year Comparisons: An executive requests data concerning fiscal quarter sales by salesperson. She'd like to see comparisons from the fiscal quarters of 2008 to the same fiscal quarters of 2007. Ten Million Dollar Benchmark: Ten million dollars of revenue is a common benchmark for Adventure Works. For each fiscal year (2007 and 2008) find the first dates when the cumulative running revenue total hit $10 million. Expired Credit Cards: The Accounting department found instances where expired credit cards were used with sales orders. You are asked examine all credit cards and report the extent of such activity. The Mentors: The Vice President of Sales wants the five most successful sales people to mentor the five least successful sales people. Create a list of sales people to match with one another.

Online/Offline: Create a summary table that shows, by territory, the percentage of orders placed online in comparison to orders not placed online. 

Solutions to challenge questions available for download. Details inside.

Year: 2015

Publisher: CreateSpace Independent Publishing Platform

Language: english

Pages: 197

ISBN 10: 1517290708

ID:  SC - 1297

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.

Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby.

With more than 200+ recipes, you’ll learn how to:

    Use the mysql client and write MySQL-based programs
    Create, populate, and select data from tables
    Store, retrieve, and manipulate strings
    Work with dates and times
    Sort query results and generate summaries
    Use stored routines, triggers, and scheduled events
    Import, export, validate, and reformat data
    Perform transactions and work with statistics
    Process web input, and generate web content from query results
    Use MySQL-based web session management
    Provide security and server administration

Categories: Computers\\Databases
Year: 2014
Edition: 3
Publisher: O'Reilly Media
Language: english
Pages: 866
ISBN 10: 1449374026
ISBN 13: 9781449374020

ID:  SC - 1299

Read More ...