SQL Primer

An Accelerated Introduction to SQL Basics



Bookstore > Books > SQL Primer

Price$29.99 - $37.98
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 4

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:  $35.81  |  Publisher:  Addison-Wesley  |  Release:  2018

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 Server's uniqu...

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

Oracle PL/SQL Language Pocket Reference, 4th Edition

Oracle PL/SQL Language Pocket Reference, 4th Edition

by Steven Feuerstein, Bill Pribyl, Chip Dawes

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. A companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming, this concise guide boils down the most vital PL/SQL information i...

Price:  $5.98  |  Publisher:  O'Reilly Media  |  Release:  2007

Learning SQL, 2nd Edition

Learning SQL, 2nd Edition

by Alan Beaulieu

Updated for the latest database management systems, 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 self-conta...

Price:  $14.50  |  Publisher:  O'Reilly Media  |  Release:  2009

SQL and Relational Theory

SQL and Relational Theory

by C. J. Date

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. 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 explanations of the reasoning be...

Price:  $62.10  |  Publisher:  O'Reilly Media  |  Release:  2009

Head First SQL

Head First SQL

by Lynn Beighley

Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it....

Price:  $9.90  |  Publisher:  O'Reilly Media  |  Release:  2007

Beginning SQL Server Modeling

Beginning SQL Server Modeling

by Bart Weller

Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book...

Price:  $29.00  |  Publisher:  Apress  |  Release:  2010

Pro SQL Database for Windows Azure, 2nd Edition

Pro SQL Database for Windows Azure, 2nd Edition

by Scott Klein, Herve Roggero

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database fo...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2012