DEVELOP THE SKILLS YOU NEED FOR YOUR FIRST REAL-WORLD SQL JOB

For over 30 years, data scientists, programmers, and other tech professionals have been using SQL databases to collect, retrieve, and modify data. Thanks to its ubiquity, interacting with SQL remains an essential part of the daily lives of data scientists, business intelligence analysis, Cloud engineers, machine learning programmers, and others.

Job Ready SQL delivers the foundational skills you need to work with SQL data of any type. Using a straightforward 'learn-by-doing' approach, this accessible and concise handbook teaches you the basics of SQL so you can quickly and efficiently apply your knowledge in real-world scenarios and environments. Every lesson includes clear explanations of key concepts and hands-on exercises that mirror SQL tasks you might encounter in the field.

You'll discover the basics of SQL database creation and management, develop an understanding of the fundamental concepts underlying data engineering and data science, become familiar with more advanced concepts, like Data Definition Language (DDL) commands and Data Manipulation Language (DML) commands, and more.

Along with useful reference information on querying SQL-based databases, Job Ready SQL provides easy-to-follow information about:

• Exploring relational databases and SQL
• Installing a MySQL server
• Manipulating SQL data
• Joining SQL databases
• Interacting with SQL via Python, Java, and other languages
• Common and useful SQL terms
• Building and normalizing a sample SQL database

The companion website at www.wiley.com/go/jobreadygo provides supplemental files to be used by the reader in several lessons found in the book.