SQL Database Programming

By:

Fehily, Chris

Material type: Text

TextLanguage: English Publication details: Questing Vole Press 2020Edition: 5th EditionDescription: 466 pages 8 x 1.05 x 10 inchesISBN:

9781937842475

Subject(s):

DDC classification:

005.75 FEH 2020

Contents:

Contents Introduction 1. Running SQL Programs 2. The Relational Model 3. SQL Basics 4. Retrieving Data from a Table 5. Operators and Functions 6. Summarizing and Grouping Data 7. Joins 8. Subqueries 9. Set Operations 10. Inserting, Updating, and Deleting Rows 11. Creating, Altering, and Dropping Tables 12. Indexes 13. Views 14. Transactions 15. Advanced SQL

Summary: Covers Oracle Database, Microsoft SQL Server, Microsoft Access, IBM Db2 Database, MySQL, PostgreSQL, and Standard SQL. Hundreds of examples of varied difficulty encourage you to experiment and explore. Download the sample database and SQL source code to follow along with the examples. Organize your database in terms of the relational model. Master tables, columns, rows, and keys. Retrieve, filter, sort, and format data. Use functions and operators to transform and summarize data. Create, alter, and drop database tables. Answer hard questions by using joins, subqueries, constraints, conditional logic, and metadata. Create indexes that speed sorts and searches. Use views to secure and simplify data access. Insert, update, delete, and merge data. Execute transactions to maintain the integrity of your data. Avoid common pitfalls involving nulls. Troubleshoot and optimize queries. Learn advanced techniques that extend the power of SQL.

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Call number	Status	Date due	Barcode
Book	Symbiosis International University, Dubai	005.75 FEH 2020 (Browse shelf(Opens below))	Checked out	12/05/2025	SIU00360

Browsing Symbiosis International University, Dubai shelves Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.74 SIL 2020 Database system concepts /	005.743 CON 2015 Database systems : a practical approach to design, implementation, and management /	005.745 HER 2009 Storage management in data centers : understanding. exploiting, tuning, and trobleshooting Veritas Storage Foundation /	005.75 FEH 2020 SQL Database Programming	005.756 BLO 2021 RDBMS Relational Database Management System : A Complete Guide - 2020 Edition	005.756 BLO 2021 RDBMS Relational Database Management System : A Complete Guide - 2020 Edition	005.756 BLO 2021 RDBMS Relational Database Management System : A Complete Guide - 2020 Edition	Next

Contents
Introduction
1. Running SQL Programs
2. The Relational Model
3. SQL Basics
4. Retrieving Data from a Table
5. Operators and Functions
6. Summarizing and Grouping Data
7. Joins
8. Subqueries
9. Set Operations
10. Inserting, Updating, and Deleting Rows
11. Creating, Altering, and Dropping Tables
12. Indexes
13. Views
14. Transactions
15. Advanced SQL

Covers Oracle Database, Microsoft SQL Server, Microsoft Access, IBM Db2 Database, MySQL, PostgreSQL, and Standard SQL.
Hundreds of examples of varied difficulty encourage you to experiment and explore.
Download the sample database and SQL source code to follow along with the examples.
Organize your database in terms of the relational model.
Master tables, columns, rows, and keys.
Retrieve, filter, sort, and format data.
Use functions and operators to transform and summarize data.
Create, alter, and drop database tables.
Answer hard questions by using joins, subqueries, constraints, conditional logic, and metadata.
Create indexes that speed sorts and searches.
Use views to secure and simplify data access.
Insert, update, delete, and merge data.
Execute transactions to maintain the integrity of your data.
Avoid common pitfalls involving nulls.
Troubleshoot and optimize queries.
Learn advanced techniques that extend the power of SQL.

There are no comments on this title.

to post a comment.