Would the basics of SQL querying be useful to you, but you dont want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics–and more–in an easily digestible way.

+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutralso very adaptable and flexiblebut the books Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

SQL Server 2005, Microsoft’s next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power–making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.Programming SQL Server 2005 from O’Reilly provides a practical look at this updated version of Microsoft’s premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005.

Programming SQL Server 2005 can help you:

• Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable
• Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications
• Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems

Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it’s beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts.

The implementation of stored procedures in MySQL 5.0 a huge milestone — one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work — and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

The “MySQL Phrasebook” is a pocket guide that is jam-packed with useful and essential code “phrases” for the MySQL developer’s everyday use. Packed with practical solutions for tasks that the MySQL developer must accomplish every day, it fills the need for a short, functional, to-the-point reference for MySQL. This is the guide to consult when you need an immediate, applicable solution to frequent tasks and code that is flexible and adaptable to your needs. Your time won’t be wasted on more tutorials — it simply puts essential “phrases” at your fingertips that you can take with you everywhere.

If you’re new to databases, or need a SQL refresher, this step-by-step introduction has everything you need to generate, manipulate, and retrieve data using Microsoft’s SQL Server 2005. Every topic, concept, and idea in the book comes with examples of code and output, along with exercises to help you gain proficiency. Plenty of texts explain database theory. This book lets you apply the theory as you learn SQL.

Anyone who interacts with today’s modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

 For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any “bad SQL” later.In The Art of SQL, author and SQL expert Stephane Faroult argues that this “safe approach” only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

The Art of SQL offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult’s approach takes a page from Sun Tzu’s classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can’t be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

Beginning with an overview
of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you’ll be prepared to meet the ever-increasing demands of programming.

What you will learn from this book
* How T-SQL provides you with the means to create tools for managing hundreds of databases
* Various programming techniques that use views and stored procedures
* Ways to optimize query performance
* How to create databases that will be an essential foundation to applications you develop later

PL/SQL, Oracle’s powerful procedural language, has been the cornerstone
of Oracle application development for nearly 15 years. Although
primarily a tool for developers, PL/SQL has also become an essential
tool for database administration, as DBAs take increasing
responsibility for site performance and as the lines between developers
and DBAs blur.

Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs
fills the gap. Covering the latest Oracle version, Oracle Database 10g
Release 2 and packed with code and usage examples, it contains:

• A quick tour of the PL/SQL language, providing enough basic information about language fundamentals to get DBAs up and running
• Extensive
  coverage of security topics for DBAs: Encryption (including both
  traditional methods and Oracle’s new Transparent Data Encryption, TDE);
  Row-Level Security (RLS), Fine-Grained Auditing (FGA); and random value
  generation
• Methods for DBAs to improve query and database performance with cursors and table functions
• Coverage
  of Oracle scheduling, which allows jobs such as database monitoring and
  statistics gathering to be scheduled for regular execution

Using Oracle’s built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA,
DBMS_RANDOM, DBMS_SCHEDULING) as a base, the book describes ways of
building on top of these packages to suit particular organizational
needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world’s foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

SAP R/3 for Everyone is the nontechnical user’s guide to working with SAP R/3, the leading business enterprise software product in the world. Written and road-tested by experienced SAP R/3 users and trainers, this book saves typical SAP R/3 users time and
trouble by providing them with the universal skills needed to work with any module of this complex software.

SAP R/3 can be used effectively by anyone who can perform a handful of simple procedures that are employed in nearly every SAP R/3 transaction. The authors explain these procedures in plain English, using illustrations and real-world examples.

After a brief explanation of the architecture and operation of SAP R/3, readers get step-by-step instruction in

• Logging on and off, managing passwords, and customizing the SAP application window and screens
• Navigating between screens with menu folders, transaction codes, and the menu bar
• Setting up customized favorites folders with quick links to the initial screens of transactions and other useful resources
• Understanding the four basic transaction types
• Working
  on initial screens, including tips and techniques for entering codes,
  searching for codes, customizing initial screens, and using multiple
  selection screens and selection options
• Customizing output reports with filters, sorts, sums, and display variants
• Exporting output reports to Microsoft Excel and Word and e-mailing output reports to other SAP users

ISBN:

076457955X

Link:

http://rapidshare.de/files/19651089/Beginning_Transact-SQL_with_SQL_Server_2000_and_2005.rar