Learn Java, Cisco, Linux, Microsoft

Provide Learning tools , Ebooks for Java, Cisco, Linux, Microsoft

. .
Showing posts with label Data Base. Show all posts
Showing posts with label Data Base. Show all posts
Friday, September 25, 2009

Oracle PL/SQL Programming, Fifth Edition



This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website.
This indispensable reference for both novices and experienced Oracle programmers will help you:
- Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
- Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
- Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
- Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
- Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
- Build modular PL/SQL applications using procedures, functions, triggers, and packages


Download 

comments (0)

Friday, September 11, 2009

Oracle - July/August 2009 (Data Base)

 
Download

comments (0)

Saturday, September 5, 2009

Mastering Oracle 8i ( Data Base )

 
Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you’re working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you’d want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There’s some discussion of hooks for software developers, as well.
Download          Mirror             Mirror2

comments (0)

Monday, August 31, 2009

A Beginner's Guide for Databases

 
Description: Essential Database Skills--Made Easy!

Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases.

Designed for Easy Learning
Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
Ask the Expert--Q&A sections filled with bonus information and helpful tips
Try This--Hands-on exercises that show you how to apply your skills
Notes--Extra information related to the topic being covered
Self Tests--Chapter-ending quizzes to test your knowledge

comments (0)

Saturday, August 29, 2009

Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites

 

Download Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites at High Speed


Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic Websites


If you know HTML, this guide will have you building interactive websites quickly. You'll learn how to create responsive, data-driven websites with PHP, MySQL, and javascript, regardless of whether you already know how to program. Discover how the powerful combination of PHP and MySQL provides an easy way to build modern websites complete with dynamic data and user interaction. You'll also learn how to add javascript to create rich Internet applications and websites.Learning PHP, MySQL, and javascript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.

This book will help you:
• Understand PHP essentials and the basics of object-oriented programming
• Master MySQL, from database structure to complex queries
• Create web pages with PHP and MySQL by integrating forms and other HTML features
• Learn about javascript, from functions and event handling to accessing the Document Object Model
• Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
• Make Ajax calls and turn your website into a highly dynamic environment
• Upload and manipulate files and images, validate user input, and secure your applications

comments (0)

Data Mining with Microsoft SQL Server 2008

 
Description: Understand how to use the new features of Microsoft SQL Server 2008 for data mining by using the tools in Data Mining with Microsoft SQL Server 2008, which will show you how to use the SQL Server Data Mining Toolset with Office 2007 to mine and analyze data. Explore each of the major data mining algorithms, including naive bayes, decision trees, time series, clustering, association rules, and neural networks. Learn more about topics like mining OLAP databases, data mining with SQL Server Integration Services 2008, and using Microsoft data mining to solve business analysis problems.
Download

comments (0)

Thursday, August 27, 2009

Beginning Access 2007 VBA

 
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object-oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands-on experience in building real-world solutions using the concepts covered in the book.

comments (0)

Friday, August 21, 2009

Microsoft SQL Server 2008 Administration with Windows PowerShell


The definitive guide to automating SQL Server admnistration with Powershell scripts
If you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server.

You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort.

# The new release of Microsoft SQL Server 2008 now includes Windows PowerShell, allowing administrators of large-scale enterprise databases to automate many tasks
# SQL Server 2008 Administration with Windows PowerShell introduces you to PowerShell, covering its components in detail as well as providing basic instruction in using scripts to administer the database
# The book includes numerous examples of SQL tasks that have been automated and also provides completed scripts that you can put to use immediately
# The Companion Web site includes complete code scripts

If you're a database administrator, the scripts and techniques in SQL Server 2008 Administration with Windows PowerShell will save you hours of effort.

comments (0)

Friday, August 7, 2009

Teach Yourself MySQL in 10 Minutes


Sams Teach Yourself MySQL in 10 Minutes provides a no-fluff, just-the-answers guide to building and managing MySQL databases. It is carefully organized and thoughtfully written to provide just the information that you need in order to gain a rapid working knowledge of MySQL. Get up to speed quickly with Sams Teach Yourself MySQL in 10 Minutes.

comments (0)

Wednesday, August 5, 2009

Oracle Database 11g SQL - Master SQL and PL/SQL in the Oracle Database


"Oracle Database 11g SQL - Master SQL and PL/SQL in the Oracle Database" November 2008 | English | 690 Pages | PDF | 7 MB

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

* Explore SQL Plus and SQL Developer
* Use SQL SELECT, INSERT, UPDATE, and DELETE statements
* Write PL/SQL programs
* Create tables, sequences, indexes, views, and triggers
* Write advanced queries containing complex analytical functions
* Create database objects and collections to handle abstract data
* Use large objects to handle multimedia files containing music and movies
* Write Java programs to access an Oracle Database using JDBC
* Tune your SQL statements to make them execute faster
* Explore the XML capabilities of the Oracle Database
* Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

comments (0)

Subscribe to: Posts (Atom)