Details

Title Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Author Simon, Mark
Binding Paperback
Condition Used - Very good
Pages 454
Volumes 1
Language ENG
Publisher Apress
Publication date 9/5/2023 12:00:01 AM
Illustrated Yes
Features Illustrated
Bookseller's Inventory # mon0004099859
ISBN 9781484296844 / 1484296842
Weight 1.8 lbs (0.82 kg)
Dimensions 10 x 7 x 0.96 in (25.40 x 17.78 x 2.44 cm)
Size 0.9843 10.0000 6.8898
Category Computers - Data Base Management
Quantity available 8
Bookseller catalogues Book

About Schwabe Books California, United States

Specialising in: Academic/University Press, Antiquarian/Rare, General Non-Fiction

Biblio member since 2010

We offer over 150,000 books in all subject areas. Heavy concentration in the following subject areas: Academic/university press, Antiquarian/Rare and general non-fiction.

Terms of Sale: 30 day return guarantee, with full refund including original shipping costs for up to 30 days after delivery if an item arrives misdescribed or damaged.

Browse books from Schwabe Books

Reader reviews for Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights

Write a review for this book

Important Terms and Guidelines

Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
Reviews must be at least 140 characters in length.
Please do not reveal critical plot elements.
This is not a help line. Contact customer support if you need help.

Your review must not include:

Obscenities, discriminatory language, or other insulting language not suitable for public domain
Advertisements, “spam” content, or references to other products, offers or websites.
Email addresses, URLs, phone numbers, physical addresses or other contact information.
Overly critical comments about other reviews or reviewers
Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
Availability, price, or alternative ordering/shipping information

From the publisher

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.

From the rear cover

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.

You will:

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

About the author

Mark Simon has been involved in training and education since the beginning of his career. He started as a teacher of mathematics, but quickly pivoted into IT consultancy and training because computers are much easier to work with than high school students. He has worked with and trained in several programming and coding languages, and currently focuses mainly on web development and database languages. When not involved in work, you will generally find him listening to or playing music, reading, or just wandering about.

BIBLIO is the largest independent book marketplace in the world, with over 100 million books.