Introduction to SQL
Installing Oracle Grid Infrastructure
Creating and managing users
Installing and configuring an Oracle Database
Creating and managing storage structures
Administering the Oracle database
Understanding the Oracle database architecture and how its components work and interact with one another
Performing backup and recovery
Diagnosing and repairing data failures with Flashback technology
Managing space to optimize database storage
Monitoring and managing major database components, including memory, performance and resources
Backup and recovery strategies
Automating DBA tasks with the Scheduler
CERTIFICATES
Oracle DB 12c Backup and Recovery
State of the Industry
Oracle Database 12c Backup and Recovery Workshop course will teach you how to evaluate your own recovery requirements. You’ll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. This course will teach you about the Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios.
In this Oracle Database 12c Backup and Recovery Workshop you will learn to:
Develop appropriate backup and recovery procedures to address your business needs.
Implement backup and recovery settings and perform backup operations to disk and tape.
Employ Oracle Database recovery procedures to recover from media and other failures.
Diagnose and repair data failures.
Use Flashback Technologies and data duplication to complement backup and recovery procedures.
Secure the availability of your database by appropriate backup and recovery strategies.
- English
- 30 hours*
- As per demand
- Talk to an
ADVISOR
* Morning, evening, weekends
Who Should Apply
This course is intended for Database Administrators, Technical Administrators, Support Engineers, and Technical Consultants.
Dwany H
Big Data Developer
Sihame B
BI Developer
Rosana N
Java Developer
Karla P
Java Developer
Under Development
WHAT YOU WILL LEARN COURSE OUTLINE
AEC Program – Oracle Database 12c Backup and Recovery Workshop
SKILLS ACQUIRED
Under Development
CERTIFICATION EXAMS
Certificate of participation in ‘Oracle Database Administration’ course.
Follow through Certification
The professionals taking this path can pursue the following certification:
Oracle Database 11g Administrator Certified Professional
TOP REASON
TO JOIN MCIT
- Industry-relevant, job-ready programs
- Internship possibilities
- Eligibility for off-campus work permit program [ocwpp]
- Eligibility for post-graduation work permit [pgwp]
- Eligibility for points under Quebec’s immigration policy
- Scholarships and financial aid
INSTRUCTOR SPOTLIGHT
Gregory Shinder
I love working with SQL Server, especially to solve performance problems. Have a poor-performing query? Challenge accepted! I also like to design and implement high availability and disaster recovery solutions. When I’m not trying to break another SQL server, you’ll find me teaching SQL.
Dhruv Gusain
Enterprise Java developer with a passion for sports. My Aim, to have a connection with the students and make them understand the crux of any concept.
Ayda Ghasemi
I am a SQL instructor at MCIT and a member of the Data and BI team at Couche-Tard. I have expertise in Microsoft Azure stack on-premises and in Azure cloud. I hold a bachelors in Physics and an MBA. I also spent a year as a BI developer at MCIT.
Haythem Rehouma
I am a full-stack and mobile developer who works on native mobile (Android and iOS) and cross-platform (PhoneGap/Ionic/ReactNative/Angular) apps for both business and consumer customers. Examples of my apps included location-based services and sensors.
Jiji Raghavan
I am a software QA instructor at MCIT where I help students focus on their vision by guiding them through each phase of their career. I have 6 years of experience as a QA engineer and 2 years in teaching. It motivates me as I can see myself as an agent of change in my students’ life. I want to inspire all of my students to be ambitious and make a difference in their life and career.
Kashyap Vedantam
With more than 6 years of industry experience, I’ve developed many applications in various programming languages. I hold a masters in applied computer science from Concordia and am a certified Microsoft SQL developer. I seek to create a classroom atmosphere that is stimulating and makes students feel valued. "Grow by learning something new every day."
Souleyman Sidibe
I am an experienced IT project manager with significant expertise in business intelligence (BI). I hold high-level degrees in IT networking, telecommunications, business intelligence, and programming. I’ve previously worked as a database specialist, an ETL developer, a BI analyst, and a business analyst. My main motivation in teaching is to transfer the knowledge that helps others fulfill themselves.
Toufik Lazri
I am a university graduate in computer engineering and have been developing and implementing computer applications for more than 25 years. I have been teaching Java technologies for more than 10 years. I enjoy passing on my knowledge in a clear and dynamic way in order for students to make a successful transition to the labor market.
Vimal Kapoor
I am a dynamic IT professional with experience in corporate IT systems, network support solutions, and Wipro technologies. I have the proven ability to provide creative and effective server and networking strategies for all Microsoft operating systems and server products.
Aimable Karangwa
I hold a masters in IT management and am a Certified Business Analyst Professional (CBAP), a PMI-Agile Certified Practitioner (PMI-ACP), and have obtained a PRINCE2 Foundation certification. I have 17 Years of experience as a senior business analyst consultant.
Iraj Hedayati
I'm leading the data team at Guavus, a major data analytics company, working with the Hadoop ecosystem. I hold a master's degree in computer science and one in software engineering. I was always eager to pursue teaching, an activity that I thoroughly enjoy.COMMUNITY TESTIMONIAL
I am an attorney from Brazil. Montreal College provided me with the optimal environment for a career shift.
Ricardo Gomez — BA Student
