Showing posts with label Databases and SQL. Show all posts
Showing posts with label Databases and SQL. Show all posts

Expert Cube Development With Microsoft Sql Server 2008 Analysis Services

Chris Webb, Marco Russo, Alberto Ferrari "Expert Cube Development With Microsoft Sql Server 2008 Analysis Services"
PP | English | 2009 | ISBN: 1847197221 | 360 pages | PDF | 5,6 MB


Microsoft SQL Server Analysis Services ("Analysis Services" from here on) is now ten years old, a mature product proven in thousands of enterprise-level deployments around the world. Starting from a point where few people knew it existed and where those that did were often suspicious of it, it has grown to be the most widely deployed OLAP server and one of the keystones of Microsoft's Business Intelligence (BI) product strategy. Part of the reason for its success has been the easy availability of information about it: apart from the documentation Microsoft provides there are white papers, blogs, newsgroups, online forums, and books galore on the subject. So why write yet another book on Analysis Services? The short answer is to bring together all of the practical, real-world knowledge about Analysis Services that's out there into one place.

We, the authors of this book, are consultants who have spent the last few years of our professional lives designing and building solutions based on the Microsoft Business Intelligence platform and helping other people to do so. We've watched Analysis Services grow to maturity and at the same time seen more and more people move from being hesitant beginners on their first project to confident cube designers, but at the same time we felt that there were no books on the market aimed at this emerging group of intermediate-to-experienced users. Similarly, all of the Analysis Services books we read concerned themselves with describing its functionality and what you could potentially do with it but none addressed the practical problems we encountered day-to-day in our work—the problems of how you should go about designing cubes, what the best practices for doing so are, which areas of functionality work well and which don't, and so on. We wanted to write this book to fill these two gaps, and to allow us to share our hard-won experience. Most technical books are published to coincide with the release of a new version of a product and so are written using beta software, before the author has had a chance to use the new version in a real project. This book, on the other hand, has been written with the benefit of having used Analysis Services 2008 for almost a year and before that Analysis Services 2005 for more than three years.


PMP Exam Prep, Sixth Edition


PMP Exam Prep, Sixth Edition, « Rita's Course in a Book for Passing the PMP Exam»
RMC Publications, Inc. | 2009-04-10 | ISBN: 1932735186 | 544 pages | PDF | 18,9 MB

Can you imagine valuing a book so much that you send the author a Thank You letter?

Hundreds of thousands of project managers understand why PMP Exam Prep by Rita Mulcahy, PMP, is a worldwide best-seller. Is it Rita's years of PMP exam preparation experience? The endless hours of ongoing research? The interviews with project managers who failed the exam, to identify gaps in their knowledge? Or is it the razor-sharp focus on making sure project managers don't waste a single minute of their time studying any more than they absolutely have to? Actually, it's all of the above.

PMP Exam Prep, Sixth Edition by Rita Mulcahy contains hundreds of updates and improvements from previous editions--including new exercises and sample questions never before in print. Offering hundreds of sample questions, critical time-saving tips plus games and activities available nowhere else, this book will help you pass the PMP exam on your FIRST try.

Learning PHP and MySQL

Learning PHP and MySQL

Publisher: O'Reilly Media, Inc | ISBN: 0596101104 | edition 2006 | CHM | 376 pages | 12,2 mb

The PHP scripting language and MySQL open source database are quite effective independently, but together they make a simply unbeatable team. When working hand-in-hand, they serve as the standard for the rapid development of dynamic, database-driven websites. This combination is so popular, in fact, that it's attracting many programming newbies who come from a web or graphic design background and whose first language is HTML. If you fall into this ever-expanding category, then this book is for you.
Learning PHP and MySQL starts with the very basics of the PHP language, including strings and arrays, pattern matching and a detailed discussion of the variances in different PHP versions. Next, it explains how to work with MySQL, covering information on SQL data access for language and data fundamentals like tables and statements. Finally, after it's sure that you've mastered these separate concepts, the book shows you how to put them together to generate dynamic content. In the process, you'll also learn about error handling, security, HTTP authentication, and more.


Depositfiles

mirror

mirror

Php Oracle Web Development: Data Processing, Security, Caching, Xml, Web Services, and Ajax

Yuli Vasiliev "Php Oracle Web Development: Data Processing, Security, Caching, Xml, Web Services, and Ajax"
PP | English | 2007 | ISBN: 1847193633 | 396 pages | PDF | 7,1 MB


Oracle Database gets high marks for performance, reliability, and scalability. Building and deploying your PHP applications on Oracle Database enables you to combine the power and robustness of Oracle and the ease of use, short development time, and high performance of PHP. When used in a complementary way, PHP and Oracle allow you to build high-performance, scalable, and reliable data-driven Web applications with a minimum of effort.
When building a PHP/Oracle application, you have two general options. The first is to use an Oracle database just to store data, performing all the operations on that data on the client side; the other is to use the database not only to store data, but also to process it, thus moving data processing to the data. While building the key business logic of a database-driven PHP application inside the database is always a good idea, you should bear in mind that not all of the databases available today allow you to do. The Oracle database, which offers record-breaking performance, scalability, and reliability, does. The partnership of Oracle and the open-source scripting language PHP is an excellent solution for building high-performance, scalable, and reliable data-driven web applications.
This 100% practical book is crammed full of easy-to-follow examples. It provides all the tools a PHP/Oracle developer needs to take advantage of the winning combination. It addresses the needs of a wide spectrum of PHP/Oracle developers, placing the emphasis on the most up-to-date topics, such as new PHP and Oracle Database features, stored procedure programming, handling transactions, security, caching, web services, and Ajax.
What you will learn from this book?
• Install and configure PHP and Oracle software
• Connect PHP with Oracle
• Move key application business logic into the database
• Build transactional PHP/Oracle applications
• Use security features of PHP and Oracle
• Improve performance with caching
• Employ XML features of PHP and Oracle
• Implement SOAP Web services with PHP and Oracle
• Build Ajax-driven PHP/Oracle solutions
Approach
Through numerous examples, this book shows you how to build simple and efficient PHP applications on top of Oracle, efficiently distributing data processing between the Web/PHP server and Oracle Database server.
Who this book is written for?
Although this book covers only the most popular and up-to-date topic areas on the use of PHP in conjunction with Oracle, the author does not make any assumption about the skill level of the reader. Packed with information in an easy-to-read format, the book is ideal for any PHP developer who deals with Oracle.


Oracle Sql Developer 2.1 (repost)

Sue Harper "Oracle Sql Developer 2.1"
PP | English | October 2009 | ISBN: 1847196268 | 496 pages | PDF | 10,6 MB


Oracle SQL Developer is a relatively new product included in the range of Oracle products. It was first introduced to the world in September 2005, by its code name Project Raptor. Raptor is a name many still cling to, despite being replaced very quickly with the full product name, Oracle SQL Developer (and referred to in the rest of the book as SQL Developer). The first production version was released in early 2006 and had many Oracle customers both skeptical and excited.

SQL Developer is a Graphical User Interface (GUI) for browsing and working with databases. Primarily developed for the Oracle database, it also provides a GUI for a selection of popular non-Oracle databases. As technology has evolved, many developers are looking for modern tools to assist them in daily tasks. A clean, easy to navigate interface is essential and many tools are judged on looks, performance, and functionality.

Initially billed as a light-weight, clean, easy to install GUI for the Oracle database, SQL Developer is gaining momentum in the market and broadening its scope in its offering.

The skeptics mentioned are ever concerned that Oracle is not really interested in the product, backing up this concern with the fact that SQL Developer is free. Disappointing as it is that "free" is equated with "poor quality", the last couple of years have considerably stilled many of these dissenting voices and the market using SQL Developer continues to increase. Time will tell.


Apache Roller 4.0 - Beginner's Guide

Alfonso Romero "Apache Roller 4.0 - Beginner's Guide"
PP | English | | ISBN: 184719950X | 388 pages | PDF | 18 MB


This beginner's guide is packed with information, tips, and tricks, based on the author's extensive experience with Apache Roller. In next to no time, you will be able to build and deploy your own blog. The clear and concise hands-on exercises will teach you everything you need to know to install, configure, and use Apache Roller, along with the open source software required to run it. The book includes plenty of illustrations to guide you through all the detailed exercises and tutorials, so you can get the most out of every chapter. If you are interested in establishing a blog, using Apache Roller and popular web applications to write attractive posts and promote your blog on all the major social bookmarking services, this book is for you. No previous experience on Tomcat, MySQL, the Apache Web Server, or Linux is required.



AppDev Microsoft SQL Server Reporting Services 2008 DVD-iNKiSO (2009)

AppDev Microsoft SQL Server Reporting Services 2008 DVD-iNKiSO
Rls.Date: 17/12/2009 | Tech Bookware | ISO | 1,89 Gb

In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you'll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follow using a variety of formats and client-side printing. You'll gain knowledge of SSRS Security in managing of user roles and accounts. You'll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.

Prerequisites: This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development, Visual Studio 2008 using Visual Basic and administrative tasks. Write and run expressions, script files and diagnose problems that occur.

Course includes 42+ hours of total training time...
* 12 modules of training
* Over 14 hours of media runtime
* Over 500 pages of printable courseware
* Step-by-step hands-on-labs
* Sample code

In this course, you will learn:
- Create tabular and list reports.
- Build expressions and how they are used within SSRS.
- Use global, field and parameter collections.
- Create Groups using the grouping pane for Details Group and Row Groups.
- Use parameters with stored procedures, with values on reports and unbound parameters.
- Create Matrix reports and see the new features of Matrix reports for SSRS 08.
- Deploy reports and use the report manager.
- Use SSRS Security, SSL and Data Source Security.
- Use Reporting Services APIs and Report Viewer Controls.
- Create a Web Service, a Web Service Subscription and Custom Assemblies.


Rls Date: 17/12/09
Type: Tech Bookware
Supplier: iNK H0RN
Disks: 1 DVD
Size Archive: 1,89 Gb

Install:
1. Extract
2. Mount/Burn
3. Play & Learn

Download:

Uploadbox.com
or
Rapidshare.com

SQL All-in-One Desk Reference For Dummies

Allen G. Taylor "SQL All-in-One Desk Reference For Dummies"
For Dummies | English | 2007-07-02 | ISBN: 0470119284 | 684 pages | PDF | 14 MB


SQL is the international standard language for creating and maintaining relational databases. This book is a compendium of information about SQL and relational database design, development, and maintenance. The nine mini-books cover the full spectrum of issues that arise in building, using, and maintaining relational database systems.

Book I: SQL Concepts

Book II: Relational Database Development

Book III: SQL Queries

Book IV: Data Security

Book V: SQL and Programming

Book VI: SQL and XML

Book VII: Database Tuning Overview

Book VIII: Appendixes

To start download click HERE:

Grundkurs Datenbankentwurf: Eine beispielorientierte Einführung für Studenten und Praktiker

Helmut Jarosch, "Grundkurs Datenbankentwurf: Eine beispielorientierte Einführung für Studenten und Praktiker"
Vieweg+Teubner Verlag | 2009 | ISBN: 3834809551 | 411 pages | PDF | 3,1 MB

Kurzbeschreibung Die Stimmen zur 1. und zur 2. Auflage bestätigen: Endlich ein Buch, das den Leser wirklich verständlich an die Hand nimmt und sicher zum Ziel führt. Dies gelingt durch konsequente Beispielorientierung und leichte Verständlichkeit. Unterstützt wird der Leser zusätzlich durch den Online-Service. Schritt für Schritt werden die Etappen von der Analyse der Realität, die im Datenmodell abgebildet werden soll, zur Datenbank-Strukturierung aufgezeigt. Besonderer Vorzug sind die illustrativen Anwendungsbeispiele aus verschiedenen Unternehmenszusammenhängen und kaufmännischen Bereichen, zu denen in der 3. Auflage ausführliche Lösungen ergänzt wurden. Das Buch eignet sich für Studenten und Praktiker gleichermaßen, vor allem für Informatiker, Wirtschaftsinformatiker und Betriebswirte.




SQL For Dummies

Allen G. Taylor "SQL For Dummies"
Wiley | English | August 2006 | ISBN: 047004652X | 432 pages | PDF | 7,4 MB


Become your own database guru and master the art and craft of SQL (structured query language) to access, manage, and manipulate data in a variety of relational database software programs. Get the inside tour of the major components of SQL with a copy of SQL For Dummies, 3rd Edition, by programming pro Allen Taylor. Whether you're seeking a friendly summary of basic SQL commands and statements -- or you're looking for advanced advice on database security, error handling, nested queries, ODBC, and dynamic SQL -- you'll find what you need in this book's easy-to-follow steps and examples, all written in clear, concise language.

Invoke the power of SQL without headaches and hassles as you progress from relational database fundamentals to building your own databases, retrieving data, controlling operations, and transferring data across a company intranet or the worldwide Internet. SQL For Dummies, 3rd Edition, also includes a glossary of important terms and three appendixes that cover reserved words in SQL-92, multilevel SQL subsets, and SQL implementation in Microsoft SQL Server 7.0. And, of course, this handy SQL reference includes the popular Part of Tens, where you can get the high-end lowdown on what to do, and what not to do, in designing, building, and using a relational database.

To start download click HERE:

Beginning Access 2003 VBA (Programmer to Programmer)

Beginning Access 2003 VBA (Programmer to Programmer)
Publisher: Wrox | ISBN: 0764556592 | edition 2004 | PDF | 545 pages | 11,7 mb

Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA. Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.
Not only do readers learn to build “stand-alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server.



Depositfiles

mirror

mirror

Programming Microsoft SQL Server 2000 with XML (Pro-Developer)

Programming Microsoft SQL Server 2000 with XML (Pro-Developer)
Publisher: Microsoft Press | ISBN: 0735613699 | edition 2001 | CHM | 277 pages | 10,7 mb

25-Word Description This title gives developers the expert guidance they need to build powerful, XML-enabled database applications for line-of-business, e-commerce, and the Web.
75-Word Description Extensible Markup Language (XML) is the lingua franca of business information exchange. This book gives developers the expert guidance they need to build powerful, XML-enabled database applications for line-of-business, e-commerce, and the Web. The author steps through the development of several real-world solutions, including enterprise knowledge-management systems and ultra-scalable electronic retail and business-to-business (B2B) solutions. The book includes code on a companion CD-ROM that readers can study and reuse in their own projects.



Depositfiles

Extabit

Megaupload

UML 2 pour les bases de données


Christian Soutou, ''UML 2 pour les bases de données''
Eyrolles (mars 2007) | ISBN: 2212120915 | PDF | French | 316 Pages | 5 MB

Permettant à l'origine de modéliser et de développer des applications écrites dans un langage objet (C++, Java), UML s'est imposé depuis quelques années sur le terrain de la conception de bases de données relationnelles. Le marché a suivi cette tendance car aujourd'hui, tous les outils de modélisation utilisent cette notation. Destiné aussi bien aux étudiants qu'aux professionnels, cet ouvrage explique ainsi comment construire un diagramme de classes avec UML 2 en vue de concevoir une base de données relationnelle de type SQL2 ou objet-relationnelle de type SQL3. Chaque chapitre se clôt par une série d'exercices dont les corrigés figurent sur le site www.editions-eyrolles.com.

Une étude comparative des outils de modélisation

Le dernier chapitre du livre dresse un panorama des principaux outils du marché (Enterprise Architect, MagicDraw, MEGA, ModelSphere, MyEclipse, Objecteering, Poséidon, PowerAMC, Rational Rose, Together, Visio, Visual Paradigm, Visual UML et Win'Design), en analysant pour chacun la manière dont il implémente différents critères de UML 2 : associations binaires et n-aires, classes-associations, agrégations, contraintes interassociations, héritage multiple avec contraintes, et rétrocon-ception d'une base de données.

A qui s'adresse cet ouvrage ?

* Aux étudiants en IUT, IUP, Deug et écoles d'ingénieur, ainsi qu'à leurs professeurs
* Aux professionnels souhaitant s'initier à la modélisation de bases de données avec UML
* À tous les concepteurs de bases de données désirant migrer de Merise à UML


SYSTEM 2000 CONTROL Language v12

SAS Institute Inc.,"SYSTEM 2000 CONTROL Language v12"
Publisher: SAS Publishing | ISBN: 1555441807 | edition August 6, 1991 | PDF | 116 pages | 19 mb

Describes how to use the CONTROL language to access SYSTEM 2000 facilities under MVS and CMS. Included is information on how to specify input and output files, save and restore databases, protect databases from unauthorized access, and use the Coordinated Recovery function.
My Links

uploading.com

depositfiles.com

megaupload.com

SYSTEM 2000 DEFINE Language v12



SAS Institute Inc.,"SYSTEM 2000 DEFINE Language v12"
Publisher: SAS Publishing | ISBN: 1555441793 | edition July 26, 1991 | PDF | 133 pages | 20.87 mb

Serves as a reference manual for the DEFINE language under MVS and CMS. This manual explains how to create and modify a SYSTEM 2000 database definition and includes a detailed description and examples for each DEFINE language command.
My Links

uploading.com

depositfiles.com

megaupload.com

Getting Started with SYSTEM 2000® DBMS



SAS Institute Inc.,"Getting Started with SYSTEM 2000® DBMS"
Publisher: SAS Publishing | ISBN: 1555441009 | edition January 1, 1992 | PDF | 72 pages | 15.16 mb

Introduces SYSTEM 2000 software and its associated facilities, and shows how to start using SYSTEM 2000 commands. The guide provides hands-on examples that illustrate how to define, access, and update a SYSTEM 2000 database, and guidelines for trying some of the options available with the basic commands.
My Links

uploading.com

depositfiles.com

megaupload.com

QUEUE Language for SYSTEM 2000® Software

SAS Institute Inc.,"QUEUE Language for SYSTEM 2000® Software"
Publisher: SAS Publishing | ISBN: 1555441005 | edition January 1, 1992 | PDF | 176 pages | 24.16 mb

Documents all aspects of the QUEUE language, previously documented in the three volumes of ACCESS and QUEUE languages manuals. Used together with the QUEST language manual, this technical report provides complete information for using the QUEUE facility in SYSTEM 2000 software. Also supports Version 12.
My Links

uploading.com

depositfiles.com

megaupload.com

SYSTEM 2000 Quick Reference Guide v12



SAS Institute Inc.,"SYSTEM 2000 Quick Reference Guide v12"
Publisher: SAS Publishing | ISBN: 1555441726 | edition January 1, 1992 | PDF | 176 pages | 13.7 mb

Documents all aspects of the QUEUE language, previously documented in the three volumes of ACCESS and QUEUE languages manuals. Used together with the QUEST language manual, this technical report provides complete information for using the QUEUE facility in SYSTEM 2000 software. Also supports Version 12.
My Links

uploading.com

depositfiles.com

megaupload.com

SYSTEM 2000 REPORT Language



SAS Institute Inc.,"SYSTEM 2000 REPORT Language"
Publisher: SAS Publishing | ISBN: 1555441815 | edition August 6, 1991 | PDF | 130 pages | 19.67 mb

Explains how to use REPORT language commands to produce reports from information contained in a SYSTEM 2000 database. This manual contains detailed reference material for using the REPORT language commands under MVS and CMS. Also included are examples of each command and examples of complete report composition and actual output.
My Links

uploading.com

depositfiles.com

megaupload.com

Multi-User Tuning Tools for SYSTEM 2000® Software



SAS Institute Inc.,"Multi-User Tuning Tools for SYSTEM 2000® Software"
Publisher: SAS Publishing | ISBN: 1555441580 | edition January 1, 1992 | PDF | 70 pages | 10 mb

Documents the Tuning Tools feature for SYSTEM 2000 Multi-User software. The Multi-User status console commands display details about thread, scratch pad, buffer, and queue usage. The Accounting and Diagnostic Log reports display information about system performance or about specific jobs and job types running in the system. Data are extracted from these logs into a SAS data set for use in reports, and they are summarized into historical SAS data sets for more general monthly, quarterly, or annual reports. Also supports Version 12.
My Links

uploading.com

depositfiles.com