Job Ready SQL by Kimberly A. Weiss -- Read -- Imperial Library of Trantor

Index

Cover Table of Contents 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