Login       My Wishlist
  My Cart
$0.00 / 0 items
 
EMS Linux
Utilizing the Best Tools With Linux
 
International Access
Global Shipping Options Available
  Our Catalog   Languages & Tools

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)


Super Savings Item! Save 35% on the SQL in 10 Minutes, Sams Teach Yourself (4th Edition) by Sams Publishing at EMS Linux. Hurry! Limited time offer. Offer valid only while supplies last. Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see how SQL statements are structured


Product Description

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured


Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.


Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.


You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.


With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...

  • Use the major SQL statements
  • Construct complex SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use aggregate functions to summarize data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, and more
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

Appendix D: Using SQL Datatypes

Appendix E: SQL Reserved Words


Additional Information

Manufacturer:Sams Publishing
Brand:Sams Publishing
Publisher:Sams Publishing
Studio:Sams Publishing
UPC:752063336076
EAN:9780672336072
Item Weight:0.8 pounds
Item Size:0.8 x 8.2 x 8.2 inches
Package Weight:0.84 pounds
Package Size:5.35 x 0.59 x 0.59 inches

SQL in 10 Minutes, Sams Teach Yourself (4th Edition) by Sams Publishing

Buy Now:
SQL in 10 Minutes, Sams Teach Yourself (4th Edition)

Brand: Sams Publishing
4.4 out of 5 stars with 31 reviews
Condition: New
Lead Time: 1 - 2 Business Days
Availability: In Stock
$29.99
$19.76
You Save: 34%


Quantity:  

 


View More In Languages & Tools.

 


Have questions about this item, or would like to inquire about a custom or bulk order?


If you have any questions about this product by Sams Publishing, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.

First Name:
Last Last:
Email Address:
Your Message:

Related Best Sellers


By Penguin Books
mpn: 19271399, ean: 9781593274078, isbn: 1593274076,
Use fundamental data structures like lists, tuples, and maps. Organize and reuse your code with functions and modules. Use control structures like loops and conditional statements. Draw shapes and patterns with Python's turtle module. Create games, a...

By imusti
ean: 9781848000698, isbn: 1848000693,
This newly expanded and updated second edition of the best-selling classic continues to take the "mystery" out of designing algorithms, and analyzing their efficacy and efficiency. Expanding on the first edition, the book now serves as the primary t...

By Springer
mpn: 37236906, ean: 9781461471370, isbn: 1461471370,
An Introduction to Statistical Learning provides an accessible overview of the field of statistical learning, an essential toolset for making sense of the vast and complex data sets that have emerged in fields ranging from biology to finance to marke...

By Course Technology
ean: 9781305578166, isbn: 1305578163,
Introduce your students to the latest, industry-leading, website development practices with the newest book in the remarkable Shelly Cashman Series. For more than three decades, the Shelly Cashman Series has effectively introduced computer skills to ...

By Pearson
ean: 9780133350685, isbn: 0133350681,
This is an introductory-level algorithm book. It includes worked-out examples and detailed proofs. Presents Algorithms by type rather than application. Includes structured material by techniques employed, not by the application area, so readers can...

By Brand: Cengage Learning
ean: 9781418835569, isbn: 1418835560,
This fourth edition of Gary Bronson's classic text implements the C99 standard in all discussion and example programs. An early emphasis on software engineering and top-down modular program development makes the material readily accessible to novice ...

By Pearson
mpn: illustrations, ean: 9780201308600, isbn: 0201308606,
This thorough, modern exposition of classic numerical methods using MATLAB briefly develops the fundamental theory of each method. Rather than providing a detailed numerical analysis, the behavior of the methods is exposed by carefully designed numer...

By CRC Pr I Llc
ean: 9781138436381, isbn: 1138436380,
Practical UML Statecharts in C/C plus plus Second Edition bridges the gap between high-level abstract concepts of the Unified Modeling Language (UML) and the actual programming aspects of modern hierarchical state machines (UML statecharts). The book...

By Pearson
mpn: illustrations, ean: 9780133943023, isbn: 013394302X,
For courses in computer programming.   Evaluating the Fundamentals of Computer Programming Languages Concepts of Computer Programming Languages introduces students to the fundamental concepts of computer programming languages and provides them...

By Springer
ean: 9780387966434, isbn: 0387966439,
Presents the results of an investigation into the issues raised by the development of a compiler for APL, a very high level computer programming language. APL presents a number of novel problems for a compiler writer: weak variable typing, run time c...



Privacy Policy / Terms of Service
© 2018 - emslinux.com. All Rights Reserved.