Sql Data Analysis (328 results)

Paperback. Condition: Very Good. Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book 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 learn Perform advanced statistical calculations using the WINDOW function Use SQL queries and subqueries to prepare data for analysis Import and export data using a text file and psql Apply special SQL clauses and functions to generate descriptive statistics Analyze special data types in SQL, including geospatial data and time data Optimize queries to improve their performance for faster results Debug queries that won't run Use SQL to summarize and identify patterns in data Who 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.…

Paperback. Condition: Good. Where to Start xi Introduction WITH THE EXPLOSION IN computer technology during the past 30 years, there has been an accompanying proliferation of data. In many cases, however, companies have stacks of printed data or electronic databases that are of little use to them. This is often because those who could benefit the most from this information lack experience using the tools and techniques that could help them extract knowledge from the numbers. Now, more and more databases are also placed on the Internet. In fact, at no other time in history has more information been accessible to so many people. But how can it help us? Access to this information is important because data collected in the past may be used to predict future trends or to characterize a population from which a sample has been extracted. For example, a sample poll among 1,000 voters is often used to predict the outcome of an election. The latest computer-age term for this exercise is data min- ing. Statistics is the science (and art) of mining or analyzing such data. Like lawyers and physicians, statisticians have traditionally insulated themselves from the masses by using jargon and Greek symbols, thereby helping to ensure the need for their services. …

Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc.

Paperback. Condition: Very Good. Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book 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 learn Perform advanced statistical calculations using the WINDOW function Use SQL queries and subqueries to prepare data for analysis Import and export data using a text file and psql Apply special SQL clauses and functions to generate descriptive statistics Analyze special data types in SQL, including geospatial data and time data Optimize queries to improve their performance for faster results Debug queries that won't run Use SQL to summarize and identify patterns in data Who 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.…

Paperback. Condition: Good. Where to Start xi Introduction WITH THE EXPLOSION IN computer technology during the past 30 years, there has been an accompanying proliferation of data. In many cases, however, companies have stacks of printed data or electronic databases that are of little use to them. This is often because those who could benefit the most from this information lack experience using the tools and techniques that could help them extract knowledge from the numbers. Now, more and more databases are also placed on the Internet. In fact, at no other time in history has more information been accessible to so many people. But how can it help us? Access to this information is important because data collected in the past may be used to predict future trends or to characterize a population from which a sample has been extracted. For example, a sample poll among 1,000 voters is often used to predict the outcome of an election. The latest computer-age term for this exercise is data min- ing. Statistics is the science (and art) of mining or analyzing such data. Like lawyers and physicians, statisticians have traditionally insulated themselves from the masses by using jargon and Greek symbols, thereby helping to ensure the need for their services. …

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.

Condition: very_good. Fast Free Shipping â" Very Good condition book with a firm cover and clean pages. Shows normal use and some light wear or limited notes markings. A solid, nice copy to enjoy.

Paperback. Condition: Good.

Paperback. Condition: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Fair. No Jacket. Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.

Condition: Good. 1st Edition. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.…

Condition: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

Condition: Very Good. Former library copy. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

Condition: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

Condition: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.

paperback. Condition: Good.

Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority.

Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority.

Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority.

Condition: good. Condition: Good â" Used book with some visible wear. May include stickers on the cover, wear or absence of the dust jacket, wear to the spine or inside cover, slight corner curling, minor staining, and wear along the fore edge. All orders are shipped via UPS Mail Innovations and may take up to 10 business days from the initial scan to be delivered.…

Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.