Courses

Back

Corporate Training Hire From Us Explore Courses
Intellipaat collaboration image

Database Architect Training: Combo Course

512 Ratings

Intellipaat's Database Architect Certificate master's training program lets you gain proficiency in the Oracle Database. We provide the best online training classes to help you learn Oracle PL/SQL scripting, data warehousing, data modeling, ERwin, SQL Developer and SQL DBA. You will work on real-world projects in this program.

Intellipaat courses

Watch

Course Preview

Key Highlights

68 Hrs Instructor Led Training
68 Hrs Self-paced Videos
136 Hrs Project & Exercises
Certification
Job Assistance
Flexible Schedule
Lifetime Free Upgrade
Mentor Support
trustpilot review 3332
sitejabber review 1429
mouthshut review 24068

Database Architect Training Overview

What will you learn in this training course?

  1. Core database concepts and the role of a Database Administrator
  2. SQL, PL/SQL, client/server relation and MS SQL architecture
  3. Writing SQL to query database and modifying using T-SQL
  4. ETL life cycle, data modeling and data warehousing
  5. ERwin Design Layer architecture
  6. Working with Oracle and designing, building and managing database applications
  7. Database performance, integrity and security management
  8. PL/SQL sections like declaration, execution and exception handling
  9. SQL command major groups: DDL, DML, DCL and TCL
  • SQL Developers, Database Administrators, Software Developers and BI Professionals
  • Project Managers, Business Analysts, Testing, Data Warehousing and Hadoop Professionals

There are no prerequisites for taking up this training course.

This Intellipaat combo training course has been developed keeping in mind the requirements of database professionals as well as beginners. Since this is a 5-in-1 elaborate combo course, upon the completion of the course, you can look for jobs in any of the five domains. This will help you land high-paying jobs in major multinationals.

View More

Talk To Us

We are happy to help you 24/7

Career Transition

60% Average Salary Hike

$1,20,000 Highest Salary

1500+ Career Transitions

500+ Hiring Partners

Career Transition Handbook

*Past record is no guarantee of future job prospects

Course Fees

Self Paced Training

  • 68 Hrs e-learning videos
  • Flexible Schedule
  • Lifetime Free Upgrade

$460

Online Classroom Preferred

  • Everything in Self-Paced Learning, plus
  • 68 Hrs of Instructor-led Training
  • One to one doubt resolution sessions
  • Attend as many batches as you want for Lifetime
  • Job Assistance
23 Mar

SAT - SUN

08:00 PM TO 11:00 PM IST (GMT +5:30)

30 Mar

SAT - SUN

08:00 PM TO 11:00 PM IST (GMT +5:30)

06 Apr

SAT - SUN

08:00 PM TO 11:00 PM IST (GMT +5:30)

13 Apr

SAT - SUN

08:00 PM TO 11:00 PM IST (GMT +5:30)

$965 10% OFF Expires in

Corporate Training

  • Customized Learning
  • Enterprise grade learning management system (LMS)
  • 24x7 Support
  • Enterprise grade reporting

Contact Us

Database Architect Course Content

Live Course Self Paced

Oracle PL SQL Course Content

Introduction to Oracle SQL

Preview

What is RDBMS, Oracle versions, Architecture of Oracle Database Server, Installation of Oracle 12c

Hands-on Exercise – Install Oracle 12c

Download Brochure

Using DDL Statements to Create and Manage Tables

Preview

Categorize the main database objects, Review the table structure, List the data types that are available for columns, Create a simple table, Explain how constraints are created at the time of table creation, Describe how schema objects work

Hands-on Exercise – Create a database table Person with two column (Name, Age) with constraint on age not greater than 100, Insert records using insert query

Download Brochure

List the capabilities of SQL SELECT statements, Execute a basic SELECT statement

Hands-on Exercise – Use a basic select statement to retrieve all the records in the Person table

Download Brochure

Limit the rows that are retrieved by a query, Sort the rows that are retrieved by a query, Ampersand substitution to restrict and sort output at runtime

Hands-on Exercise – Write a select query to retrieve records where age is more than 60 yrs, Write a select query to sort the records by name, Write a select query to sort the records by age in descending order, Use ampersand substitution to restrict and sort output at runtime

Download Brochure

The general functions in SQL, working with any data type and handling Null values, using COALESCE() and Null function, Constructing and executing SQL query that applies the NUL, NUL1, NUL2 and COALESCE()

Hands-on Exercise – Use NULL function to deal with null values in data

Download Brochure

Describe various types of functions (character, number, date, string etc.) available in SQL

Hands-on Exercise – Create a table with columns of type char, number and date, Use character, number, and date functions in SELECT statements

Download Brochure

Large object functions – BFILENAME, EMPTY_BLOB, EMPTY_CLOB, Aggregate or Group functions – COUNT, COUNT(*),MIN,MAX,SUM,AVG,etc…,Group BY Clause, HAVING Clause

Hands-on Exercise – Count records based on a condition, Use Count(*) to know the count of all records, Find Max, Min, Sum, Avg

Download Brochure

The various OLAP functions, cube, model clause, roll up and grouping functions

Hands-on Exercise – Working with OLAP commands – Cube, Roll Up, etc.

Download Brochure

Describe various types of conversion functions that are available in SQL, Conditional expressions in a SELECT statement

Hands-on Exercise – Group data by using the GROUP BY clause, Include or exclude grouped rows by using the HAVING clause

Download Brochure

Joins, Inner Join, Outer Join, Left Join, Right Join, Equijoins and Non-equijoins

Hands-on Exercise – Write SELECT statements to access data from more than one table using equijoins and non equijoins, Join a table to itself by using a self-join, View data that generally does not meet a join condition by using outer joins, Generate a Cartesian product of all rows from two or more tables

Download Brochure

Define subqueries, Describe the types of problems that the subqueries can solve, List the types of subqueries

Hands-on Exercise – Write single-row and multiple-row subqueries

Download Brochure

Describe set operators, UNION [ALL], INTERSECT, MINUS Operators

Hands-on Exercise – Use a set operator to combine multiple queries into a single query Control the order of rows returned

Download Brochure

Describe data manipulation language (DML) statement, Insert, Update, Delete Statements, Control transactions

Hands-on Exercise – Insert rows into a table, Update rows in a table, Delete rows from a table

Download Brochure

What is a database transaction, Properties of a transaction (Atomic, Consistent, Isolated, Durable – ACID), Avoiding error/fault in manipulating database records using transaction

Hands-on Exercise – Begin a transaction, Execute queries to update or insert or delete records, If no error, commit the transaction Else roll back the transaction and end it

Download Brochure

Views – simple and complex, Sequences, Index, Synonym

Hands-on Exercise – Create simple and complex views, Retrieve data from views, Create, maintain, and use sequences, Create and maintain indexes, Create private and public synonyms

Download Brochure

SQL Cursor, SQL Cursor Attributes., Controlling PL/SQL flow of executions, IF Statement, Simple IF Statement, IF-THAN-ELSE Statement Execution Flow, IF-THAN-ELSE Statement, IF-THAN-ELSIF Statement, Logic Tables, Boolean Conditions., Iterative controlling loop statement, Nested Loops and Labels.

Hands-on Exercise – Use Boolean condition on a select query, Use logic table, Create nested loops and labels

Download Brochure

Writing Explicit cursors, About cursors, Explicit cursor functions, Controlling explicit cursor, Opening the cursor, Fetching Data cursor, Cursor and records, Cursor for loop using sub queries

Hands-on Exercise – Write an explicit cursor, Use cursor function, Fetch data cursor

Download Brochure

Advance Explicit cursor, Cursor with parameters, For update Clause, Where current of Clause, Cursor with sub queries

Hands-on Exercise – Use cursor with subquery, Use Where Current clause to retrieve data

Download Brochure

Handling Exception, Handling Exception with PL/SQLPredefined Exceptions, User Defined Exceptions, Non-Predefined Error, Function for trapping Exception, Trapping user-defined Exception, Raise Application Error Procedure

Hands-on Exercise – Use Predefined exception, Write user defined exception, Generate and handle exception, Use a function for trapping an exception

Download Brochure

Overview of subprograms, PL/SQL Subprograms, What is Procedure, Syntax for creating Procedure, Creating Procedure with parameter, Example of Passing parameters, Referencing a public variable from a standalone procedure, Declaring Subprogram

Hands-on Exercise – Create a parameterized procedure, Pass parameters in a procedure call, Access a public variable from a standalone procedure

Download Brochure

PL/SQL records, Using Pl/SQL Table method and example, Creating PL/SQL Table, Packages – Objective, overview, component, developing, removing, advantages, Creating the package specification/example, Declaring Public construct, Public and private construct, Invoking package construct, Guide lines for deploying packages

Hands-on Exercise – Create a package, Deploy the created package

Download Brochure

Overloading, Using forward declaration, One time only procedure, Package functions, User define package function, Persistent state of package function, Persistent state of package variable, Controlling the persistent state of package cursor, Purity end, Using supplied package, Using native dynamic SQL, Execution flow, Using DBMS-SQL package, Using DBMS-DDL package, Submitting jobs, Interacting with operating system links

Hands-on Exercise – Use supplied package, Use native dynamic SQL, Use DBMS-SQL package, Use DBMS-DDL package, Submit a job

Download Brochure

Triggers – Definition, objective and its event type, Application & database triggers, Business application scenarios for implementing triggers, Define DML triggers, Define Non – DML triggers, Triggers event type & body, Creating DML triggers using the create triggers statement, Define statement level triggers v/s low level triggers, Triggers firing sequence: single row manipulation, Creating a DML statement triggers, Using old and new qualifiers, Old and new qualifiers, Instead of triggers, Managing triggers using the alter & drop SQL statement, Testing triggers

Hands-on Exercise – Create a DML statement trigger, Use old and new qualifiers, Manage a trigger using the alter & drop SQL statement, Test the created triggers

Download Brochure

Viewing trigger information, Describe user triggers, What is a compound trigger and working with it, Compound trigger structure for tables, Timing-point sections of a table compound trigger, Compound trigger structure for views, Trigger restrictions on mutating tables, Compound trigger restrictions, Using a compound trigger to resolve the mutating table error, Creating triggers on system events, LOGON and LOGOFF triggers example, Call statements in triggers, Benefits of database-event triggers, System privileges required to manage triggers

Hands-on Exercise – View a trigger’s information, Use a compound trigger structure for views, Use a compound trigger to resolve the mutating table error, Create triggers on system events, Use LOGON and LOGOFF triggers, Call statements in triggers

Download Brochure

Dynamic SQL-objectives, Describe execution flow of SQL statements, Dynamic SQL with a DDL statement-example, Working with dynamic SQL, Native Dynamic SQL(NDS), Using the executive immediate statement-example, Using native dynamic SQL to compile PL/SQL code, Using DBMS-SQL with a DML statement, Using the DBMS-SQL package subprograms, Parameterized DML statement

Hands-on Exercise – Use the executive immediate statement, Use native dynamic SQL to compile PL/SQL code, Create DBMS-SQL with a DML statement, Create a DBMS-SQL package subprograms

Download Brochure

Managing Dependencies, Objectives, overview of schema object dependencies, Direct local dependencies, Querying direct object dependencies, Displaying direct and indirect dependencies, Fine-Grained dependency management, Changes to synonym dependencies, Maintaining valid PL/SQL program units and views, Object re-validation, Concepts of remote dependencies, Setting the remote dependencies mode parameter, Recompiling PL/SQL program unit, Packages and Dependencies, Successful and unsuccessful recompilation, Recompiling procedures

Hands-on Exercise – Query direct object dependencies, Display direct and indirect dependencies, Set the remote dependencies mode parameter, Recompile PL/SQL program unit, Edit a procedure and recompile it

Download Brochure

Oracle 12c DBA Course Content

What is the Oracle database? How it functions? pre-requisites, oracle database, multiple non-CDB’s share nothing, oracle database 12c installation, multi-tenant architecture, non-CDB oracle system data mixed with user data, multitenant container database, pluggable database.

Download Brochure

The Architecture of Oracle server, the key components – Oracle Instance and Oracle Database, the various file types – data files, control files, redo log files, benefits of CDB, easier management of database, support for oracle database resource manager, pluggable database (PDB), database instance, contents of CDB and pluggable DB, control files and redo log files, shared oracle supplied metadata, root container, data dictionary, creation of PDB’s, seed PDB, limit PDB

Download Brochure

The basics of Oracle Storage structures, logical storage units like tablespaces, data blocks, extents and segments, database Schemas, Schema Objects, Operating System blocks, table statement and way to check “create table”, the instance, the CDB, containers, root containers, PDB, local user and common user, local privileges and common privileges, steps to create a container database, creating a container database using sqlplus, database configuration assistance

Download Brochure

The Oracle Instance consists of background processes and memory structures, learn about the Oracle process and memory architecture, shared pool, redo log buffer, and buffer cache, different methods of creating PDB, steps involved in PDB, using PDB$SEED, without FILE_NAME_CONVERT, synchronization, plug a non-CDB to CDB, plug a non-CDB into CDB using DBMS_PDB, clone PDBS, plug and un-plug, plug unplugged CDB in to CDB

Download Brochure

The Oracle background process errors can be monitored using the Trace Files and Alert Logs, learn how this can be deployed for Oracle Administration and support.

Download Brochure

The methodology of starting a database instance, initializing parameter files, preparing for startup, serving user requests, understanding of the Server process and user process, administrative activities on PDB, new views associated with PDBS, determining which PDB you are in, four functions, opening, closing, and altering the open mode of PDBS, setting the default and temporary tables places for a PDB, using the alter system command from within a PDB, instance parameter change impact

Download Brochure

Automatic data optimization, ILM components, ILM challenges, what is automatic data optimization, heat map and ADO, DBA heat map segment view, monitoring statistics, creating compression polices, creating storage tiering policy, preparing evolution and execution

Hands on Lab :- Automatic Data Optimization, Reduction Policies, Alter Policy

Download Brochure

Learn about the powerful Oracle database security features, data privacy, regulatory compliance, “create user” process, altering and dropping users, generating profiles and limiting resources, auditing, activity monitoring and blocking.

Download Brochure

Understanding of Database Schema objects, the various types available like views, tables, clusters, indexes, sequence, database links, packages and procedures, learning how data is stored in database tables, creating of temporary tables and external tables.

Download Brochure

Resource manager. Resource manager and pluggable database, managing resource between PDBs, CDB resource plan basics:share, CDB resource plan basics:Limits, creating a CDB resource plan, creating a CDB resource plan:SQL example, enabling a CDB resource plan, managing PDB resource plan.

Download Brochure

Mastering the database Schema objects, learning Materialized View, deploying user-generated schema object for generating sequence, the balanced search tree index structure for placing and locating files, learn about data concurrency and data consistency in multi-user databases, the concepts of Locking and Deadlocks.

Download Brochure

Study the client/server Network Environment, configuring the network, connecting to the database, the Oracle Network Environment and database link, starting up a instance, SHOUT DOWN, NOMOUNT, MOUNT, OPEN, PDB, OPEN, clone PDBS.

Download Brochure

Understand how Oracle database ecosystem backup and recovery is deployed, the database testing, database standby, Media recovery options, backup in offline mode, CDB backup and recover, archiving challenges and solutions, in data base archiving, security and performance: audit architecture, consolidation: unique audit trail, extended audit information, data pump audit policy, new administrative privileges, new administrative privileges:SYSBACKUP, new administrative privileges:SYSDG, new administrative privileges:SYSKM

Download Brochure

Learn the significance of Oracle Recovery Manager, how it deploys performance, management and restoration of entire databases, learn about SQL Loader, Oracle Data Pump for import and export and support for External Table.

Download Brochure

The Oracle Data Dictionary contains information related to database privileges, objects, users, and roles, learn Dynamic Performance Table for identifying instance-level problems, get complete knowledge to work with Oracle DBA, connection access DBA, data dictionary views, after CDB creation, alert log file, provisioning new pluggable databases NOARCHIVELOG mode, media failure, flashback CDB, data dictionary views

Download Brochure

Understanding what is database tuning, skills needed to lower response time, increase throughput for time-sensitive applications, how to optimize the storage space, deploy SQL scripts, Index Statistics and Selectivity, how to tune the database, what is a Chained Row and Lock in Oracle.

Download Brochure

In-depth understanding of the Oracle database tuning, what is a shared pool tuning, how to improve the performance with the help of data dictionary, tuning the data dictionary, implementing the PL/SQL code and reusing the code and database buffer.

Download Brochure

Data Warehouse Course Content

Introducing Data Warehouse and Business Intelligence, understanding difference between database and data warehouse, working with ETL tools, SQL parsing.

Download Brochure

Understanding the Data Warehousing Architecture, system used for Reporting and Business Intelligence, understanding OLAP vs. OLTP, introduction to Cubes.

Download Brochure

The various stages from Conceptual Model, Logical Model to Physical Schema, Understanding the Cubes, benefits of Cube, working with OLAP multidimensional Cube, creating Report using a Cube.

Download Brochure

Understanding the process of Data Normalization, rules of normalization for first, second and third normal, BCNF, deploying Erwin for generating SQL scripts.

Download Brochure

The main components of Business Intelligence – Dimensions and Fact Tables, understanding the difference between Fact Tables & Dimensions, understanding Slowly Changing Dimensions in Data Warehousing.

Download Brochure

SQL parsing, compilation and optimization, understanding types and scope of cubes, Data Warehousing Vs. Cubes, limitations of Cubes and evolution of in-memory analytics.

Download Brochure

Learning the Erwin model, understanding the Design Layer Architecture, data warehouse modeling, creating and designing user defined domains, managing naming and data type standards.

Download Brochure

Understanding of the forward and reverse engineering, comparison between the two.

Download Brochure

SQL Course Content

Various types of databases, introduction to Structured Query Language, distinction between client server and file server databases, understanding SQL Server Management Studio, SQL Table basics, data types and functions, Transaction-SQL, authentication for Windows, data control language, and the identification of the keywords in T-SQL, such as Drop Table.

Download Brochure

Data Anomalies, Update Anomalies, Insertion Anomalies, Deletion Anomalies, Types of Dependencies, Functional Dependency, Fully functional dependency, Partial functional dependency, Transitive functional dependency, Multi-valued functional dependency, Decomposition of tables, Lossy decomposition, Lossless decomposition, What is Normalization?, First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form(BCNF), Fourth Normal Form, Entity-Relationship Model, Entity and Entity Set, Attributes and types of Attributes, Entity Sets, Relationship Sets, Degree of Relationship, Mapping Cardinalities, One-to-One, One-to-Many, Many-to-one, Many-to-many, Symbols used in E-R Notation.

Download Brochure

Introduction to relational databases, fundamental concepts of relational rows, tables, and columns; several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys, understanding group functions, the unique key, etc.

Download Brochure

Advanced concepts of SQL tables, SQL functions, operators & queries, table creation, data retrieval from tables, combining rows from tables using inner, outer, cross, and self joins, deploying operators such as ‘intersect,’ ‘except,’ ‘union,’ temporary table creation, set operator rules, table variables, etc.

Download Brochure

Understanding SQL functions – what do they do?, scalar functions, aggregate functions, functions that can be used on different datasets, such as numbers, characters, strings, and dates, inline SQL functions, general functions, and duplicate functions.

Download Brochure

Understanding SQL subqueries, their rules; statements and operators with which subqueries can be used, using the set clause to modify subqueries, understanding different types of subqueries, such as where, select, insert, update, delete, etc., and methods to create and view subqueries.

Download Brochure

Learning SQL views, methods of creating, using, altering, renaming, dropping, and modifying views; understanding stored procedures and their key benefits, working with stored procedures, studying user-defined functions, and error handling.

Download Brochure

User-defined functions; types of UDFs, such as scalar, inline table value, multi-statement table, stored procedures and when to deploy them, what is rank function?, triggers, and when to execute triggers?

Download Brochure

SQL Server Management Studio, using pivot in MS Excel and MS SQL Server, differentiating between Char, Varchar, and NVarchar, XL path, indexes and their creation, records grouping, advantages, searching, sorting, modifying data; clustered indexes creation, use of indexes to cover queries, common table expressions, and index guidelines.

Download Brochure

Creating Transact-SQL queries, querying multiple tables using joins, implementing functions and aggregating data, modifying data, determining the results of DDL statements on supplied tables and data, and constructing DML statements using the output statement.

Download Brochure

Querying data using subqueries and APPLY, querying data using table expressions, grouping and pivoting data using queries, querying temporal data and non-relational data, constructing recursive table expressions to meet business requirements, and using windowing functions to group and rank the results of a query.

Download Brochure

Creating database programmability objects by using T-SQL, implementing error handling and transactions, implementing transaction control in conjunction with error handling in stored procedures, and implementing data types and NULL.

Download Brochure

Designing and implementing relational database schema; designing and implementing indexes, learning to compare between indexed and included columns, implementing clustered index, and designing and deploying views and column store views.

Download Brochure

Explaining foreign key constraints, using T-SQL statements, usage of Data Manipulation Language (DML), designing the components of stored procedures, implementing input and output parameters, applying error handling, executing control logic in stored procedures, and designing trigger logic, DDL triggers, etc.

Download Brochure

Applying transactions, using the transaction behavior to identify DML statements, learning about implicit and explicit transactions, isolation levels management, understanding concurrency and locking behavior, and using memory-optimized tables.

Download Brochure

Accuracy of statistics, formulating statistics maintenance tasks, dynamic management objects management, identifying missing indexes, examining and troubleshooting query plans, consolidating the overlapping indexes, the performance management of database instances, and SQL server performance monitoring.

Download Brochure

Corelated Subquery, Grouping Sets, Rollup, Cube

Hands-on Exercise

Implementing Corelated Subqueries, Using EXISTS with a Correlated subquery, Using Union Query, Using Grouping Set Query, Using Rollup, Using CUBE to generate four grouping sets, Perform a partial CUBE.

Download Brochure
  • Performance Tuning and Optimizing SQL Databases
  • Querying Data with Transact-SQL
Download Brochure

MS SQL Server DBA Course Content

  • Plan Installation

Evaluate installation requirements; design the installation of SQL Server and its components (drives, service accounts, etc.); plan scale-up vs. scale-out basics; plan for capacity, including if/when to shrink, grow, autogrow, and monitor growth; manage the technologies that influence SQL architecture (e.g., service broker, full text, scale out, etc.); design the storage for new databases (drives, filegroups, partitioning, etc.); design the database infrastructure; configure an SQL Server standby database for reporting purposes; Windows-level security and service-level security; core mode installation; benchmark a server before using it in a production environment (SQLIO, Tests on SQL Instance, etc.); and choose the right hardware

  • Installing SQL Server and Related Services

Test connectivity; enable and disable features; install SQL Server database engine and SSIS (but not SSRS and SSAS); and configure an OS disk

  • Implementing a Migration Strategy

Restore vs. detach/attach; migrate security; migrate from a previous version; migrate to new hardware; and migrate systems and data from other sources

  • Configuring Additional SQL Server Components

Set up and configure all SQL Server components (Engine, AS, RS, and SharePoint integration) in a complex and highly secure environment; configure full-text indexing; SSIS security; filestream; and filetable

  • Manage SQL Server Agent

Create, maintain, and monitor jobs; administer jobs and alerts; automate (setup, maintenance, monitoring) across multiple databases and multiple instances; send to “Manage SQL Server Agent jobs”

Download Brochure
  • Managing and Configuring Databases

Design multiple file groups; database configuration and standardization: autoclose, autoshrink, recovery models; manage file space, including adding new filegroups and moving objects from one filegroup to another; implement and configure contained databases; data compression; configure TDE; partitioning; manage log file growth; DBCC

  • Configuring SQL Server Instances

Configure and standardize a database: autoclose, autoshrink, recovery models; install default and named instances; configure SQL to use only certain CPUs (affinity masks, etc.); configure server level settings; configure many databases/instance, many instances/server, virtualization; configure clustered instances including MSDTC; memory allocation; database mail; configure SQL Server engine: memory, filffactor, sp_configure, default options

  • Implementing an SQL Server Clustered Instance

Install a cluster; manage multiple instances on a cluster; set up subnet clustering; recover from a failed cluster node

  • Managing SQL Server Instances

Install an instance; manage interaction of instances; SQL patch management; install additional instances; manage resource utilization by using Resource Governor; cycle error logs

Download Brochure
  • Identifying and Resolving Concurrency Problems

Examine deadlocking issues using the SQL server logs using trace flags; design reporting database infrastructure (replicated databases); monitor via DMV or other MS product; diagnose blocking, live locking and deadlocking; diagnose waits; performance detection with built in DMVs; know what affects performance; and locate and if necessary kill processes that are blocking or claiming all resources

  • Collecting, Analyzing, and Troubleshooting Data

Monitor using Profiler; collect performance data by using System Monitor; collect trace data by using SQL Server Profiler; identify transactional replication problems; identify and troubleshoot data access problems; gather performance metrics; identify potential problems before they cause service interruptions; identify performance problems;, use XEvents and DMVs; create alerts on critical server condition; monitor data and server access by creating audit and other controls; identify IO vs. memory vs. CPU bottlenecks; and use the Data Collector tool

  • Auditing SQL Server Instances

Implement a security strategy for auditing and controlling the instance; configure an audit; configure server audits; track who modified an object; monitor elevated privileges as well as unsolicited attempts to connect; and policy-based management

Download Brochure
  • Configuring and Maintaining a Back-up Strategy

Manage different backup models, including point-in-time recovery; protect customer data even if backup media is lost; perform backup/restore based on proper strategies including backup redundancy; recover from a corrupted drive; manage a multi-TB database; implement and test a database implementation and a backup strategy (multiple files for user database and tempdb, spreading database files, backup/restore); back up a SQL Server environment; and back up system databases

  • Restoring Databases

Restore a database secured with TDE; recover data from a damaged DB (several errors in DBCC checkdb); restore to a point in time; file group restore; and page-level restore

  • Implementing and Maintaining Indexes

Inspect physical characteristics of indexes and perform index maintenance; identify fragmented indexes; identify unused indexes; implement indexes; defrag/rebuild indexes; set up a maintenance strategy for indexes and statistics; optimize indexes (full, filter index); statistics (full, filter) force or fix queue; when to rebuild vs. reorg and index; full text indexes; and column store indexes

  • Importing and Exporting Data

Transfer data; bulk copy; and bulk insert

Download Brochure
  • Managing Logins and Server Roles

Configure server security; secure the SQL Server using Windows Account / SQL Server accounts, server roles; create log in accounts; manage access to the server, SQL Server instance, and databases; create and maintain user-defined server roles; and manage certificate logins

  • Managing Database Security

Configure database security; database level, permissions; protect objects from being modified; auditing; and encryption

  • Managing Users and Database Roles

Create access to server / database with least privilege; manage security roles for users and administrators; create database user accounts; and contained login

  • Troubleshooting Security

Manage certificates and keys, and endpoints

Download Brochure
  • Implementing AlwaysOn
    • Implement AlwaysOn availability groups and AlwaysOn failover clustering
  • Implementing replication
    • Troubleshoot replication problems and identify appropriate replication strategy
Download Brochure
View More

Database Architect Projects

Peer Learning

Via Intellipaat PeerChat, you can interact with your peers across all classes and batches and even our alumni. Collaborate on projects, share job referrals & interview experiences, compete with the best, make new friends — the possibilities are endless and our community has something for everyone!

class-notifications
Hackathons
career-services
major-announcements
collaborative-learning

Database Architect Certification

certificateimage Click to Zoom

This course is designed for clearing two certification exams.

  • Oracle PL/SQL Developer Certified Associate
  • Oracle Database Administrator Certified Associate
  • Microsoft 70-761 and 70-762 SQL Server Certification Exam
  • Microsoft Certified Database Administrator (MCDBA) Exam

The entire course content is in line with these certification exams and helps you clear them with ease and get the best jobs in top MNCs.

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast track your career effortlessly.

At the end of this training program, there will be quizzes that perfectly reflect the type of questions asked in the respective certification exams and help you score better marks.

Intellipaat Course Completion Certification will be awarded upon the completion of the project work (after expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.

Database Architect Reviews

( 512 )

Our Alumni Works At

Master Client Desktop

Frequently Asked Questions on Database Architect

Why should I learn Database Architect from Intellipaat?

Intellipaat offers a comprehensive Database Architect training. This is an industry-designed training course that includes Oracle Pl/SQL, DBA, data warehousing and data modeling, among other things. You will gain proficiency in database administration and SQL development. The entire course is in line with clearing two certifications such as Oracle PL/SQL Developer Certified Associate and Oracle Database Administrator Certified Associate.

You will be working on real-time projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fees. Hence, it is clearly a one-time investment.

Intellipaat offers training on SQL Certification Course, PL SQL, SQL Server DBA, Oracle DBA, Oracle RAC, and SQL Developer DBA Masters Program in the Database domain.

3 technical 1:1 sessions per month will be allowed.

Intellipaat is offering 24/7 query resolution, and you can raise a ticket with the dedicated support team at any time. You can avail of email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, 1:1 session support is provided for a period of 6 months from the start date of your course.

Intellipaat provides placement assistance to all learners who have successfully completed the training and moved to the placement pool after clearing the PRT( Placement Readiness Test) More than 500+ top MNC’s and startups hire Intellipaat learners. Our Alumni works with Google, Microsoft, Amazon, Sony, Ericsson, TCS, Mu Sigma, etc.

Apparently, no. Our job assistance is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final decision on hiring will always be based on your performance in the interview and the requirements of the recruiter.

View More