Job Ready SQL
- Length: 416 pages
- Edition: 1
- Language: English
- Publisher: Wiley
- Publication Date: 2023-05-09
- ISBN-10: 1394181035
- ISBN-13: 9781394181032
- Sales Rank: #0 (See Top 100 Books)
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.
Cover Title Page Introduction WHAT DOES THIS BOOK COVER? READER SUPPORT FOR THIS BOOK Part I: Introduction to Database Concepts Lesson 1: Exploring Relational Databases and SQL SAVING DATA WHAT IS A DATABASE? RELATIONAL DATABASE CONCEPTS ACID COMPLIANCE ENTITY INTEGRITY BACKUP STRATEGIES SUMMARY EXERCISES Lesson 2: Applying Normalization WHAT IS NORMALIZATION? NORMALIZING DATA FIRST NORMAL FORM SECOND NORMAL FORM THIRD NORMAL FORM DENORMALIZATION SUMMARY EXERCISES Lesson 3: Creating Entity‐Relationship Diagrams USING ERDs ERD COMPONENTS ERD OF DATABASE WHAT ABOUT MANY‐TO‐MANY RELATIONSHIPS? SUMMARY EXERCISES Lesson 4: Pulling It All Together: Normalizing a Vinyl Record Shop Database THE VINYL RECORD SHOP DATA OVERVIEW STEP 1: IDENTIFY THE ENTITIES AND ATTRIBUTES STEP 2: FIRST NORMAL FORM STEP 3: SECOND NORMAL FORM STEP 4: THIRD NORMAL FORM STEP 5: FINALIZE THE STRUCTURE FINAL STEPS SUMMARY Part II: Applying SQL Lesson 5: Working with MySQL Server MySQL INSTALLATION MySQL NOTIFIER COMMAND‐LINE INTERFACE GETTING STARTED WITH MySQL WORKBENCH SUMMARY EXERCISES Lesson 6: Diving into SQL INTRODUCTION TO SQL SQL SYNTAX WORKING WITH NULL VALUES WORKING WITH INDEXES SUMMARY EXERCISES Lesson 7: Database Management Using DDL DATABASE MANAGEMENT MySQL DATA TYPES MANAGING TABLES IN MYSQL MANAGING RELATIONSHIPS IN MySQL SUMMARY EXERCISES Lesson 8: Pulling It All Together: Building the Vinyl Record Shop Database STEP 1: EXAMINE THE STRUCTURE STEP 2: CREATE THE DATABASE STEP 3: CREATE THE PRIMARY TABLES STEP 4: CREATE THE RELATED TABLES STEP 5: FINALIZE THE SCRIPT SUMMARY Part III: Data Management and Manipulation Lesson 9: Applying CRUD: Basic Data Management and Manipulation DATA MANIPULATION LANGUAGE CREATE A DATABASE INSERT DATA UPDATE DATA DELETE DATA SUMMARY EXERCISES Lesson 10: Working with SELECT Queries SETTING UP A DATABASE USING THE SELECT KEYWORD USING THE WHERE CLAUSE PERFORMING CALCULATIONS SUMMARY EXERCISES Lesson 11: Adding JOIN Queries STARTING WITH A SCHEMA GET DATA FROM MULTIPLE TABLES USE THE JOIN CLAUSE INNER JOIN OUTER JOIN: LEFT, RIGHT, AND FULL SELF‐JOIN AND ALIASES CROSS JOIN SUMMARY EXERCISES Lesson 12: Sorting and Limiting Query Results USING ORDER BY USING LIMIT USING DISTINCT SUMMARY EXERCISES Lesson 13: Grouping and Aggregates AGGREGATE FUNCTIONS USING GROUP BY USING HAVING SELECT EVALUATION ORDER OTHER EXAMPLES SUMMARY EXERCISES Lesson 14: Pulling It All Together: Adding Data to the Vinyl Record Shop Database INSERTING DATA IMPORT CSV DATA ADD DATA TO THE SCRIPT TEST THE SCRIPT WRAP UP THE VINYL MUSIC SHOP SCRIPT SUMMARY Lesson 15: Diving into Advanced SQL Topics ADDING SUBQUERIES WORKING WITH VIEWS UNDERSTANDING TRANSACTIONS SCHEMA OPTIMIZATION SUMMARY EXERCISES Appendix A: Bonus Lesson on Applying SQL with Python DATABASE OPERATIONS TABLE OPERATIONS DATA OPERATIONS: CRUD SUMMARY EXERCISES Appendix B: SQL Quick Reference WORKING WITH DATABASES DEFINING TABLES, COLUMNS, AND ROWS PERFORMING TABLE QUERIES BASIC SQL DATA TYPES Index Copyright Acknowledgments About the Authors About the Technical Writer About the Technical Editor End User License Agreement
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.