Instant Oracle Database and PowerShell Howto Geoffrey Hudik 9781849688581 Books
Download As PDF : Instant Oracle Database and PowerShell Howto Geoffrey Hudik 9781849688581 Books
Utilize the power of Microsoft's powerful scripting engine to automate database tasks with Oracle from PowerShell
Overview
- Learn something new in an Instant! A short, fast, focused guide delivering immediate results.
- Load Oracle Data Access components and connect to Oracle databases.
- Retrieve, format, filter, and export data.
- Execute database procedures and modify database objects
- Build Oracle script libraries and run automated, unattended scripts
In Detail
PowerShell provides a rich, object-oriented scripting language that can be used to perform a number of Oracle database tasks. It can be harnessed to automate manual tasks in graphical database management systems or go beyond what can be done in Oracle-only command line shells.
Oracle and PowerShell will walk you through scripting a number of common Oracle database tasks with real-world code examples and detailed explanations so you can automate operations without manual labor or writing custom utility applications.
This book will start with accessing Oracle and retrieving and modifying data, and will build up to more involved operations, building a reusable script library along the way.
You will also see how to execute and modify database procedures from PowerShell, run unattended, scheduled scripts, and automate database deployments using Oracle command line tools from PowerShell. Finally you will learn how to tap into a powerful library in Oracle's Developer Tools and visualize Oracle data using Microsoft's Charting library.
In the Oracle Database and PowerShell How-to you'll learn all the major building blocks for automating Oracle database tasks using Microsoft's rich scripting language.
What you will learn from this book
- Different ways to access Oracle from PowerShell such as ODP.NET.
- Various PowerShell tips, techniques, and samples.
- Visualize data using graphical charting tools.
- Executing and modifying database procedures.
- Running scripts in a scheduled, automated fashion with error handling.
- Automating SQL*Plus from PowerShell for complex SQL execution.
- Harnessing Oracle Developer Tools’ rich Oracle library.
Approach
Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. Get the job done and learn as you go. This How-To guide is full of hands-on examples to get your databases automated in no time, with easy to follow code that will prove useful time and time again.
Who this book is written for
If you are a .NET developer using an Oracle Database or a regular Oracle Database user this book is full of helpful hints and tricks to automate Oracle Databases with Powershell.
Instant Oracle Database and PowerShell Howto Geoffrey Hudik 9781849688581 Books
I highly recommend Geoffrey Hudik's Instant Oracle Database and PowerShell How-to ebook, part of Packt Publishing's Instant book series. Packt's Instant book series promises short, fast, and focused information; Hudik's book delivers. It's eighty pages deliver hundreds of pages worth of the author's knowledge in a highly-condensed format, perfect for today's multi-tasking technical professionals.Hudik's book is perfect for anyone experienced with the Oracle Database 11g platform, and interested in leveraging Microsoft's PowerShell scripting technology to automate their day-to-day database tasks. Even a seasoned developer, already experienced in both technologies, will learn how to easily overcome several integration intricacies, clearly covered by the author.
As a busy Lead Developer for a large public company, I was able to immediately start implementing many of the book's lessons to improve my productivity. I especially enjoyed the way the book builds upon previous lessons, resulting in a useful collection of foundational PowerShell scripts and modules. Building on top of these, save time when automating a new task.
Product details
|
Tags : Instant Oracle Database and PowerShell How-to [Geoffrey Hudik] on Amazon.com. *FREE* shipping on qualifying offers. Utilize the power of Microsoft's powerful scripting engine to automate database tasks with Oracle from PowerShell <b>Overview</b> <ul> <li>Learn something new in an Instant! A short,Geoffrey Hudik,Instant Oracle Database and PowerShell How-to,Packt Publishing,1849688583,Databases - General,Computer Books: Database,Computers,Computers Databases General,Oracle
People also read other books :
- Fantasy Craft CFG01001 Alex Flagg Scott Gearin Patrick Kapera 9780982684306 Books
- House of Goats (Audible Audio Edition) Tammy Owen Colleen Patrick LLC Wyrd Goat Press Books
- Dark Souls Tales of Ember #2 eBook George Mann Tauriq Moosa Alan Quah Michael Walsh Daniel Serra Damien Worm Caspar Wijngaard
- Rapture Myths edition by Steve Wohlberg Religion Spirituality eBooks
- Earth Dragon Canon Walking Martial Arts and Self Evolution Troy Williams 9780981967523 Books
Instant Oracle Database and PowerShell Howto Geoffrey Hudik 9781849688581 Books Reviews
...I was expecting more zombies in it. Other than that it contains a good introduction on connecting PowerShell to an Oracle database and several other tutorials and snippets that could prove to be quite useful for any Oracle/.Net junkie.
Powershell is a much more powerful than MS-DOS command line to access your Oracle Database.
I just received this book yesterday. The format is pretty unusual, 192m x 235mm x 4 mm -) It is well printed and it looks nice.
The book focuses more on developings API's than write DBA's scripts, if you do not want to use Oracle Data Provider assembly (odp.net), there is little else said on Powershell and Oracle.
The approach of the author is to provide receipts for common tasks like retrieve or output data out of the databases, starting with connection string until advanced graphs (with the Windows.Forms assembly)
I like a lot of code, and detailled explanations
I miss one-liners. You have to write functions to understand how it works
I highly recommend Geoffrey Hudik's Instant Oracle Database and PowerShell How-to ebook, part of Packt Publishing's Instant book series. Packt's Instant book series promises short, fast, and focused information; Hudik's book delivers. It's eighty pages deliver hundreds of pages worth of the author's knowledge in a highly-condensed format, perfect for today's multi-tasking technical professionals.
Hudik's book is perfect for anyone experienced with the Oracle Database 11g platform, and interested in leveraging Microsoft's PowerShell scripting technology to automate their day-to-day database tasks. Even a seasoned developer, already experienced in both technologies, will learn how to easily overcome several integration intricacies, clearly covered by the author.
As a busy Lead Developer for a large public company, I was able to immediately start implementing many of the book's lessons to improve my productivity. I especially enjoyed the way the book builds upon previous lessons, resulting in a useful collection of foundational PowerShell scripts and modules. Building on top of these, save time when automating a new task.
0 Response to "⋙ Libro Gratis Instant Oracle Database and PowerShell Howto Geoffrey Hudik 9781849688581 Books"
Post a Comment