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 |