talk-data.com talk-data.com

Topic

SQL

Structured Query Language (SQL)

database_language data_manipulation data_definition programming_language

82

tagged

Activity Trend

107 peak/qtr
2020-Q1 2026-Q1

Activities

Showing filtered results

Filtering by: O'Reilly Data Science Books ×
Scala: Guide for Data Science Professionals

Scala will be a valuable tool to have on hand during your data science journey for everything from data cleaning to cutting-edge machine learning About This Book Build data science and data engineering solutions with ease An in-depth look at each stage of the data analysis process — from reading and collecting data to distributed analytics Explore a broad variety of data processing, machine learning, and genetic algorithms through diagrams, mathematical formulations, and source code Who This Book Is For This learning path is perfect for those who are comfortable with Scala programming and now want to enter the field of data science. Some knowledge of statistics is expected. What You Will Learn Transfer and filter tabular data to extract features for machine learning Read, clean, transform, and write data to both SQL and NoSQL databases Create Scala web applications that couple with JavaScript libraries such as D3 to create compelling interactive visualizations Load data from HDFS and HIVE with ease Run streaming and graph analytics in Spark for exploratory analysis Bundle and scale up Spark jobs by deploying them into a variety of cluster managers Build dynamic workflows for scientific computing Leverage open source libraries to extract patterns from time series Master probabilistic models for sequential data In Detail Scala is especially good for analyzing large sets of data as the scale of the task doesn’t have any significant impact on performance. Scala’s powerful functional libraries can interact with databases and build scalable frameworks — resulting in the creation of robust data pipelines. The first module introduces you to Scala libraries to ingest, store, manipulate, process, and visualize data. Using real world examples, you will learn how to design scalable architecture to process and model data — starting from simple concurrency constructs and progressing to actor systems and Apache Spark. After this, you will also learn how to build interactive visualizations with web frameworks. Once you have become familiar with all the tasks involved in data science, you will explore data analytics with Scala in the second module. You’ll see how Scala can be used to make sense of data through easy to follow recipes. You will learn about Bokeh bindings for exploratory data analysis and quintessential machine learning with algorithms with Spark ML library. You’ll get a sufficient understanding of Spark streaming, machine learning for streaming data, and Spark graphX. Armed with a firm understanding of data analysis, you will be ready to explore the most cutting-edge aspect of data science — machine learning. The final module teaches you the A to Z of machine learning with Scala. You’ll explore Scala for dependency injections and implicits, which are used to write machine learning algorithms. You’ll also explore machine learning topics such as clustering, dimentionality reduction, Naïve Bayes, Regression models, SVMs, neural networks, and more. This learning path combines some of the best that Packt has to offer into one complete, curated package. It includes content from the following Packt products: Scala for Data Science, Pascal Bugnion Scala Data Analysis Cookbook, Arun Manivannan Scala for Machine Learning, Patrick R. Nicolas Style and approach A complete package with all the information necessary to start building useful data engineering and data science solutions straight away. It contains a diverse set of recipes that cover the full spectrum of interesting data analysis tasks and will help you revolutionize your data analysis skills using Scala. Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the code file.

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition

Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information includes retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code. The reference information includes statements, dictionary components, and system options.

Pro Tableau: A Step-by-Step Guide

Leverage the power of visualization in business intelligence and data science to make quicker and better decisions. Use statistics and data mining to make compelling and interactive dashboards. This book will help those familiar with Tableau software chart their journey to being a visualization expert. Pro Tableau demonstrates the power of visual analytics and teaches you how to: Connect to various data sources such as spreadsheets, text files, relational databases (Microsoft SQL Server, MySQL, etc.), non-relational databases (NoSQL such as MongoDB, Cassandra), R data files, etc. Write your own custom SQL, etc. Perform statistical analysis in Tableau using R Use a multitude of charts (pie, bar, stacked bar, line, scatter plots, dual axis, histograms, heat maps, tree maps, highlight tables, box and whisker, etc.) What you'll learn Connect to various data sources such as relational databases (Microsoft SQL Server, MySQL), non-relational databases (NoSQL such as MongoDB, Cassandra), write your own custom SQL, join and blend data sources, etc. Leverage table calculations (moving average, year over year growth, LOD (Level of Detail), etc. Integrate Tableau with R Tell a compelling story with data by creating highly interactive dashboards Who this book is for All levels of IT professionals, from executives responsible for determining IT strategies to systems administrators, to data analysts, to decision makers responsible for driving strategic initiatives, etc. The book will help those familiar with Tableau software chart their journey to a visualization expert.

Big Data Analytics with R

Unlock the potential of big data analytics by mastering R programming with this comprehensive guide. This book takes you step-by-step through real-world scenarios where R's capabilities shine, providing you with practical skills to handle, process, and analyze large and complex datasets effectively. What this Book will help me do Understand the latest big data processing methods and how R can enhance their application. Set up and use big data platforms such as Hadoop and Spark in conjunction with R. Utilize R for practical big data problems, such as analyzing consumption and behavioral datasets. Integrate R with SQL and NoSQL databases to maximize its versatility in data management. Discover advanced machine learning implementations using R and Spark MLlib for predictive analytics. Author(s) None Walkowiak is an experienced data analyst and R programming expert with a passion for data engineering and machine learning. With a deep knowledge of big data platforms and extensive teaching experience, they bring a clear and approachable writing style to help learners excel. Who is it for? Ideal for data analysts, scientists, and engineers with fundamental data analysis knowledge looking to enhance their big data capabilities using R. If you aim to adapt R for large-scale data management and analysis workflows, this book is your ideal companion to bridge the gap.

Mastering the SAS DS2 Procedure

Enhance your SAS® data wrangling skills with high precision and parallel data manipulation using the new DS2 programming language.

This book addresses the new DS2 programming language from SAS, which combines the precise procedural power and control of the Base SAS DATA step language with the simplicity and flexibility of SQL. DS2 provides simple, safe syntax for performing complex data transformations in parallel and enables manipulation of native database data types at full precision. It also introduces PROC FEDSQL, a modernized SQL language that blends perfectly with DS2. You will learn to harness the power of parallel processing to speed up CPU-intensive computing processes in Base SAS and how to achieve even more speed by processing DS2 programs on massively parallel database systems. Techniques for leveraging Internet APIs to acquire data, avoiding large data movements when working with data from disparate sources, and leveraging DS2’s new data types for full-precision numeric calculations are presented, with examples of why these techniques are essential for the modern data wrangler.

While working through the code samples provided with this book, you will build a library of custom, reusable, and easily shareable DS2 program modules, execute parallelized DATA step programs to speed up a CPU-intensive process, and conduct advanced data transformations using hash objects and matrix math operations.

SAS 9.4 SQL Procedure User's Guide, Third Edition, 3rd Edition

Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information includes retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code. The reference information includes statements, dictionary components, and system options.

Sharpening Your Advanced SAS Skills

This guide presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. It empowers both advanced programmers who need a quick refresher and programmers interested in learning new techniques. It shows how to take advantage of the latest SAS options and new SAS procedures. The book illustrates syntax with simple, common task-oriented examples and prepares readers for the advanced SAS certification exam. Mindmaps and process flowcharts are available on the author's website.

Beginning Big Data with Power BI and Excel 2013

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft’s Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps. While Beginning Big Data with Power BI and Excel 2013 covers prominent tools such as Hadoop and the NoSQL databases, it recognizes that most small and medium-sized businesses don’t have the Big Data processing needs of a Netflix, Target, or Facebook. Instead, it shows how to import data and use the self-service analytics available in Excel with Power BI. As you’ll see through the book’s numerous case examples, these tools—which you already know how to use—can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects. Through instruction, insight, advice, and case studies, Beginning Big Data with Power BI and Excel 2013 will show you how to: Import and mash up data from web pages, SQL and NoSQL databases, the Azure Marketplace and other sources. Tap into the analytical power of PivotTables and PivotCharts and develop relational data models to track trends and make predictions based on a wide range of data. Understand basic statistics and use Excel with PowerBI to do sophisticated statistical analysis—including identifying trends and correlations. Use SQL within Excel to do sophisticated queries across multiple tables, including NoSQL databases. Create complex formulas to solve real-world business problems using Data Analysis Expressions (DAX).

SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information includes retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code. The reference information includes statements, dictionary components, and system options.

Computer Science Illuminated, 6th Edition

Each new print copy includes Navigate 2 Advantage Access that unlocks a comprehensive and interactive eBook, student practice activities and assessments, a full suite of instructor resources, and learning analytics reporting tools.

Fully revised and updated, the Sixth Edition of the best-selling text Computer Science Illuminated retains the accessibility and in-depth coverage of previous editions, while incorporating all-new material on cutting-edge issues in computer science. Authored by the award-winning Nell Dale and John Lewis, Computer Science Illuminated’s unique and innovative layered approach moves through the levels of computing from an organized, language-neutral perspective.

Designed for the introductory computing and computer science course, this student-friendly Sixth Edition provides students with a solid foundation for further study, and offers non-majors a complete introduction to computing.

Key Features of the Sixth Edition include:

Access to Navigate 2 online learning materials including a comprehensive and interactive eBook, student practice activities and assessments, learning analytics reporting tools, and more
Completely revised sections on HTML and CSS
Updates regarding Top Level Domains, Social Networks, and Google Analytics
All-new section on Internet management, including ICANN control and net neutrality 
New design, including fully revised figures and tables
New and updated Did You Know callouts are included in the chapter margins
New and revised Ethical Issues and Biographies throughout emphasize the history and breadth of computing
Available in our customizable PUBLISH platform

A collection of programming language chapters are available as low-cost bundling options. Available chapters include: Java, C++, Python, Alice, SQL, VB.NET, RUBY, Perl, Pascal, and JavaScript.

With Navigate 2, technology and content combine to expand the reach of your classroom. Whether you teach an online, hybrid, or traditional classroom-based course, Navigate 2 delivers unbeatable value. Experience Navigate 2 today at www.jblnavigate.com/2

Automated Data Collection with R: A Practical Guide to Web Scraping and Text Mining

A hands on guide to web scraping and text mining for both beginners and experienced users of R Introduces fundamental concepts of the main architecture of the web and databases and covers HTTP, HTML, XML, JSON, SQL. Provides basic techniques to query web documents and data sets (XPath and regular expressions). An extensive set of exercises are presented to guide the reader through each technique. Explores both supervised and unsupervised techniques as well as advanced techniques such as data scraping and text management. Case studies are featured throughout along with examples for each technique presented. R code and solutions to exercises featured in the book are provided on a supporting website.

Visio Services Quick Guide: Using Visio with Sharepoint 2013 and Office 365

In this fast-paced 100-page guide, you’ll learn to load, display and interact with dynamic, data-powered Visio diagrams in SharePoint 2013 or Office 365. Visio Services Quick Guide gives you the tools to build anything from a simple project workflow to an organizational infrastructure diagram, powered by real data from SharePoint or SQL Server. Colleagues can load your diagrams entirely in the browser, meaning that a single Visio client installation is enough to get started. Readers with JavaScript experience will also find out how to get additional control over Visio diagrams using the JavaScript mashup API, and how to build a custom data provider. The final chapter covers some useful information on administering Visio Services. Get started bringing your Visio diagrams to life with the Visio Services Quick Guide.

Create Web Charts with D3

Create Web Charts with D3 shows how to convert your data into eye-catching, innovative, animated, and highly interactive browser-based charts. This book is suitable for developers of all experience levels and needs: if you want power and control and need to create data visualization beyond traditional charts, then D3 is the JavaScript library for you. By the end of the book, you will have a good knowledge of all the elements needed to manage data from every possible source, from high-end scientific instruments to Arduino boards, from PHP SQL databases queries to simple HTML tables, and from Matlab calculations to reports in Excel. This book contains content previously published in Beginning JavaScript Charts. Create all kinds of charts using the latest technologies available on browsers Full of step-by-step examples, Create Web Charts with D3 introduces you gradually to all aspects of chart development, from the data source to the choice of which solution to apply. This book provides a number of tools that can be the starting point for any project requiring graphical representations of data, whether using commercial libraries or your own

SAS Certification Prep Guide, 4th Edition
Businesses rely on career professionals with strong SAS knowledge and skills. Set yourself apart from the competition by earning the only globally recognized credential endorsed by SAS.

The SAS Certification Prep Guide: Advanced Programming for SAS 9, Fourth Edition, prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs, as well as a new chapter on creating functions with PROC FCMP. You will also become familiar with the enhancements and new functionality that are available in SAS 9.

New or experienced SAS users will find this guide to be an invaluable resource that covers the objectives tested on the exam. The text contains quizzes that enable you to test your understanding of material in each chapter. Quiz solutions are included at the end of the book. Candidates must earn the SAS Certified Base Programmer for SAS 9 Credential before taking the SAS Advanced Programming for SAS 9 exam.

You’ll find instructions on how to obtain sample data when accessing SAS through SAS Enterprise Guide, SAS Studio, SAS University Edition, and the SAS windowing environment. This edition provides significant improvements to numerous examples, making the code even more efficient.

Experience is a critical component to becoming a SAS Certified Professional. This comprehensive guide along with training in SAS SQL1, SAS Macro Language 1, and SAS Programming 3 are valuable resources designed to help you prepare for the Advanced SAS Certification exam.

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide introduces you to Microsoft's BI tools and systems. You'll gain hands-on experience building solutions that handle data warehousing, reporting, and predictive analytics. With step-by-step tutorials, you'll be equipped to transform data into actionable insights. What this Book will help me do Understand and implement multidimensional data models using SSAS and MDX. Write and use DAX queries and leverage SSAS tabular models effectively. Improve and maintain data integrity using MDS and DQS tools. Design and develop polished, insightful dashboards and reports using PerformancePoint, Power View, and SSRS. Explore advanced data analysis features, such as Power Query, Power Map, and basic data mining techniques. Author(s) Abolfazl Radgoudarzi and Reza Rad are experienced practitioners and educators in the field of business intelligence. They specialize in SQL Server BI technologies and have extensive careers helping organizations harness data for decision-making. Their approach combines clear explanations with practical examples, ensuring readers can effectively apply what they learn. Who is it for? This book is ideal for database developers, system analysts, and IT professionals looking to build strong foundations in Microsoft SQL Server's BI technologies. Beginners in business intelligence or data management will find the topics accessible. Intermediate practitioners will expand their ability to build complete BI solutions. It's designed for anyone eager to develop skills in data modeling, analysis, and visualization.

2013 Data Science Salary Survey

What tools do successful data scientists and analysts use, and how much money do they make? We surveyed hundreds of attendees at the O'Reilly Strata Conferences in Santa Clara, California and New York to understand. Findings from the survey include: Average number of tools and median income for all respondents Distribution of responses by age, location, industry, and position Detailed analysis of tools used by respondents and correlation to their salaries - including by tool clusters (Hadoop, SQL/Excel, and other) Correlation of specialized big data tools usage and salary What tools should you be learning and using? Read this valuable report to gain insight from these potentially career-changing findings.

PROC SQL: Beyond the Basics Using SAS, Second Edition

Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful "Summary" that precede each chapter to look for help on a specific topic.

The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language using discussion and numerous real-world examples.

This book is part of the SAS Press program.

Segmentation and Lifetime Value Models Using SAS

Help your organization determine the value of its customer relationships with Segmentation and Lifetime Value Models Using SAS. This book contains a wealth of information that will help you perform analyses to identify your customers and make informed marketing investments. It answers core questions on customer relationship management (CRM), provides an overall framework for thinking about CRM, and offers real-world examples across a variety of industries.

Edward C. Malthouse introduces you to a number of useful models, ranging from simple to more complicated examples, and discusses their applications. You'll learn about segmentation models for identifying groups of customers and about lifetime value models for estimating the future value of the segments. You'll learn how to prepare data and estimate models using Base SAS, SAS/STAT, SAS/IML, and SQL.

Marketing analysts, CRM analysts, database managers, and anyone looking to address the challenges of allocating marketing resources to different customer groups will benefit from the concepts and exercises in this book. Analysts will learn how to approach unique business problems. Managers will gain a sense of what's possible and what to ask of their analytics departments.

This book is part of the SAS Press program.

Microsoft Excel 2013: Building Data Models with PowerPivot

Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®

SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition

Prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. You will also become familiar with the enhancements and new functionality that are available in SAS 9.