Free shipping on all orders over $79* Limited Time Only
Track My Order
Help Centre
Likes
My Wish ListsLogin / Join
Booktopia
Australia's local bookstore
Get Free Shipping on orders over $79
Leveling Up with SQL : Advanced Techniques for Transforming Data into Insights - Mark Simon

Leveling Up with SQL

Advanced Techniques for Transforming Data into Insights

By: Mark Simon

eText | 4 September 2023

At a Glance

eText

$84.99

or 4 interest-free payments of $21.25 with

 or 

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level.

Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself.

After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data.

What Will You Learn

  • Gain a stronger understanding of database design principles, especially individual tables
  • Understand the relationships between tables
  • Utilize techniques such as views, subqueries, common table expressions, and windowing functions

Who Is This Book For:

SQL Databases users who want to improve their knowledge and techniques.

on
Desktop
Tablet
Mobile

You Can Find This eBook In

Non-FictionComputing & I.T.DatabasesData MiningComputer Programming & Software DevelopmentMicrosoft ProgrammingMathematicsProbability & StatisticsComputer ScienceArtificial IntelligenceExpert Systems & Knowledge-Based Systems

More in Databases

China's Megatrends : The 8 Pillars of a New Society - John Naisbitt

eBOOK

China's Megatrends

The 8 Pillars of a New Society

eBook

RRP $21.99

$17.99

18%
OFF
AI-Powered Search - Trey Grainger

eBOOK

AI-Powered Search

eBook

$52.99

Conquering the Decision Abyss - Keith Hartley

eBOOK

Conquering the Decision Abyss

eBook

RRP $15.39

$14.99

Transformers in Action - Nicole Koenigstein

eBOOK

Transformers in Action

eBook

$44.99

Investing for Programmers - Stefan Papp

eBOOK

Investing for Programmers

eBook

$44.99

This product is categorised by