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

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.