SQL All-in-One For Dummies

4th Edition
id: 1023682 VIP Open in MaM

By Allen G Taylor, Richard Blum

Series: For Dummies

Language: English

Category: Ebook - Computer/Internet

Categories: Computer/Internet

Size: 8.8 MiB epub Files: 1

Uploader: draino

Uploaded At: 2024-04-10 03:09:22

For Dummies; 4th Edition 2024, Database Programming, SQL

Description


The most thorough SQL reference, now updated for SQL:2023

SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there’s no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career.


This Dummies All-in-One guide is for all SQL users―from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.
.

Table of Contents

Book 1. Getting Started with SQL

1. Understanding Relational Databases
2. Modeling a System
3. Getting to Know SQL
4. SQL and the Relational Model
5. Knowing the Major Components of SQL
6. Drilling Down to the SQL Nitty-Gritty

Book 2. Developing Relational Databases

1. System Development Overview
2. Building a Database Model
3. Balancing Performance and Correctness
4. Creating a Database with SQL

Book 3. Writing SQL Queries

1. Values, Variables, Functions, and Expressions
2. SELECT Statements and Modifying Clauses
3. Querying Multiple Tables with Subqueries
4. Querying Multiple Tables with Relational Operators
5. Cursors

Book 4. Securing Your Data

1. Protecting Against Hardware Failure and External Threats
2. Protecting Against User Errors and Conflicts
3. Assigning Access Privileges
4. Error Handling

Book 5. Programming with SQL

1. Database Development Environments
2. Interfacing SQL to a Procedural Language
3. Using SQL in an Application Program
4. Designing a Sample Application
5. Building an Application
6. Understanding SQL’s Procedural Capabilities
7. Connecting SQL to a Remote Database

Book 6. Working with Advanced Data Types in SQL. XML, JSON, and PGQ

1. Using XML with SQL
2. Storing XML Data in SQL Tables
3. Retrieving Data from XML Documents
4. Using JSON with SQL
5. Exploring Property Graph Queries

Book 7. Optimizing Your Database

1. Tuning the Database
2. Tuning the Environment
3. Finding and Eliminating Performance Bottlenecks

Book 8. Appendixes

Appendix A. SQL:2023 Reserved Words
Appendix B. Glossary

Other Torrents

Ebook - Computer/Internet
SQL All-In-One for Dummies 3rd Edition
by Allen G Taylor
series For Dummies
(1 April 2019): The latest on SQL databases
epub | 0 comments
Computer/Internet
1
8.3 MiB
2019-04-12 09:51:01
Fentible
15 seeders
0 leechers
188 snatches