SQL for Beginners

Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle

De: Preston Prescott

Narrado por: Elaine Kellner

Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data you need, and much more. The book uses plain, clear, and concise language all geared to helped you learn SQL in the easiest manner possible. Here is just some of what you'll learn when you listen to SQL for Beginners:

• How to create and delete databases.
• How to design tables and what data types to use when.
• Ways to populate your database and tables with data.
• How to change a table after it's been created.
• How to extract all, or just some, of the data from a database.
• How to retrieve and sort data.
• Perform mathematical calculations using SQL such as averaging, finding the largest number in a set, and more.
• Format the data in a database including returning the data as all uppercase, lowercase, and more.
• How to write efficient SQL statements and clauses.
• How and why to create relationships in your databases.
• The difference between and inner, outer, right, and left join.
• How to perform SQL sub-queries.
• How to construct complex SQL statements using multiple clauses and operators
• Ways to summarize the data in your databases.
• And much more....

Works with Microsoft SQL Server, MySQL, MariaDB, SQLite, IBM DB2, PostgreSQL, Microsoft Access, and Oracle. You can use the SQL queries and concepts found in SQL for Beginners work on any SQL database including SQL Server, MySQL, PostgreSQL, and Oracle. Invaluable to computer programmers.... All but the simplest of computer programs interact with a database.

PLEASE NOTE: When you purchase this title, the accompanying PDF will be available in your Audible Library along with the audio.

©2015 Deep Thought Press (P)2015 Deep Thought Press

Good for beginners

This is a great introduction to SQL. I took 2 semesters in college and just wanted a brush up. This covers pretty much everything that was in the 101 course. It was mentioned that there is no companion book download available. In the preface they give a link for the companion and as of June 2019 it's still available at that link. It has tables that you can reference as you go.

This book tells you how to do stuff

It's very, dry, but it's all there. Downloading the accompanying .pdf is talked about in the first 3 minutes of starting the book/file and it's constantly referenced.

This book isn't fancy, doesn't explain extra stuff, it's kind of like a plain English version of a reference chart.

I'm in the process of learning SQL and feel I got a good sense of what it's capable of. It'd be good to listen to it while sitting in front of the computer ready to go.

No accompanying material included

I only listened to the very beginning since the audiobook reffers the accompanying PDF file that isn't provided together with the book. The description doesn't mention that there is a PDF file included, but this situation discouraged me so much that it was the first book that I returned on Audible.

No visuals

It is impossible to learn the SQL langues without a visual or diagram to follow.

Great intro helped me on my way

Helped me utilize the SQL database my work has. Really encourage people to learn this.

For the information, good, short, to the point.

The title explains it all. This is informative into a technical aspect of databases. I was just learning union statements. I'll give it a second listen.

Dr.mk

The information was step by step well said and to the point life is good....