100 Best SQL Books of All Time (Updated for 2026)

1

Sams Teach Yourself SQL in 10 Minutes

Ben Forta

5.0

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition"New full-color code examples help you see how SQL statements are structured"
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes off

2

SQL Cookbook

Anthony Molinaro

4.9

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers nev

3

SQL Pocket Guide

Jonathan Gennick

4.7

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.

SQL Pocket Guide describes ho

4

SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL

Walter Shields

4.6

SQL Made Easy- The Ultimate Step by Step Guide To Success Do you want to learn SQL programming without the complicated explanations?
Do you want to understand how to manage databases without all the confusion?
Well than, this is your go to guide to help you master SQL programming in no time!
This book breaks down the fundamentals elements that are essential to make you proficient in SQL programm

5

Learning SQL

Alan Beaulieu

4.6

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a

6

T-SQL Fundamentals

Itzik Ben-Gan

4.6

Effectively query and modify data using Transact-SQL
Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries,

7

Practical SQL: A Beginner's Guide to Storytelling with Data

Anthony DeBarros

4.6

Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools.

You'll first cover the fundamentals of databa

8

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

John L. Viescas

4.6

The #1 Easy, Common-Sense Guide to SQL Queries--Updated with More Advanced Techniques and Solutions

Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on cla

9

Head First SQL

Lynn Beighley

4.5

Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that pu

10

SQL Antipatterns

Bill Karwin

4.5

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.

Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the commo

11

SQL Performance Explained

Markus Winand

4.5

SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product. Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) too

12

SQL in 10 Minutes a Day, Sams Teach Yourself

Ben Forta

4.5

Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results.
By working through the book's 22 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of the SQL language.
Lessons cover IBM DB2, Microsoft SQL Server and SQL Server Express, MariaDB, MySQL, Oracle and Oracle express, PostgreSQL, and SQLite.
Full-color code e

13

Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5)

Robin Nixon

4.5

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you’ll tackle dynamic web programming with the latest versions of today’s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries.

Web designers will learn how to use the

14

Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming

Eric Matthes

4.4

Second edition of the best selling Python book in the world. A fast-paced, no-nonsense guide to programming in Python. This book teaches beginners the basics of programming in Python with a focus on real projects.

This is the second edition of the best selling Python book in the world. Python Crash Course, 2nd Edition is a straightforward introduction to the core of Python programming. Author Eric

15

The Art of SQL

Stephane Faroult, Peter Robson

4.4

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.

In The Ar

16

High Performance MySQL: Optimization, Backups, Replication & Load Balancing

Baron Schwartz

4.4

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of co

17

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

Ralph Kimball

4.4

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing!

The first edition of Ralph Kimball's "The Data Warehouse Toolkit" introduced the foundation on which the data warehousing industry has been built - and now, these books are considered the most authoritative guides on dimensional modeling. This new third edition is a complete library of dimension

Cover unavailable

18

Sams Teach Yourself SQL in 10 Minutes (4th Edition)

Ben Forta

4.4

This updated and expanded second edition of the Sams Teach Yourself SQL in 10 Minutes (4th Edition) provides a user-friendly introduction to the subject, Taking a clear structural framework, it guides the reader through the subject's core elements. A flowing writing style combines with the use of illustrations and diagrams throughout the text to ensure the reader understands even the most complex

19

A Smarter Way to Learn JavaScript: The new approach that uses technology to cut your effort in half

Mark Myers

4.4

The most enthusiastically reviewed programming book on AmazonBuy the book and get access to all 1,750 interactive exercises free.
"Damn, this program is ridiculously good. The author needs to sign up to run this country's education program."-Matthew Highland
"This is the most incredible learning experience I have ever had. Amazing!!" -Jon W. Christophersen
"If you're thinking of learning how to progr

20

Microsoft SQL Server 2012: T-SQL Fundamentals

Itzik Ben-Gan

4.4

Gain a solid understanding of T-SQL—and write better queries

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quic

Cover unavailable

21

SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL

Upom Malik

4.4

22

SQL for Dummies

Allen G. Taylor

4.4

Get ready to make SQL easy!

Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secu

23

Learn SQL (using MySQL) in One Day and Learn It Well: SQL for Beginners with Hands-on Project

LCF Publishing

4.4

New Book by Best-Selling Author Jamie Chan. Learn SQL Fast with a unique Hands-On Project. Book 5 of the Learn Coding Fast Series.

Learn SQL (using MySQL) Fast and Learn It Well. Master SQL Programming with a unique Hands-On Project
The information era is upon us and the ability to organize and make sense of data has become an invaluable skill.

Have you been hearing about data, databases and SQL a

Cover unavailable

24

The Definitive Guide to Dax: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

Alberto Ferrari

4.4

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently f

25

Exam Ref 70-761 Querying Data with Transact-SQL

Itzik Ben-Gan

4.4

This is a reference material to prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, book focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Covered topics include the exp

26

Microsoft SQL Server 2008 Internals

Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic, Benjamin Nevarez

4.3

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:

What happens internally when SQL Se

27

Mastering Oracle SQL

Sanjay Mishra and Alan Beaulieu

4.3

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an

28

Microsoft SQL Server 2008: T-SQL Fundamentals

Itzik Ben-Gan

4.3

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.

Discover how to:

Apply T-SQL fundamentals, cr

Cover unavailable

29

The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel

Marco Russo

4.3

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expr

30

High Performance MySQL: Optimization, Backups, and Replication

Baron Schwartz, Peter Zaitsev, et al.

4.3

31

SQL, PL/SQL: The Programming Language of Oracle

Ivan Bayross

4.3

32

Inside Microsoft SQL Server 2008: T-SQL Programming

Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, Isaac Kunen

4.3

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions.

Discover how to:

Work with T-SQL and CLR user-defined functions, stored procedures, and trigger

33

Understanding SQL

Martin Gruber

4.3

34

SQL in a Nutshell: A Desktop Quick Reference

Kevin Kline, Daniel Kline, Brand Hunt

4.3

SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL

35

The Manga Guide to Databases (Manga Guide To...)

Ltd. Tren-Pro Co.

4.3

Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you.

Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many c

36

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012

Dejan Sarka, Itzik Ben-Gan, et al.

4.3

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

Create database objects
Work with data
Modify data
Tr

Cover unavailable

37

Sql Guide (Quick Study: SQL)

Inc. BarCharts

4.3

38

Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself

Ben Forta

4.3

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.
This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the

39

SQL and Relational Theory: How to Write Accurate SQL Code

C. J. Date

4.3

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear

40

SQL Server Execution Plans

Grant Fritchey

4.3

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defi ned in your query. How aggregations in GROUP BY queries are put togethe

41

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

Michael J. Hernandez

4.2

Learn database design the easy, common-sense way! For years, Michael J. Hernandez's best selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, most straightforward, software-independent tutorial on the basic principles of relational database design. Now, he's thoroughly updated this hands-on best-seller, making it even easier to understand and use, while thoroughl

42

High Performance MySQL: Optimization, Backups, Replication, and More

Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling

4.2

43

Simply SQL

Rudy Limeback

4.2

Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.

Step through the basic SQL synta

44

Inside Microsoft SQL Server 2008: T-SQL Querying

Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass

4.2

Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.

Discover how to:

- Move from procedural programming to the language of sets and logic
- Optimize query tuning with a top-dow

45

Murach's Oracle SQL and PL/SQL for Developers

Joel Murach

4.2

If you're developing applications that access Oracle databases, you can save time and trouble by having the database do more work for you. That's where this book comes in. It teaches you how to create effective SQL queries to retrieve and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches

46

OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press)

Steve O'Hear

4.2

47

Excel 2019 All-In-One for Dummies

Greg Harvey

4.2

Make Excel work for you

Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel appli

48

Data Analysis Using SQL and Excel

Gordon S. Linoff

4.2

A practical guide to data mining using SQL and ExcelData Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis--SQL and Excel--to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business

49

SQL Server 2008 Query Performance Tuning Distilled

Grant Fritchey, Sajal Dam

4.2

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble-shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that ch

50

Microsoft Excel 2013: Building Data Models with PowerPivot

Alberto Ferrari

4.2

Your guide to quickly turn data into results.

Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of

51

The Guru's Guide to Transact-SQL

Ken Henderson, Joe Celko

4.2

Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management. This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical

52

The SQL Server 6 5 Performance Optimization and Tuning Handbook

Ken England Microsoft Certified Systems Engineer and a Microsoft Certified Trainer

4.2

53

Oracle PL/SQL Programming

Steven Feuerstein and Bill Pribyl

4.2

Considered throughout the Oracle technology community to be the best Oracle PL/SQL programming book available, this guide is the definitive reference on Oracle’s powerful procedural language. Like its predecessors, this sixth edition covers language fundamentals, advanced coding techniques, and best practices for using PL/SQL.

Thoroughly updated for Oracle Database 12c Release 1, this edition is pa

54

Professional Microsoft SQL Server 2014 Integration Services

Brian Knight, Devin Knight, et al.

4.2

55

SQL Server Query Performance Tuning Distilled

Sajal Dam

4.2

Many SQL Server-based applications perform far below expectation costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.

SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new cha

56

MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

Guy Harrison, Steven Feuerstein

4.2

The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to b

57

Inside the SQL Server Query Optimizer

Benjamin Nevarez

4.2

The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to DBAs and Developers a

58

Inside Microsoft SQL Server 2005: Query Tuning and Optimization: Query Tuning and Optimization

Kalen Delaney, Sunil Agarwal, Craig Freedman, Ron Talmage, Adam Machanic

4.2

Dig into the internals of tuning and optimization features in SQL Server 2005—with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries—and optimize database performance.

Discover how to:

Create a baseline and monitor workload by using System Monitor and DMVs Design, manipulate, and

59

Oracle Database 12c SQL

Jason Price

4.2

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Write Powerful SQL Statements and PL/SQL Programs

Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest databas

60

Learn SQL: A Practical Guide for SQL Server and Database Fundamentals

Jacob Schulz

4.2

61

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Joy Mundy, Warren Thornthwaite, Ralph Kimball

4.2

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming "Business Intelligence release" of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the po

62

Inside Microsoft SQL Server 2005: T-SQL Querying

Itzik Ben-Gan, Lubor Kollar, Dejan Sarka

4.2

Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

Understand logical and physical q

63

Oracle SQL Tuning with Oracle Sqltxplain

Stelios Charalambides

4.2

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole.

Firmly based in real world problems, this book helps you re

Cover unavailable

64

Python Programming: 4 Manuscripts - Artificial Intelligence Python, Reinforcement Learning with Python, Text Analytics with Python, Convolutional Neural Networks in Python

Dany Log

4.2

65

PostgreSQL: Up and Running

Regina O. Obe and Leo S. Hs

4.2

If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.

With numerous

66

Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model

Alberto Ferrari

4.1

Build agile and responsive Business Intelligence solutions

Analyze tabular data using the BI Semantic Model (BISM) in Microsoft® SQL Server® 2012 Analysis Services—and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you’ll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on boo

67

SQL Server 2012 Query Performance Tuning

Grant Fritchey, Sajal Dam

4.1

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with

68

The Essence of SQL: A Guide to Learning Most of SQL in the Least Amount of Time

David Rozenshtein

4.1

-- Excellent resource for corporate training and as a university text.
-- Author is a nationally recognized, widely published SQL expert.
-- Compatible with all SQL dialects.

69

SQL: Advanced Guide in SQL Programming

Paige Jacobs

4.1

70

Inside Microsoft SQL Server 2005: T-SQL Programming

Itzik Ben-gan, Dejan Sarka, Roger Wolter

4.1

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

Understand when to apply set-based programming techniques
Design and implement

71

Joe Celko's SQL for Smarties: Advanced SQL Programming

Joe Celko

4.1

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new ch

72

Performance Tuning with SQL Server Dynamic Management Views

Louis Davidson, Tim Ford

4.1

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. Why, then, aren't all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried and trusted" tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the "ready made" reports built into SSMS? Why do even those that do use the DMVs speak wistfully about "good old sysprocesses"? There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system. Secondly, the DMVs have a reputation of being difficult to use. In the process of exposing as much useful data as possible, sysprocesses has been de-normalized, and many new views and columns have been added. This fact, coupled with the initially-baffling choices of what columns will be exposed where, has lead to some DBAs to liken querying DMVs to "collecting mystic spells." In fact, however, once you start to write your own scripts, you'll see the same tricks, and similar join patterns, being used time and again. As such, a relatively small core set of scripts can be readily adapted to suit any requirement. This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own systems, including how to: • Root out the queries that are causing memory or CPU pressure on your system • Investigate caching, and query plan reuse • Identify index usage patterns • Track fragmentation in clustered indexes and heaps • Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom. • Find out where SQL Server is spending time waiting for resources to be released, before proceeding • Monitor usage and growth of tempdb The DMVs don't make existing, built-in, performance tools obsolete. On the contrary, they complement these tools, and offer a flexibility, richness and granularity that are simply not available elsewhere. Furthermore, you don't need to master a new GUI, or a new language in order to use them; it's all done in a language all DBAs know and mostly love: T-SQL.

73

MySQL

Paul DuBois

4.1

A guide for end users and administrators alike. MySQL helps users make the most of MySQL, a client-server SQL database management system.
-- Devoted exclusively to helping users make the most of the MySQL database system
-- Provides the best single source of understandable, practical information for learning how to use MySQL productively
-- Closely tied to the MySQL developers, Paul DuBois is a MySQL

74

Microsoft SQL Server 2012: Step by Step

Patrick LeBlanc

4.1

Your hands-on, step-by-step guide to building applications with Microsoft® SQL Server® 2012

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Disco

75

Developing Time-Oriented Database Applications in SQL

Richard T. Snodgrass

4.1

76

Microsoft SQL Server 2016: A Beginner's Guide

Dusan Petkovic

4.1

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Up-to-date Microsoft SQL Server 2016 skills made easy!Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQ

77

Inside Microsoft SQL Server 7.0 (Mps)

Ron Soukup, Kalen Delaney

4.1

A must-read for developers and IT professionals who need tounderstand Microsoft SQL Server from the inside out. Written bya Microsoft SQL Server guru, this comprehensive guide providesupdated, authoritative advice for installing, administering, andprogramming with version 7.0. The CD contains productevaluation documentation, sample code and scripts, white papers,and a benchmarking kit.

78

Effective SQL: 61 Specific Ways to Write Better SQL

John L. Viescas, Douglas J. Steele, Ben G. Clothier

4.1

"Given the authors' reputations, I expected to be impressed. I was blown away! . . . Most SQL books sit on my shelf. This one will live on my desk."
-Roger Carlson, Microsoft Access MVP (2006-2015)

"Rather than stumble around reinventing wheels or catching glimpses of the proper approaches, do yourself a favor: Buy this book."
--Dave Stokes, MySQL Community Manager, Oracle Corporation

Effective SQL

Cover unavailable

79

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press)

Steve O'Hearn

4.1

80

Masterminds of Programming: Conversations with the Creators of Major Programming Languages

Federico Biancuzzi, . Chromatic

4.1

Masterminds of Programming features exclusive interviews with the creators of several historic and highly influential programming languages. In this unique collection, you'll learn about the processes that led to specific design decisions, including the goals they had in mind, the trade-offs they had to make, and how their experiences have left an impact on programming today. Masterminds of Progra

81

SQL All-In-One For Dummies, 3rd Edition

Taylor

4.1

The latest on SQL databases

SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there,

82

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase

George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi

4.1

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move direc

83

Delivering Business Intelligence with Microsoft SQL Server 2008

Brian Larson

4.1

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Serv

84

Introducing Microsoft SQL Server 2014

Ross Mistry and Stacia Misner

4.1

NOTE: This title is also available as a free eBook on the Microsoft Download Center. It is offered for sale in print format as a convenience.

Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insigh

85

Inside Microsoft SQL Server 2005: The Storage Engine

Kalen Delaney

4.1

Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.

Discover how to:

Upgrade or migrate to SQL Server 2005 and choose configuration option

Cover unavailable

86

Computer Programming for Beginners: Fundamentals of Programming Terms and Concepts

Conley Walsh

4.1

Every Conceivable Topic a Complete Novice Needs To Know Get the Kindle version FREE when purchasing the Paperback!

If you are a newcomer to programming it's easy to get lost in the technical jargon, before even getting to the language you want to learn.

What are statements, operators, and functions?
How to structure, build and deploy a program?
What is functional programming and object oriented progra

87

Microsoft SQL Server 2012 a Beginners Guide 5/E

Dusan Petkovic

4.1

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Essential Microsoft SQL Server 2012 Skills Made EasyGet up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands

88

SQL: A Practical Introduction Guide to Learn Sql Programming Language. Learn Coding Faster with Hands-On Project. Crash Course Guide for your Computer Programming

Jason Crash

4.1

89

An Introduction to Database Systems

C.J. Date

4.0

Continuing in the eighth edition, An Introduction to Database Systems provides a comprehensive introduction to the now very large field of database systems by providing a solid grounding in the foundations of database technology while shedding some light on how the field is likely to develop in the future. This new edition has been rewritten and expanded to stay current with database system trends

90

Inside Microsoft SQL Server 2000

Kalen Delaney

4.0

91

SQL Server MVP Deep Dives

Paul Nielsen, Kalen Delaney, Adam Machanic, Kimberly Tripp, Paul Randal, Greg Low

4.0

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their know

92

SQL Tuning

Dan Tow

4.0

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.

There are two basic issues to focus on when tuning

93

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Joe Celko

4.0

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.

This book will change the way you think about the problems you solve w

94

97 Things Every Programmer Should Know: Collective Wisdom from the Experts

Kevlin Henney

4.0

Tap into the wisdom of experts to learn what every programmer should know, no matter what language you use. With the 97 short and extremely useful tips for programmers in this book, you'll expand your skills by adopting new approaches to old problems, learning appropriate best practices, and honing your craft through sound advice.

With contributions from some of the most experienced and respected p

95

Professional SQL Server 2008 Integration Services

Brian Knight, Erik Veerman, Grant Dickinson, Douglas Hinson, Darren Herbold

4.0

The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS) Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever Case studies and tutorial examples acquired over

96

Linq Pocket Reference: Learn and Implement Linq for .Net Applications

Joseph Albahari

4.0

Ready to take advantage of LINQ with C# 3.0? This guide has the detail you need to grasp Microsoft's new querying technology, and concise explanations to help you learn it quickly. And once you begin to apply LINQ, the book serves as an on-the-job reference when you need immediate reminders.

All the examples in the LINQ Pocket Reference are preloaded into LINQPad, the highly praised utility that le

97

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

Jason Brimhall, David Dye, Timothy Roberts, Wayne Sheffield, Jonathan Gennick, Joseph Sack

4.0

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is

Cover unavailable

98

MySQL Pocket Reference: SQL Functions and Utilities

George Reese

4.0

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job compani

99

NoSQL for Mere Mortals

Dan Sullivan Sullivan

4.0

The Easy, Common-Sense Guide to Solving Real Problems with NoSQL The Mere Mortals(R) tutorials have earned worldwide praise as the clearest, simplest way to master essential database technologies. Now, there's one for today's exciting new NoSQL databases. NoSQL for Mere Mortals guides you through solving real problems with NoSQL and achieving unprecedented scalability, cost efficiency, flexibility

100

The Language of SQL

Larry Rockoff

4.0

The Language of SQL, Second Edition
Many SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors.
For SQL beginners, it's more important for a book to focus on general concepts and to offer clear explanations and examples of wha