SQL: A Beginner's Guide, Fourth Edition

SQL: A Beginner's Guide, Fourth Edition
ISBN-10
0071842594
ISBN-13
9780071842594
Category
Computers
Pages
560
Language
English
Published
2015-10-22
Publisher
McGraw Hill Professional
Author
Andy Oppel

Description

Essential SQL Skills Made Easy Fully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features. Designed for Easy Learning: • Key Skills & Concepts—Lists of specific skills covered in the chapter • Ask the Expert—Q&A sections filled with bonus information and helpful tips • Try This—Hands-on exercises that show how to apply your skills • Notes—Extra information related to the topic being covered • Tips—Helpful reminders or alternate ways of doing things • Cautions—Errors and pitfalls to avoid • Self-Tests—Chapter-ending quizzes to test your knowledge • Annotated Syntax—Example code with commentary that describes the programming techniques being illustrated

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • PROC SQL by Example: Using SQL within SAS
    PROC SQL by Example: Using SQL within SAS
    By Howard Schreier

    This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL. This book is part of the SAS Press program.

  • Learning SQL: Master SQL Fundamentals
    Learning SQL: Master SQL Fundamentals
    By Alan Beaulieu

    ... Michael | Smith | NULL | NULL | | Susan | Barker | Michael | Smith | | Robert | Tyler | Michael | Smith | | Susan ... Hawthorne | | Helen | Fleming | Susan | Hawthorne | | Chris | Tucker | Helen | Fleming | | Sarah | Parker | Helen ...

  • SQL For Dummies
    SQL For Dummies
    By Allen G. Taylor

    SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease.

  • Oracle SQL*Plus: The Definitive Guide
    Oracle SQL*Plus: The Definitive Guide
    By Jonathan Gennick

    0 A 0 is used to mark the spot in the result where you want to begin displaying leading zeros . It replaces one of the 9s . The most common location for a 0 is at the extreme left of the format string , but you can place it elsewhere .

  • SQL Performance Explained: Everything Developers Need to Know about SQL Performance
    SQL Performance Explained: Everything Developers Need to Know about SQL Performance
    By Markus Winand

    SQL Performance Explained: Everything Developers Need to Know about SQL Performance

  • SQL in a Nutshell
    SQL in a Nutshell
    By Leo S. Hsu, Regina O. Obe, Kevin Kline

    For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products.

  • SQL in a Nutshell: A Desktop Quick Reference
    SQL in a Nutshell: A Desktop Quick Reference
    By Daniel Kline, Kevin Kline, Brand Hunt

    For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products.

  • Discovering SQL: A Hands-On Guide for Beginners
    Discovering SQL: A Hands-On Guide for Beginners
    By Alex Kriegel

    This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL.

  • Inside Microsoft SQL Server 6.5
    Inside Microsoft SQL Server 6.5
    By Ron Soukup

    With CDROM Ron Soukup, former general manager for the SQL Server product and current SQL team guru, has penned this comprehensive guide for those who develop this important database tool.

  • Practical Oracle SQL: Mastering the Full Power of Oracle Database
    Practical Oracle SQL: Mastering the Full Power of Oracle Database
    By Kim Berg Hansen

    If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:Pivoting rows to columns and columns to rowsRecursion in SQL with MODEL and WITH ...