SQL All -In-One For Dummies, 3rd Edition

[tetox]

Hidden Content

Give reaction to this post to see the hidden content.

Book: SQL All -In-One For Dummies, 3rd Edition
Author(s): Allen G. Taylor
Publisher: Wiley
Tags: SQL databases, XML, JSON.
Year: 3rd Edition (April 23, 2019)
Print Length: 816 pages
Format: EPUB
Language: English
ISBN-10: 1119569613
ISBN-13: 9781119569619
Size: 8.72 MB (Rar)

Book Description
SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

• Cope with any issue that arises in SQL database creation and management
• Get current on the newest SQL updates and capabilities
• Reference information on querying SQL-based databases in the SQL language
• Understand relational databases and their importance to today’s organizations

SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.

Table Of Contents
Introduction
Book 1: SQL Concepts
    Chapter 1: Understanding Relational Databases
    Chapter 2: Modeling a System
    Chapter 3: Getting to Know SQL
    Chapter 4: SQL and the Relational Model
    Chapter 5: Knowing the Major Components of SQL
    Chapter 6: Drilling Down to the SQL Nitty-Gritty
Book 2: Relational Database Development
    Chapter 1: System Development Overview
    Chapter 2: Building a Database Model
    Chapter 4: Creating a Database with SQL
Book 3: SQL Queries
    Chapter 1: Values, Variables, Functions, and Expressions
    Chapter 2: SELECT Statements and Modifying Clauses
    Chapter 3: Querying Multiple Tables with Subqueries
    Chapter 4: Querying Multiple Tables with Relational Operators
    Chapter 5: Cursors
Book 4: Data Security
    Chapter 1: Protecting Against Hardware Failure and External Threats
    Chapter 2: Protecting Against User Errors and Conflicts
    Chapter 3: Assigning Access Privileges
    Chapter 4: Error Handlingns
Book 5: SQL and Programming
    Chapter 1: Database Development Environments
    Chapter 2: Interfacing SQL to a Procedural Language
    Chapter 3: Using SQL in an Application Program
    Chapter 4: Designing a Sample Application
    Chapter 5: Building an Application
    Chapter 6: Understanding SQL’s Procedural Capabilities
    Chapter 7: Connecting SQL to a Remote Database
Book 6: SQL, XML, and JSON
    Chapter 1: Using XML with SQL
    Chapter 2: Storing XML Data in SQL Tables
    Chapter 3: Retrieving Data from XML Documents
    Chapter 4: Using JSON with SQL
Book 7: Database Tuning Overview
    Chapter 1: Tuning the Database
    Chapter 2: Tuning the Environment
    Chapter 3: Finding and Eliminating Bottlenecks
Book 8: Appendices

Hidden Content

Give reaction to this post to see the hidden content.

Credits to the one who initially shared the file.

Edited February 14, 2020 by Bad Karma
Dead links removed