SQL The Complete Reference 3rd Edition

Author: James Groff
Publisher: McGraw Hill Professional
ISBN: 0071592563
Format: PDF, ePub
Download Now
The Definitive Guide to SQL Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume. Build SQL-based relational databases and applications Create, load, and modify database objects using SQL Construct and execute simple, multitable, and summary queries Implement security measures with authentication, privileges, roles, and views Handle database optimization, backup, recovery, and replication Work with stored procedures, functions, extensions, triggers, and objects Extend functionality using APIs, dynamic SQL, and embedded SQL Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL

SQL

Author: James R. Groff
Publisher:
ISBN: 9780072225600
Format: PDF, ePub, Docs
Download Now
Provides an in-depth discussion of SQL fundamentals, modern SQL products, and SQLs role in trends such as data warehousing, "thinclient" architectures, and Internet-based e-commerce.

JavaScript The Complete Reference 2nd Edition

Author: Thomas Powell
Publisher: McGraw-Hill Professional
ISBN: 9780072253573
Format: PDF
Download Now
Geared to all levels and types of developers, this comprehensive reference reveals how to develop powerful Web pages with JavaScript 2.0 by covering Core Language, Client-Side JavaScript, embedded objects, and security and how to increase productivity with improved and expanded event handling, object-oriented programming, and Internet Explorer-specific coverage. Original. (Intermediate)

SQL For Dummies

Author: Allen G. Taylor
Publisher: John Wiley & Sons
ISBN: 111865711X
Format: PDF, Kindle
Download Now
Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

C The Complete Reference 4th Edition

Author: Herbert Schildt
Publisher: McGraw Hill Professional
ISBN: 0072226803
Format: PDF
Download Now
Best-selling genius Herb Schildt covers everything from keywords, syntax, and libraries, to advanced features such as overloading, inheritance, virtual functions, namespaces, templates, and RTTI—plus, a complete description of the Standard Template Library (STL).

SQL in a Nutshell

Author: Kevin Kline
Publisher: "O'Reilly Media, Inc."
ISBN: 0596554257
Format: PDF, ePub
Download Now
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

Securing SQL Server

Author: Denny Cherry
Publisher: Syngress
ISBN: 0128013753
Format: PDF, ePub, Mobi
Download Now
SQL server is the most widely-used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, Third Edition, you will learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book, Denny Cherry - a Microsoft SQL MVP and one of the biggest names in SQL server - will teach you how to properly secure an SQL server database from internal and external threats using best practices as well as specific tricks that the author employs in his role as a consultant for some of the largest SQL server deployments in the world. Fully updated to cover the latest technology in SQL Server 2014, this new edition walks you through how to secure new features of the 2014 release. New topics in the book include vLANs, setting up RRAS, anti-virus installs, key management, moving from plaintext to encrypted values in an existing application, securing Analysis Services Objects, Managed Service Accounts, OS rights needed by the DBA, SQL Agent Security, Table Permissions, Views, Stored Procedures, Functions, Service Broker Objects, and much more. Presents hands-on techniques for protecting your SQL Server database from intrusion and attack Provides the most in-depth coverage of all aspects of SQL Server database security, including a wealth of new material on Microsoft SQL Server 2014. Explains how to set up your database securely, how to determine when someone tries to break in, what the intruder has accessed or damaged, and how to respond and mitigate damage if an intrusion occurs.

MySQL The Complete Reference

Author: Vikram Vaswani
Publisher: McGraw Hill Professional
ISBN: 0071782435
Format: PDF, Docs
Download Now
Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

SQL A Beginner s Guide Fourth Edition

Author: Andy Oppel
Publisher: McGraw Hill Professional
ISBN: 0071842594
Format: PDF, ePub
Download Now
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

Python

Author: Martin C. Brown
Publisher: McGraw-Hill Osborne Media
ISBN: 9780072127188
Format: PDF
Download Now
Python is an intergrated, object-orientated development language for use in computer programming. This text is split into distinct sections, each concentrating on a core angle of the language. The book also contains sections for Web and application development, the two most popular uses for Python. It is designed to teach a programmer how to use Python by explaining the mechanics of Python. The appendixes offer a quick guide to the main features of the Python language, as well as additional guides to non-essential systems such as the IDLE development environment and general guidelines for migrating from another language.