Job Ready SQL

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.

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 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

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.