From Herb Schildt, the number-one programming author worldwide, comes this fully revised and updated introductory Java guide. You will get all the information you need to get up and running with the latest version of the most popular Web programming language.
Java: A Beginner’s Guide, Fifth Edition will have you programming in Java right away. The book has been updated to cover the new features of Java including closures, the enhanced switch statement, the enhanced catchstatement, and extension methods, and more.
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
Tips–Helpful reminders or alternate ways of doing things
Self Tests–End-of-chapter reviews to test your knowledge
Annotated syntax–Example code with commentary that describes the programming techniques being illustrated
About the Author
Herb Schildt (Mahomet, IL) is the world’s leading programming author, whose books have sold more than 3.5 million copies worldwide. His acclaimed books include Java: The Complete Reference, C++: The Complete Reference and C#: The Complete Reference.
In this international bestseller, top-selling programming author Herbert Schildt shows you everything you need to develop, compile, debug, and run Java programs. The book has been updated to cover the latest version of the world’s number-one programming language.
Java 7: The Complete Reference, Eighth Edition covers all of the Java 7 features, including closures, superpackages, reified generic types, the enhanced switch statement, chained method invocations, extension methods, the enhanced catch statement, and enum values. The book also includes details on the Swing Application Framework and a chapter on language-level XML support.
About the Author
Herb Schildt (Mahomet, IL) is the world’s leading programming author, whose books have sold more than 3.5 million copies worldwide. His acclaimed books include Java: The Complete Reference, C++: The Complete Reference and C#: The Complete Reference.
100 CSS and HTML power solutions in one handy guide
Plug-in CSS is filled with with ready-to-use CSS and HTML solutions for creating dynamic websites. Save hundreds of hours of programming time! Make your website look great with custom fonts, animated menu systems, individually styled forms, and other effects. This practical guide shows you how to do all of these things and much more using simple style sheet plug-ins.
This practical guide takes you through each example step by step so there’s no need to look up anything elsewhere. Every solution is complete and applicable immediately. The book can be dipped into as required with each chapter being self contained. Plus, you can download all the style sheets and HTML from the book’s companion website.
Plug-in CSS
Gives you 100 ready-to-use CSS and HTML solutions
Solves a single problem or set of problems in each chapter with the entire solution available
Features a companion website with all the book’s ready-to-run examples available for download
Covers all the main dynamic features a webmaster needs to accomplish
About the Author
Robin Nixon (Kent, UK) is a developer and freelance technical writer who has published more than 500 articles in magazines such as , and PC Answers. He is the author of five computing books, including Plug-In PHP: 100 Power Solutions and Plug-in JavaScript: 100 Power Solutions.
This practical introductory guide teaches you how to build rich interactive content with JavaFX.
JavaFX: A Beginner’s Guide shows you how to get started creating rich, interactive content using this cross-platform content delivery system. The book walks you through the basics to more challenging concepts, so you’ll quickly understand and begin using JavaFX. This practical guide also covers the JavaFX Production Suite–a powerful plugin for Adobe Photoshop and Adobe Illustrator that allows users to create content specifically for JavaFX.
Discover how to take advantage of cross-platform capabilities–JavaFX is fully integrated with the Java Runtime and thus JavaFX content can run on any platform capable of running Java. You’ll learn, step by step, how to build desktop, browser, and mobile applications.
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
Tips–Helpful reminders or alternate ways of doing things
Annotated Syntax–Example code with commentary that describes the programming techniques being illustrated
About the Author
J. F. DiMarzio (Tampa, FL) has been a professional Java developer for more than nine years and a professional web developer for more than 15. He now actively works with Java and JavaFx to create stunning user experiences for his clients. DiMarzio has written seven books, including Android: A Programmer’s Guide and runs Technical Difficulties, a Java, JavaFx, JQuery, and Android blog at jfdimarzio.com.
Hard stuff made easy! Your practical, self-paced guide to Web design
Web Design Demystified covers all of the key concepts and technologies needed to master Web design fundamentals and become proficient in site design and implementation. Learn about the most common tools and best practices, as well as essential design features users expect. The book provides a basic understanding of HTML, XHTML, and CSS, which is the foundation for all Web design.
This hands-on tutorial explains the basics of JavaScript, PHP, RSS and other necessary features for today’s websites. Testing and verification, search engine optimization, FTP and other essentials of going live are also covered. Each chapter features hands-on exercise and a self-test to verify understanding. A comprehensive final exam covers all the core concepts presented in the book.
Web Design Demystified
Shows how to use the essential technologies for current Web design, including HTML, CSS, JavaScript, and more
Provides a complete standalone tutorial in Web design for which no prior experience is required
Outlines the key topics covered in Web design classes
Includes end-of-chapter quizzes and a final exam to reinforce learning and pinpoint weaknesses
About the Author
Wendy Willard (Bel Air, MD) is an accomplished professional with more than 13 years of experience in all aspects of design, including publication, print, and Web. She is the author of the bestseller, HTML: A Beginner’s Guide, now in its fourth edition, and has written additional books and articles on the topics of Photoshop, Web design, and Mac O/S.
Take your database skills to the next level—develop powerful, custom Access 2010 applications using Visual Basic for Applications
Microsoft Access 2010 VBA Macro Programming follows the successful format of Richard Shepherd’s bestseller, Excel VBA Macro Programming, taking the reader through the structure of VBA and how to use it specifically in Access. The book explains, step by step, how to write VBA code–from the basics to dealing with errors and debugging code. This practical guide includes examples that illustrate how to use VBA in Access to do specific tasks. Readers will learn real-world skills by example.
Microsoft Access 2010 VBA Macro Programming features:
Easy-to-understand instructions that explain how to accomplish programming tasks right away
20 practical sample applications
Details on adding custom menus and Access add-ins
About the Author
Richard Shepherd spent the last 20 years developing computer software in blue chip organizations. He is a qualified accountant and the bestselling author of Excel VBA Macro Programming and Excel 2007 VBA Macro Programming.
Practical Software Project Estimation: A Toolkit for Estimating Software Development Effort & Duration
Peter Hill, International Software Benchmarking Standards Group
Proven techniques from the International Software Benchmarking Standards Group
Practical Software Project Estimation is a complete toolkit for accurately estimating the size, cost, and duration of software development projects. This book is based on software project data collected by the International Software Benchmarking Standards Group (ISBSG) which contains an updated repository of more than 5,000 completed projects from around the world. The book provides clear explanations of different estimation techniques and shows you how to use them. Estimation equations and project delivery rate tables are provided for use in estimating projects, along with insights and best practices based on completed projects sitting in the ISBSG software project repository.
Practical Software Project Estimation:
Provides solutions for mitigating a wide variety of software project failures and pitfalls and delivering accurate estimates
Contains data based on more than 5,000 completed international software projects
Includes estimating exercises for real-world practice
Enables accurate estimation of costs and durations of large and small software projects
Explains different estimating techniques and how to best apply them
About the Author
Peter Hill is the chief executive officer and a director of the ISBSG. He has been in the information services industry for more than 40 years and has compiled and edited five books for the ISBSG.
The ISBSG (Australia, Finland, China, Germany, India, Italy, Japan, Korea, Netherlands, Spain, Switzerland, UK, USA) is a not-for-profit organisation that established and now grows, maintains and exploits two repositories of IT history data (software metrics) to help improve the management of IT globally.
Mission of the ISBSG: “To improve the management of IT resources by both business and government through the provision and exploitation of public repositories of software engineering knowledge that are standardized, verified, recent and representative of current technologies.”
The ISBSG’s formation in 1997 was built upon several years of previous cooperation by a group of national software metrics associations with the common aim of developing and promoting the use of IT industry history data to improve software processes and products, for the benefit of both businesses and governments worldwide. Current members of the ISBSG represent IT and Metrics Associations from thirteen countries (Australia, Finland, China, Germany, India, Italy, Japan, Korea, Netherlands, Spain, Switzerland, UK, USA ).
A Zend Technologies columnist and bestselling PHP author provides practical information on today’s most popular PHP framework—with more than 7 million downloads.
Aimed squarely at real-world PHP developers working against aggressive deadlines, Zend Framework: A Beginner’s Guide teaches developers how to work smarter, by using the most popular open-source framework for PHP. Feature-rich, robust and mature, Zend Framework can simplify and shorten the application development cycle, reduce testing time, improve quality, and provide the developer with the extensibility, scalability and flexibility needed in today’s competitive, rapidly-changing environment. This book shows how to maximize all the features of Zend Framework.
Zend Framework is to PHP what JavaServer Faces is to Java. Just as Java Server Faces: The Complete Reference is popular and useful for Java developers, Zend Framework: A Beginner’s Guide will be the best guide for open source developers looking to develop web applications using PHP and the new Zend Framework.
Key Selling Features
Author is has been a well-known featured columnist with Zend Technologies since 2006. His columns are among the most popular on the Zend Technology community site.
Covers the most important components of the Zend Framework
Introduces MVC concepts and theory, and then demonstrates real-world implementation of the theory
Provides numerous projects and code examples
Companion website includes all of the code in the book
About the Author
Vikram Vaswani (Bombay, India) is the founder and CEO of Melonfire (http://www.melonfire.com/), a company specializing in software consultancy and content creation and syndication services. He is also the author of PHP Programming Solutions, How to do Everything with PHP and MySQL, and MySQL: The Complete Reference (all McGraw-Hill/Osborne titles) and XML and PHP (New Riders Publishing) He is also the author of numerous well-received articles on open-source technologies (including Perl, Python, XML and the very popular PHP 101 series), all written with the goal of making complex technologies accessible and understandable to novice users.
He has been developing software since 1995, was first introduced to PHP in 1998, and hasn’t looked back since. He is regular columnist with Zend Technologies (creators of PHP), as well as with IBM DeveloperWorks, CNET Builder.com, DevX.com and other OSS sites
Articles by Vikram Vaswani
Article 01: Zend Developer Zone on April 21, 2010 Build an Enterprise – Grade PHP Stack with Zend Server 5.0 and Oracle 11g To read, please click HERE
Article 02: IBM on May 11, 2010 Implement SOAP services with the Zend Framework To read, please clickHERE
This hands-on guide shows SharePoint 2010 administrators how to use PowerShell to automate repetitive tasks and conduct remote troubleshooting.
PowerShell for Microsoft SharePoint 2010 Administrators explains how to take advantage of PowerShell─the built-in scripting language─to increase productivity by automating tasks on both local and remote systems. PowerShell is fully integrated into SharePoint 2010, providing administrators with a revolutionary set of tools, including more than 500 new PowerShell commands. This book covers all PowerShell capabilities.
This comprehensive guide provides an introduction to PowerShell for administrators who have never used it before. Specifics on how and why to use PowerShell with SharePoint are included. Real-word scenarios demonstrate the advantages of PowerShell as a tool to solve common problems.
PowerShell for Microsoft SharePoint 2010 Administrators
Covers the latest versions: SharePoint 2010 and PowerShell 2.0
Is written by global SharePoint and PowerShell experts and bloggers
Includes comparisons between PowerShell scripting and built-in SharePoint tools that demonstrate the differences and provide a good understanding of when to use PowerShell
Requires no prior knowledge of PowerShell—provides a good introduction to both PowerShell and SharePoint
Offers extensive PowerShell script examples for download
Practical PowerPivot & DAX Formulas for Excel 2010
Extract actionable BI using Excel 2010 PowerPivot and DAX language
Featuring 200 ready-to-use DAX queries, Practical PowerPivot & DAX Queries for Excel 2010 shows Office and Excel power users how to take advantage of DAX (Data Analysis Expressions)—the new standard language for extracting BI within Excel. An entire section shows how to create tables, pivot tables, and PowerPivot tables in Excel. You can then progress to writing DAX queries and formulas to harness the power of BI.
This solutions-based guide contains more than 200 DAX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:
Query: Introduction and description of query and its use
Syntax: Complete DAX syntax
Result: Screen shot showing the data returned in an Excel 2010 pivot table
Analysis: Analysis of the results and tips for customization
Practical PowerPivot & DAX Queries for Excel 2010
Includes 200+ ready-to-use, easily customizable DAX queries, all available for download
Features a practical and hands-on approach with a minimum of difficult concepts and theory
Explains how to visualize actionable BI
Helps to dramatically improve analysis and decision-making skills
Microsoft SharePoint 2010 Web Applications The Complete Reference
Leverage SharePoint’s revolutionary software development platform to build business applications
Microsoft SharePoint 2010 Web Applications: The Complete Reference is the perfect guide for developers who want to use SharePoint to build any type of web application using SharePoint as a platform. In SharePoint 2010, practically all of the additional functionality is aimed at extending this development capability. This book fully covers all of these features. Learn how to build a self-service web portal for customers; create a unified access point for all internal line-of-business applications; deliver e-commerce solutions; and much more.
Microsoft SharePoint 2010 Web Applications: The Complete Reference:
Defines best practices covering the entire project lifecycle
Explains which development tool best suits each task
Provides step-by-step, real-world examples with downloadable sample code
Features comprehensive coverage of all the new SharePoint 2010 features
Helps to builds the skills required to use SharePoint as a development platform, both from a software development perspective and from a project management perspective
Written by a former member of the SharePoint development team, this is a step-by-step guide to mastering the latest release of this integrated suite of server capabilities.
In How to Do Everything: Microsoft SharePoint 2010, Stephen Cawood—one of the people who helped build SharePoint—offers advice from his many years of working with SharePoint customers, cutting to the core and focusing on key features to get you up to speed quickly. You’ll get easy-to-follow tutorials on blogs, wikis, MySites, Web parts, taxonomy, document management, workflow, publishing sites, team sites, and much more. Take full advantage of the content management, enterprise search, collaboration, and information-sharing capabilities of SharePoint 2010 with help from this practical guide.
How to Do Everything: Microsoft SharePoint 2010:
Covers the key new features, including new out-of-the-box web parts and SharePoint taxonomy
Contains step-by-step examples that walk you through the most common SharePoint tasks
Explains how to use SharePoint Workspace to work with SharePoint offline
Includes valuable advice from SharePoint experts
Functions as a handy reference to learn new features and as a refresher
A full-color, step-by-step guide to all the key features of SharePoint 2010
Microsoft SharePoint 2010 QuickSteps starts you up on SharePoint 2010 right away, including SharePoint Server 2010, SharePoint Designer 2010, and SharePoint Workspace 2010. Color screenshots and clear instructions make it easy to ramp up on the latest release of Microsoft’s integrated collaboration suite. Follow along and quickly learn how to plan, build, administer, and secure a SharePoint site and integrate it with Microsoft Office 2010. Get up to speed on SharePoint 2010 in no time with help from this practical, fast-paced guide.
Microsoft SharePoint 2010 QuickSteps
Offers full-color coverage of the key capabilities of the entire SharePoint suite
Features high production quality, breadth of coverage, and a low price
Includes color screenshots on every page with step-by-step explanations
Business Intelligence with Microsoft® Office PerformancePoint™ Server 2007
Deliver BI Solutions with Microsoft Office PerformancePoint Server 2007
Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services.
Configure, deploy, and secure all the PerformancePoint components
Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer
Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007
Enable advanced data analysis with PerformancePoint Server and ProClarity tools
Take advantage of the enhanced analytic capabilities of Excel 2007
The ultimate guide to Microsoft Office Project Server 2007
This comprehensive guide takes you through the planning and implementation lifecycle of a Project Server installation. You will learn how to utilize this powerful software to set up and manage projects, allocate human as well as financial resources, track progress, and adjust activities quickly to accommodate project changes and updates.
Endorsement
“Microsoft Office Project Server 2007 is an extremely advanced and dynamic toolset requiring fundamental organizational inspection. Rob and Dave provide an equally deep and unique perspective of this powerful solution.” –Daniel T. Renier, Principal Consultant, Milestone Consulting Group, Inc.
Extract and analyze mission-critical enterprise data using Microsoft Office 2007
This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today’s networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you’re already using to help you in your everyday work.
Create Excel PivotTables and PivotCharts and apply Conditional Formatting
Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
Connect external data to Excel using Office Data Connections and SharePoint
Create SharePoint dashboards that display data from multiple sources
Add Key Performance Indicators and Excel Services reports to your dashboards
Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
Generate integrated PerformancePoint Scorecards
Create Visio PivotDiagrams and Windows Mobile spreadsheets
All of the examples in the book can be downloaded for free by doing the following: go to www.mhprofessional.com. Click on the Computing tab. Click on the Downloads page. Click on the book’s title to download the examples.
Microsoft® Office SharePoint® Server 2007: A Beginner’s Guide
Set up and administer a SharePoint Server 2007 environment
Get started on Microsoft Office SharePoint Server 2007 quickly and easily with help from this step-by-step guide. Using clear instructions, Microsoft Office SharePoint Server 2007: A Beginner’s Guide shows you how to set up and configure SharePoint Server, collect and store data, build lists and libraries, and enable enterprise search capabilities. You’ll learn how to create portals and Web pages, secure your SharePoint Server 2007 environment, and optimize performance. Microsoft Office 2007 integration techniques are also covered.
Install and configure SharePoint Server 2007
Secure your SharePoint Server network and data
Easily locate files and folders using the Search feature
Simplify data collection using forms and workflows
Logically organize content into lists and libraries
Monitor, maintain, and back up your SharePoint Server environment
Build Web applications and portals from reusable, modular Web Parts
Improve efficiency using customized views and metadata schemes
Seamlessly integrate with Microsoft Office Outlook 2007
Microsoft® Office SharePoint® Server 2007: The Complete Reference
The definitive guide to Microsoft Office SharePoint Server 2007
Deploy and manage Microsoft Office SharePoint Server 2007 in the enterprise with help from this one-stop resource. Through detailed instructions, screenshots, and code samples, this comprehensive guide shows you, step-by-step, how to use SharePoint Server and make the most of all its powerful tools and utilities.
Microsoft Office SharePoint Server 2007: The Complete Reference explains how to develop a customized installation plan, configure the server for optimal performance, and administer users, documents, and content. You’ll get full details on designing feature-rich portals and collaboration sites, creating user-friendly forms and workflows, using modular Web Parts, and incorporating business data.
Install and configure SharePoint Server for the entire enterprise
Manage the server from the Central Administration site
Design SharePoint Server portals, websites, lists, and document libraries
Work with SharePoint Web Parts or build your own
Ensure cross-site consistency using site columns and content types
Create site definitions and templates using SharePoint Designer and Visual Studio
Build custom workflows using SharePoint Designer
Extend SharePoint Server using the Object Model and Event Receivers
Import and map enterprise information using the Business Data Catalog
Use the advanced services of Office Search and Excel Web Services
Endorsement
“This well-planned and well-written book offers a comprehensive reference for IT professionals, application developers and business analysts working with SharePoint applications.” – James A. Robertson, MCSD.NET, Senior Software Engineer, Applied Information Sciences
Visualizing Information with Microsoft® Office Visio® 2007
Create and distribute data-connected Microsoft Office Visio diagrams and reports
Get full details on the powerful features of Microsoft Office Visio 2007 inside this comprehensive volume. Written by Visio expert David Parker, Visualizing Information with Microsoft Office Visio 2007 demonstrates how to effectively visualize, explore, and communicate complex business information. Learn to use PivotDiagrams, Data Graphics, and Smart Tags, as well as link data to shapes and create meaningful Visio documents and reports. Plus, you’ll get vital security information, time-saving tips, troubleshooting techniques, and downloadable macros and code samples.
Essential Skills for Database Users and Professionals
Create shapes and link them to data
Summarize and analyze information using PivotDiagrams
Use Data Graphics, Smart Tags, and SmartShapes to reinforce information
Generate robust Excel, HTML, and XML reports
Create custom, reusable templates, stencils, and masters
Update and enhance diagrams with Reviewer’s comments and markups
Integrate Visio diagrams with other Windows applications
Publish and securely distribute Visio documents and summaries
Extend functionality using VBA macros, add-ins, and wrapper applications
McGraw-Hill Professional has published a series of titles on Microsoft SQL Server 2005. These comprehensive resources show you how to get up-and-running on SQL Server 2005, create and manage databases and tables, triggers, functions, stored procedures, transactions, and advanced database queries covering every aspect of the new release in full detail, starting with an in-depth review of the core database engine, build robust, high-performance Business Intelligence solutions with SSIS, generate and distribute comprehensive, integrated reports, create robust data management and business intelligence applications, transform disparate enterprise data into actionable business intelligence, create and use stored procedures for optimal database performance, and more.
SQL Server 2005 is Microsoft’s next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on:
Enterprise data management capabilities, including security and clustering
Build robust, high-performance Business Intelligence solutions with SSIS
Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services — the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you’ll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:
Build packages with the SSIS Import and Export Wizard and BIDS
Create expressions using variables, functions, and operators
Lay out package workflow with Control Flow Containers and tasks
Secure SSIS packages and encrypt sensitive data
Monitor and audit runtime events using log providers
Respond to external triggers with event handlers
Transform and manipulate input using Data Flow Components
Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
Load Data warehouse using Slowly Changing Dimension transformation
Deploy, optimize, troubleshoot, and debug SSIS packages
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
Create and Use Stored Procedures for Optimal Database Performance
Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server’s native Transact-SQL and .NET CLR languages. You’ll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.
Essential Skills for Database Professionals
Group and execute T-SQL statements using batches, scripts, and transactions
Create user-defined, system, extended, temporary, global temporary, and remote stored procedures
Develop and manage stored procedures using C# and Visual Basic .NET
Implement database access using ADO.NET
Create CLR user-defined functions and triggers
Implement reliable debugging and error handling techniques and security measures
Manage source code in a repository such as Visual SourceSafe
Create stored procedures for web search engines
Use system and extended stored procedures to interact with the SQL Server environment
Delivering Business Intelligence with Microsoft SQL Server 2005
Transform disparate enterprise data into actionable business intelligence
Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It’s all right here — from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
Understand the goals and benefits of business intelligence
Manage Analysis Services databases using BI Development Studio
Improve performance and decrease latency using proactive caching
Create interactive reports using SQL Server 2005 Reporting Services
Enable ad hoc reporting using Report Models and Report Builder
Integrate with applications using ADOMD.NET and the Report Viewer Control
Design and create relational data marts and OLAP cubes
Perform powerful data analysis using MDX queries and scripts
Perform complex operations with Integration Services
Uncover behavior patterns and proclivities using data mining
CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS
Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. Microsoft SQL Server 2005 Developer’s Guide explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth — including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
Use SQL Server Management Studio and Business Intelligence Development Studio
Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML)
Create custom database objects with .NET CLR
Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET
Develop and deploy SQL Server Integration Services packages
Design enterprise reports using Reporting Services and Report Builder
Integrate cross-platform data using XML and Web services
Extend SQL Server manageability using SQL Management Objects (SMO)
Generate and distribute comprehensive, integrated reports
Transform disparate corporate data into business intelligence with help from this hands-on guide. Microsoft SQL Server 2005 Reporting Services explains how to create, manage, and deliver traditional and interactive reports with this powerful server-based reporting solution. Written by a member of the Reporting Services development team, the book covers the entire report-building and distribution process and offers complete details on all the product’s integrated features. Improve business decision-making in your organization by getting the right information to the right people at the right time.
ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS
Install and set up SQL Server 2005 Reporting Services
Use the SELECT query to extract report data from your data sources
Add charts, images, and other graphics
Generate reports using the Report Wizard and from scratch
Maintain a secure, managed environment
Integrate reports with desktop and web applications
Enable end-user access to reports via the Report Server and its Report Manager web interface
Export reports to other presentation and data exchange rendering formats
Learn to use all the powerful features available in SQL Server 2005 from this straightforward, hands-on guide. Set up SQL Server 2005, automate system administration tasks, execute simple and complex database queries, and use the robust analysis, business intelligence, and reporting tools. Troubleshooting, data partitioning, replication, and query optimization are also covered. With SQL Server 2005: A Beginner’s Guide, you’ll be able to set up a secure, reliable, and productive data management platform in no time.
Essential Skills for Database Professionals
Install and customize SQL Server 2005
Create, alter, and remove database objects with Transact-SQL statements
Use SQL Server as a native XML database system
Tune your database system for optimal performance
Use the new SQL Server Management Studio tool for executing and analyzing ad hoc queries
Retrieve data from more than one source using join operations and SELECT statements
Secure your database using two different authentication modes–Windows and mixed
Restore databases using transaction logs and backup and recovery methods
Streamline system administration tasks using the SQL Server Agent service tool
Analyze and manage information stored in a data warehouse with Microsoft Analysis Services
Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
Install and configure SQL Server 2005
Manage database design
Use Transact-SQL and XML
Work with functions, triggers, and CLR integration
Optimize, monitor, and secure databases
Create stored procedures
Handle disaster recovery
Work with Service Broker, Web Services, and MARS
Use SQL Server Reporting Services and Notification Services
Manage locks, deadlocks, and cursors
Transfer data using Replication and SQL Server Integration Services
The CD-ROM features:
Six full practice exams-two for each exam: 70-431, 70-441, & 70-442
Scripts from the step-by-step exercises in the book
Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
Install and configure SQL Server 2005
Use Transact-SQL
Manage server infrastructure design
Optimize databases
Secure databases and servers
Ensure high availability
Implement backup and recovery strategies
Maximize the built-in administration tools
Use Business Intelligence tools, including SSIS and SSRS
Manage concurrency
The CD-ROM features:
Six full practice exams–two for each exam: 70-431, 70-443, and 70-444
Scripts from the step-by-step exercises in the book
Video training clips from the author
Complete electronic book
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)
With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know–and shows you how to prepare–for this challenging exam.
100% complete coverage of all official objectives for Exam 70-431
Exam Readiness Checklist at the front of the book–you’re ready for the exam when all objectives on the list are checked off
Inside the Exam sections in every chapter highlight key exam topics covered
Simulated exam questions match the format, tone, topics, and difficulty of the real exam
Covers all the exam topics, including:
Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors
CD-ROM includes:
Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool
Java, A Beginner’s Guide
Posted by mheasiacomputing 
