An Oracle Press guide to successfully implementing business process management projects using Oracle BPM Suite 11g
Written by experts with years of real-world experience in the science and art of BPM, Oracle BPM Suite 11g Handbook is a balanced combination of essential BPM concepts, including various methodology aspects related to successful BPM adoption in an organization, best practices, and a detailed treatment of all the features/functionalities of Oracle BPM Suite 11gR1. The author team includes members of the product management group for Oracle Fusion Middleware and subject-matter experts from the Oracle Enterprise Architecture team and from a BPM-focused Oracle partner. This Oracle Press guide serves as a complete introduction and practical reference for developers, managers, business analysts, software architects, and administrators.
Oracle BPM Suite 11g Handbook
Includes full details on components and features of Oracle BPM Suite 11g
Covers Oracle BPM methodology essentials, including process discovery and design
Explains end-user screen development, integration with outside systems, process monitoring, and continuous process improvement
Features visuals and screenshots
Contains example sets, available for download, demonstrating usage of Oracle BPM Suite 11gfeatures
Is written by members of Oracle’s Product Management and Global Enterprise Architecture teams as well as independent experts on the topic
About the Authors
Manoj Das is senior manager in the product management group for Oracle Fusion Middleware. His focus is on BPEL and Business Rules. Manoj joined Oracle from the Siebel acquisition where he was responsible for driving the next generation process-centric application platform.
Manas Debis a senior director in the Fusion Middleware/SOA, BPM, Governance Suites Product Group at Oracle. He currently leads outbound product management and many strategic engagement initiatives for Oracle’s SOA, BPM and Governance solutions worldwide.
Mark Wilkins is an enterprise architect for Oracle’s Global Enterprise Architecture Program where he works across product lines to develop BPM strategies. Mark joined Oracle from BEA where he was instrumental in developing Service Oriented Architecture methods and service offerings.
The definitive Oracle Press guide to programming and working with Oracle Database 11g and Oracle MySQL in a mixed environment.
Oracle Database 11g and MySQL 5.5 Database Developer Handbookis a comparative handbook to support developers moving from MySQL to Oracle or Oracle to MySQL. The book compares and demonstrates development environments, architecture, security, transactions, and referential integrity concepts. It compares and contrasts SQL dialects and approaches across the spectrum of SQL commands and discusses their portability. The book also compares and contrasts stored programs in both databases and discusses their design portability.
Clear examples, instructions, and explanations make this single volume handbook the standard for porting dialects between the Oracle and MySQL databases. Best practices are highlighted throughout the chapters. Mastery questions are provided at the end of each chapter with an appendix containing answers with explanations.
Oracle Database 11g and MySQL 5.5 Database Developer Handbook
Focuses on how to port the SQL dialects to either database as needed
Explains comparable SQL and PL/SQL/Stored Procedure development techniques
Compares and contrasts development strategies in solving problems with SQL and PL/SQL/Stored Procedures
Features best practices in database development to support web-based applications
Highlights Oracle Database 11g and Oracle MySQL 5.5 unique SQL and PL/SQL/Stored Program features
About the Author
Michael McLaughlin, Oracle ACE (Rexburg, ID) is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming and Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. He worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.
A complete Oracle Press guide to Oracle Fusion Middleware 11g
Featuring best practices for deploying, securing, virtualizing, and managing enterprise-grade Oracle Fusion Middleware applications throughout all life-cycle phases, Oracle Fusion Middleware 11g Architecture and Management is organized into two parts. Part I provides an end-to-end description of the architecture of Oracle Fusion Middleware components—WebLogic Server, SOA Suite, WebCenter, Oracle ADF, and Oracle Identity and Access Management Suite—with each chapter introducing a different component of the Oracle Fusion Middleware 11gstack. Each chapter in this section introduces a sample use case which shows how the concepts discussed apply to a real-life scenario. Part II focuses on provisioning, securing, optimizing, monitoring, and virtualizing for applications built on Oracle Fusion Middleware.
Oracle Fusion Middleware 11g Architecture and Management
Targets life-cycle management for Oracle Fusion Middleware 11gbuilt enterprise applications
Covers the entire stack of Oracle Fusion Middleware 11gcomponents in depth
Provides an end-to-end detailed description of Oracle Fusion Middleware SOA, WebCenter, ADF, and IDM system architecture as well as their dependencies on common components
Describes patterns in which the components of each Oracle Fusion Middleware product suite can be configured and deployed, as well as the trade-offs that should be considered
Includes advanced topics in the areas of provisioning, securing, optimizing, monitoring, and virtualizing for an enterprise-grade application built on Oracle Fusion Middleware
Highlights best practices—a series of opinions based on the authors’ field experience
Features a real-world, complex, distributed application throughout the book, leveraging key Oracle WebLogic Server, SOA, ADF, and WebCenter feature
About the Authors
Reza Shafii (San Francisco, CA)is a Senior Principal Product Manager within the Oracle Fusion Middleware Platform Architecture team. Reza is responsible for ensuring that all Oracle Fusion Middleware products are architecturally aligned, optimized for life-cycle management, and tightly integrated. In this role, Reza has developed an in-depth understanding of the FMW products and their use by customers. Reza blogs and speaks at local user groups and large conferences such as Oracle OpenWorld.
Stephen Lee (San Francisco, CA)is a Principal Product Manager, Oracle Identity and Access Management. Stephen focuses in the area of Identity Administration, Audit and Compliance as well as Middleware Security. Prior to joining the product management team, Stephen led the design and development of the application runtime and deployment security model for Oracle Application Server 10g. Previously, Stephen was a key developer for Oracle Internet Directory, an LDAP directory product.
Paul Encarnación (Bethesda, MD) is a Director in development with Oracle.
Proven strategies for implementing the right data warehouse and business intelligence solutions for current and future business needs
In The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights, business intelligence and data warehousing expert Robert Laberge explains the components and different alternatives in building a data warehouse and describes pros and cons for choosing one path over another. Building a data warehouse is unique for each organization but can be guided by the author’s years of knowledge obtained from working on many differing data warehouse and business intelligence environments in organizations around the world.
The book covers practical and technical aspects of current data warehouse and business intelligence issues with views on realistic solutions within the management and technical arenas. Data warehousing topics are first presented from a high-level overview to ensure the terminology and context is understood, and are then covered in deeper detail to clarify the specifics. These topics all pertain to data warehousing, business intelligence, and performance management.
The Data Warehouse Mentor
Explains the proper implementation of the many available technologies and practices
Shares the author’s nearly 30 years of data warehouse and business intelligence experience in more than 20 countries worldwide
Mentors you to success in determining and deploying the most effective data warehouse and business intelligence solutions for your business
Helps you anticipate future data requirements and usage to ensure the design and build environment for your solution is flexible and open to change
About the Author
Robert (Bob) Laberge (CA) is currently a lead principle consultant for the IBM world centre lab for Industry Models and Assets in Dublin which focuses on data warehousing and business intelligence solutions. Bob has helped over 50 large organizations including Target, Qwest, ING, Mayo Clinic, Canadian Tire, Shoppers Drug Mart, BMW, Korea Telecom, Scotiabank, Capital One, Reliance Infocomm, and Tata Group in this area. Bob has a Masters of Business Administration from the University of Durham in Durham, UK and has nearly 30 years in Information Technology. His IT interests started at Saint Francis Xavier University in Nova Scotia in 1979, entered the business / IT world in Montreal soon after and has since travelled the world in over 20 countries mentoring, training, demonstrating data warehouse and business intelligence practicalities and solutions.
Other books you might be interested:
9780072262650 BusinessObjects XI (Release 2): The Complete Reference
9780071498524 IBM Cognos 8 Business Intelligence: The Official Guide
9780071548083 Microsoft SQL Server 2008 Reporting Services
The only Oracle Press guide to linking and embedding Oracle CRM On Demand reports
Oracle CRM On Demand Embedded Analytics provides you with a justification and process for embedding analytic reports throughout the Oracle CRM On Demand user interface. The techniques presented in this Oracle Press guide will help end users react and adapt to business conditions in a real-time fashion, as embedded reports effectively push business data to the screens that the users are already accessing in the course of normal business.
Each chapter describes embedded analytic usage and capabilities. Real-world case examples for different types of embedded analytics provide a framework for tested usage of hyperlinked reports, Web Applet reports, Home Page reports, and gadgets. Formatting tips explain how to make an embedded report look like a natural part of the user interface.
Oracle CRM On Demand Embedded Analytics
Written by a recognized Oracle CRM On Demand expert who has developed training courses for Oracle, regularly blogs, and speaks at conferences
Helps you extend Oracle CRM On Demand by making reports available via custom links and embedding reports onto home pages, into Web Applets, and more
Features real-world case examples for different types of embedded analytics
About the Author
Michael D. Lairson (Wake Forest, NC) is currently Manager of Business Intelligence Services with Intelenex, an Oracle partner, and works directly with customers implementing CRM On Demand. He is the author of Oracle CRM On Demand Reporting (McGraw-Hill, 2008) and is considered the foremost resource for report development and training in Oracle CRM On Demand reporting. Michael is involved in a number of forums, blogs, and user groups focused on reporting. (OTN Forums, LinkedIn groups, Facebook groups, Twitter, User Group for Oracle Business Intelligence, etc.)
Prior to joining Intelenex, Michael worked for Siebel Systems/Oracle for nearly 8 years where he played a key role in the development of the Advanced Analytics Workshop training offered by Oracle. Michael is an often-requested resource for reporting assistance from past and current customers, readers of his first book, Oracle employees, and other Oracle partners.
Hard stuff made easy! Your practical, self-paced guide to database fundamentals
Databases Demystified, Second Edition is the curriculum-based tutorial for anyone overwhelmed by confusing subjects and complex textbooks. The book is user friendly, engaging, easy to follow, and designed for the student or non-expert wanting to quickly learn the ins and outs of databases and immediately apply the concepts learned.
Clear language, step-by-step discussions, and quizzes at the end of each chapter make understanding databases easy. Learn how to form database queries using Microsoft Access and SQL, explore methods for connecting a database to applications, and discover how to store historical data for analyses. From logical data design using normalization, to database security and data warehousing, this hands-on guide is simple enough for a beginner but challenging enough for an advanced student.
Databases Demystified, Second Edition
Covers Access 2010, the latest ANSI/ISO standard, and MySQL 5.5
Includes new coverage of advanced normal forms, UML diagrams, and integrating XML and objects into databases
Features chapter-opening objectives that offer insight into what you’re going to learn in each step
Provides questions at the end of every chapter to reinforce learning and pinpoint weaknesses
Contains a final exam for overall self-assessment
About the Author
Andrew J. (Andy) Oppel (Alameda, CA) is a proud graduate of The Boys’ Latin School of Maryland and of Transylvania University (Lexington, Kentucky) where he earned a BA in computer science. He has been continuously employed in a wide variety of information technology positions, including programmer, programmer/analyst, systems architect, project manager, senior database administrator, database group manager, consultant, database designer, data modeler, and data architect.
In addition, he has served as a part-time instructor with the University of California, Berkeley, Extension, for more than 25 years and received the Honored Instructor Award for the year 2000. His teaching work included developing three courses for UC Extension, “Concepts of Database Management Systems,” “Introduction to Relational Database Management Systems,” and “Data Modeling and Database Design.” He also earned his Oracle 9i Database Associate certification in 2003. He is currently a senior data modeler for Blue Shield of California. Andy has designed and implemented hundreds of databases for a wide range of applications, including medical research, banking, insurance, apparel manufacturing, telecommunications, wireless communications, and human resources.
He is the author of Databases Demystified (McGraw-Hill Professional, 2004), SQL Demystified (McGraw-Hill Professional, 2005), Databases: A Beginner’s Guide (McGraw-Hill Professional, 2009), and Data Modeling: A Beginner’s Guide (McGraw-Hill Professional, 2010), and is co-author of two other books. His database product experience includes IMS, DB2, Sybase ASE, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, 9i, and 10g). The current edition of the book had 20 five-star reviews on Amazon.
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
About the Author
Art Tennick (Brighton, UK) has worked in relational database design and SQL queries for over 20 years. He has been involved in multidimensional database design, cubes, data mining, and DMX and MDX queries for 10 years. His experience in Excel spans 20 years. Based in the UK, he has been a software consultant, trainer, and writer for some 25 years. Recently, he has worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2010. This is his 20th book and he has also written over 300 articles for computer magazines in the USA, the UK, and Ireland. His web site is www.MrCube.net.
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
Create integrated business intelligence solutions using the newest releases of the Microsoft BI stack
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to use the entire Microsoft BI stack–SQL Server 2008 R2, SharePoint 2010, and Office 2010 components, including Excel/Gemini–to create integrated, practical, business intelligence solutions. An overview of SQL Server Analysis Services sets the stage for broad coverage of Excel as a front end for “self-service analysis,” using SharePoint features for collaboration and workgroup BI, and leveraging Reporting Services for enterprise dashboards and reports. This practical guide focuses on building end-to-end BI solutions that solve real business data dilemmas.
Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 features:
Authoritative content written by a senior technology specialist at Microsoft who has presented to thousands of users and developers on Microsoft’s BI technologies
A foreword by Thierry D’Hers, Business Intelligence Group Program Manager at Microsoft
Real-world exercises that enable you to build practical solutions for your own business problems
An expert guide to working with SQL Server in a mixed-database environment
Microsoft SQL Server Administration for Oracle DBAs is the ideal resource for experienced Oracle database professionals looking to expand their knowledge and skill set into the Microsoft database platform. The book compares and contrasts the platform architectures and shows how to perform everyday database administrator tasks. Screenshots, script examples, and step-by-step labs are included in this practical guide.
This book is not designed to be a “SQL Server is better than Oracle” or vice versa. It will enable experienced Oracle database administrators to get up to speed on the Microsoft SQL Server platform by building on existing relational database skills. The authors’ combination of expertise in both technologies ensures technical accuracy and real-world experiences. Interviews with members of the Oracle DBA community are included in this practical guide.
Microsoft SQL Server Administration for Oracle DBAs
Is co-written by a data platform technical specialist at Microsoft, UK who works daily with large customers integrating SQL Server into Oracle
Teaches dual skills using real-world examples based on authors’ vast experience
Quickly explains how to perform everyday database admin tasks on SQL Server
Focuses on making both platforms work together successfully
Includes step-by-step labs and interviews with members of the Oracle DBA community
Extract real, actionable business intelligence by utilizing the power of SQL queries
Featuring 300 ready-to-use SQL queries Practical SQL Queries for SQL Server 2008 shows how to write SQL queries within Microsoft’s BI stack, but well over 90% of the SQL queries will work with relational databases from other vendors. This solutions-based guide contains more than 300 SQL 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 syntax
Result: Screen shot showing the data returned from the SQL Server relational database by the query
Analysis: Analysis of the results and tips for customization
Specific emphasis is placed on writing SQL for use within Microsoft SQL Server Management Studio (SSMS) connecting to SQL Server – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), Winforms and Webforms, and in a large variety of third-party front-ends.
Practical SQL Queries for SQL Server 2008
Includes 300+ ready-to-use, easily customizable SQL queries, all available for download
Features a practical, 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
Complete coverage of SQL queries
Select – single table
Where; Order By
Select – multiple tables
Aggregates; Select – new tables
Except/Intersect/Union
Group By
System functions
Subqueries
Delete/Insert/Update
Views/User-defined functions
Stored procedures/Programming
DDL (data definition language)/DCL
Microsoft SQL Server 2008 R2 Analytics & Data Visualization
A practical guide to the next-generation Business Intelligence tools available in SQL Server 2008
This book will help DBAs and business intelligence architects work with the latest 3-D visualization techniques that revolutionize data reporting, analysis, and measurement in SQL Server 2008. You will appreciate the complete end-to-end explanation of the real-time visual representation of metrics and trends.
Microsoft SQL Server 2008 Analytics and Data Visualization begins with an overview of how these new tools, acquired from Dundas, fit into the SQL Server 2008 BI stack. You will learn strategies for data mining and advanced analytics. The book explains the full range of cutting-edge data visualization tools, including several customizable charts, map solutions for geographic data, illustrative gauges, and detailed calendars. An eight-page full-color insert highlights dazzling examples of 3-D visuals that convey business metrics in innovative ways.
Benefit to the Customer
Understand 3-D visualization techniques that can be used in reporting, analysis, and measurement.
Examples of the newest ‘Dundas’ BI tools for 3-D data visualization
Easily explore data relationships with a friendly front-end to statistical algorithms
Examples that can be used by BI Architects and connected to every desktop
Hands-On Microsoft SQL Server 2008 Integration Services
A practical guide to mastering Microsoft SQL Server 2008 Integration Services
Hands-On Microsoft SQL Server 2008 Integration Services makes learning SSIS easier through the use of extensive exercises structured around every component within the tool. The complex topics of embedding control flow tasks and containers in a data workflow and using data transformations in the data flow are covered with real-world examples and step-by-step methods.
Hands-On Microsoft SQL Server 2008 Integration Services features:
Details on installation, control flow, data flow transformations, administration, security, and troubleshooting
Two new chapters on extending SSIS through scripting/programming and standard methods for developing a data warehouse architecture
New advanced examples throughout each chapter
Hands-on exercises that are broken down into objectives, solution methodologies, numbered steps, and review for reinforcing techniques
A focus on real-world data warehousing solutions that can be easily applied to your own business challenges
Extract real, actionable business intelligence using DMX
Practical DMX Queries for SQL Server Analysis Services shows how to write DMX queries within Microsoft’s BI stack. This solutions-based guide contains more than 240 DMX 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 syntax
Result: Screen shot showing the data returned from the Analysis Services data mining model by the query
Analysis: Analysis of the results and tips for customization
Specific emphasis is placed on writing DMX for use within Microsoft SQL Server Management Studio (SSMS) connected to Microsoft SQL Server Analysis Services (SSAS) – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), WinForms and WebForms, and in a large variety of third-party front-ends.
Practical DMX Queries for SQL Server Analysis Services:
Includes 240+ ready-to-use, easily customizable DMX queries, all available for download
Features a practical, hands-on approach with a minimum of difficult concepts and theory
Explains how to visualize actionable BI
Shows how to surface knowledge discovery and make informed predictions quickly
Helps to dramatically improve analysis and decision-making skills
Complete coverage of DMX queries
Cases Queries
Content Queries
Prediction Queries with Decision Trees
Prediction Queries with Time Series
Prediction and Cluster Queries with Clustering
Prediction Queries with Association and Sequence Clustering
DDL (data definition language) Queries
Schema and Column Queries
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
The Business Intelligence market continues to grow, despite the ongoing global recession. In fact, Gartner published (in June 2009) its annual analysis of the Business Intelligence market, citing that worldwide sales of Business Intelligence software grew 22% in 2008 (versus 13% year prior). Total revenue for the market came in at $8.8B. The BI category continues to be an area of focus and expansion for McGraw-Hill Professional.
MDX (Multi-Dimensional Expressions) is a standard language for extracting business intelligence from multi-dimensional cubes within data warehouses and is supported by multiple database vendors. This book is a guide to writing MDX queries within Microsoft’s Business Intelligence stack. The book’s approach is solutions-based, and hands-on, containing more than 300 MDX queries that can be immediately applied across a wide variety of Business Intelligence-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 Overview: Introduction and description of query and its use
Syntax: Complete syntax
Result: Illustrates the data returned from the Analysis Services cube by the query
Analysis: Analysis of the results and tips for customization
Specific emphasis is placed on writing MDX for use within Microsoft SQL Server Analysis Services (SSAS)—however, the techniques and queries can also be utilized across Excel, Excel Services in Sharepoint, Reporting Services (SSRS), Integration Services (SSIS), Performance Point Server dashboards, Winforms and Webforms, and in a large variety of third-party front-ends.
Features
Practical and hands-on with a minimum of difficult concepts and theory
Over 300 MDX queries – all downloadable from www.mhprofessional.com
Clear and simple layout
Refer to any query within the book and become immediately productive
Learn how to visualize actionable Business Intelligence
Create a Highly Available Microsoft SQL Server 2008 Environment
Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.
Configure Windows Failover Clustering
Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
Install SQL Server 2008 on your cluster
Handle cluster management and backup
Configure and manage database mirroring for high availability
Implement Hyper-V virtualization and Live Migration
Take immediate advantage of all the innovative features and benefits available in SQL Server 2008 with help from this expert guide. Written by the technical director for SQL Server Magazine, this book offers a concise yet in-depth look at the new and improved enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements of SQL Server 2008. This is the perfect resource for decision-makers, developers, and DBAs preparing for upgrades or migration. Get details on:
The new Transparent Data Encryption, Extended Events, filtered indexes, and auditing features
The new Resource Governor, policy-based management framework, T-SQL IntelliSense and debugging, and PowerShell integration
Availability enhancements-Failover Clustering, Database Mirroring, peer-to-peer replication, backup compression, and the new table lock escalation
The new ADO.NET Entity Framework
LINQ (Language Integrated Query)
The new native DATE, TIME, FILESTREAM, and Geospatial data types
T-SQL enhancements, such as the new DECLARE, MERGE, and GROUPING SETS statements
The more powerful BI toolset, including Integration Services Data Profiling, Analysis Services new Cube Designer, and Reporting Services new tablix controls
Improved Microsoft Office integration capabilities
Delivering Business Intelligence with Microsoft SQL Server 2008
Maximize the Business Intelligence Tools in Microsoft SQL Server 2008
Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.
Understand the goals and benefits of business intelligence
Design and create relational data marts and OLAP cubes
Manage Analysis Services databases using BI Development Studio
Cleanse data and populate data marts with SQL Server Integration Services
Take advantage of the flexibility of the Unified Dimensional Model
Manipulate and analyze data using MDX scripts and queries
Use data mining to identify data patterns, correlations, and clustering
Develop and distribute interactive reports with SQL Server 2008 Reporting Services
Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
The Definitive Guide to Microsoft SQL Server 2008 Reporting Services
Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.
Install, configure, and customize SQL Server 2008 Reporting Services
Create SELECT queries to extract data
Generate reports from the Report Wizard and from scratch
Add charts, images, and gauges
Build reusable report templates
Use the new Tablix data format to create reports with any structure
Export reports to Word, Excel, PDF, HTML, XML, and other formats
Enable end-user access to reports via the Report Server and its Report Manager web interface
Get Started on Microsoft SQL Server 2008 in No Time
Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner’s Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.
Set up, configure, and maintain SQL Server 2008
Build and manage database objects using Transact-SQL statements
Create stored procedures and user-defined functions
Optimize database performance, availability, and reliability
Implement solid security using authentication, encryption, and authorization
Automate tasks using SQL Server Agent
Create reliable data backups and perform flawless system restores
Use all-new SQL Server 2008 Business Intelligence, development, and administration tools
Learn in detail the SQL Server XML technology (SQLXML)
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
Oracle BPM Suite 11g Handbook
Posted by mheasiacomputing 
