Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.300+ ready-to-use, powerful MDX queriesThis hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.Work with dimensions, hierarchies, levels, and membersNavigate both horizontally and vertically across dimensions and hierarchiesSort the results of your queriesAccess subsets of dimension members and measure values using the Where clause and Filter functionUse MDX query calculationsExtract and manipulate dates and timesProduce totals, subtotals, and changes cross time using aggregate and other functionsCreate, visualize, and manipulate setsWork with perspectives, subselects, and subcubesDisplay and hide empty cellsUse, modify, format, and create Key Performance Indicators (KPIs)Deliver MDX query results to end users
Relational Data Clustering
A culmination of the authors' years of extensive research on this topic, Relational Data Clustering: Models, Algorithms, and Applications addresses the fundamentals and applications of relational data clustering. It describes theoretic models and algorithms and, through examples, shows how to apply these models and algorithms to solve real-world problems.After defining the field, the book introduces different types of model formulations for relational data clustering, presents various algorithms for the corresponding models, and demonstrates applications of the models and algorithms through extensive experimental results. The authors cover six topics of relational data clustering: Clustering on bi-type heterogeneous relational dataMulti-type heterogeneous relational data Homogeneous relational data clusteringClustering on the most general case of relational dataIndividual relational clustering frameworkRecent research on evolutionary clusteringThis book focuses on both practical algorithm derivation and theoretical framework construction for relational data clustering. It provides a complete, self-contained introduction to advances in the field.
Pro SQL Server 2008 Policy-Based Management
Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization. Provides in-depth treatment of policy-based management in a single source Provides practical usage scenarios for policy-based management Provides guidance to help meet growing regulatory compliance needs
Oracle RMAN 11g Backup and Recovery
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Recovery MasterProtect your databases from hardware, software, and operator failures using the detailed information in this Oracle Press guide. Oracle RMAN 11g Backup and Recovery explains how to configure databases, generate accurate archives, and carry out system restores. Work from the command line or Oracle Enterprise Manager, automate the backup process, perform Oracle Flashback recoveries, and integrate cloud computing technology. This authoritative resource also shows you how to create reports, optimize performance, and implement third-party administration utilities.Set up, configure, and maintain Oracle Recovery Manager (Oracle RMAN)Manage physical and virtual media with Oracle Secure BackupWork with Oracle RMAN catalogs, packages, and control filesUse the Amazon Web Services cloud as an offsite storage solutionCreate online, offline, and incremental system backupsPerform full and partial Oracle RMAN database restoresCorrect user-induced errors with Oracle FlashbackProduct clone and standby databases on local or remote serversUse Oracle Real Application Clusters and synch and split technologyFor a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Oracle Enterprise Manager 10g Grid Control Handbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Enterprise Manager 10g Grid ControlCentralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, implement top-down performance monitoring, and maximize system availability.Plan and carry out an Oracle Enterprise Manager 10g Grid Control rolloutSet up customized metrics, alerts, thresholds, targets, and agentsManage IT resources from a centralized control console or the command lineManage your infrastructure using secure protocolsAutomate administrative tasks with Oracle's management agentDistribute business intelligence using the reporting and dashboard featuresWork with Oracle Enterprise Manager Database Control and Oracle Real Application ClustersBuild physical and logical standby databases using Oracle Data Guard
Applied SAP Bi 7.0 Web Reports: Using Bex Web Analyzer and Web Application Designer
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Deliver SAP BI 7.0 Web ReportsDistribute integrated, accurate, and timely data across your enterprise using the Web-based reporting components in SAP BI. Written by an SAP insider, Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer shows you how to construct effective queries, create HTML-based reports, and combine key analytics into a dashboard-style interface. Learn how to import data from multiple providers, configure custom templates, track Key Performance Indicators (KPIs), and incorporate JavaScript and XHTML. Security, troubleshooting, and third-party tools are also discussed in this comprehensive guide.Essential BI skills for business professionals: Define queries and export them as links with BEx Web AnalyzerCreate BI-specific HTML pages using Web Application Designer and Report DesignerConstruct reusable templates, shortcuts, and Web itemsDesign high-impact BI dashboards, cockpits, and billboardsIntegrate toolbars, drilldown capabilities, and drag-and-drop featuresPublish reporting objects with the Broadcaster and Broadcast WizardMigrate existing systems and reports to the SAP BI 7.0 platformAdd BusinessObjects, Crystal Reports, and JavaScript componentsPeter Jones, MBA, is a principal/platinum business applications consultant with SAP Professional Services Consulting. He has more than 11 years of consulting and educational experience in a variety of strategic and leadership roles. Jones is the author of SAP Business Information Warehouse Reporting.
DBA Survivor
DBA Survivor is a book to help new database administrators understand more about the world of database administration. More and more people are moving into the DBA profession, and many are looking for a getting-started guide. Blogs are written about how to be an exceptional DBA and what to do in your first 100 days. This book takes a different approach, injecting some humor into helping you understand how to hit the ground running, and most importantly how to survive as a DBA. And it's not just survival that matters. Author Thomas LaRock wants much more for you than mere survival. He wants you to have excellence, competence, visibility, confidence, and service. These are the traits and characteristics of DBAs who truly succeed and become respected in their profession. Don't settle for just muddling through your job each day. Strive to excel. Aim to make a difference, for your clients, and for your colleagues. Focuses on the soft skills that distinguish truly exceptional DBAs Takes a humorous approach to keep readers engaged Written by a SQL Server "Most Valuable Professional" and board member of PASS
Oracle Database 11g Pl/SQL Programming Workbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource.Understand the Oracle development architecture and the mechanics of connectionsWork with data types, structures, blocks, cursors, and PL/SQL semanticsWrite, deploy, and use functions, procedures, and packagesManage transactions and moreUse dynamic SQL statements in real-world applicationsSupport online transaction processing and data warehousing applications with external tablesFind syntax samples and best practices to solve problemsWrite, deploy, and use object typesFor a complete list of Oracle Press titles, visit www.OraclePressBooks.com
Microsoft SQL Server 2008 High Availability With Clustering & Database Mirroring
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Create a Highly Available Microsoft SQL Server 2008 EnvironmentWritten 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 ClusteringSet up the Microsoft Distributed Transaction Coordinator on a two node failover clusterInstall SQL Server 2008 on your clusterHandle cluster management and backupConfigure and manage database mirroring for high availabilityImplement Hyper-V virtualization and Live MigrationManage a SQL Server virtual machineMichael Otey is the technical director for SQL Server Magazine and Windows IT Pro and the bestselling author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books. He is president of TECA, Inc., a software development and consulting company.
Oracle SQL Recipes
Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side. Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems
Oracle Essbase & Oracle OLAP
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The only book to cover and compare Oracle's online analytic processing productsWith the acquisition of Hyperion Systems in 2007, Oracle finds itself owning the two most capable OLAP products on the market--Essbase and the OLAP Option to the Oracle Database. Written by the most knowledgeable experts on both Essbase and Oracle OLAP, this Oracle Press guide explains how these products are similar and how they differ. Oracle Essbase & Oracle OLAP will help you architect the Oracle OLAP product that is most appropriate for your application, and build, tune, and maintain OLAP solutions.
Oracle JDeveloper 11g Handbook
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Written by the most knowledgeable Oracle JDeveloper author team in the worldThis Oracle Press guide shows how to build Web applications using the Fusion Middleware development tool, Oracle JDeveloper. The book discusses the latest technologies and explains how to develop code using multiple techniques.Oracle JDeveloper 11g Handbook: A Guide to Fusion Web Development covers the Oracle Application Development Framework and JavaServer Faces. Hands-on practice examples walk you through the creation of a complete sample application that employs highly-interactive user interface components and declarative development methods. You will learn the techniques required to implement Fusion-oriented software solutions in JDeveloper.
Pro Apache
* The Definitive Guide to Apache, Third Edition is a new revision of Peter Wainwright's best-selling (actually, the highest-selling) book on Apache configuration and administration. * Provides multiple methods and examples of how to solve a particular problem; compares and contrasts the methods rather than recommending a single, "best" solution. * Demonstrates how to use many of the most-popular scripting languages such as PHP, Perl, and Python to create dynamic web sites.
Text Mining
The Definitive Resource on Text Mining Theory and Applications from Foremost Researchers in the FieldGiving a broad perspective of the field from numerous vantage points, Text Mining: Classification, Clustering, and Applications focuses on statistical methods for text mining and analysis. It examines methods to automatically cluster and classify text documents and applies these methods in a variety of areas, including adaptive information filtering, information distillation, and text search. The book begins with chapters on the classification of documents into predefined categories. It presents state-of-the-art algorithms and their use in practice. The next chapters describe novel methods for clustering documents into groups that are not predefined. These methods seek to automatically determine topical structures that may exist in a document corpus. The book concludes by discussing various text mining applications that have significant implications for future research and industrial use.There is no doubt that text mining will continue to play a critical role in the development of future information systems and advances in research will be instrumental to their success. This book captures the technical depth and immense practical potential of text mining, guiding readers to a sound appreciation of this burgeoning field.
Data Warehouse Design: Modern Principles and Methodologies
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Foreword by Mark Stephen LaRow, Vice President of Products, MicroStrategy"A unique and authoritative book that blends recent research developments with industry-level practices for researchers, students, and industry practitioners."Il-Yeol Song, Professor, College of Information Science and Technology, Drexel University
MySQL Administrator’s Bible
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management--including MySQL's unique approach to basic database features and functions--as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
The Top Ten Algorithms in Data Mining
Identifying some of the most influential algorithms that are widely used in the data mining community, The Top Ten Algorithms in Data Mining provides a description of each algorithm, discusses its impact, and reviews current and future research. Thoroughly evaluated by independent reviewers, each chapter focuses on a particular algorithm and is written by either the original authors of the algorithm or world-class researchers who have extensively studied the respective algorithm.The book concentrates on the following important algorithms: C4.5, k-Means, SVM, Apriori, EM, PageRank, AdaBoost, kNN, Naive Bayes, and CART. Examples illustrate how each algorithm works and highlight its overall performance in a real-world application. The text covers key topics--including classification, clustering, statistical learning, association analysis, and link mining--in data mining research and development as well as in data mining, machine learning, and artificial intelligence courses. By naming the leading algorithms in this field, this book encourages the use of data mining techniques in a broader realm of real-world applications. It should inspire more data mining researchers to further explore the impact and novel research issues of these algorithms.
Databases
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Essential Database Skills--Made Easy!Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases. Designed for Easy LearningKey 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 skillsNotes--Extra information related to the topic being coveredSelf Tests--Chapter-ending quizzes to test your knowledge
Beginning Oracle Database 11g Administration
Oracle Database is one of the most widely-used database systems in the world. It's a complicated, many-faceted product. Aspiring database administrators often don't know where to begin in learning it. Author Iggy Fernandez remembers that feeling very well. Today and administrator of multi-terabyte databases for some of the world's largest corporations, Iggy got his start as an Oracle DBA by being unexpectedly thrown into the position, literally overnight. He knows what it's like to be floundering in a sea of Oracle technology, not knowing in which direction to swim. This book, that he wrote, teaches readers to swim.
Mastering SQL Server 2008
As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support--the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.
FileMaker Pro 10
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it -- especially with this book as your guide. Clear, thorough, and accessible, FileMaker Pro 10: The Missing Manual helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker. With this book, you will: Get your first database running in minutes and perform basic tasks right away Catalog people, processes, and things with streamlined data entry and sorting tools Use your data to generate reports, correspondence, and other documents with ease Create, connect, and manage multiple tables and set up complex relationships that display just the data you need Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas Outfit your database for the Web, and import and export data to other formats You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.
Oracle Database 11g
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Get a Solid Foundation in Oracle Database TechnologyMaster Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being coveredMastery Checks--Chapter-ending quizzes to test your knowledge
Pro Full-Text Search in SQL Server 2008
Businesses today want actionable insights into their data--they want their data to reveal itself to them in a natural and user-friendly form. What could be more natural than human language? Natural-language search is at the center of a storm of ever-increasing web-driven demand for human-computer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its built-in enterprise-level natural-language search engine in the form of integrated full-text search (iFTS). iFTS uses text-aware relational queries to provide your users with fast access to content. Whether you want to set up an enterprise-wide Internet or intranet search engine or create less ambitious natural-language search applications, this book will teach you how to get the most out of SQL Server 2008 iFTS: Introducing powerful iFTS features in SQL Server, such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop lists Showing you how to optimize full-text query performance through features like full-text indexes and iFilters Providing examples that help you understand and apply the power of iFTS in your daily projects
Application Development with Microsoft Access 2007
Application Development with Microsoft(R) Access 2007 Live Lessons Microsoft Access/Databases For Access power users, programmers, and anyone who wants to master Access 2007 development fast. In Application Development with Access 2007, renowned Access developer, trainer, and author Alison Balter teaches all the skills you need to build professional-quality Access 2007 applications. This package brings together more than twelve hours of personalized, expert video training: 100+ quick, practical video lessons that demonstrate all the skills you need to build virtually any Access application. You'll learn one step at a time, at your own pace--using hands-on examples that reflect realistic development challenges and showcase Access 2007's remarkable capabilities. Application Development with Access 2007 delivers the power of the best classroom training at a small fraction of the cost. If you don't have time to read a huge book on Access development, this is exactly what you've been searching for! Looking for a better way to master today's rapidly changing programming technologies? Want expert help, but don't have the time or energy to read a book? Can't find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world's leading technology experts. LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions--you'll learn key skills in as little as fifteen minutes! Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your instructor shows how to get results in today's top development environments: including Microsoft's Visual Studio and eclipse.org's Eclipse. "We are reaching more and more for video alternatives because they make sense! The imprints of Pearson Technology Group are the most trusted source of quality technology books, and they will be the brands we turn to for visual learning." --Leo J. Hauguel, Information Security Analyst 5 Wells Fargo Services Company Alison Balter, one of the world's most experienced Access developers and trainers, has created Access applications ranging from small end-user projects to enterprise-wide systems. Her thirteen books on Access include Alison Balter's Mastering Microsoft Office Access 2007 Development. System Requirements Operating System: Windows 98, 2000, XP, or Vista; Mac OS X; versions of Linux with the Flash 8 Player or later Multimedia: DVD drive, an 800x600 or higher display, and sound card with speakers Computer: 500MHz or higher, 128MB RAM or more
Linux Recipes for Oracle DBAs
Linux Recipes for Oracle DBAs is an example-based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task-oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done. Takes you directly from problem to solution Covers the "right" mix of Linux user and administration tasks for database administrators Respects your time by being succinct and to-the-point
Oracle Enterprise Manager 10g Grid Control Implementation Guide
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Install and Configure Grid Control to Manage Your Oracle LandscapeBuild a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. You'll also get full coverage of backup and recovery strategies and high-availability techniques.Prepare infrastructure hosts for Grid Control rolloutInstall the Oracle management repository, service, and agentsSelect the Grid Control installation options that fit your needsDiscover and manage host, database, and application server targetsSet target metrics and policies according to best practicesOptimize performance and availability of your Grid Control frameworkSecure the Grid Control framework to protect data transmitted between components
Delivering Business Intelligence with Microsoft SQL Server 2008
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Maximize the Business Intelligence Tools in Microsoft SQL Server 2008Manage, 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 intelligenceDesign and create relational data marts and OLAP cubesManage Analysis Services databases using BI Development StudioCleanse data and populate data marts with SQL Server Integration ServicesTake advantage of the flexibility of the Unified Dimensional ModelManipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clusteringDevelop and distribute interactive reports with SQL Server 2008 Reporting ServicesIntegrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
Expert Oracle Database 11g Administration
Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.
Professional Microsoft SQL Server 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.
Pro Oracle Application Express
Pro Oracle APEX assumes that readers already know the rudiments of using APEX. The book tackles the harder problem of showing readers how to take full advantage of the APEX framework. As with any framework, there are right and wrong ways to do things, and there are "blind-alleys" that are best avoided. Pro Oracle APEX gives readers what they need to know in order to build serious, enterprise-level applications useable by hundreds, even thousands of people. Cowritten by an original creator of APEX and a key APEX user with deep connections into Oracle's APEX development team, Pro Oracle APEX will be the book that sets the standard in its topic area.
Microsoft SQL Server 2008 Reporting Services
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate 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 ServicesCreate SELECT queries to extract dataGenerate reports from the Report Wizard and from scratchAdd charts, images, and gaugesBuild reusable report templatesUse the new Tablix data format to create reports with any structureExport reports to Word, Excel, PDF, HTML, XML, and other formatsEnable end-user access to reports via the Report Server and its Report Manager web interface
Oracle CRM On Demand Reporting
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Your One-Stop Guide to Oracle CRM On Demand ReportingPlan, build, and distribute data-rich business intelligence reports with ease. Oracle CRM On Demand Reporting details the entire report-building process and explains how to use the powerful features available in Answers On Demand to create and share comprehensive, integrated reports. The book includes proven strategies for report design and development, real-world examples, formatting tips, advanced reporting techniques, and sample formulas. Convert disparate corporate data into actionable business intelligence with help from this detailed guide. Maximize the features of Answers On DemandStrategically plan your reportsFormat, sort, filter, and modify report dataUse column formulas with numeric, date and time, and text data Apply logic and transform data with column formulasFormat report title and table viewsAdd charts, graphs, pivot tables, filter prompts, and interactivity to reportsConfigure advanced views and create custom dashboardsManage reports and control access
Pro SQL Server 2008 Relational Database Design and Implementation
Louis Davidson's book on database design is a solid, five-star book on Amazon that is reviewed and endorsed by leading lights such as Adam Mechanic and James Luetkehoelter. The book is technically and theoretically sound, and is grounded in best-practices. The previous two editions have sold in excess of 5000 units. There is no better book on database design catering to the SQL Server professional.
Pro SQL Server 2008 Reporting Services
Pro SQL Server Reporting Services 2008 is the third edition of Apress' top book on Microsoft's enterprise-level reporting tool. The previous edition has sold some 2100 units over a two-year period. This revision, combined with the impending release of SQL Server 2008 breath new life into the topic, and into this book.
Pro T-sql 2008 Programmer’s Guide
Skill with the Transact-SQL language is key to any developer making use of Microsoft SQL Server. Written especially for developers, the Pro T-SQL 2008 Programmer's Guide shows developers the full range of what's possible using the language. Readers become fully-grounded in the language, in the key features that SQL Server has to offer, and they are introduced to best-practices that will help ensure their success.
SQL
Essential Skills--Made Easy!Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated
Microsoft SQL Server 2008: A Beginner’s Guide
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Get Started on Microsoft SQL Server 2008 in No TimeLearn 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 2008Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functionsOptimize database performance, availability, and reliabilityImplement solid security using authentication, encryption, and authorization Automate tasks using SQL Server AgentCreate reliable data backups and perform flawless system restoresUse all-new SQL Server 2008 Business Intelligence, development, and administration toolsLearn in detail the SQL Server XML technology (SQLXML)
Beginning SQL Server 2008 for Developers
Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services. The author has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He maintains visibility in the field through his website and his other books. The two previous editions of this book have sold well.
SQL Server 2008 Transact-SQL Recipes
Without Transact-SQL, there is nothing. Developers and database administrators using Microsoft SQL Server 2008 are highly-motivated to learn Transact-SQL, because that language enables them to store and retrieve data, to move business logic into the database, and to interface with advanced SQL Server features. The recipe format facilitates just-in-time learning, showing readers immediately how to perform their assigned tasks, and is sure to be a hit with today's busy professional.
SQL Bible
Harness SQL for Oracle 11g, IBM DB2, and Microsoft SQL Server 2008Combining theory with everyday practicality, this definitive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers. Learn the basics of SQL and relational databases Explore tables, views, sequences, and other database objects Examine transactions and locking in multiuser environments Review functions mandated by the SQL standard and the three major vendors Access metadata information and implement database security Go beyond SQL to XML integration, OLAP business intelligence, and more Companion Web SiteFind downloadable code examples and more at www.wiley.com/go/SQLBible2
