- Database introduction
- Oracle database 12c architecture
- Database startup & user requests
- Oracle backup & recovery
- Database tuning continued
- Memory & process architecture
- Database resource manager
- Alert & trace files
- Database tuning
- Database Schema Objects
- Managing data with ILM
- Data dictionary & dynamic performance tables
- Oracle recovery manager (RMAN)
- Deep dive into schema objects
- Oracle storage structures
- Database Security
- Oracle Network Environment
- Home
- Intellipaat
- Courses
- Database Architect Training Combo
Database Architect Training: Combo Course
Become a Database Architect, developer and administrator of Oracle PL/SQL through Database Architect Training: Combo Course by Intellipaat.
Online
₹ 26,220
Quick facts
particular | details | |||
---|---|---|---|---|
Collaborators
Microsoft Corporation
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
The Database Architect Training: Combo Course by Intellipaat is a combo-training course that caters to the requirements of both beginners and professionals in the field of Database Development. This is a certification course that helps the candidate gain command over Oracle as a Database Software and guarantees training at an advanced master’s level.
A candidate will gain a lot of master training from the course as it has a plethora of subjects clubbed under the same course, like Oracle DBA, SQL Warehousing, SQL DBA, Data Modelling, Oracle PL/SQL scripting, ERwin, SQL developer etc. This combo of a course is inclusive of 5 in 1 elaborate structure of Job domains, and a candidate can apply to any major MNC offering such Jobs due to increased employability and grab high pay.
The programme is basically application-based and thus candidates are given opportunities to work on real-world projects. Important skills like Data modelling, warehousing and handling of database systems will be imparted to the students during the process so that they go on to develop proficiency in administering Databases and working on SQL.
The highlights
- 68 hours of self-paced videos
- Lifetime support and access
- 68-hour instructor-led training
- Flexible schedule
- 136 hours of project work and course exercises
- Self-paced course
- Certification and job assistance
Program offerings
- Exercises
- Project work
- Self-paced videos
- Instructor led training
Course and certificate fees
Fees information
- Self-paced training programme costs Rs. 26,220.
- Online Classroom programme costs Rs. 55,005.
- A discount of 10% is applicable on the classroom training for the next 23 hours.
- There is an option of availing ‘No Interest Financing’ for the classroom programme, starting at Rs. 5000 per month.
- IGST of 18% is payable on both options.
Fee Category | Amount in Rupees | |
Base Fee | Rs. 26,220 (self-paced) | Rs. 55,005 (online classroom) |
Discount | - | 10% of the total payable amount |
GST | Rs. 4,720 | Rs. 14,621 |
Total | Rs. 30,940 | Rs. 64,906 |
certificate availability
certificate providing authority
Eligibility criteria
Certification Qualifying Details
Certification of completion will be awarded to the candidates by Intellipaat once they have finished the course by scoring at least 60% marks in the exam for qualification, completed the training programme, worked on projects, quizzes, and submitted assignments successfully. The certificate is affiliated with Intellipaat and recognised by its organisation, over 80 top MNCs of the world, and some of the Fortune 500 companies as well.
What you will learn
After successful completion, the candidates would be able to:
- Work with oracle by building, designing, and managing database applications.
- Perform and review the execution, declaration, performance, and exception handling of databases along with those of PL/SQL sections.
- Apply core database concepts and take on the role of an administrator.
- Write SQL for the query database and can also modify it using T-SQL, maintain client/server relations, and complete MS SQL architecture.
- Use SQL command major groups like TCL, DML, DDL, and DCL, along with building Erwin design layer architecture.
Who it is for
This programme is strongly recommended for those who are:
- Aspirants looking for jobs in the arena of Database development and architecture.
- Professionals belonging to the fields of SQL Development, Data Warehousing, Erwin, Data Modeling, etc. who require additional database expertise.
- Students wanting to appear in examinations like Oracle PL/SQL developer certified associate and Oracle database administrator certified associate.
Admission details
Students wanting to take admission in the Database Architect Training: Combo Course by Intellipaat need to follow the following steps one by one:
Step 1: Go to the course webpage.
Step 2: Click on ‘Enroll now’ and choose your preferred training between the ‘self-paced course and ‘classroom-teaching programme’.
Step 3: If you choose the online classroom programme, there is an option for financing as well. To proceed further, review your cart and click on ‘checkout’.
Step 4: If there is some coupon available, type in the code. Else, check the invoice details.
Step 5: Login through your Intellipaat account, Google, or Facebook to authenticate your identity.
Step 6: Enter your card or internet banking details.
Step 7: After your transaction is complete, the course will be made available at the same ID.
The syllabus
Oracle 12c DBA course content
SQL course content
- Introduction to SQL
- Designing and implementing database objects
- SQL operators
- Microsoft courses study material
- Querying data with advanced Transact-SQL components
- SQL optimization and performance
- Advanced topics
- Working with subqueries
- Managing data with transact-SQL
- Programming databases using transact-SQL
- Working with SQL: Join, tables, and variables
- Managing database concurrency
- Deep dive into user-defined functions
- SQL views, functions, and stored procedures
- Optimizing database objects
- Deep dive into SQL functions
- Implementing programmability objects
- Database normalization and entity-relationship model
Oracle PL SQL course content
- Introduction to Oracle SQL
- Exception handling
- Using DDL statements to create and manage tables
- Restricting and sorting data
- Advance package concepts and functions
- Using single-row functions to customize the output
- Large object functions
- Introduction to the explicit cursor
- Using conversion functions and conditional expressions
- Displaying data from multiple tables
- Compound triggers
- Using subqueries to solve queries
- Database transactions
- Creating other schema objects
- Writing cursor and conditional statement
- Advance concepts of an explicit cursor
- Writing subprogram, procedure, and passing parameters
- General functions
- Creating a PL/SQL package
- OLAP functions
- Retrieving data using the SQL SELECT statement
- Introduction and writing triggers
- Manipulating data using SQL
- Working with dynamic SQL
- Advance level- scripting
- Using the set operators
Database architecture projects
- Logical & physical data modelling using Erwin (Invoice Mgmt)
- Performing DML operations on the database
- SQL Server audit
- Tuning of the database
- Writing complex subqueries
- End-to-End implementation of data warehouse (Retail store)
MS SQL server DBA course content
- Installation and configuration
- Implementing high availability
- Managing instances and databases
- Optimizing and troubleshooting
- Managing data
- Implementing security
Data warehouse course content
- Introduction to the data warehouse
- The architecture of the data warehouse
- Data modelling concepts
- Forward and reverse engineering
- Data normalization
- Dimension & fact table
- SQL parsing, cubes & OLAP
- Erwin design layer architecture (self-paced)
Evaluation process
Candidates need to appear in a qualifying exam and score at least 60% to get an affiliated certificate by Intellipaat.
How it helps
Advantages of pursuing the Database Architect Training: Combo Course by Intellipaat varies from candidate to candidate, but the course helps professionals in scoring a raise in their current job profile, and even apply for promotion in their firms, students get the advantage of transiting to higher levels of knowledge and qualification, while some employed in other fields started a new career in Database Architecture sector.
The programme has laid provisions for reviewing projects submitted by the candidates for better outcomes. Other facilities that help in the cause of the curriculum are the availability of exclusive job portals, interviews planned with top companies, and learning managers dedicated to the bunch of students. Intellipaat also offers services of resume preparation that’ll help in landing on better employers and also helps in preparation for a LinkedIn Profile for a better outlook.
Candidates pursuing the Database Architect Training: Combo Course by Intellipaat can appear for two certification exams, namely the ‘Oracle database administrator certified associate’ examination and ‘Oracle PL/SQL developer certified associate’ examination, just after completion due to the curriculum being apt for aspirants, enabling ease in getting through.
The course grants the candidates the experience of working on real-world industry scenarios so that it could be of application in their careers and the assignments are structured to have vast implications. At the posterior of the course curriculum, there are a number of quizzes scheduled to check understanding as per the various certification exams to improve performance.
FAQs
Intellipaat certification is accepted into more than 80 MNCs all over the globe, including Mu Sigma, Ericsson, Hexaware, Cognizant, Standard Chartered, Sony, Saint-Gobain, TCS, Genpact, Cisco, etc.
The Database Architect Training: Combo Course by Intellipaat has a 24*7 query resolution team, along with solutions to queries through emails, and personal doubt-solving sessions with the trainers.
There is a range of projects a candidate will be working on including those from the fields of technology, networking, insurance, e-commerce, sales, and banking.
The trainers at Intellipaat are industry experts and have more than twelve years of experience in their respective domains. They are actively engaged in their respective industries as consultants, as subject matter experts.
A student can transition very easily, just by paying the extra fees and can join the very next ongoing batch.
There are three different kinds of training programmes provided on the platform, namely Instructor-led, self-paced and corporate training programme.
Candidates are given the project of writing complex sub-queries under SQL training.
Strong reporting, 24*7 support, customised learning and enterprise grade-learning mechanism system (LMS) is the offerings of corporate training.
A candidate is entitled to attend as many batches wanted, for a lifetime, after enrollment.
It offers support to candidates seeking jobs in various firms and MNCs. It offers opportunities to discover various competitive openings, although selection depends on the performance of the candidate in the interview.