Databaser

Data is at the center of many challenges in system design today. Difficult issues such as scalability, consistency, reliability, efficiency, and maintainability need to be resolved. In addition, there's an overwhelming variety of tools and analytical systems, including relational databases, NoSQL datastores, plus data warehouses and data lakes. What are the right choices for your application? How do you make sense of all these buzzwords?In this second edition, authors Martin Kleppmann and Chris Riccomini build on the foundation laid in the acclaimed first edition, integrating new technologies and emerging trends. You'll be guided through the maze of decisions and trade-offs involved in building a modern data system, from choosing the right tools like Spark and Flink to understanding the intricacies of data laws like the GDPR.Peer under the hood of the systems you already use, and learn to use them more effectivelyMake informed decisions by identifying the strengths and weaknesses of different toolsNavigate the trade-offs around consistency, scalability, fault tolerance, and complexityUnderstand the distributed systems research upon which modern databases are builtPeek behind the scenes of major online services, and learn from their architectures

International bestseller with over half a million copies sold!Celebrate a decade of data storytelling with this special 10th anniversary edition of Storytelling with Data. Featuring refreshed visuals, expanded content, and new insights, this collector's edition builds on the classic's foundational lessons, empowering you to craft persuasive data stories.Don't simply show your data—tell a story with it!Storytelling with Data teaches you the fundamentals of data visualization and how to communicate effectively with data. You'll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examples—ready for immediate application to your next graph or presentation.Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal don't make it any easier. This book demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.Specifically, you'll learn how to: Understand the importance of context and audienceDetermine the appropriate type of graph for your situationRecognize and eliminate the clutter clouding your informationDirect your audience's attention to the most important parts of your dataThink like a designer and utilize concepts of design in data visualizationLeverage the power of storytelling to help your message resonate with your audienceTogether, the lessons in this book will help you turn your data into high impact visual stories that stick with your audience. Rid your world of ineffective graphs, one exploding 3D pie chart at a time. There is a story in your data—Storytelling with Data will give you the skills and power to tell it.

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligenceBegins with fundamental design recommendations and progresses through increasingly complex scenariosPresents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and moreDesign dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

**From BBC presenter and journalist Ros Atkins, creator of the viral 'Ros Atkins on...' explainer videos and host of the forthcoming BBC Radio 4 podcast 'Communicating with Ros Atkins'**'A great read for polishing your communication skills' FORBES 'For all those who want their audiences to listen and understand' JEREMY BOWEN 'Precision, deftness and a calming expertise' THE TIMES Do you worry about holding people's attention during presentations?Are you unsure where to start when faced with writing an essay or report?Are you preparing for an interview and wondering how to get all your points across?Explanation - identifying and communicating what we want to say - is an art. And the BBC presenter and journalist Ros Atkins, creator of the viral 'Ros Atkins on...' explainer videos, is something of a master of the form. In this book, Ros shares the secrets he has learned from years of working in high-pressure newsrooms, identifying the ten elements of a good explanation and the seven steps you need to take to express yourself with clarity and impact.Whether at work, school, university or home, we all benefit from being able to articulate ourselves clearly. Filled with practical examples, The Art of Explanation is a must-read for anyone who wants to sharpen their communication skills.

Denna bok ger en introduktion till relationsdatabaser och en pedagogiskt upplagd genomgång av SQL-språket. Syftet är att förmedla kunskaper som behövs för att någorlunda kunna förstå en databas uppbyggnad och för att kunna ställa frågor mot databasen. Boken kan användas som kurslitteratur på databaskurser eller som en självstudiebok. Förftattarna är lärare vid högskolan i Luleå och har mångårig erfarenhet av undervisning i relationsdatabaser och SQL-språket.

Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contentsBuilding formulas with Excel table objects, correcting common formula errors and using formula variablesWorking with data series, changing basic chart elements and making use of chart customizationLoading data from other sources, performing common transformations and applying conditional logicMicrosoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.

Winner of the 2019 International Cartographic Conference – Educational Products awardA lavishly illustrated reference guide, Cartography. by Kenneth Field is an inspiring and creative companion along the nonlinear journey toward making a great map. This sage compendium for contemporary mapmakers distills the essence of cartography into useful topics, organized for convenience in finding the specific idea or method you need. Unlike books targeted to deep scholarly discourse of cartographic theory, this book provides sound, visually compelling information that translates into practical and useful tools for modern mapmaking. At the intersection of science and art, this book serves as a guidepost for designing an accurate and effective map.

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you will learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available in the framework of the data engineering lifecycle. Authors Joe Reis and Matt Housley walk you through the data engineering lifecycle and show you how to stitch together a variety of cloud technologies to serve the needs of downstream data consumers. You will understand how to apply the concepts of data generation, ingestion, orchestration, transformation, storage, governance, and deployment that are critical in any data environment regardless of the underlying technology. This book will help you: Assess data engineering problems using an end-to-end data framework of best practices Cut through marketing hype when choosing data technologies, architecture, and processes Use the data engineering lifecycle to design and build a robust architecture Incorporate data governance and security across the data engineering lifecycle

Databasteknik används nästan överallt i dag där data behöver lagras och bearbetas. Allt från webbplatser till mobilappar lagrar sina data i databaser. Databaser har därför blivit ett av de områden inom datatekniken som man har störst nytta av att kunna, vare sig man är användare, datatekniker eller programmerare.Boken Databasteknik börjar med grunderna om databaser, som scheman, datamodellering och användningsområden för databaser. Vi går vidare bland annat med frågespråk, transaktionshantering, säkerhet, prestanda och hur databashanteraren arbetar internt.Den vanligaste och populäraste typen av databaser är relations­databaser, och tyngdpunkten ligger därför på dem, bland annat med frågespråket SQL, och vi beskriver system som MySQL, PostgreSQL och Microsoft SQL Server. Men vi vänder oss till alla som arbetar med databaser, även till exempel objektorienterade databaser och NoSQL-databaser.

Transform your data analysis experience with Power Query, the ultimate tool for importing, reshaping, and cleansing data through a user-friendly interface. Whether you're using Power BI, Excel, or other Microsoft products, Power Query's capabilities are at your fingertips. Renowned Power Query experts Daniil Maslyuk and Gil Raviv guide you through mastering this indispensable tool, helping you eliminate tedious manual data preparation, tackle common issues, and avoid potential pitfalls. In this updated edition, you'll delve into comprehensive analytics challenges, seamlessly integrating your skills into a realistic, final project. By the end, you'll possess the expertise to handle any data and convert it into actionable insights.

You will learn how to:

Effortlessly prepare data by utilizing Power Query in Power BI and Excel to transform your data quickly and efficiently Overcome common data preparation problems with intuitive mouse clicks and straightforward formula edits Combine data from various sources, multiple queries, and mismatched tables with ease Reshape tables to suit your analysis needs Use the Power Query M formula language to create flexible data mashups and tailor transformations to your requirements Address and overcome collaboration challenges by using Power Query's powerful features Gain crucial insights from text feeds by enhancing your data analysis capabilities Profile data, diagnose queries, improve query performance, and more!

About This Book

For everyone who wants to get more done with Power Query in less time For business and financial professionals, developers, entrepreneurs, students, and others who need to efficiently manage and analyze data

Learn to research, plan, design, and test the UX of AI-powered products Unlock the future of design with UX for AI—your indispensable guide to not only surviving but thriving in a world powered by artificial intelligence. Whether you're a seasoned UX designer or a budding design student, this book offers a lifeline for navigating the new normal, ensuring you stay relevant, valuable, and indispensable to your organization. In UX for AI: A Framework for Designing AI-Driven Products, Greg Nudelman—a seasoned UX designer and AI strategist—delivers a battle-tested framework that helps you keep your edge, thrive in your design job, and seize the opportunities AI brings to the table. Drawing on insights from 35 real-world AI projects and acknowledging the hard truth that 85% of AI initiatives fail, this book equips you with the practical skills you need to reverse those odds. You'll gain powerful tools to research, plan, design, and test user experiences that seamlessly integrate human-AI interactions. From practical design techniques to proven user research methods, this is the essential guide for anyone determined to create AI products that not only succeed but set new standards of value and impact. Inside the book: Hands-on exercises: Build your confidence and skills with practice UX design tasks like Digital Twin and Value Matrix, which you can immediately apply to your own AI projects.Common AI patterns and best practices: Explore design strategies for LLMs (Large Language Models), search engines, copilots, and more.Proven user research strategies: Learn how to uncover user needs and behaviors in this brave new world of AI-powered design.Real-world case studies: See how simple, practical UX approaches have prevented multimillion-dollar failures and unlocked unprecedented value.Perfect for any UX designer working with AI-enabled and AI-driven products, UX for AI is also a must-read resource for designers-in-training and design students with an interest in artificial intelligence and contemporary design.

A fast, up-to-date, and convenient desk reference for Excel users of any skill level Drawn from the most important tasks in the latest bestselling Excel Bible , Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet program, from functions to charts, graphs, formulas and more. Prepare for a whirlwind tour of Excel, packed with simple and step-by-step guides to common and lesser-known Excel features. This book shows you how to: Create new spreadsheets and workbooks by entering and editing worksheet dataSimplify working with large amounts of data by naming and moving rangesMake calculations and draw conclusions from your data by using formulasVisualize and present your data by creating functional chartsThe secret weapon in your productivity arsenal Being great at Excel is quickly becoming a standard expectation for a ton of employers and organizations, in all sorts of industries. Sharpening your skills can boost your workplace performance and make it easier to land promotions or find new roles. Excel Quick and Easy makes it a breeze to develop the proficiencies that help you stand out from your peers. Unique features of this book Step-by-step guides to the most commonly used and productive Excel tasks, from basic worksheet operations to formatting spreadsheets for hardcopy printingIntuitive explanations for making your data tell a compelling story with visualizations, including charts, graphs, and tablesAdvanced number-crunching techniques, including formulas and functions, that help you unlock fresh insights and new conclusions from your dataExcel Quick and Easy is the perfect reference for brand-new Excel users trying to get up-to-speed quickly and confidently. It's also a must-read for anyone migrating from another spreadsheet program, like Google Sheets, or more experienced Excel users who need to solidify and improve their skills. If you're tired of stumbling through your spreadsheets and just “surviving” in Excel, grab a copy of Excel Quick and Easy and supercharge your productivity. You'll refine your understanding of the basics, learn brand-new skills and features, and become the Excel expert that every office desperately needs.

Learn how to use R to turn data into insight, knowledge, and understanding. Ideal for current and aspiring data scientists, this book introduces you to doing data science with R and RStudio, as well as the tidyverse-a collection of R packages designed to work together to make data science fast, fluent, and fun. Even if you have no programming experience, this updated edition will have you doing data science quickly.You'll learn how to import, transform, and visualize your data and communicate the results. And you'll get a complete, big-picture understanding of the data science cycle and the basic tools you need to manage the details. Each section in this edition includes exercises to help you practice what you've learned along the way.Updated for the latest tidyverse best practices, new chapters dive deeper into visualization and data wrangling, show you how to get data from spreadsheets, databases, and websites, and help you make the most of new programming tools.You'll learn how to:Visualize-create plots for data exploration and communication of resultsTransform-discover types of variables and the tools you can use to work with themImport-get data into R and in a form convenient for analysisProgram-learn R tools for solving data problems with greater clarity and easeCommunicate-integrate prose, code, and results with Quarto

Enterprises have made amazing advances by taking advantage of data about their business to provide predictions and understanding of their customers, markets, and products. But as the world of business becomes more interconnected and global, enterprise data is no long a monolith; it is just a part of a vast web of data. Managing data on a world-wide scale is a key capability for any business today.The Semantic Web treats data as a distributed resource on the scale of the World Wide Web, and incorporates features to address the challenges of massive data distribution as part of its basic design. The aim of the first two editions was to motivate the Semantic Web technology stack from end-to-end; to describe not only what the Semantic Web standards are and how they work, but also what their goals are and why they were designed as they are. It tells a coherent story from beginning to end of how the standards work to manage a world-wide distributed web of knowledge in a meaningful way.The third edition builds on this foundation to bring Semantic Web practice to enterprise. Fabien Gandon joins Dean Allemang and Jim Hendler, bringing with him years of experience in global linked data, to open up the story to a modern view of global linked data. While the overall story is the same, the examples have been brought up to date and applied in a modern setting, where enterprise and global data come together as a living, linked network of data. Also included with the third edition, all of the data sets and queries are available online for study and experimentation at data.world/swwo.

This highly regarded textbook provides the definitive account of Customer Relationship Management (CRM) concepts, applications, and technologies, focusing on how companies can create and maintain mutually beneficial relationships with customers.Readers will gain a thorough understanding of the conceptual foundations of CRM, see CRM in practice through illustrative case examples and exercises, and understand how to organise customer data gathering, analysis, and presentation for decision making. The book achieves these outcomes by first considering strategic CRM before moving into operational CRM and, finally, onto analytical aspects of CRM. The fifth edition has been fully updated to include:A series of new case examples to illustrate CRM within various regional and industrial contexts, including those relevant to large, medium, and small enterprisesA series of new exercises and discussion questions to help readers understand CRM concepts and to support pedagogical processes, particularly in higher education environmentsA greater emphasis on managerial applications of CRM through new content to help guide managersAn updated account of new and emerging technologies relevant to CRMExpanded coverage of customer experience (CX), customer engagement (CE), and customer journey management (CJM)Customer Relationship Management is essential reading for advanced undergraduate and postgraduate students studying CRM, Sales Management, Customer Experience Management, and Relationship Marketing, as well as executives who oversee CRM functions. Online resources include an Instructor’s Manual, chapter-by-chapter PowerPoint slides, and a bank of exam questions.

This textbook is aimed at readers who have little or no knowledge of computer programming but want to learn to program in Python. It starts from the very basics including how to install your Python environment, how to write a very simple program and run it, what a variable is, what an if statement is, how iteration works using for and while loops as well as important key concepts such as functions, classes and modules. Each subject area is prefaced with an introductory chapter, before continuing with how these ideas work in Python.The second edition has been completely updated for the latest versions of Python including Python 3.11 and Python 3.12. New chapters have been added such as those that consider where and how Python is used, the use of Frozensets, how data can be sorted, enumerated types in Python, structural pattern matching and how (and why) Python Virtual Environments are configured. A new chapter ‘The Python Bites back’ is introduced to present the fourteen most common / biggest gotchas for someone new to Python. Other sections have been updated with new features such as Exception Groups, string operations and dictionary operations.A Beginners Guide to Python 3 Programming second Edition provides all you need to know about Python, with numerous examples provided throughout including several larger worked case studies illustrating the ideas presented in the previous chapters.

Get the definitive handbook for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.10 and pandas 1.4, the third edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You'll learn the latest versions of pandas, NumPy, and Jupyter in the process.Written by Wes McKinney, the creator of the Python pandas project, this book is a practical, modern introduction to data science tools in Python. It's ideal for analysts new to Python and for Python programmers new to data science and scientific computing. Data files and related material are available on GitHub.Use the Jupyter notebook and IPython shell for exploratory computingLearn basic and advanced features in NumPyGet started with data analysis tools in the pandas libraryUse flexible tools to load, clean, transform, merge, and reshape dataCreate informative visualizations with matplotlibApply the pandas groupby facility to slice, dice, and summarize datasetsAnalyze and manipulate regular and irregular time series dataLearn how to solve real-world data analysis problems with thorough, detailed examples

This text provides a mathematically rigorous introduction to modern methods of machine learning and data analysis at the advanced undergraduate/beginning graduate level. The book is self-contained and requires minimal mathematical prerequisites. There is a strong focus on learning how and why algorithms work, as well as developing facility with their practical applications. Apart from basic calculus, the underlying mathematics — linear algebra, optimization, elementary probability, graph theory, and statistics — is developed from scratch in a form best suited to the overall goals.  In particular, the wide-ranging linear algebra components are unique in their ordering and choice of topics, emphasizing those parts of the theory and techniques that are used in contemporary machine learning and data analysis.  The book will provide a firm foundation to the reader whose goal is to work on applications of machine learning and/or research into the further development of this highly active field of contemporary applied mathematics.To introduce the reader to a broad range of machine learning algorithms and how they are used in real world applications, the programming language Python is employed and offers a platform for many of the computational exercises. Python notebooks complementing various topics in the book are available on a companion GitHub site specified in the Preface, and can be easily accessed by scanning the QR codes or clicking on the links provided within the text. Exercises appear at the end of each section, including basic ones designed to test comprehension and computational skills, while others range over proofs not supplied in the text, practical computations, additional theoretical results, and further developments in the subject.  The Students’ Solutions Manual may be accessed from GitHub. Instructors may apply for access to the Instructors’ Solutions Manual from the link supplied on the text’s Springer website.The book can be used in a junior or senior level course for students majoring in mathematics with a focus on applications as well as students from other disciplines who desire to learn the tools of modern applied linear algebra and optimization. It may also be used as an introduction to fundamental techniques in data science and machine learning for advanced undergraduate and graduate students or researchers from other areas, including statistics, computer science, engineering, biology, economics and finance, and so on.

Join the millions of people already using Microsoft Access and become a database power-user in no time! In the newly revised edition of Microsoft Access For Dummies, professional database developer and Access extraordinaire Laurie Ulrich-Fuller walks you through the ins-and-outs of one of the world's most popular database platforms. This is the perfect beginner's guide to Microsoft Access, showing you how to create databases, extract data, create reports, and more. The author demonstrates a ton of tips, tricks, and best practices you can use immediately to create, maintain, and improve your databases. You'll also find: Updates outlining edge browser controls in formsStep-by-step guides explaining how to import, export, and edit dataEasy-to-follow query-writing tutorials to help you find the exact data you're looking for when you need itWhether you're a database novice or a data science whiz, Microsoft Access For Dummies has the info you need to supercharge your database skills. It's the perfect, how-to guide to get you up-to-speed on everything you need to know to get started with Microsoft's world-famous database app.

Polisens brottsdatalag utgör en central del av det rättsliga ramverk som styr hur personuppgifter får behandlas inom brottsbekämpande verksamhet. Den befinner sig i skärningspunkten mellan EU-rätt och nationell lagstiftning, där dataskyddsförordningen och brottsdatadirektivet sätter de övergripande ramarna, medan svenska registerlagar konkretiserar tillämpningen.

I denna kommentar ges en klar och pedagogisk genomgång av hur regelverket hänger ihop och fungerar i praktiken. Med brottsdatalagen (2018:1177) som generell ram och lagen (2018:1693) om polisens behandling av personuppgifter som ett verksamhetsanpassat komplement, skapas en struktur där effektiv brottsbekämpning balanseras mot ett starkt skydd för individens personliga integritet.

Polisens brottsdatalag framträder därmed som länken mellan princip och praktik en avgörande komponent för att säkerställa både effektiv informationshantering och ett robust integritetsskydd i polisens arbete.

Using the open source R language, you can build powerful statistical models to answer many of your most challenging questions. R has traditionally been difficult for non-statisticians to learn, and most R books assume far too much knowledge to be of help. R for Everyone is the solution.

 

Drawing on his unsurpassed experience teaching new users, professional data scientist Jared P. Lander has written the perfect tutorial for anyone new to statistical programming and modeling. Organized to make learning easy and intuitive, this guide focuses on the 20 percent of R functionality you’ll need to accomplish 80 percent of modern data tasks. Lander’s self-contained chapters start with the absolute basics, offering extensive hands-on practice and sample code. You’ll download and install R; navigate and use the R environment; master basic program control, data import, and manipulation; and walk through several essential tests. Then, building on this foundation, you’ll construct several complete models, both linear and nonlinear, and use some data mining techniques.

 

By the time you’re done, you won’t just know how to write R programs, you’ll be ready to tackle the statistical problems you care about most.

 

Coverage Includes:

Exploring R, RStudio, and R packages Using R for math: variable types, vectors, calling functions, and more Exploiting data structures, including data.frames, matrices, and lists Creating attractive, intuitive statistical graphics Writing user-defined functions Controlling program flow with if, ifelse, and complex checks Improving program efficiency with group manipulations Combining and reshaping multiple datasets Manipulating strings using R’s facilities and regular expressions Creating normal, binomial, and Poisson probability distributions Programming basic statistics: mean, standard deviation, and t-tests Building linear, generalized linear, and nonlinear models Assessing the quality of models and variable selection Preventing overfitting, using the Elastic Net and Bayesian methods Analyzing univariate and multivariate time series data Grouping data via K-means and hierarchical clustering Preparing reports, slideshows, and web pages with knitr Building reusable R packages with devtools and Rcpp Getting involved with the R global community

Written by renowned data science experts Foster Provost and Tom Fawcett, Data Science for Business introduces the fundamental principles of data science, and walks you through the "data-analytic thinking" necessary for extracting useful knowledge and business value from the data you collect. This guide also helps you understand the many data-mining techniques in use today. Based on an MBA course Provost has taught at New York University over the past ten years, Data Science for Business provides examples of real-world business problems to illustrate these principles. You'll not only learn how to improve communication between business stakeholders and data scientists, but also how participate intelligently in your company's data science projects. You'll also discover how to think data-analytically, and fully appreciate how data science methods can support business decision-making.Understand how data science fits in your organization - and how you can use it for competitive advantage Treat data as a business asset that requires careful investment if you're to gain real value Approach business problems data-analytically, using the data-mining process to gather good data in the most appropriate way Learn general concepts for actually extracting knowledge from data Apply data science principles when interviewing data science job candidates

Struggling to grasp machine learning concepts or unsure how to apply them in the real world? This book aims to change that by using the world's most popular game-soccer-to illuminate key concepts in predictive modeling and data science. Whether you're a complete beginner or you're interested in entering the burgeoning field of sports analytics, you'll develop a solid foundation in machine learning through engaging examples that bridge academic principles with practical applications.Written by experts in both machine learning and sports analytics, this practical Python-focused guide introduces fundamental data science techniques using real soccer data. Ideal for students, analysts, and soccer fans alike, it offers instructions on models and techniques such as logistic regression, random forests, deep learning, simulations, and feature engineering. But instead of memorizing algorithms, you'll learn by building predictive models to analyze match outcomes, test betting strategies, run simulated game scenarios, and more.Understand machine learning concepts by working with real sports dataDevelop, refine, and evaluate machine learning models, using Python for data analysisCarry out detailed analyses and research on soccer game predictions and betting strategies to surface valuable insightsApply the skills you learn to predictive modeling scenarios in other industries

Data engineers proficient in Databricks are currently in high demand. As organizations gather more data than ever before, skilled data engineers on platforms like Databricks become critical to business success. The Databricks Data Engineer Associate certification is proof that you have a complete understanding of the Databricks platform and its capabilities, as well as the essential skills to effectively execute various data engineering tasks on the platform.In this comprehensive study guide, you will build a strong foundation in all topics covered on the certification exam, including the Databricks Lakehouse and its tools and benefits. You'll also learn to develop ETL pipelines in both batch and streaming modes. Moreover, you'll discover how to orchestrate data workflows and design dashboards while maintaining data governance. Finally, you'll dive into the finer points of exactly what's on the exam and learn to prepare for it with mock tests.Author Derar Alhussein teaches you not only the fundamental concepts but also provides hands-on exercises to reinforce your understanding. From setting up your Databricks workspace to deploying production pipelines, each chapter is carefully crafted to equip you with the skills needed to master the Databricks Platform. By the end of this book, you'll know everything you need to ace the Databricks Data Engineer Associate certification exam with flying colors, and start your career as a certified data engineer from Databricks!You'll learn how to:Use the Databricks Platform and Delta Lake effectivelyPerform advanced ETL tasks using Apache Spark SQLDesign multi-hop architecture to process data incrementallyBuild production pipelines using Delta Live Tables and Databricks JobsImplement data governance using Databricks SQL and Unity CatalogDerar Alhussein is a senior data engineer with a master's degree in data mining. He has over a decade of hands-on experience in software and data projects, including large-scale projects on Databricks. He currently holds eight certifications from Databricks, showcasing his proficiency in the field. Derar is also an experienced instructor, with a proven track record of success in training thousands of data engineers, helping them to develop their skills and obtain professional certifications.

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 featuresUse SQL data statements to generate, manipulate, and retrieve dataCreate database objects, such as tables, indexes, and constraints with SQL schema statementsLearn how datasets interact with queries; understand the importance of subqueriesConvert and manipulate data with SQL's built-in functions and use conditional logic in data statements

Seasoned Experts Alberto Ferrari and Marco Russo Help You Master DAX for Superior Business Intelligence Solutions

The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel. With years of experience since the inception of Power Pivot, the authors offer a comprehensive reference that navigates through the unique and complex concepts of DAX, making it an essential tool for BI professionals. This third edition updates you with the latest features and provides a framework for writing efficient DAX code, enhancing your ability to customize calculations in data models. You will gain the skills necessary to understand and apply advanced DAX concepts, structure code in user-defined functions, and leverage new calendars for time intelligence calculations.

By reading this book, you will:

Understand the foundational concepts of DAX and its unique language structure Master the use of evaluation contexts to enhance data analysis Utilize CALCULATE and CALCULATETABLE functions effectively Implement variables to simplify complex DAX expressions Leverage classic and new calendar based time intelligence functions Work with iterators to perform advanced calculations Apply visual calculations to improve report interactivity Create and manage calculation groups for dynamic reporting Handle complex hierarchies and relationships in data models Author DAX queries for testing and troubleshooting

About This Book

For BI professionals and Excel power users eager to deepen their understanding of DAX and enhance their data modeling capabilities with advanced techniques For data analysts and IT specialists seeking to optimize their use of Microsoft Power BI, Fabric, Analysis Services, and Excel for more efficient and insightful data analysis