Название: Job Ready SQL Автор: Kimberly A. Weiss, Haythem Balti Издательство: Wiley Год: 2023 Страниц: 415 Язык: английский Формат: pdf (true), epub Размер: 23.9 MB
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 a number of lessons.
• Part 1: 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.
• Part 2: Applying SQL The second part focuses on getting you set up to use MySQL. This includes help for 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.
• Part 3: 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.
Job Ready SQL is a must-have resource for students and working professionals looking to quickly get up to speed with SQL and take their relational database skills to the next level.
Contents:
Introduction Part I: Introduction to Database Concepts Lesson 1: Exploring Relational Databases and SQL Lesson 2: Applying Normalization Lesson 3: Creating Entity‐Relationship Diagrams Lesson 4: Pulling It All Together: Normalizing a Vinyl Record Shop Database Part II: Applying SQL Lesson 5: Working with MySQL Server Lesson 6: Diving into SQL Lesson 7: Database Management Using DDL Lesson 8: Pulling It All Together: Building the Vinyl Record Shop Database Part III: Data Management and Manipulation Lesson 9: Applying CRUD: Basic Data Management and Manipulation Lesson 10: Working with SELECT Queries Lesson 11: Adding JOIN Queries Lesson 12: Sorting and Limiting Query Results Lesson 13: Grouping and Aggregates Lesson 14: Pulling It All Together: Adding Data to the Vinyl Record Shop Database Lesson 15: Diving into Advanced SQL Topics Appendix A: Bonus Lesson on Applying SQL with Python Appendix B: SQL Quick Reference Index
Скачать Job Ready SQL
|