The Language of SQL: How to Access Data in Relational Databases

The Language of SQL: How to Access Data in Relational Databases

1 edition (June 3, 2010) | ISBN: 143545751X | Pages: 256 | PDF | 14.86 MB

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special "Database Differences" boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.

Download

Programming Microsoft SQL Server 2012

Programming Microsoft SQL Server 2012

2012 | 816 Pages | ISBN: 0735658226 | EPUB + PDF | 12 MB + 24 MB

Take your database programming skills to a new level��and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you��re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

Download

or

Download

High Performance MySQL: Optimization, Backups, and Replication

High Performance MySQL: Optimization, Backups, and Replication

Publisher: O'R[eil]ly M[ed]ia; 3 edition 2012 | 826 Pages | ISBN: 1449314287 | EPUB + PDF | 5 MB + 16 MB

How can you bring out MySQLs full power? With High Performance MySQL youll learn advanced techniques for everything from designing schemas, indexes and queries to tuning your MySQL server operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Download

or

Download

Modern Database Management (10th Edition)

Modern Database Management (10th Edition)

10/ed(6-2010) | PDF | 624 pages | ISBN: 0136088392 | 8.42 Mb

Provide the latest information in database development. Focusing on what leading database practitioners say are the most important aspects to database development, Modern Database Management presents sound pedagogy and includes topics that are critical for the practical success of database professionals.

This text also continues to guide readers into the future by presenting research that could reveal the ��next big thing�� in database management.

The tenth edition reflects the major trends in information systems and helps readers acquire the skills the need to be successful in today��s database management field.

Download

Oracle Database 11g R2 Performance Tuning Cookbook

Oracle Database 11g R2 Performance Tuning Cookbook

2012 | 542 Pages | ISBN: 1849682607 | PDF | 9.09 Mb

Achieve better performance from your Oracle Database applications

Learn the right techniques to achieve best performance from the Oracle Database 

Avoid common myths and pitfalls that slow down the database 

Diagnose problems when they arise and employ tricks to prevent them 

Explore various aspects that affect performance, from application design to system tuning

In Detail

Oracle's Database offers great performance, scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into performance issues and when a problem arises it's very difficult to identify the cause and the right solution to the problem. 

The Oracle Database 11g R2 Performance Tuning Cookbook helps DBAs and developers to understand every aspect of Oracle Database that can affect performance. You will be guided through implementing the correct solution in a proactive way before problems arise, and how to diagnose issues on your Oracle database-based solutions. 

This fast-paced book offers solutions starting from application design and development, through the implementation of well-performing applications, to the details of deployment and delivering best-performance databases. 

With this book you will quickly learn to apply the right methodology to tune the performance of an Oracle Database, and to optimize application design and SQL and PL/SQL code. By following the real-world examples you will see how to store your data in correct structures and access and manipulate them at a lightning speed. You will learn to speed up sort operations, hack the optimizer and the data loading process, and diagnose and tune memory, I/O, and contention issues. 

The purpose of this cookbook is to provide concise recipes, which will help you to build and maintain a very high-speed Oracle Database environment. 

Effectively apply performance tuning principles with concise recipes

What you will learn from this book

Design applications that run at lightning speed 

Implement fast and scalable SQL and PL/SQL code 

Choose the correct structures to store the data and access them 

Optimize sort operations, such as order-by, Top-N queries, ranking, and set operators 

Help the optimizer to choose the right access plan to retrieve data at the best available speed 

Load data in the database at a faster speed by using the correct tools and options 

Tune the database memory to obtain maximum performance using available resources 

Tune the I/O operations, by designing a database over the I/O system 

Tune and reduce contention issues on data and structures by using an optimal design 

Approach

In this book you will find both examples and theoretical concepts covered.

Every recipe is based on a script/procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another.

Who this book is written for

This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. 

If you are an architect who wants to design better applications, a DBA who is keen to dig into the causes of performance issues, or a developer who wants to learn why and where the application is running slow, this is the book for you. 

Basic knowledge of SQL language is required and general knowledge of the Oracle Database architecture is preferable.

Download

or

Download

Pro Silverlight 5 in VB

Pro Silverlight 5 in VB

Publisher: A[pre]ss; 4 edition 2012 | 976 Pages | ISBN: 1430235187 | EPUB + PDF | 30 MB + 27 MB

Silverlight 5 is the latest iteration of Microsoft's cross-browser technology for creating rich user experiences on the Web. Like its predecessor, Silverlight 4, it rides atop the .NET Framework for maximum ease of use and coding efficiency. The new technology carries forward much of the work that has been done before and augments it in many important respects, including support for H.264 video, major improvements to the graphics engine (including true 3D rendering), and much richer data-binding options for interfacing with other applications.

Download

or

Download

Microsoft ADO.NET 4 Step by Step

Microsoft ADO.NET 4 Step by Step Summary:

Micrоsoft Prеss | 2010-11-01 | 0735638888 | PDF | 440 pages | 7.78 MB

Teach yourself the fundamentals of ADO.NET 4 -- one step at a time. With this practical, learn-by-doing tutorial, you get the clear guidance and hands-on examples you need to start creating datacentric applications for Windows® and the Web.

Discover how to:

Connect to external data sources, including databases and other data formats 

Use ADO.NET Entity Framework to interact with underlying data stores 

Build Entity Framework models with graphical design tools in Microsoft Visual Studio 2010 

Analyze information stored in ADO.NET with various LINQ providers 

Bind data directly to Windows Forms and Web Forms to drive information to users 

Manage disconnected or standalone data and information 

Go beyond the core functionality of ADO.NET to manipulate data in more advanced ways 

Your step by step digital content includes:

Practice exercises 

Fully searchable online edition of this book -- with unlimited access on the Web

Download

or

Download

or

Download

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Mastering phpMyAdmin 3.3.x for Effective MySQL Management- Summary:

P..t (10-2010) | PDF | 412 Pages | 1849513546 | 16.6Mb

phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions.

However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.

Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy to follow, step by step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up to date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.

Download

or

Download

or
Download

Oracle Warehouse Builder 11g R2: Getting Started 2011 (with code)

Oracle Warehouse Builder 11g R2: Getting Started 2011 (with code) Summary:

Publisher: Pa,ckt Pub,lishi,ng 2011 | 424 Pages | ISBN: 1849683441 | PDF | 10 MB

In today’s economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database. Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time. This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book’s end, you will have built your own data warehouse from scratch. Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You’ll follow the whole process with detailed screenshots of key steps along the way that have all been updated for the new Fusion Client Platform interface in 11gR2, alongside numerous tips and hints not covered by the official documentation. You’ll finish up with a brand new chapter on code templates where you’ll implement a complete mapping using JDBC connectivity and code template mappings.

• Configure your Oracle database to communicate with a non-Oracle database using Oracle Heterogeneous Services
• Build, view, and edit a cube and its dimensions, using Warehouse Builder Wizards and the Data Object Editor
• Discover the underlying star schema relational structure that Warehouse Builder will build to implement your cube and dimensions
• Recognize what a staging area is, and build a staging table and mapping to load it from SQL Server database tables
• Master various operators for use in mappings, for the transformation and flow of data
• Build and execute mappings to load dimensions and a cube using the Warehouse Builder Mapping Editor and Control Center Manager
• Detailed explanation of the new interface in 11gR2
• Implement JDBC connectivity to a remote database and access source data using a code template mapping

Download

or

Download

or

Download

or
Download

or

Download

or

Download

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2 ed

Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard, 2 ed Summary:

MgH Osb..ne M.dia | 2011 | ISBN: 0071752080 | 557 pages | PDF | 5,4 MB

Leverage Oracle Database 11g Release 2 High Availability Features Protect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource. Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version 

Build test clusters and hosts using Oracle VM 

Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System 

Create synchronized standby databases using Oracle Data Guard 

Reliably archive and restore data with Oracle Recovery Manager 

Use Oracle Flashback to identify and undo user errors 

Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment.

Download 

Oracle Database 10g: The Complete Reference

Oracle Database 10g: The Complete Reference Summary:

Publisher: McGraw-Hill Osborne Media | ISBN: 0072253517 | edition 2004 | PDF | 1348 pages | 5,5 mb

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs.

Download

or

Download 

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 Summary:

Publisher: Ad..dison-Wesl.ey Professional 2008 | 304 Pages | ISBN: 0321497643 | PDF | 3 MB

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn’t enough: models that don’t reflect SQL Server’s unique real-world strengths and weaknesses often lead to disastrous performance. A Developer’s Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms. You’ll begin with a concise, practical overview of the core data modeling techniques. Next, you’ll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you’ll systematically transform those logical models into physical models that make the most of SQL Server’s extended functionality. All of this book’s many examples are available for download from a companion Web site.

Understand your data model’s physical elements, from storage to referential integrity

Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration

Normalize data models, one step at a time

Gather and interpret requirements more effectively

Learn an effective methodology for creating logical models

Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships 

Create physical models—from establishing naming guidelines through implementing business rules and constraints

Use SQL Server’s unique indexing capabilities, and overcome their limitations

Create abstraction layers that enhance security, extensibility, and flexibility.

Download

or

Download

or

Download

PostgreSQL Developer's Handbook

PostgreSQL Developer's Handbook Summary:

Publisher: Sams | ISBN: 0672322609 | edition 2001 | CHM | 768 pages | 2,2 mb

PostgreSQL is an object-relational database server that is widely considered to be the world's most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP.

Download

or

Download 

Inductive Databases and Constraint-Based Data Mining

Inductive Databases and Constraint-Based Data Mining Summary:

Sp-r | 2010 | ISBN: 1441977376 | 458 pages | PDF | 4,6 MB

This book presents inductive databases and constraint-based data mining, emerging research topics lying at the intersection of data mining and database research. The book provides an overview of the state-of-the art in this novel research area. Of special interest are the recent methods for constraint-based mining of global models for prediction and clustering, the unification of pattern mining approaches through constraint programming, the clarification of the relationship between mining local patterns and global models, and the proposed integrative frameworks and approaches for inductive databases. On the application side, applications to practically relevant problems from bioinformatics are presented to attract additional attention from a wider audience.

The primary audience consists of scientists and graduate students in computer science and bio-informatics. Potential readers are likely to attend conferences on databases, data mining/ machine learning, and bio-informatics.

Download

or

Download

or

Download

Oracle APEX 4.0 Cookbook

Oracle APEX 4.0 Cookbook Summary:

Packt Publishing | 2010 | ISBN: 1849681341 | 328 pages | PDF | 12,1 MB

Over 80 great recipes to develop and deploy fast, secure, and modern web applications with Oracle Application Express 4.0

Create feature-rich web applications in APEX 4.0

Integrate third-party applications like Google Maps into APEX by using web services

Enhance APEX applications by using stylesheets, Plug-ins, Dynamic Actions, AJAX, JavaScript, BI Publisher, and jQuery

Hands-on examples to make the most out of the possibilities that APEX has to offer

Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible In Detail Oracle Application Express 4.0 is a rapid web application development tool that works with the Oracle database. Using features like Plug-ins and Dynamic Actions, APEX helps you build applications with the latest techniques in AJAX and JavaScript. The Oracle Application Express 4.0 Cookbook shows you recipes to develop and deploy reliable, modern web applications using only a web browser and limited programming experience. With recipes covering many different topics, it will show you how to use the many features of APEX 4.0. You will learn how to create simple form and report pages and how to enhance the look of your applications by using stylesheets. You will see how you can integrate things such as Tag Clouds, Google Maps, web services, and much more in your applications. Using Plug-ins, Dynamic Actions, BI Publisher, translations and Websheets, you will be able to enhance your applications to a new level in APEX. This book will show you how to be Agile in the development of your web applications by using Team Development, debugging, and third-party tools. After reading this book, you will be able to create feature-rich web applications in Application Express 4.0 with ease and confidence. A practical reference guide with over 70 recipes for every APEX developer What you will learn from this book

Create feature-rich web applications in APEX 4.0

Integrate third-party applications like Google Maps into APEX by using web services

Enhance APEX applications by using stylesheets, Plug-ins, Dynamic Actions, AJAX, JavaScript, BI Publisher, and jQuery

Hands-on examples to make the most out of the possibilities that APEX has to offer

Find out about the APEX Dictionary, Translations, Websheets, and the new Application Builder

Make the development process easier by using debugging

Deploy APEX applications using the APEX Listener and Apache

Use Team Development to make APEX projects lean and Agile

Download

or

Download

MySQL (4th Edition)

MySQL (4th Edition) Summary:

Publisher: Addison-Wesley 2008 | 1224 Pages | ISBN: 0672329387 | PDF | 4 MB

The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn't "free" about MySQL (the application) is its server's commercial use; all clients and noncommercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its value and the value of its namesake.

The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)

The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces. 

Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.

Although it is nearly 800 pages in length, DuBois's book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application.

Download

or
Download

or
Download 

Oracle CRM On Demand Deployment Guide (Osborne ORACLE Press Series

Oracle CRM On Demand Deployment Guide (Osborne ORACLE Press Series) Summary:

Media; 1 edition (May 17, 2010) | ISBN: 0071717633 | 240 pages | PDF | 4 MB

Foster long-term customer relationships and accelerate productivity using the proven strategies and best practices in this Oracle Press guide. Oracle CRM On Demand Deployment Guide shows how to set up, customize, and manage a dynamic software-as-a-service solution across your enterprise. Develop implementation plans, maximize user adoption, build applets and portals, integrate Web 2.0 features, and use analytics dashboards. The latest design, tuning, and data security techniques are also covered in this practical resource. * Establish business objectives, project requirements, and key success metrics

* Staff an implementation team and develop effective rollout plans

* Configure, deploy, and administer Oracle CRM On Demand

* Manage users and restrict access using roles and privileges

* Customize sales, marketing, and service processes with the object model

* Embed external content and URLs using the web services API

* Distribute real-time BI using dashboards and advanced reporting tools

* Incorporate web tabs, mashups, Google services, and RSS feeds

Download

or

Download

Knowledge Discovery Practices and Emerging Applications of Data Mining: Trends and New Domains

Knowledge Discovery Practices and Emerging Applications of Data Mining: Trends and New Domains Summary:

IG.I Gl.bal | 2010 | ISBN: 1609600673 | 350 pages | PDF | 6 MB

Recent developments have drastically increased the volume and complexity of data available to be mined, leading researchers to explore new ways to glean non-trivial data automatically. Knowledge Discovery Practices and Emerging Applications of Data Mining: Trends and New Domains introduces the reader to recent research activities in the field of data mining. This book covers association mining, classification, mobile marketing, opinion mining, microarray data mining, internet mining and applications of data mining on biological data, telecommunication and distributed databases, among others, while promoting understanding and implementation of data mining techniques in emerging domains.

Download

or
Download

or

Download

Oracle Enterprise Manager 10g Grid Control Handbook

Oracle Enterprise Manager 10g Grid Control Handbook Summary:

Mc Gra w-H ill Osbo rne M edia | 2010 | ISBN: 0071634223 | 688 pages | PDF | 10,2 MB

Master Oracle Enterprise Manager 10g Grid Control Centralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, implement top-down performance monitoring, and maximize system availability.

Plan and carry out an Oracle Enterprise Manager 10g Grid Control rollout 

Set up customized metrics, alerts, thresholds, targets, and agents 

Manage IT resources from a centralized control console or the command line 

Manage your infrastructure using secure protocols 

Automate administrative tasks with Oracle's management agent 

Distribute business intelligence using the reporting and dashboard features 

Work with Oracle Enterprise Manager Database Control and Oracle Real Application Clusters 

Build physical and logical standby databases using Oracle Data Guard.

Download

or

Download 

Oracle 10g sous Windows

Oracle 10g sous Windows Summary:

Eyr-olles | 2006 | ISBN: 2212117078 | 845 pages | PDF | 16,6 MB

Un ouvrage de référence. Pratique et exhaustif, ce livre fournira au lecteur toutes les clés pour réussir l'intégration et l'exploitation d'Oracle 10g en environnement Windows : installation, configuration, création d'une base de données, stratégie de sécurité, administration, gestion des sauvegardes et du stockage, optimisation des performances, développement Java et XML... Il l'aidera à choisir parmi les multiples options possibles et le guidera pas à pas grâce à des check-lists et des conseils précis.

Download

or
Download