SQL Database Programming (Fifth Edition)

SQL Database Programming (Fifth Edition)
Author :
Publisher : Questing Vole Press
Total Pages : 593
Release :
ISBN-10 : 9781937842246
ISBN-13 : 193784224X
Rating : 4/5 (46 Downloads)

Book Synopsis SQL Database Programming (Fifth Edition) by : Chris Fehily

Download or read book SQL Database Programming (Fifth Edition) written by Chris Fehily and published by Questing Vole Press. This book was released on 2020-01-31 with total page 593 pages. Available in PDF, EPUB and Kindle. Book excerpt: 2024 update. This book teaches newcomers SQL, the language of databases, and includes examples for the most widely used database systems. In all its editions, this book has sold more than 150,000 copies and is popular with end users, students, data scientists, statisticians, epidemiologists, analysts, app developers, webmasters, and hobbyists. Thorough cross-referencing makes it a useful desktop reference for experienced SQL programmers. - 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. 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 About the Author Chris Fehily is a statistician and author living in Carmel, California.


SQL Database Programming (Fifth Edition) Related Books

SQL Database Programming (Fifth Edition)
Language: en
Pages: 593
Authors: Chris Fehily
Categories: Computers
Type: BOOK - Published: 2020-01-31 - Publisher: Questing Vole Press

DOWNLOAD EBOOK

2024 update. This book teaches newcomers SQL, the language of databases, and includes examples for the most widely used database systems. In all its editions, t
SQL
Language: en
Pages: 504
Authors: Chris Fehily
Categories: Computers
Type: BOOK - Published: 2010-04-16 - Publisher: Peachpit Press

DOWNLOAD EBOOK

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide take
Learn SQL Database Programming
Language: en
Pages: 550
Authors: Josephine Bush
Categories: Computers
Type: BOOK - Published: 2020-05-29 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner’s guide Key FeaturesExplore all SQL statements in depth us
Joe Celko's SQL for Smarties
Language: en
Pages: 580
Authors: Joe Celko
Categories: Computers
Type: BOOK - Published: 2000 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

An industry consultant shares his most useful tips and tricks for advanced SQL programming to help the working programmer gain performance and work around syste
Hitchhiker's Guide to Visual Basic and SQL Server
Language: en
Pages: 820
Authors: William R. Vaughn
Categories: Computers
Type: BOOK - Published: 1997 - Publisher:

DOWNLOAD EBOOK

Microsoft insider William R. Vaughn shows developers how to use Visual Basic 5.0 to access data via SQL Server. This fifth edition also reveals the possibilitie