Sams Teach Yourself SQL in One Hour a Day Paperback / softback

by Ryan Stephens, Ron Plew, Arie Jones

Part of the Sams Teach Yourself -- Hours series

Paperback / softback

Item not Available

Description

The Fifth Edition of Sams Teach Yourself SQL in 21 Days More than 48,000 sold! Â In just one hour a day, youâ€™ll have all the skills you need to begin creating effective SQL queries, reports, and database applications.

With this complete tutorial, youâ€™ll quickly master the basics and then move on to more advanced features and concepts: Â Quickly apply essential SQL techniques in useful, real-world queries Design trustworthy, high-performance databases Manipulate your data with views and transactions Leverage powerful features including stored procedures, triggers, and cursors Work with new objects introduced with the latest SQL standards Get practical, expert tips on implementing SQL in your business environment Â Learn on your own time, at your own pace No previous SQL or database experience required Learn techniques that work with any current version of SQL Discover how to write faster, more efficient queries Secure your data using best practices from experienced database administrators Build more powerful databases with features exclusive to Oracle SQL*Plus, Oracle PL/SQL, and Microsoft Transact-SQL Write queries for the free, open source MySQL database Embed your SQL code in other applications Â Ryan Stephens and Ron Plew are President and VP of Perpetual Technologies, Inc. (PTI) in Indianapolis, IN, providing managed services and consulting for top database implementations running Oracle, SQL Server, and other leading technologies.

They taught for 5+ years as adjunct professors at Indiana University-Purdue University.

Their books include Sams Teach Yourself SQL in 24 Hours, First through Fourth Editions, Sams Teach Yourself SQL in 21 Days, Second through Fourth Editions, and Database Design. Â Table of Contents Â Introduction Â 1 Â PART I: Introducing SQL Â LESSON 1: Getting Started with SQLÂ Â Â Â 5 Â Â Â Â A Brief History of SQLÂ Â Â Â 5 Â Â Â Â A Brief History of DatabasesÂ Â Â Â 6 Â Â Â Â Todayâ€™s Database LandscapeÂ Â Â Â 11 Â Â Â Â A Cross-Product LanguageÂ Â Â Â 12 Â Â Â Â Â Â Â Â Early ImplementationsÂ Â Â Â 12 Â Â Â Â Â Â Â Â SQL and Client/Server Application DevelopmentÂ Â Â Â 13 Â Â Â An Overview of SQLÂ Â Â Â 13 Â Â Â Popular SQL ImplementationsÂ Â Â Â 14 Â Â Â Â Â Â Â Â MySQLÂ Â Â Â 14 Â Â Â Â Â Â Â Â OracleÂ Â Â Â 14 Â Â Â Â Â Â Â Â Microsoft SQL Server and SybaseÂ Â Â Â 15 Â Â Â Â Â Â Â Â IBM DB2Â Â Â Â 16 Â Â Â Open Database ConnectivityÂ Â Â