SQL for data analysis : (Record no. 89320)

MARC details
000 -LEADER
fixed length control field 04362cam a22004931i 4500
001 - CONTROL NUMBER
control field BDZ0039984592
003 - CONTROL NUMBER IDENTIFIER
control field StDuBDS
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20241009132257.0
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
fixed length control field m || d |
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr |||||||||||
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 190513s2019 enk o 000|0|eng|d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781789803846 (PDF ebook) :
Terms of availability 22.78
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
Canceled/invalid ISBN 9781789807356 (pbk.) :
Terms of availability 23.99
040 ## - CATALOGING SOURCE
Original cataloging agency StDuBDS
Language of cataloging eng
Description conventions rda
-- pn
Transcribing agency StDuBDS
Modifying agency Uk
-- StDuBDSZ
072 #7 - SUBJECT CATEGORY CODE
Subject category code U
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code COM
Source ukslc
072 #7 - SUBJECT CATEGORY CODE
Subject category code U
Source thema
072 #7 - SUBJECT CATEGORY CODE
Subject category code UMX
Source thema
072 #7 - SUBJECT CATEGORY CODE
Subject category code UN
Source thema
072 #7 - SUBJECT CATEGORY CODE
Subject category code UNF
Source thema
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Edition number 23
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Malik, Upom,
Relator term author.
245 10 - TITLE STATEMENT
Title SQL for data analysis :
Remainder of title perform fast and efficient data analysis with the power of SQL /
Statement of responsibility, etc. Upom Malik, Matt Goldwasser, Benjamin Johnston.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. Birmingham :
Name of publisher, distributor, etc. Packt Publishing,
Date of publication, distribution, etc. 2019.
300 ## - PHYSICAL DESCRIPTION
Extent 1 online resource.
336 ## - CONTENT TYPE
Content type term text
Source rdacontent
337 ## - MEDIA TYPE
Media type term computer
Source rdamedia
338 ## - CARRIER TYPE
Carrier type term online resource
Source rdacarrier
366 ## - TRADE AVAILABILITY INFORMATION
Detailed date of publication 20190823
Availability status code Available
520 8# - SUMMARY, ETC.
Summary, etc. 'SQL for Data Analysis' covers everything you need to go from knowing basic SQL to start telling stories and identifying trends in data. With this book, you will be able to look at data with the critical eye of an analytics professional and extract meaningful insights that will improve your business.
Expansion of summary note Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasetsKey FeaturesExplore a variety of statistical techniques to analyze your dataIntegrate your SQL pipelines with other analytics technologiesPerform advanced analytics such as geospatial and text analysisBook DescriptionUnderstanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain the most effective business insights from data, this book is for you. SQL for Data Analytics helps you build the skills to move beyond basic SQL and instead learn to spot patterns and explain the logic hidden in data. You'll discover how to explore and understand data by identifying trends and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll learn how to increase your productivity with the help of profiling and automation. By the end of this book, you'll be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of an analytics professional. Please note: if you are having difficulty loading the sample datasets, there are new instructions uploaded to the GitHub repository. The link to the GitHub repository can be found in the book's preface.What you will learnPerform advanced statistical calculations using the WINDOW functionUse SQL queries and subqueries to prepare data for analysisImport and export data using a text file and psqlApply special SQL clauses and functions to generate descriptive statisticsAnalyze special data types in SQL, including geospatial data and time dataOptimize queries to improve their performance for faster resultsDebug queries that won't runUse SQL to summarize and identify patterns in dataWho this book is forIf you're a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.
588 ## - SOURCE OF DESCRIPTION NOTE
Source of description note Description based on CIP data; resource not viewed.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element SQL (Computer program language)
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Data mining.
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Computers and IT
Source of heading or term ukslc
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Computing & information technology
Source of heading or term thema
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Programming & scripting languages: general
Source of heading or term thema
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Databases
Source of heading or term thema
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Data mining
Source of heading or term thema
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Goldwasser, Matt,
Relator term author.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Johnston, Benjamin
Titles and other words associated with a name (Computer scientist),
Relator term author.
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
Relationship information Print version :
International Standard Book Number 9781789807356
710 ## - ADDED ENTRY--CORPORATE NAME
Corporate name or jurisdiction name as entry element VLeBooks
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier <a href="https://www.vlebooks.com/product/openreader?id=BradfordC&accId=7057554&isbn=9781789803846">https://www.vlebooks.com/product/openreader?id=BradfordC&accId=7057554&isbn=9781789803846</a>
Public note Click here to access
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Shelving location Date acquired Source of acquisition Cost, normal purchase price Full call number Date last seen Cost, replacement price Price effective from Koha item type
    Dewey Decimal Classification   Available online Online Library Online Library Online Resources 26/04/2024 48 71.99 VLeBooks 26/04/2024 71.99 26/04/2024 E-book