Computers

The Practical SQL Handbook

The Practical SQL Handbook

Author: Judith S. Bowman

Publisher: Addison-Wesley

ISBN: UOM:49015002638030

Category: Computers

Page: 454

View: 372

SQL: Structured Query Language.
Computers

The Practical SQL Handbook

The Practical SQL Handbook

Author: Judith S. Bowman

Publisher: Alyson Publishing

ISBN: 0201703092

Category: Computers

Page: 469

View: 798

This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. The Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users. The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL?s most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix. Highlights include: Detailed coverage of SQL commands for creating databases, tables, and indexes, and for adding, changing, and deleting data Using the SELECT command to retrieve specific data Handling NULL values (missing information) in a relational database Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax) Working with nested queries (subqueries) to get data from multiple tables Creating views (virtual tables) to provide customized access to data Using SQL functions A bonus CD-ROM contains a time-limited, full-feature version of the Sybase® Adaptive Server Anywhere™ software as well as the sample database, scripts, and examples included in the book. The Practical SQL Handbook is the most complete reference available for day-to-day SQL implementations. 0201703092B05222001

Structured Query Language : Using the Practical SQL Handbook (SQL)

Structured Query Language : Using the Practical SQL Handbook (SQL)

Author: Harry Harry

Publisher:

ISBN: 1492973378

Category:

Page: 354

View: 754

The Practical SQL Handbook is the best-selling guide to learning SQL, the standard language for accessing information in relational databases. This book not only teaches SQL as it has been established by ANSI standards committees but also as the language is used to solve real business problems. You'll learn step-by-step the basic vocabulary and functions of the language and the processes and issues involved in developing robust applications. This book provides a thorough grounding in the basics of database design, security, and integrity. You will learn SQL pragmatically, by creating a sample database and then working through dozens of examples with it. Fully updated to cover the ANSI SQL '92 standard, the third edition of The Practical SQL Handbook includes a cookbook of specific solutions, ready-to-use code, and general strategies for common business database challenges. Find out how to: *create and use views *use and apply subqueries *join tables for comprehensive data analysis *handle null values *create reports using groups and aggregate functions Bonus CD-ROM -- Get Hands-On Practice Using SQL!The CD-ROM includes the Windows 3.x , Windows 95, and Windows NT versions of the SybaseA (R) 3.0 SQL AnywhereaA A Runtime, a full-featured SQL database. Book Contents:===========Chapter 1 Introduction to SQLChapter 2 Introduction to the Query: The SELECT StatementChapter 3 Expressions, Conditions, and OperatorsChapter 4 Functions: Molding the Data You RetrieveChapter 5 Clauses in SQLChapter 6 Joining TablesChapter 7 Sub queries: The Embedded SELECT StatementChapter 8 Manipulating DataChapter 9 Creating and Maintaining TablesChapter 10 Creating Views and IndexesChapter 11 Controlling TransactionsChapter 12 Database SecurityChapter 13 Advanced SQL TopicsChapter 14 Dynamic Uses of SQLChapter 21 Common SQL Mistakes/Errors and ResolutionsAppendixesAnswers to Quizzes and Excercises
Computers

Oracle SQL and PL/SQL Handbook

Oracle SQL and PL/SQL Handbook

Author: John Adolph Palinski

Publisher: Addison-Wesley Professional

ISBN: 0201752948

Category: Computers

Page: 532

View: 690

CD-ROM contains: Practice database -- Sample scripts reference in text.
Computers

SQL Queries for Mere Mortals

SQL Queries for Mere Mortals

Author: John L. Viescas

Publisher: Addison-Wesley Professional

ISBN: 9780133824841

Category: Computers

Page: 792

View: 159

The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. informit.com/aw forMereMortals.com
Computers

Practical Oracle8i

Practical Oracle8i

Author: Jonathan Lewis

Publisher: Addison-Wesley Professional

ISBN: UCSD:31822029722238

Category: Computers

Page: 637

View: 355

A guide to designing and constructing Oracle databases covers leveraged tablespaces, partitioning, LOBs, autonomous transactions, row-level security, parallel query, parallel server, and Oracle's new analytical functions.
Computers

SQL Primer

SQL Primer

Author: Rahul Batra

Publisher: Apress

ISBN: 9781484235768

Category: Computers

Page: 194

View: 672

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter. Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language. What You'll Learn Create and populate your own database tables Read SQL queries and understand what they are doing Execute queries that get correct results Bring together related rows from multiple tables Group and sort data in support of reporting applications Get a grip on nulls, normalization, and other key concepts Employ subqueries, unions, and other advanced features Who This Book Is For Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.
Computers

Recent Advances and Issues in Computers

Recent Advances and Issues in Computers

Author: Martin Gay

Publisher: Greenwood Publishing Group

ISBN: 1573562270

Category: Computers

Page: 261

View: 773

Describes the latest developments and innovations in computer science research and technology.
Computers

Advantage Database Server

Advantage Database Server

Author: Cary Jensen

Publisher: AuthorHouse

ISBN: 9781425977269

Category: Computers

Page: 616

View: 365

With the launch of ADS 7.0, the authors can now satisfy the needs of this growing community with an official guide on ADS.
Computers

The Firebird Book

The Firebird Book

Author: Helen Borrie

Publisher: Apress

ISBN: 9781430207436

Category: Computers

Page: 1128

View: 266

* This is the "official" book on FirebirdSQL—it’s being written with the support of the development and management team. * Includes an extensive set of working, real-world examples, a troubleshooting guide, and a guide to migrating existing databases to FirebirdSQL. * This is the only book on the topic; appeals to users worldwide, especially in Europe; Most people deploy Firebird on Windows.
Computers

PostgreSQL 8.4 Official Documentation - Volume V. Internals and Appendixes

PostgreSQL 8.4 Official Documentation - Volume V. Internals and Appendixes

Author: The PostgreSQL Global Development Group

Publisher: Fultus Corporation

ISBN: 9781596821620

Category: Computers

Page: 444

View: 468

Welcome to the "PostgreSQL 8.4 Official Documentation - Volume V. Internals and Appendixes"! After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards.
Computers

PostgreSQL 9.0 Official Documentation - Volume V. Internals and Appendixes

PostgreSQL 9.0 Official Documentation - Volume V. Internals and Appendixes

Author: Postgresql Global Development Group

Publisher: Fultus Corporation

ISBN: 9781596822504

Category: Computers

Page: 484

View: 196

This book is part of the PostgreSQL 9.0 documentation collection (up-to-date & full), published by Fultus Corporation. PostgreSQL 9.0 includes built-in, binary replication, and over a dozen other major features which will appeal to everyone from web developers to database hackers.