Download or read book Database Administration written by Craig Mullins and published by Addison-Wesley Professional. This book was released on 2002 with total page 736 pages. Available in PDF, EPUB and Kindle. Book excerpt: Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.

Download or read book Oracle Database Administration for Microsoft SQL Server DBAs written by Michelle Malcher and published by McGraw Hill Professional. This book was released on 2010-10-06 with total page 353 pages. Available in PDF, EPUB and Kindle. Book excerpt: Apply Your SQL Server DBA Skills to Oracle Database Administration Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard

Download or read book Learning SQL written by Alan Beaulieu and published by O'Reilly Media. This book was released on 2009-04-11 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Download or read book Principles of Database Management written by Wilfried Lemahieu and published by Cambridge University Press. This book was released on 2018-07-12 with total page 817 pages. Available in PDF, EPUB and Kindle. Book excerpt: Introductory, theory-practice balanced text teaching the fundamentals of databases to advanced undergraduates or graduate students in information systems or computer science.

Download or read book Oracle DBA Mentor written by Brian Peasland and published by Apress. This book was released on 2019-03-29 with total page 454 pages. Available in PDF, EPUB and Kindle. Book excerpt: New Oracle database administrators can get off the ground running. This book helps you develop the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues. Along the way, you will see how to create your first database and implement best practices to ensure a well-running database system. What makes Oracle DBA Mentor different is that it also teaches you how to obtain answers that are not found in this or other books. Focus is given to creating a test bed and running test cases to examine hypotheses and prove out solutions so you can be sure they work in production. Attention is given to navigating product documentation and networking in forums and social media to build your skills and a network to draw on when solving problems under pressure. There are chapters of step-by-step technical content as well as coverage of essential skills to succeed as a DBA no matter which database engine you administer. By the time you are done reading this book, you will have confidence to face many of the situations thrown in your direction. You will know where to go for the answers you don’t yet know that you need. You’ll be able to work and troubleshoot under pressure. You’ll know how to create a database, institute backup and recovery procedures, secure the database and its valuable corporate data, and acquire more knowledge as needed so you can run a database to meet the needs of your organization. What You'll LearnInstall Oracle Database with best practices Implement backup and recovery procedures Understand the fundamentals of databases and data security Find answers to technical problems using Oracle documentation, Oracle Support, and other resources Patch and upgrade an Oracle database Who This Book Is For The novice database administrator who wants help getting off the ground with their DBA career, and in building the skills to let that career flourish in the long term. Mid-level DBAs will also find the book helpful as they try to grow their career to the next level. While the book is geared toward the Oracle platform, database administrators from other platforms can benefit from the soft skills covered in this book.

Download or read book Professional Azure SQL Managed Database Administration written by Ahmad Osama and published by Packt Publishing Ltd. This book was released on 2021-03-08 with total page 725 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master data management by effectively utilizing the features of Azure SQL database. Key FeaturesLearn to automate common management tasks with PowerShell.Understand different methods to generate elastic pools and shards to scale Azure SQL databases.Learn to develop a scalable cloud solution through over 40 practical activities and exercises.Book Description Despite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management. The book begins by introducing you to the Azure SQL managed databases (Azure SQL Database and Azure SQL Managed Instance), explaining their architecture, and how they differ from an on-premises SQL server. You will then learn how to perform common tasks, such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you will study how you can save costs and manage and scale multiple SQL databases using elastic pools. You will also implement a disaster recovery solution using standard and active geo-replication. Finally, you will explore the monitoring and tuning of databases, the key features of databases, and the phenomenon of app modernization. By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learnUnderstanding Azure SQL database configuration and pricing optionsProvisioning a new SQL database or migrating an existing on-premises SQL Server database to an Azure SQL databaseBacking up and restoring an Azure SQL databaseSecuring and scaling an Azure SQL databaseMonitoring and tuning an Azure SQL databaseImplementing high availability and disaster recovery with an Azure SQL databaseManaging, maintaining, and securing managed instancesWho this book is for This book is designed to benefit database administrators, database developers, or application developers who are interested in developing new applications or migrating existing ones with Azure SQL database. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.

Download or read book PostgreSQL 14 Administration Cookbook written by Simon Riggs and published by Packt Publishing Ltd. This book was released on 2022-03-31 with total page 608 pages. Available in PDF, EPUB and Kindle. Book excerpt: Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenance Key FeaturesTroubleshoot and tackle any administration and management problems in PostgreSQL 14Find expert techniques for monitoring, fine-tuning, and securing your databaseAdopt efficient replication for high availability with PostgreSQL 14Book Description PostgreSQL is a powerful, open-source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 14 allows you to scale up your PostgreSQL infrastructure. With this book, you'll take a step-by-step, recipe-based approach to effective PostgreSQL administration. This book will get you up and running with all the latest features of PostgreSQL 14 while helping you explore the entire database ecosystem. You'll learn how to tackle a variety of problems and pain points you may face as a database administrator such as creating tables, managing views, improving performance, and securing your database. As you make progress, the book will draw attention to important topics such as monitoring roles, validating backups, regular maintenance, and recovery of your PostgreSQL 14 database. This will help you understand roles, ensuring high availability, concurrency, and replication. Along with updated recipes, this book touches upon important areas like using generated columns, TOAST compression, PostgreSQL on the cloud, and much more. By the end of this PostgreSQL book, you'll have gained the knowledge you need to manage your PostgreSQL 14 database efficiently, both in the cloud and on-premise. What you will learnPlan, manage, and maintain PostgreSQL databases in productionWork with the newly introduced features of PostgreSQL 14Use pgAdmin or OmniDB to perform database administrator (DBA) tasksUse psql to write accurate and repeatable scriptsUnderstand how to tackle real-world data issues with the help of examplesSelect and implement robust backup and recovery techniques in PostgreSQL 14Deploy best practices for planning and designing live databasesWho this book is for This Postgres 14 book is for database administrators, data architects, database developers, and anyone with an interest in planning and running live production databases using PostgreSQL 14. Those looking for hands-on solutions to any problem associated with PostgreSQL 14 administration will also find this book useful. Some experience with handling PostgreSQL databases will help you to make the most out of this book, however, it is a useful resource even if you are just beginning your Postgres journey.

Download or read book Oracle Data Guard 11gR2 Administration Beginner s Guide written by Emre Baransel and published by Packt Publishing Ltd. This book was released on 2013-01-01 with total page 695 pages. Available in PDF, EPUB and Kindle. Book excerpt: Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.

Download or read book Practical Issues in Database Management written by Fabian Pascal and published by Addison-Wesley Professional. This book was released on 2000 with total page 296 pages. Available in PDF, EPUB and Kindle. Book excerpt: The aim of this work is to provide a correct and up-to-date understanding of the practical aspects of crucial, yet little- understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives advice on how to deal with them. Topics covered include complex data types, missing information, data hierarchies, and quota queries. Annotation copyrighted by Book News, Inc., Portland, OR

Download or read book Db2 9 For Linux Unix And Windows Dba Guide Reference And Exam Prep 6 E written by Baklarz and published by Pearson Education India. This book was released on 2008-09 with total page 1140 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Download or read book Expert Oracle Database 11g Administration written by Sam Alapati and published by Apress. This book was released on 2009-01-10 with total page 1376 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Download or read book OCA Oracle Database 11g Administration I Exam Guide Exam 1Z0 052 written by John Watson and published by McGraw Hill Professional. This book was released on 2008-05-15 with total page 770 pages. Available in PDF, EPUB and Kindle. Book excerpt: A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration

Download or read book Professional Azure SQL Database Administration written by Ahmad Osama and published by Packt Publishing Ltd. This book was released on 2018-07-31 with total page 398 pages. Available in PDF, EPUB and Kindle. Book excerpt: Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases. Key Features Implement backup, restore, and recovery of Azure SQL databases Create shards and elastic pools to scale Azure SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises across 24 topics to reinforce your learning Book Description As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It’s important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database. What you will learn Learn how to provision a new database or migrate an existing on-premise solution Understand how to backup, restore, secure, and scale your own Azure SQL Database Optimize the performance by monitoring and tuning your cloud-based SQL instance Implement high availability and disaster recovery procedures with SQL Database Develop a roadmap for your own scalable cloud solution with Azure SQL Database Who this book is for This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.

Download or read book Expert Oracle Database 10g Administration written by Sam Alapati and published by Apress. This book was released on 2006-11-22 with total page 1285 pages. Available in PDF, EPUB and Kindle. Book excerpt: *One-stop reference for administration and management of Oracle 10g Database *9i predecessor was a best seller; this edition covers all new features, with fully field-tested examples—not just "showcase" examples *Contains essential primers on Unix, Linux and Windows NT management and on SQL and PL/SQL programming; ideal for new/aspiring DBAs

Download or read book Beginning Oracle Database 12c Administration written by Ignatius Fernandez and published by Apress. This book was released on 2015-07-20 with total page 370 pages. Available in PDF, EPUB and Kindle. Book excerpt: Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: • Install and configure an Oracle database, and ensure that it’s properly licensed; • Execute common management tasks in a Linux environment; • Defend against data loss by implementing sound backup and recovery practices; and • Improve database and query performance.

Download or read book Professional Azure SQL Database Administration written by Ahmad Osama and published by Packt Publishing Ltd. This book was released on 2019-07-19 with total page 562 pages. Available in PDF, EPUB and Kindle. Book excerpt: Leverage the features of Azure SQL database and become an expert in data management Key FeaturesExplore ways to create shards and elastic pools to scale Azure SQL databasesAutomate common management tasks with PowerShellImplement over 40 practical activities and exercises to reinforce your learningBook Description Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality. Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You’ll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you’ll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You’ll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions. By the end of this book, you’ll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learnUnderstand Azure SQL Database configuration and pricing optionsProvision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL DatabaseBack up and restore Azure SQL DatabaseSecure an Azure SQL databaseScale an Azure SQL databaseMonitor and tune an Azure SQL databaseImplement high availability and disaster recovery with Azure SQL DatabaseAutomate common management tasks with PowerShellDevelop a scalable cloud solution with Azure SQL DatabaseManage, maintain, and secure managed instancesWho this book is for If you’re a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.

Download or read book PostgreSQL Administration Essentials written by Hans-Jürgen Schönig and published by Packt Publishing Ltd. This book was released on 2014-10-15 with total page 212 pages. Available in PDF, EPUB and Kindle. Book excerpt: If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators.