SQL Primer

An Accelerated Introduction to SQL Basics



Bookstore > Books > SQL Primer

Price$30.89 - $36.78
Rating
AuthorRahul Batra
PublisherApress
Published2018
Pages194
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484235754
ISBN-139781484235751
EBook Hardcover Paperback

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter.

Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.

Create and populate your own database tables; Read SQL queries and understand what they are doing; Execute queries that get correct results; Bring together related rows from multiple tables; Group and sort data in support of reporting applications; Get a grip on nulls, normalization, and other key concepts; Employ subqueries, unions, and other advanced features.




5 5 15

Similar Books


SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition

by John L. Viescas

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 classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...

Price:  $18.13  |  Publisher:  Addison-Wesley  |  Release:  2018

SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni

Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...

Price:  $48.15  |  Publisher:  Microsoft Press  |  Release:  2020

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008

C Primer Plus, 6th Edition

C Primer Plus, 6th Edition

by Stephen Prata

C Primer Plus is a carefully tested, well-crafted, and complete tutorial on a subject core to programmers and developers. This computer science classic teaches principles of programming, including structured code and top-down design.Author and educator Stephen Prata has created an introduction to C that is instructive, clear, and insightf...

Price:  $37.07  |  Publisher:  Addison-Wesley  |  Release:  2013

Beginning Microsoft SQL Server 2008 Administration

Beginning Microsoft SQL Server 2008 Administration

by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...

Price:  $5.17  |  Publisher:  Wrox  |  Release:  2009

Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...

Price:  $5.49  |  Publisher:  Wrox  |  Release:  2010

SQL All-in-One For Dummies, 2nd Edition

SQL All-in-One For Dummies, 2nd Edition

by Allen G. Taylor

SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into ea...

Price:  $7.49  |  Publisher:  Wiley  |  Release:  2011

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference

by Mark Gurry

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...

Price:  $6.76  |  Publisher:  O'Reilly Media  |  Release:  2002