Your cart is empty
Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Poder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefitfrom the advantages that the platform provides. Changes the wayyou think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the black box mystique and showing how Exadata actually works What you'll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including Real Application Clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for
Expert Oracle Exadata is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents What Is Exadata? Offloading / Smart Scan Hybrid Columnar Compression Storage Indexes Exadata Smart Flash Cache Exadata Parallel Operations Resource Management Configuring Exadata Recovering Exadata Exadata Wait Events Understanding Exadata Performance Metrics Monitoring Exadata Performance Migrating to Exadata Storage Layout Compute Node Layout Unlearning Some Things We Thought We Knew
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you'll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you've reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You'll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle's world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQLas apowerful andscalable programming language for deploying logic inside the database engine What you'll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scalesthrough pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for
Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle's class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of Contents Do Not Use Dynamic SQL: Handling the Unknown PL/SQL and Parallel Processing Warnings and Conditional Compilation PL/SQL Unit Testing Bulk SQL Operations Know Your Code Contract-Oriented Programming PL/SQL from SQL Choosing the Right Cursor PL/SQL Programming in the Large Evolutionary Data Modeling Profiling for Performance Coding Conventions and Error Handling Dependencies and Invalidations
Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication. The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You'll learn methods for tuning Oracle GoldenGate performance. You'll discover GoldenGate's utility as a migration and extract, transform, load (ETL) tool. You'll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment. Explains all aspects of using GoldenGate for replication Covers homogeneous, heterogeneous, and bidirectional replication Shows the use of GoldenGate for data migration and extract, transform, load (ETL) What you'll learn Install Oracle GoldenGate quickly and painlessly Design single- and bi-directional replication solutions Apply GoldenGate to high-availability solutions Troubleshoot and tune GoldenGate for performance Verify data synchronization using GoldenGate Veridata Manage and monitor GoldenGate environments using GoldenGate Director Who this book is for
Expert Oracle GoldenGate is for database professionals who need to master the latest in replication technology from Oracle. It is for the Oracle Database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software. Table of Contents Introduction Installation Architecture Basic Replication Bi-Directional Replication Heterogeneous Replication Tuning Oracle GoldenGate Monitoring Oracle GoldenGate Oracle GoldenGate Veridata Oracle GoldenGate Director Troubleshooting High Availability & Disaster Recovery Zero Downtime Migrations and Upgrades Best Practices
Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out of Oracle in years. Application Express, termed "APEX" for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users. Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle's new plug-in architecture. You'll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the hard problems are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer. Focuses on high-end, enterprise-level development Covers new features such as plug-ins and Websheets Introduces the new interface released with APEX 4.0 What you'll learn Design APEX solutions that conform to your corporate look and feel Create compelling reports, charts, navigation, and layout Create your own components based upon APEX's new plug-in architecture Authenticate users and manage their access to your applications Develop and deploy web services using APEX Scale APEX applications to thousands of users Secure your applications and data from intrusion Who this book is for
Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product singdeveloping secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding scalability, globalization, configuration and lifecycle management, and more. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Presents best-practices and development insights from leading experts in the field Addresses globalization, scalability, security, and other concerns of enterprise-level development Shows how to customize APEX for your own application needs What you'll learn Solve tough problems in scalability in order to serve thousands of users Design applications to sidestep performance problems and easily scale upwards Deploy applications globally while respecting linguistic and cultural differences Customize applications by exploiting APEX's roots in PL/SQL Reduce the stress of managing application lifecycle and configuration Secure outwardly-facing applications and their data from intrusion Who this book is for
Expert Oracle Application Express is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book. Table of Contents OHS, EPG, and APEX Listener Compared Oracle APEX 4.0 Charts Inside Out Tabular Forms Team Development Globalization Debugging Dynamic Actions Security Lifecycle Management Working with APEX Collections Plug-Ins Architecture Advanced Interactive Reporting
This training guide has been written specifically for the OCR Level 2 ITQ unit Database Software, which requires you to iuse a software application to create and edit a single table database. Each exercise in this guide has been designed to gradually build up your knowledge of Microsoft Access using a simple, user friendly, step-by-step approach. This optional level 2 unit has a credit value of 4, and requires you to demonstrate the skills and knowledge needed to use a range of intermediate database software tools and techniques which may be non-routine or unfamiliar. This guide provides you with the knowledge and techniques necessary to meet these learning outcomes. Data files to accompany this title are available to download from our website, which allow you to practise the many different software features covered.
Oracle PL/SQL Recipes is your go to book for PL/SQL programming
solutions. It takes a task-oriented approach to PL/SQL programming
that lets you quickly look up a specific task and see the pattern
for a solution. Then it's as simple as modifying the pattern for
your specific application and implementing it. And you're done and
home for dinner.
Oracle PL/SQL Recipes is database administrators and developers wanting to take advantage of Oracle Database's built-in support for procedural logic. Database administrators can use PL/SQL to automate administrative tasks, audit access to sensitive data, and more. Developers will be able to optimize processing, push business logic into the database layer, and interface with Java and web applications. Table of Contents PL/SQL Fundamentals Essential SQL Looping and Logic Functions, Packages, and Procedures Triggers Type Conversion Numbers, Strings, and Dates Dynamic SQL Exceptions PL/SQL Collections and Records Automating Routine Tasks Oracle SQL Developer Analyzing and Improving Performance Using PL/SQL on the Web Java in the Database Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython Unit Testing With utPLSQL
Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite-an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot performance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation.RAC is a complex and powerful technology. It demands expertise in its deployment. You can't just wing it in creating a RAC solution. Julian and Steve have earned the right to term themselves expert-in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. * Rigorous and technically accurate content* Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting* Up-to-date with the very latest RAC featuresWhat you'll learn* Plan the architecture for a successful RAC installation* Implement failover and other fault-tolerant features* Scale RAC clusters up and down as needed to achieve performance targets* Consolidate RAC clusters using Oraclea s virtualization solution* Manage RAC proactively so as to sleep well at night* Troubleshoot and solve performance and availability problemsWho this book is for Pro Oracle Database 11g RAC on Linux is written for Oracle Database Administrators who want to step up their skills to be equal to the task of managing Real Application Clusters.
Thousands of IT organizations have adopted clustering to improve the availability of mission-critical software services. Today, with the rapid growth of cloud computing environments, clustering is even more crucial. " ""Oracle""(R)""Solaris Cluster Essentials "is a comprehensive, authoritative guide to the industry's most stable, robust clustering platform: Oracle Solaris Cluster. This book covers both Oracle Solaris Cluster 3.2 and Oracle Solaris Cluster Geographic Edition in thorough detail, offering start-to-finish lifecycle guidance for planning, implementation, management, and troubleshooting. Written by Oracle Solaris Cluster expert Tim Read, this book covers both high availability and disaster recovery features, and offers in-depth guidance for both Oracle and non-Oracle database environments. It also presents several example implementations that can be used to quickly construct effective proofs-of-concept. Whether you're new to clustering or upgrading from older solutions, this book brings together all the information you'll need to maximize the value, reliability, and performance of any Oracle Solaris Cluster environment. You'll learn how to Understand Oracle Solaris Cluster's product features and architecture, and their implications for design and performanceEstablish requirements and design clustered systems that meet themMaster best practices for integrating clustering with virtualization technologiesImplement proven disaster recovery planning techniquesEfficiently maintain Oracle Solaris Cluster environments Part of the Oracle Solaris System Administration Series, "Oracle""(R)""Solaris Cluster Essentials "combines a complete technology introduction and hands-on guide for every architect, administrator, and IT manager responsible for high availability and business continuity.
Designed for any Oracle professional who must quickly implement Oracle reporting, this indispensable guide offers new tips and tricks that make Oracle reporting simple. The basics of PL/SQL are introduced using multiple examples that include code snippets and sample code results. The example-driven methodology teaches PL/SQL language structures, anonymous blocks, and stored procedures so well that by the end of the first chapter users will be coding blocks confidently. Exercises are also provided intermittently to test knowledge comprehension. While gradually building on previous concepts and increasing in complexity, this handbook always focuses on manageability.
Today's Oracle professionals are challenged to protect their mission-critical data from many types of threats. Electronic data is being stolen is record amounts, and criminals are constantly devising sophisticated tools to breech your Oracle firewall. With advanced Oracle Forensics we can now proactively ensure the safety and security of our Oracle data, and all Oracle Forensics techniques are part of the due diligence that is required for all production databases. A failure to apply Forensics techniques to identify unseen threats can lead to a disaster, and this book is required reading for every Oracle DBA. This indispensable book is authored by Paul Wright, the world's top Oracle forensics expert, and the father of the field of Oracle Forensics. Packed with insights and expert tips, this is the definitive reference for all Oracle professional who are charged with protecting their valuable corporate information.
Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.* Fully-revised to cover Oracle Database 11g* Proof-by-example approach: Let the evidence be your guide* Dives deeply into Oracle Databases's most powerful featuresWhat you'll learn* Develop an evidence-based approach to problem solving* Manage transactions in highly concurrent environments* Speed access to data through table and index design* Manage files and memory structures for performance and reliability* Scale up through partitioning and parallel processing* Load and unload data to interface with external systems* Think for yourself; don't take Tom's word for it Who this book is for This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go to book for those wishing to create efficient and scalable applications.
Covering all major aspects of Linux system management critical to running Oracle on Linux, this guide focuses on those tasks most important to Oracle administrators, such as file management, moving and managing files between servers, startup and shutdown tasks, and shell scripting. This reference breaks down the complex subject of Linux administration into easy to digest chapters that are organized by task, providing clear, concise direction for learning to administer Oracle databases on the Linux operating system.
This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.
Database systems have been driving dynamic web sites since the early 90s; nowadays, even seemingly static web sites employ a database back-end for personalization and advertising purposes. In order to keep up with the high demand fuelled by the rapid growth of the Internet, a number of caching and materialization techniques have been proposed for web databases over the years. The main goal of these techniques is to improve performance, scalability, and manageability of database-driven dynamic web sites, in a way that the quality of data is not compromised. Although caching and materialization are well understood concepts in the traditional database and networking/operating systems literature, the Web and web databases bring forth unique characteristics that warrant new techniques and approaches. In this survey, the authors adopt a data management point of view to describe the system architectures of web databases, and analyze the research issues related to caching and materialization in such architectures. They also present the state of the art in caching and materialization for web databases and organize current approaches according to the fundamental questions, namely how to store, how to use, and how to maintain cached/materialized web data. Finally, they associate work in caching and materialization for web databases to similar techniques in other related areas, such as data warehousing, distributed systems, and distributed databases.
A guide to the design of the Museum Archive software package (available at www.musarch.com), complete with the full database schema and the source code snippets used by the developer. Owners of this book are entitled to a free upgrade to the premium version of the software.
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to coverdevelopments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle database.Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you'll learn How to create database tables and define their relationships How to add data to your tables, thenchange and delete that data How to write database queries that generate accurate results How to avoid common traps and pitfalls in writing SQL queries How to take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more How to get a handle on Oracle database's support for object types in the database Who this book is for
This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed. Table of Contents Relational Database Systems and Oracle Introduction to SQL, AQL*Plus, and SQL Developer Data Definition, Part I Retrieval: The Basics Retrieval: Functions Data Manipulation Data Definition, Part II Retrieval: Multiple Tables and Aggregation Retrieval: Some Advanced Features Views Writing and Automating SQL*Plus Scripts Object-Relational Features
This Book, Written For Readers Who Have Little Or No Previous Experience With Databases, SQL, Or SQL Server, Provides A Very Systematic Approach To Learning SQL Using SQL Server. Each Chapter Is Written In A Step-By-Step Manner And Has Examples That Can Be Run Using SQL Server. Using The Sample Tables And Data Provided, The Reader Of This Book Will Be Able To Do All The Examples To Experience Hands-On SQL Programming In SQL Server. The Book Also Presents A Series Of Exercises At The End Of The Chapters To Help Readers Gain Proficiency With SQL. With This Book You Will Learn Beginning SQL Commands - How To Retrieve And Manipulate Data Using The Simple SELECT Statement; How To Customize SQL Server 2008'S Settings And About SQL Server 2008'S Functions; How To Create, Alter, Populate And Delete Tables; About Joins, A Common Database Mechanism For Combining Tables; Query Development, The Use Of Views And Other Derived Structures; Simple Set Operations; About Aggregate Functions; How To Write Subqueries And Correlated Subqueries; How To Create And Use Indexes And Constraints; Transaction Processing.
Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance "Oracle Performance Survival Guide" offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest "bang for the buck." Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You'll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes - "Tuning by layers," the most effective, highest-value approach to Oracle performance optimization - Making the most of Oracle's core tools for tracing, monitoring, and diagnosing performance - Highly efficient database logical and physical design, indexing, transaction design, and API use - SQL and PL/SQL tuning, including the use of parallel SQL techniques - Minimizing contention for locks, latches, shared memory, and other database resources - Optimizing memory and physical disk IO - Tuning Real Application Cluster (RAC) databases guyharrison.netinformit.com/ph
Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.Introduces encryption, guiding readers through its implementation in SQL Server Demonstrates advanced techniques such as the use of hardware security modules Covers all that a SQL Server database administrator needs to know about encryption What you'll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for
The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft. Table of Contents Introduction to Encryption Encryption Key Management Symmetric Encryption Asymmetric Encryption Extensible Key Management Transparent Data Encryption Hashing SQL CLR Cryptography Indexing Encrypted Data Encrypting Connections to SQL Server 2008 Regulatory Requirements
Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.Clearly describes relational database concepts Explains the SQL Server database engine and supporting tools Shows various database maintenance scenarios What you'll learn To understand core concepts of relational databases How to install SQL Server in your environment How to use the tools that come with SQL Server to perform daily administrative tasks How to design and implement a database maintenance plan in SQL Server Configuring database security and protect your sensitive data from intruders How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations Who this book is for
This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents The Database Administration Profession Planning and Installing SQL Server 2008 What's in the Toolbox? Creating Tables and Other Objects Transact-SQL SQL Server Internals Storage Management Strategies Database Backup Strategies Database Restore Strategies Common Database Maintenance Tasks Automation Through SQLCMD and PowerShell Database Maintenance Plans Performance Tuning and Optimization SQL Server Security Auditing, Encryption, and Compliance SQL Server in the Enterprise Where to Go Next?
Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance What you'll learn Plan effectively for database mirroring. Learn what questions to ask and what problems to anticipate Get step-by-step instructions on how to set up database mirroring Automate the initial setup and the ongoing maintenance of mirrored databases Monitor database mirroring, detect failures, and generate automated alerts Build a system that automatically responds to and fixes common problems Build in support for the missing facets of database mirroring, such as support for cross-database dependencies Define groups of databases that all fail over together to their mirrors when just one of those databases fails Create operational processes so that even nontechnical staff can manage mirrored databases Who this book is for
General audience: Pro SQL Server 2008 Database Mirroring is aimed at SQL Server 2008 database administrators, and especially those who desire to mirror their databases in support of high availability. System administrators and operational engineers who manage Windows Server systems that support mirrored database environments will also find much in the book of interest. Table of Contents High Availability Options Database Mirroring Overview Planning and Best Practices Database Mirroring Setup Automating Setup Maintenance Simplified Monitoring and Alerting Upgrading to SQL Server 2008 Reporting Considerations Planning for Failure
Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible.
You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data.
Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code.
This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code.Imparts best practices for writing T-SQL Helps readers avoid common errors Shows how to write scalable code that yields good performance What you'll learn Understand the fundamentals of relational theory, upon which Transact-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work through new and advanced features such as common-table expressions and virtual tables Enhance performance by knowing when to apply features such table value parameters Who this book is for
This book is for developers who will be writing database applications against SQL Server databases. Table of Contents Getting Started Writing Simple SELECT Queries Using Functions and Expressions Querying Multiple Tables Grouping and Summarizing Data Manipulating Data Understanding T-SQL Programming Logic Moving Logic to the Database Working with New Data Types Writing Advanced Queries Where to Go Next?
You may like...
Professional Microsoft SQL Server 2016…
Paul Turley Paperback
Oracle Business Process Management Suite…
Manoj Das, Manas Deb, … Paperback
Microsoft Access 2010 - Comprehensive…
Gary Shelly, Philip Pratt, … Paperback
Shelly Cashman Series Microsoft Office…
Philip Pratt, Mary Last Paperback
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback
New Perspectives Microsoft Office 365…
Mark Shellman, Sasha Vodnik Paperback
Oracle Database Administration for…
Michelle Malcher Paperback
Access 2019 Bible
Michael Alexander, Richard Kusleika Paperback (1)
Oracle Database 10g Real Application…
K. Gopalakrishnan Paperback