A Guide to SQL 10th Edition by Mark Shellman 9798214336602

A Guide to SQL 10th Edition by Mark Shellman – Ebook PDF Instant Download/DeliveryISBN:   9798214336602  

Full download A Guide to SQL 10th Edition after payment.

Product details:

ISBN-13 : 9798214336602 

Author :  Mark Shellman 

Effectively introduce your students to SQL programming today using the straightforward instruction, extensive hands-on exercises and emphasis on actual business applications in Shellman/Afyouni/Pratt/Last’s A GUIDE TO SQL, Tenth Edition. This edition builds upon a best-selling, proven presentation as the authors introduce basic SQL commands in the context of an intriguing ongoing case. Students see how this contemporary business uses SQL to manage orders and items as well as track the activities of customers and sales reps. The authors emphasize how to apply fundamental principles and enhance programming practices, regardless of the database environment. Meaningful examples throughout the text highlight the latest versions of MySQL as well as Oracle® and Microsoft SQL Server.

A Guide to SQL 10th Table of contents:

Module 1. Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
1-1. What Is a Database?
1-2. The Kimtay Pet Supplies Database
1-3. Staywell Student Accommodation Database
Module Summary
Key Term
Case Exercises
Module 2. Database Design Fundamentals
2-1. Database Concepts
2-1a. Relational Databases
2-1b. Entities, Attributes, and Relationships
2-2. Functional Dependence
2-3. Primary Keys
2-4. Database Design
2-4a. Design Method
2-4b. Database Design Requirements
2-4c. Database Design Process Example
2-5. Normalization
2-5a. First Normal Form
2-5b. Second Normal Form
2-5c. Third Normal Form
2-6. Diagrams for Database Design
Module Summary
Key Terms
Review Questions
Case Exercises
Module 3. Creating Tables
3-1. Creating and Running SQL Commands
3-1a. Using MySQL Workbench
3-1b. Entering Commands
3-2. Creating a Database
3-2a. Changing the Default Database
3-3. Creating a Table
3-3a. Correcting Errors in SQL Commands
3-3b. Dropping a Table
3-4. Using Data Types
3-5. Using Nulls
3-6. Adding Rows to a Table
3-6a. The INSERT Command
3-6b. Inserting a Row that Contains Nulls
3-7. Viewing Table Data
3-8. Correcting Errors in a Table
3-9. Saving SQL Commands
3-10. Creating the Remaining Database Tables
3-11. Describing a Table
Module Summary
Key Terms
Review Questions
Case Exercises
Module 4. Single-Table Queries
4-1. Constructing Simple Queries
4-1a. Retrieving Certain Columns and All Rows
4-1b. Retrieving All Columns and All Rows
4-1c. Using a WHERE Clause
4-1d. Using Compound Conditions
4-1e. Using the BETWEEN Operator
4-1f. Using Computed Columns
4-1g. Using the LIKE Operator
4-1h. Using the IN Operator
4-2. Sorting
4-2a. Using the ORDER BY Clause
4-2b. Additional Sorting Options
4-3. Using Functions
4-3a. Using the COUNT Function
4-3b. Using the SUM Function
4-3c. Using the AVG, MAX, and MIN Functions
4-3d. Using the DISTINCT Operator
4-4. Nesting Queries
4-4a. Subqueries
4-5. Grouping
4-5a. Using the GROUP BY Clause
4-5b. Using a HAVING Clause
4-5c. HAVING vs. WHERE
4-6. Nulls
4-7. Summary of SQL Clauses, Functions, and Operators
Module Summary
Key Terms
Review Questions
Case Exercises
Module 5. Multiple-Table Queries
5-1. Querying Multiple Tables
5-1a. Joining Two Tables
5-2. Comparing Joins, In, and Exists
5-2a. Using the IN Operator
5-2b. Using the EXISTS Operator
5-2c. Using a Subquery Within a Subquery
5-2d. A Comprehensive Example
5-2e. Using an Alias
5-2f. Joining a Table to Itself
5-2g. Using a Self-Join on a Primary Key Column
5-2h. Joining Several Tables
5-3. Set Operations
5-4. All and Any
5-5. Special Operations
5-5a. Inner Join
5-5b. Outer Join
5-5c. Product
Module Summary
Key Terms
Review Questions
Case Exercises
Module 6. Updating Data
6-1. Creating a New Table from an Existing Table
6-2. Changing Existing Data in a Table
6-3. Adding New Rows to an Existing Table
6-4. Autocommit, Commit, and Rollback
6-5. Transactions
6-6. Changing and Deleting Existing Rows
6-6a. Executing a Rollback
6-7. Changing a Value in a Column to Null
6-8. Changing a Table’s Structure
6-8a. Making Complex Changes
6-9. Dropping a Table
Module Summary
Key Terms
Review Questions
Case Exercises
Module 7. Database Administration
7-1. Creating and Using Views
7-2. Using a View to Update Data
7-2a. Updating Row-and-Column Subset Views
7-2b. Updating Views Involving Joins
7-2c. Updating Views Involving Statistics
7-3. Dropping a View
7-4. Security
7-5. Indexes
7-5a. Creating an Index
7-5b. Dropping an Index
7-5c. Creating Unique Indexes
7-6. System Catalog
7-6a. Update of the System Catalog
7-7. Integrity Constraints in SQL
Module Summary
Key Terms
Review Questions
Case Exercises
Module 8. Functions, Procedures, and Triggers
8-1. Using SQL in a Programming Environment
8-2. Using Functions
8-2a. Character Functions
8-2b. Number Functions
8-2c. Working with Dates
8-3. Concatenating Columns
8-4. Stored Procedures Using MySQL
8-4a. Retrieving a Single Row and Column
8-5. Error Handling
8-6. Using Update Procedures
8-6a. Changing Data with a Procedure
8-6b. Deleting Data with a Procedure
8-7. Selecting Multiple Rows with a Procedure
8-7a. Using a Cursor
8-7b. Opening a Cursor
8-7c. Fetching Rows from a Cursor
8-7d. Closing a Cursor
8-7e. Writing a Complete Procedure Using a Cursor
8-7f. Using More Complex Cursors
8-7g. Advantages of Cursors
8-8. Using PL/SQL in Oracle
8-8a. Error Handling in PL/SQL
8-8b. Writing a Complete Procedure Using a Cursor in PL/SQL
8-9. Using T-SQL in SQL Server
8-9a. Retrieving a Single Row and Column in T-SQL
8-9b. Changing Data with a Stored Procedure in T-SQL
8-9c. Deleting Data with a Stored Procedure in T-SQL
8-9d. Using a Cursor in T-SQL
8-9e. Using More Complex Cursors in T-SQL
8-10. Using a Trigger

People also search for A Guide to SQL 10th:

a guide to sql 9th edition pdf
    
a guide to sql pdf
    
a guide to sql 9th edition
    
a guide to sql 9th edition pdf free download
    
a guide to sql 10th edition answers

Tags:

A Guide,SQL,Mark Shellman,Cengage Learning