All counter of AlamanShop


Peter Gulutzan, Trudy Pelzer
SQL Performance Tuning

— y.
Publisher: —
Description: — [detailed...]

ISBN: 0201791692
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Kenneth Hess
SQL Power!: The Comprehensive Guide (Comprehensive Guides)

2006 y.
Publisher: —
Description: If you?re an aspiring database administrator, you need to learn SQL quickly to advance in your career. SQL Power! The Comprehensive Guide provides just the data you need to go from novice to master by immersing you in real-life database design, implementation, and administration situations. The book is equally useful for those already experienced with databases and SQL who want to increase their knowledge without having to sift through a tome. Beginning with an overview of SQL and the concept of relational databases, the book goes on to cover all the major topics, including tables, primary keys, relationships, foreign keys, MySQL, and database software, as well as the data definition, data manipulation, and data control languages. Later chapters cover higher-level topics such as advanced queries, virtual tables, normalization, and embedded SQL. The book?s examples build upon one another, with end-ofchapter exercises that test your knowledge as you go. All of the source code used in… [detailed...]

ISBN: 1598632124
Book size: —; Page extent: 444.

 

PUT TO
THE BASKET
John L. Viescas, Michael J. Hernandez
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

2007 y.
Publisher: Addison-Wesley Professional
Description: Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a `Mere Mortal` will indeed be empowered to perform the superhuman. Do not walk past this book! Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of `SQL Queries for Mere Mortals` helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users. The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats:… [detailed...]

ISBN: 0321444434
Book size: —; Page extent: 672.

 

PUT TO
THE BASKET
Michael J. Hernandez, John L. Viescas
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

— y.
Publisher: —
Description: To the people who are accomplished in its use, Structured Query Language (SQL) is a highly capable, eminently flexible, even beautiful way of describing the data that you want from a database, or the changes that you want to make to a database. For the rest of us, however, SQL is a first-class nuisance that we do our best to avoid by relying on relatively user-friendly--but usually less powerful--tools. SQL Queries for Mere Mortals aims to bring SQL-phobes closer to the first camp by tutoring them carefully in what SQL can do. The authors recognize that SQL queries usually come about as a result of questions from human beings, and so usefully spend a fair bit of time showing how to convert, say, `In what cities do our customers live?` into, `Select city from the customers table` and, finally, `SELECT city FROM customers` in SQL. They call this the `translation and clean up` process, and it`s a fine approach. They don`t press it too far, however, and are equally… [detailed...]

ISBN: 0201433362
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Steven Parker
SQL Server 100 Most Asked Questions: Best Practices guide to managing, mining, building and developing SQL Server databases

2008 y.
Publisher: —
Description: The Smart Guide to building World-Class Applications. This book is your source for the latest SQL server news, updates, tips, tricks and more. You get real answers that make a difference, it is the only All SQL Server, All the time starter technical resource for developers, DBA`s and business intelligence architects. By delivering a unique blend of tactical, hands-on information, this book facilitates the context and content necessary to help SQL Server professionals get their jobs done. Finding information and answers quickly is critical to the success of today`s IT organizations. This book covers the 100 most asked SQL Server questions, at the right time, with the right message [detailed...]

ISBN: 1921523697
Book size: —; Page extent: 176.

 

PUT TO
THE BASKET
Carlos Rojas, Fernando Guerrero
SQL Server 2000 Programming by Example

— y.
Publisher: —
Description: SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you`re a complete novice to SQL Server 2000 programming, you will benefit by reading through the book`s logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples. [detailed...]

ISBN: 0789724499
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Tony Bain, Louise Davidson, Robin Dewson, Chuck Hawkins
SQL Server 2000 Stored Procedures Handbook (Expert`s Voice)

— y.
Publisher: —
Description: Stored procedures are compiled T-SQL statements that reside on the database. They are the cornerstones of successful data manipulation, and data-handling operations of every complexity make use of them. This book is an in-depth guide to a key area of database development. This book tackles real-world problems faced by developers when working with stored procedures, showing you how to solve these problems, avoid the common pitfalls, and produce faster, more robust stored procedures. Put simply:if you want to write better stored procedures, then this is the book for you. [detailed...]

ISBN: 1590592875
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Kevin Williams, Bryant Likes, Andy Novick, Daryl Barnes, Paul Morris
SQL Server 2000 XML Distilled

— y.
Publisher: —
Description: XML is one of a family of web standards for data description, validation, manipulation, and interchange. It enables the construction of application-specific data languages, which can be handled by generic tools. Its other main benefits are its platform independence, self-describing structure, and human readability. All the big relational database vendors are adding XML support to their databases n and their confidence in XML as a maturing data standard is strengthening. Microsoft`s commitment to XMLextends beyond the database to include application and presentation layers, particularly in .NET. The nascent field of web services will depend on the effective interface between relational databases and the XML messages that link them. SQL Server 2000 XML Distilled is for you if: You are an experienced SQL Server professional (a DBA or data-tier developer) with a knowledge of the basics of XML who is being asked either to present relational data in an XML format, or to store XML data… [detailed...]

ISBN: 1590591917
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Paul Nielsen
SQL Server 2005 Bible

2006 y.
Publisher: Wiley
Description: Use this comprehensive tutorial and reference to increase productivity and write stored procedures using the language with which you`re most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server. You`ll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you`ll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task. A companion Web site provides all of the code examples found in the book. [detailed...]

ISBN: 0764542567
Book size: —; Page extent: 1294.

 

PUT TO
THE BASKET
Eric L. Brown
SQL Server 2005 Distilled (Microsoft Windows Server)

2006 y.
Publisher: —
Description: - [detailed...]

ISBN: 0321349792
Book size: —; Page extent: 336.

 

PUT TO
THE BASKET
Joseph Sack
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

2005 y.
Publisher: —
Description: Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL--related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer. This `no-fluff` desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory. Additionally, this book provides `how-to` answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise… [detailed...]

ISBN: 159059570X
Book size: —; Page extent: 768.

 

PUT TO
THE BASKET
Sharon Dooley
SQL Server 7 Essential Reference

— y.
Publisher: —
Description: SQL Server Essential Reference provides solid grounding in fundamental SQL Server 7 administrative tasks to help you tame your SQL Server environment. With coverage ranging from installation, monitoring, troubleshooting, security, managing client connectivity, storage and transaction management, and back-up and recovery plans, SQL Server Essential Reference breaks down SQL Server administration into its necessary functions and key conceptual areas, making a quick reference work even more quickly.This speed and flexibility is derived from Sharon Dooley?s care with the layout and content of the book. Utilizing convenient referential aids such as concise descriptions, useful examples, code examples, performance tips, warning and danger alerts, best practices, and helpful cross-references, this portable volume is the ultimate SQL Server reference. SQL Server Essential Reference is a must-have for any SQL Server administrator. [detailed...]

ISBN: 0735708649
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
William C. Amo
SQL Server 7 OLAP Developer`s Guide (With CD-ROM)

— y.
Publisher: —
Description: Microsoft ® SQL Server ? OLAP Developer`s Guide Your Complete How-To Guide Understand the ROLAP, MOLAP, and HOLAP data storage structures Populate a data warehouse using SQL Server 7 Data Transformation Services Create data cubes with OLAP Manager Wizards Use Decision Support Objects to build powerful OLAP applications for the enterprise Retrieve and display OLAP data using ADO MD objects and PivotTable Services Use MDX to write `what-if` and other sophisticated OLAP queries Develop custom add-ins for OLAP Manager using Visual Basic Build client-side applications to query OLAP data using Excel PivotTables Construct a custom application that drills up and down through cell sets Set up data descriptions in the English Query environment CD-ROM Includes: Microsoft SQL Server 7.0 120-day evaluation edition Ready-to-use source code and all examples from the book AntQuery (trial) OLAP@Work for Microsoft… [detailed...]

ISBN: 0764546430
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Ken England, Nigel Stanley
SQL Server 7.0 Handbook : A Guide to Microsoft Database Computing

— y.
Publisher: —
Description: Let the experts help you work smarter with the new SQL Server. The SQL Server 7.0 Handbook concisely and authoritatively explains how to design, implement, administer, and tune Microsoft`s powerful new database management system for Windows NT. Readers will learn all major SQL Server 7.0 capabilities, especially its new scalability, decision support, performance, and replication features. The authors, recognized SQL Server authorities, including a former SQL Server product manager, explain how to use the database with other critical Microsoft data management technologies and products, including Microsoft Transaction Server and Active Data Objects (ADO). No other book will enable database administrators, designers, programmers, and IT managers to master SQL Server 7.0 more thoroughly or quickly. Computer professionals studying for Microsoft Certified Professional (MCSE) qualifications will find this book essential reading. Learn major new SQL Server 7.0… [detailed...]

ISBN: 155558201X
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Rob Tiffany
SQL Server CE Database Development with the .NET Compact Framework

— y.
Publisher: —
Description: — [detailed...]

ISBN: 1590591194
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Jim Samuelson, M. Santos, S. Miller, S. Hughes, B. Sullivan
SQL Server DTS

2001 y.
Publisher: Sams
Description: This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner toDTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000. [detailed...]

ISBN: 0735711232
Book size: —; Page extent: 512.

 

PUT TO
THE BASKET
Eric Johnson
SQL Server Fundamentals for the Accidental DBA (Video Training) (LiveLessons)

2009 y.
Publisher: —
Description: SQL Server Fundamentals for the Accidental DBA Eric Johnson For power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training. Eric Johnson shows you how to perform every essential DBA task with SQL Server 2005 and SQL Server 2008, even if you’ve never had any DBA training. Learn at your own pace through realistic hands-on examples that walk you through every step! SQL Server MVP and expert Eric Johnson is a database analyst who has spent many years working with Microsoft SQL Server. He is author of A Developer’s Guide to Data Modeling for SQL Server (Addison-Wesley, 2008) and the forthcoming Windows Essential Business Server 2008 Unleashed (Sams). Eric is currently the President of the Colorado Springs SQL Server Users Group. “Are you an accidental DBA–out of the blue expected to run Microsoft SQL Server efficiently, reliably, and securely–when nobody ever taught you how? From installation to backup/restore, indexing to… [detailed...]

ISBN: 0321602773
Book size: —; Page extent: 80.

 

PUT TO
THE BASKET
Sajal Dam
SQL Server Query Performance Tuning Distilled, Second Edition

2004 y.
Publisher: —
Description: Many SQL Server-based applications perform far below expectation-costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap. The second edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book shows how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are crucial issues like index analysis and tuning, preventing deadlocks, optimizing workload, and minimizing costs. [detailed...]

ISBN: 1590594215
Book size: —; Page extent: 624.

 

PUT TO
THE BASKET
Morris Lewis
SQL Server Security Distilled, Second Edition

— y.
Publisher: —
Description: SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional. SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any DBA who implemented the securityprecautions detailed in the book would not have been affected by the infamous Slammer virus. This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even… [detailed...]

ISBN: 1590592190
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Neil Pike
SQL Server: Common Problems, Tested Solutions

— y.
Publisher: —
Description: SQL Server: Common Problems, Tested Solutions consists of over 500 common and not-so-common questions that users of all versions of SQL Server are likely to ask. Most of these problems and solutions are either undocumented or poorly documentedin Microsoft`s own literature. Answers are as concise and to the point as possible. Each FAQ article in the book contains helpful information about the applicable SQL Server version, related FAQ articles, related Microsoft Knowledge Base articles, and other reference works. This book`s dual indexes and cross-references allow the reader to easily find related FAQ articles in other categories. [detailed...]

ISBN: 189311581X
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Joseph J. Bambara, Paul R. Allen
SQL Server® Developer`s Guide

— y.
Publisher: —
Description: Because it underlies the information infrastructure of so many organizations, Microsoft SQL Server is a great place for systems experts to extend their knowledge beyond general familiarity. By acquiring a programmer`s knowledge of this robust databasesolution, you can make yourself far more valuable than an ordinary system administrator. SQL Server Developer`s Guide will get you started in the use of Structured Query Language (SQL), Java, and C to build SQL Server 7.0 applications. You`ll have to back this book with a language text if you lack general programming skills, but SQL Server Developer`s Guide does a competent job of explaining how SQL Server interacts with software that`s designed to read and write databases. Some readers will object to the inclusion of general programming advice about such topics as debugging and source management. It sometimes seems that the authors, given a chance to write a programming book, tried to include lots of … [detailed...]

ISBN: 0764546724
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Cecelia L. Allison
SQL for Microsoft Access, 2nd Edition (Wordware Applications Library)

2008 y.
Publisher: —
Description: SQL for Microsoft Access unlocks the power of Structured Query Language (SQL) in Microsoft Access. It guides the reader through step-by-step examples that use SQL script in Microsoft Access to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including combined queries, joined queries, nested queries, views, and temporary tables. The reader also discovers how SQL script can be implemented within VBA and ASP code. [detailed...]

ISBN: 1598220608
Book size: —; Page extent: 400.

 

PUT TO
THE BASKET
Mary Pyefinch
SQL from the Ground Up

— y.
Publisher: —
Description: SQL (structured query language) is flexible, cross-platform language used to identify trends and relationships in data. SQL relational database business and services is a multi-billion dollar industry. The perfect introduction to SQL in an accelerated tutorial fashion. Real-world examples of how to design a database and retrieve data using queries and reports. [detailed...]

ISBN: 0072119748
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Chris Fehily
SQL, Second Edition (Visual QuickStart Guide)

2005 y.
Publisher: —
Description: As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too-- no programming experience required! After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage. Best of all, the book`s examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On… [detailed...]

ISBN: 0321334175
Book size: —; Page extent: 440.

 

PUT TO
THE BASKET
Robert Sheldon
SQL: A Beginner`s Guide, Second Edition

— y.
Publisher: —
Description: Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you’ll learn step-by-step how to create a database, create tables,enforce data integrity, query and modify data, and implement advanced data access techniques. [detailed...]

ISBN: 0072228857
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Chris Newman
SQLite

— y.
Publisher: —
Description: SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL andPostgreSQL, however it is faster than both databases. In SQLite , author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or aboutits use in conjunction with PHP this is the book for you. [detailed...]

ISBN: 067232685X
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Galina Landres, Vlad Landres
SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8

— y.
Publisher: —
Description: Programmers, database developers, administrators responsible for PeopleSoft support, functional users, and project managers are discovering SQR, or Structured Query Report Writer, which has become increasingly popular since PeopleSoft selected it as its main SQL processing and reporting tool. This new language liberates programmers from the constraints of SQL and allows them to concentrate on the application aspects of their programs. This new edition covers all SQR language elements and features, showing developers the best ways of utilizing the languages capabilities and demonstrating good programming habits. Written in a `let`s do it together` tutorial style, this book starts with the basics and leads users toward a full understanding of the subject. Part one describes the SQR language with all of its features, while part two covers all aspects of interaction between SQR programs and PeopleSoft. This makes the book a working manual for both SQR programmers and PeopleSoft developers. [detailed...]

ISBN: 1932394001
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Jeffrey Posulns, Robert J. Shimonski, Jeremy Faircloth
SSCP Study Guide and DVD Training System

— y.
Publisher: —
Description: The SSCP Study Guide &, DVD Training System is a one-of-a-kind integration of text, DVD-quality instructor led training, and Web-based exam simulation and remediation. This system gives you 100% coverage of the official International Information Systems Security Certification Consortium, Inc. (ISC)2 SSCP security domains plus test preparation software for the edge you need to pass the exam on your first try. [detailed...]

ISBN: 1931836809
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Daniel J. Barrett, Richard E. Silverman, Robert G. Byrnes
SSH, the Secure Shell: The Definitive Guide

2005 y.
Publisher: —
Description: Are you serious about network security? Then check out SSH, the Secure Shell, which provides key-based authentication and transparent encryption for your network connections. It`s reliable, robust, and reasonably easy to use, and both free and commercialimplementations are widely available for most operating systems. While it doesn`t solve every privacy and security problem, SSH eliminates several of them very effectively. Everything you want to know about SSH is in our second edition of SSH, The Scure Shell: The Definitive Guide . This updated book thoroughly covers the latest SSH-2 protocol for system administrators and end users interested in using this increasingly popular TCP/IP-based solution. How does it work? Whenever data is sent to he network, SSH automatically encrypts it. When data reaches its intended recipient, SSH decrypts it. The result is `transparent` encryption-users can work normally, unaware that their communications are already encrypted. SSH… [detailed...]

ISBN: 0596008953
Book size: —; Page extent: 645.

 

PUT TO
THE BASKET
Arnold, Dr. Tilden, Dr. Arnold Tilden
SST

— y.
Publisher: —
Description: SST ? is a powerful sales education program that has enabled clients to improve performance by up to 500% by teaching them the skills and tools to communicate in the preferred style of the buyer. It emphasizes the importance of learning one personality type extremely well: your own. [detailed...]

ISBN: 0738830720
Book size: —; Page extent: —.

 

PUT TO
THE BASKET
Creative Mechanics
STAGE THIS! Ten-Minute Plays

2005 y.
Publisher: —
Description: Book DescriptionA collection of ten-minute plays from Creative Mechanics Theatre Company and E Merging Writers? 2005 competition, Stage This! is an exciting and diverse group of new plays ripe for reading and demanding to be staged.Download DescriptionA collection of ten-minute plays from Creative Mechanics Theatre Company and E Merging Writers` 2005 competition, Stage This! is an exciting and diverse group of new plays ripe for reading and demanding to be staged. [detailed...]

ISBN: 0595346596
Book size: —; Page extent: 114.

 

PUT TO
THE BASKET
Сайт создан в системе uCoz