306 Migration courses

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Database Designers Support Engineer Technical Administrator Overview Back up, restore, and patch DBCS database deployments Describe the DBaaS and on-premises Oracle Database architectures Manage database instances Manage UNDO data Move data between databases Implement basic backup and recovery procedures Monitor and tune database performance Tune SQL to improve performance Manage resources with Oracle Database Resource Manager Create pluggable databases (PDBs) Configure the Oracle network environment Administer user security and implement auditing Create and manage tablespaces Manage storage space Create and manage Database as a Cloud Service (DBCS) database deployments Register databases and manage performance with Enterprise Manager Cloud Control The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Exploring Oracle Database Architecture Introducing Oracle Database Relation Database Models Oracle SQL and PL/SQL Oracle Database Server Architecture Connecting to Oracle Databases Oracle Database Tools Oracle-Supplied User Accounts Querying the Oracle Data Dictionary Managing Database Instances Initialization Parameter Files Starting Up Oracle Databases Shutting Down Oracle Databases Opening and Closing PDBs Working with the Automatic Diagnostic Repository (ADR) Querying Dynamic Performance Views Creating PDBs Methods and Tools to Create PDBs Creating PDBs from Seed with SQL*Plus Cloning PDBs with SQL*Plus Unplugging and Pluggin In PDBs with SQL*Plus Dropping PDBs with SQL*Plus Configuring the Oracle Network Environment Oracle Net Services How Listeners Work Configuring Listeners for Dynamic Service Registration Configuring Listeners for Static Service Registration Configuring Local Naming for Connections Testing Oracle Net Connectivity with tnsping Configuring Communication Between Databases Dedicated Versus Shared Server Configurations Administering User Security Creating Users Granting Privileges Creating and Granting Roles Revoking Privileges and Roles Creating and Assigning Profiles Authenticating Users Assigning Quotas to Users Applying the Principal of Least Privilege Creating and Managing Tablespaces How Table Data is Stored Creating Tablespaces in SQL*Plus Altering and Dropping Tablespaces in SQL*Plus Viewing Tablespace Information in SQL*Plus Implementing Oracle Managed Files Moving and Renaming Online Data Files in SQL*Plus Managing Storage Space Oracle Database Space Management Features Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Understanding Deferred Segment Creation Space-Saving Features Managing UNDO Data Undo Data: Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Local Undo Mode Versus Shared Undo Mode Configuring Undo Retention Categories of Undo Moving Data Moving Data: General Architecture Oracle Data Pump: Overview Oracle Data Pump: Benefits Data Pump Export and Import Clients Data Pump Utility: Interfaces and Modes Data Pump Import: Transformations SQL*Loader Overview Loading Methods Backup and Recovery Concepts DBA Responsibilities Categories of Failure Understanding Instance Recovery Understanding Types of Backups Comparing Complete and Incomplete Recovery Oracle Data Protection Solutions Flashback Technology Monitoring and Tuning Database Performance Managing Performance Activities Performance Planning Considerations Database Maintenance Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor Performance Monitoring Performance Tuning Methodology Database Server Statistics and Metrics SQL Tuning SQL Tuning Process Oracle Optimizer Optimizer Statistics SQL Plan Directives Adaptive Execution Plans SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Oracle Database Resource Manager Oracle Database Resource Manager: Overview Resource Manager Elements Using Resource Manager to Allocate Resources Creating a Simple Resource Plan Creating a Complex Resource Plan Using the Active Session Pool Feature Limiting CPU Utilization at the Database Level Limiting CPU Utilization at the Server Level Enterprise Manager Cloud Control Controlling the Enterprise Manager Cloud Control Framework Starting the Enterprise Manager Cloud Control Framework Stopping the Enterprise Manager Cloud Control Framework Introduction to Oracle Database Cloud Service Oracle Cloud: Overview Database Cloud Service Offerings DBCS Architecture Features and Tooling Additional Database Configuration Options Creating DBCS Database Deployments Automated Database Provisioning Creating a Database Deployment How SSH Key Pairs are Used Creating an SSH Key Pair Storage Used for Database Files Managing DBCS Database Deployments Cloud Tooling Accessing Tools and Features from the DBCS Console Managing the Compute Node Associated With a Database Deployment Managing Network Access to DBCS Enabling Access to a Compute Node Port Scaling a Database Deployment Backing Up and Restoring DBCS Database Deployments Backing Up and Recovering Databases on DBCS Backup Destination Choices Backup Configuration Creating an On-Demand Backup Customizing the Backup Configuration Performing Recovery by Using the Console Performing Recovery by Using the dbaascli Utility Patching DBCS Database Deployments Patching DBCS Using the DBCS Console to Manage Patches Using the dbaascli Utility to Manage Patches Creating Master Encryption Keys for PDBs CDB and PDB Master Encryption Keys Determining Whether You Need to Create and Activate and Encryption Key for a PDB Creating and Activating an Encryption Key Tablespace Encryption by Default Tablespace Encryption by Default in DBCS Transparent Data Encryption (TDE) Overview Components of TDE Using TDE Defining the Keystore Location Controlling Tablespace Encryption by Default Managing the Software Keystore and Master Encryption Key Managing the Keystore in CDBs and PDBs Additional course details: Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Read and discuss this global best-selling satirical & entertaining thriller set in the publishing industry Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this thriller set in the publishing industry to discuss questions of diversity, racism, and cultural appropriation Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using Yellowface by R.F. Kuang. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book Author Athena Liu is a literary phenomenon while her friend June Hayward is a literally nobody, and is jealous. So when Athena dies in a freak accident, June sees nothing too wrong in stealing her unpublished work and publishing it herself under the name Juniper Song. When questions start to be asked, what will June do to protect her new-found success...? Yellowface raises interesting contemporary questions of diversity, racism, and cultural appropriation, while being gripping and highly readable. ‘Ingenious, astute, hugely entertaining’ David Nicholls ‘Hard to put down. Harder to forget’ Stephen King Geoff says: "It's funny that this book has been a publishing sensation - given that it satirizes the book publishing industry! It was Amazon book of the year, and the Fiction Book of the Year 2024 at the British Book Awards."

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

Read and discuss this witty, best-selling murder mystery - clever and compelling Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this amusing book to develop your understanding of colloquial English Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week English book club course using the Richard Osman's new series after The Thursday Murder Club, We Solve Murders. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book This is the first in a new series for detective duo Steve and Amy Wheeler. Steve is happily retired and likes his routines: the pub quiz, sitting outside, his cat. His past was full of adventure, but now he likes a quiet life. His daughter-in-law Amy, however, loves adrenaline. She's a private security officer, protecting a world-famous author Rosie D’Antonio on a remote island. It should be a simple job, until there's a murder, a lot of money and someone trying to kill Amy. This thriller is filled with action, amusing lines and warmth. And you need to work out "whodunnit" - who committed the crime! 'The thing that shines through in Osman’s writing is that he really likes people and revels in all their foibles and eccentricities. All of which makes for a delightful read' THE OBSERVER Geoff says: "Richard Osman is the famous author of the best-selling Thursday Murder Club series. This new book has broken all records as the best-selling adult hardback fiction book in the UK. It is full of action, yet witty, with interesting characters, and full of British English idioms and colloquialisms - great for improving your knowledge of how English is actually spoken!"

Read and discuss this modern retelling of The Iliad by award winning writer Madeline Miller Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Discuss this modern retelling and develop your cultural knowledge Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week advanced English book club course reading and discussing the modern best-selling novel The Song of Achilles by award winning writer Madeline Miller. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book A gripping tale of love, ambition and immortal fame. This book was the winner of the Orange Women's Prize for Fiction and has sold over 1.5 million copies worldwide. It retells the story of The Iliad for modern times. The young prince Patroclus is exiled to the court of King Peleus, and is befriended by his son, Achilles. As the young men learn of war and medicine, their bond deepens, in spite of Achilles's mother Thetis. But when news reaches them that Helen of Sparta has been kidnapped, Achilles must fulfill his destiny and go to war in far off Troy. Not knowing what will become of them Patroclus accompanies him, and the years that follow test everything they value. 'Captivating' DONNA TARTT 'I loved it' J K ROWLING 'Ravishingly vivid' EMMA DONOGHUE Geoff says: "Modern day retellings of the stories from the classical Greeks have become very popular over the last decade - and this is the book that started the trend!"

Read and discuss this novel of what it is to be human Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read this contemporary novel and discuss love, emotional intelligence and humanity Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this course featuring Matt Haig's The Humans. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book From the writer of The Midnight Library and How to Stop Time comes The Humans - a funny novel about alien abduction, mathematics, and what it is to be human. It combines hilarious moments with thought-provoking insights into how we interact. Maths professor Andrew Martin, is dead. His body is now taken over by an alien, who discovers that the professor wasn't very nice. The alien finds himself learning more about the professor, his family, and “the humans”. When he starts to feel for his own wife and son - who have no clue he’s not the real Andrew- the alien has a decision to make - complete his mission or abandon it and start a new life with the humans. Geoff says: "I laughed out loud reading this - but it also addresses serious themes. It shines a light on what it means to be human, and gaining emotional intelligence."

Read and discuss this beautiful story of friendship, love and truth set in London, Tuscany and Florence Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Discuss this novel of beauty, love and art over 4 decades Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week advanced English book club course reading and discussing Still Life by Sarah Winman. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book In Italy in 1944 two strangers meet in a Tuscan villa. Ulysses Temper is a young British soldier, Evelyn Skinner a free-thinking independent-minded 64-year-old art historian, come to rescue paintings from the war and relive her memories. This chance meeting with Evelyn will transform Ulysses’ life – and everyone who knows him. ‘THE most beautiful book … it will stay with me a long time’ SARA COX, BBC TWO’S BETWEEN THE COVERS Geoff says: "This is a lovely novel, with references to the great writer EM Forster and his masterpiece "A Room With A View". Much loved by readers, the characters of this novel stay with you for a long time."

Read and discuss this beautiful story of friendship, love and truth set in London, Tuscany and Florence Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Discuss this novel of beauty, love and art over 4 decades Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week advanced English book club course reading and discussing Still Life by Sarah Winman. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book In Italy in 1944 two strangers meet in a Tuscan villa. Ulysses Temper is a young British soldier, Evelyn Skinner a free-thinking independent-minded 64-year-old art historian, come to rescue paintings from the war and relive her memories. This chance meeting with Evelyn will transform Ulysses’ life – and everyone who knows him. ‘THE most beautiful book … it will stay with me a long time’ SARA COX, BBC TWO’S BETWEEN THE COVERS Geoff says: "This is a lovely novel, with references to the great writer EM Forster and his masterpiece "A Room With A View". Much loved by readers, the characters of this novel stay with you for a long time."

Read and discuss Jane Austen's first published work, 250 years after her death! Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Study this classic novel and increase your knowledge of British culture Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this 7 week advanced course using this classic novel by one of the greatest British writers - Jane Austen. Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club book Jane Austen's Sense and Sensibility is a subtle and intelligent story of secrets and lies, and wonderfully shows a world where fixed social rules meet the feelings of the heart. Two very different sisters find themselves in a new world when their father dies. Marianne, wild and emotional, falls dangerously in love, while Elinor suffers heartbreak but hides what she really feels, even from her closest friends and family. Geoff says: "I chose this book because it is beautifully written. Jane Austen really understood human nature and delightfully describes characters and human situations."