Weiss K.A., Balti H. Job Ready SQL: Learn the most important SQL skills and apply them in your job - quickly and efficiently!

Wiley, 2023. — 415 p. — (Wiley EDGE Tech Skills Series). — ISBN: 978-1-394-18104-9.Learn the most important SQL skills and apply them in your job — quickly and efficiently!SQL (Structured Query Language) is the modern language that almost every relational database system supports for adding data, retrieving data, and modifying data in a database. Although basic visual tools are available to help end-users input common commands, data scientists, business intelligence analysts, Cloud engineers, Machine Learning programmers, and other professionals routinely need to query a database using SQL.Job Ready SQL provides readers with an understanding of relational databases and Structured Query Language (SQL). SQL is a domain-specific language designed for managing data held in a relational database management system. This book contains a full-fledged SQL course that is used by the Wiley Edge Global Academy and the Software Guild to train our alumni in SQL and other topics, such as data analysis and Data Science.Job Ready SQL provides you with the foundational skills necessary to work with data of any kind. Offering a straightforward ‘learn-by-doing’ approach, this concise and highly practical guide teaches you all the basics of SQL so you can apply your knowledge in real-world environments immediately. Throughout the book, each lesson includes clear explanations of key concepts and hands-on exercises that mirror real-world SQL tasks.Teaches the basics of SQL database creation and management using easy-to-understand language.
Helps readers develop an understanding of fundamental concepts and more advanced applications such as data engineering and data science.
Discusses the key types of SQL commands, including Data Definition Language (DDL) commands and Data Manipulation Language (DML) commands.
Includes useful reference information on querying SQL-based databases.
As mentioned, this book is a complete SQL programming course. It is broken into several parts, each containing several lessons.Introduction to Database Concepts The first part of this book focuses on introducing database concepts including structured and unstructured data, as well as relational database concepts.Applying SQL The second part focuses on getting you set up to use MySQL. This includes help installing MySQL and setting up the tools you will need to work through this book. Additionally, this section dives into the basics of MySQL including query design and development and the basics of database management.Data Management and Manipulation The third part focuses on going beyond the basics of MySQL and focuses on learning about concepts you'll need to design and develop complex databases and advanced querying of the data stored on MySQL. This includes CRUD operations, joins, select queries, sorting, and aggregation. Finally, this section also includes lessons on how to leverage Python to query SQL data.Introduction to Database Concepts.
Exploring Relational Databases and SQL.
Applying Normalization.
Creating Entity?Relationship Diagrams.
Pulling It All Together: Normalizing a Vinyl Record Shop Database.
Applying SQL.
Working with MySQL Server.
Diving into SQL.
Database Management Using DDL.
Pulling It All Together: Building the Vinyl Record Shop Database.
Data Management and Manipulation.
Applying CRUD: Basic Data Management and Manipulation.
Working with SELECT Queries.
Adding JOIN Queries.
Sorting and Limiting Query Results.
Grouping and Aggregates.
Pulling It All Together: Adding Data to the Vinyl Record Shop Database.
Diving into Advanced SQL Topics.
Appendix A: Bonus Lesson on Applying SQL with Python.
Appendix B: SQL Quick Reference.