SQL in 10 Minutes, Sams Teach Yourself 4th Edition - No cost library

SQL in 10 Minutes, Sams Teach Yourself 4th Edition

   Author(s): Ben Forta

  Publisher: SAMS

                                        

 Description: 

Fourth Edition of Sams Teach Yourself SQL in 10 Minutes

New full-color code examples demonstrate the structure of SQL statements.

A strong working knowledge of SQL is an important part of communicating with databases, whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office user. And Sams Teach Yourself SQL in 10 Minutes provides the clear, practical answers you need to get the job done.

Ben Forta, a renowned author and expert teacher, teaches you just the parts of SQL you need to know, beginning with basic data retrieval and quickly progressing to more advanced topics including joins, subqueries, stored procedures, cursors, triggers, and table constraints.

In 22 short, fast lessons, you'll learn methodically, systematically, and simply–each taking just 10 minutes or less to complete.

The book has been extensively revised, extended, and improved in the Fourth Edition of this worldwide bestseller. IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base are now covered in the lessons. In addition, new full-color SQL code listings make it easier for beginners to see the language's elements and structure.

It just takes 10 minutes to learn how to...

Use the most important SQL statements.

Make complex SQL statements by combining clauses and operators.

Database contents can be retrieved, sorted, and formatted.

Using a range of filtering strategies, pinpoint the data you need.

To summarise results, use aggregate functions.

Join two or more tables that are connected.

Data can be added, modified, and deleted.

Make changes to database tables.

Use views, stored procedures, and other resources.

Table of Contents
1 Understanding SQL

2 Retrieving Data

3 Sorting Retrieved Data

4 Filtering Data

5 Advanced Data Filtering

6 Using Wildcard Filtering

7 Creating Calculated Fields

8 Using Data Manipulation Functions

9 Summarizing Data

10 Grouping Data

11 Working with Subqueries

12 Joining Tables

13 Creating Advanced Joins

14 Combining Queries

15 Inserting Data

16 Updating and Deleting Data

17 Creating and Manipulating Tables

18 Using Views

19 Working with Stored Procedures

20 Managing Transaction Processing

21 Using Cursors

22 Understanding Advanced SQL Features

Appendix A: Sample Table Scripts

Appendix B: Working in Popular Applications

Appendix C : SQL Statement Syntax

App

.