Computers

A Guide to SQL

Author: Philip Pratt,Mary Last

Publisher: Cengage Learning

ISBN: 0324597681

Category: Computers

Page: 360

View: 3712

A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on students learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Computers

A Guide to SQL

Author: Philip J. Pratt,Mary Z. Last

Publisher: Cengage Learning

ISBN: 1111807477

Category: Computers

Page: 360

View: 5025

A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on students learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Oracle (Computer file)

A Guide to SQL Featuring Oracle

Author: Philip J. Pratt

Publisher: N.A

ISBN: 9780760049235

Category: Oracle (Computer file)

Page: 246

View: 3478

Through numerous examples, realistic exercises, and hands-on projects, this text teaches the ins-and-outs of how to use SQL in an Oracle environment.
Computers

SQL Pocket Guide

A Guide to SQL Usage

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449396664

Category: Computers

Page: 206

View: 1901

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function
Computers

A Guide to MySQL

Author: Philip J. Pratt,Mary Z. Last

Publisher: Cengage Learning

ISBN: 1285700996

Category: Computers

Page: 288

View: 3962

A Guide to MySQL, by Philip Pratt and Mary Last, is yet another step into the open-source arena, which is rapidly growing in the technology industry. Topics include design techniques, data definition, commands to query a database, updates, administration and client tools, and finally, MySQL special topics. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Computers

A Guide to SQL/DS

Author: C. J. Date

Publisher: Addison Wesley Publishing Company

ISBN: N.A

Category: Computers

Page: 505

View: 9083

This is the first book available on SQL/DS, the IBM relational database management system for the VM and VSE environments. It is already one of the most successful database products and is gaining increasing importance, given the accelerating acceptance of the VM environment in the marketplace.
Computers

A Guide to the SQL Standard

A User's Guide to the Standard Database Language SQL

Author: C. J. Date

Publisher: Addison-Wesley Professional

ISBN: N.A

Category: Computers

Page: 522

View: 4733

The previous edition of this book established itself as the most complete and understandable treatment of the SQL standard generally available. Many changes have occurred in the SQL standard world since that edition was published. The original 1992 standard itself has been significantly changed and corrected through the publication of two extensive Technical Corrigenda, one in 1994 and one in 1996. Included in the fourth edition of this important book is information on a major new component, the Call-Level Interface (SQL/CLI), and the Persistent Stored Modules feature (SQL/PSM).
Relational databases

A Guide to SYBASE and SQL Server

A User's Guide to the SYBASE Product (a Relational Database Management System with Application Development Facilities) from Sybase, Inc

Author: D. McGoveran

Publisher: Addison Wesley Longman

ISBN: 9780201557107

Category: Relational databases

Page: 548

View: 5995

Computers

Oracle SQL*Plus Pocket Reference

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 0596528906

Category: Computers

Page: 154

View: 636

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.
Data base management

The Guide to SQL Server

Author: Aloke Nath

Publisher: Addison Wesley Publishing Company

ISBN: N.A

Category: Data base management

Page: 498

View: 2326

This book takes a comprehensive look at this acclaimed new server from Ashton-Tate, providing an overview of database servers in general and a detailed explanation of the features, architecture, and actual operation of SQL Server.
Computers

SQL QuickStart Guide

The Simplified Beginner's Guide to SQL

Author: ClydeBank Technology

Publisher: ClydeBank Media LLC

ISBN: 194505154X

Category: Computers

Page: 76

View: 7800

The Ultimate Beginner's Guide To Learning SQL - From Retrieving Data To Creating Databases! Structured Query Language or SQL (pronounced sequel by many) is the most widely used programming language used in database management and is the standard language for Relational Database Management Systems (RDBMS). SQL programming allows users to return, analyze, create, manage and delete data within a database – all within a few commands. With more industries and organizations looking to the power of data, the need for an efficient, scalable solution for data management is required. More often than not, organizations implement a Relational Database Management System in one form or another. These systems create long-term data “warehouses” that can be easily accessed to return and analyze results, such as, “Show me all of the clients from Canada that have purchased more than $20,000 in the last 3 years.” This “query,” which would have taken an extensive amount of hands-on research to complete prior to the use of database, can now be determined in seconds by executing a simple SELECT SQL statement on a database. SQL can seem daunting to those with little to zero programming knowledge and can even pose a challenge to those that have experience with other languages. Most resources jump right into the technical jargon and are not suited for someone to really grasp how SQL Actually Works. That’s why we created this book. Our goal here is simple: show you exactly everything you need to know to utilize SQL in whatever capacity you may need in simple, easy to follow concepts. Our book provides Multiple Step-by-Step Examples of how to master these SQL concepts to ensure you know what you’re doing and why you’re doing it every step of the way. This book will allow you to successfully go from knowing absolutely nothing about SQL to being able to quickly retrieve and analyze data from multiple tables. Step-by-step we will Walk You Through the Fundamentals of Understanding How a Relational Database is Structured to how to execute Complex SELECT Statements to return large datasets from your database.
Computers

The Essence of SQL

A Guide to Learning Most of SQL in the Least Amount of Time

Author: David Rozenshtein

Publisher: Coriolis Group Books

ISBN: 9780964981218

Category: Computers

Page: 119

View: 5252

Ideal for programmers, managers, and students who want to quickly acquire an in-depth understanding of SQL, this book covers the important aspects of the programming language. It takes the readers from the fundamentals to the most complex features of SQL, providing a smooth transition from other programming languages.
Computers

Microsoft SQL Server 2000

A Guide to Enhancements and New Features

Author: Rahul Sharma

Publisher: Addison-Wesley Professional

ISBN: 0201752832

Category: Computers

Page: 557

View: 5943

Focusing primarily on the new features of SQL Server 2000, this informative overview draws on real-world examples and situations to demonstrate how to use the security features, replication, backup procedures, data warehousing, and optimization techniques of SQL 2000 and is accompaned by a companion CD-ROM that contains sample code, along with scripts and utilities for day-to-day DBA jobs. Original. (Intermediate)
Computers

The Guru's Guide to SQL Server Architecture and Internals

Author: Ken Henderson

Publisher: Addison-Wesley Professional

ISBN: 9780201700473

Category: Computers

Page: 1021

View: 8785

bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson
Client/server computing

Troubleshooting SQL Server

A Guide for the Accidental DBA

Author: Jonathan Kehayias,Ted Krueger

Publisher: N.A

ISBN: 9781906434786

Category: Client/server computing

Page: 370

View: 9141

This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient memory, poorly written queries, inadequate indexing, inappropriate configuration option settings); memory mismanagement; missing indexes; blocking (caused mainly by poorly designed databases that lack proper keys and indexing, and applications that apply needlessly restrictive transaction isolation levels); deadlocking (Bookmark Lookup, Serializable Range Scan, Cascading Constraint); full transaction logs (lack of log backups, hefty index maintenance operations, long running transaction, problems with replication and mirroring environments); and accidentally-lost data. Finally, the authors discuss diagnosing tools such as the Performance Monitor, Dynamic Management Views, and server-side tracing. --
Computers

Healthy SQL

A Comprehensive Guide to Healthy SQL Server Performance

Author: Robert Pearl

Publisher: Apress

ISBN: 1430267720

Category: Computers

Page: 408

View: 9013

"Robert Pearl, a well-known DBA in the SQL community, explains his holistic vision of a database instance that needs regular check-ups and gives the tools, scripts, and best practices he has collected over the years." Alberto Bolchini, Computing Reviews, May 9, 2016 Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business. Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment.
Computers

The Programmer's Guide to SQL

Author: Cristian Darie,Karli Watson

Publisher: Apress

ISBN: 1430208007

Category: Computers

Page: 576

View: 8095

This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.
Computers

The Guru's Guide to Transact-SQL

Author: Ken Henderson

Publisher: Addison-Wesley Professional

ISBN: 9780201615760

Category: Computers

Page: 551

View: 6170

Demonstrates important concepts and offers working Transact-SQL code, covering data filtering, DDL, DML, statistical functions, runs and sequences, transactions, stored procedures and triggers, and performance tuning.