Career Path - Database Administrator
Learn Database Administration from the scratchPreview Career Path - Database Administrator course
Price Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate52% Started a new career BUY THIS COURSE (
USD 45 USD 139 )-
69% Got a pay increase and promotion
Students also bought -
-
- SQL Programming with MySQL Database
- 8 Hours
- USD 17
- 4562 Learners
-
- Oracle DBA
- 10 Hours
- USD 17
- 478 Learners
-
- Oracle Multitenant DBA
- 10 Hours
- USD 17
- 22 Learners

Courses included in the Database Administrator Career Path program
1) Oracle DBA
2) Oracle Multitenant DBA
3) SQL Programming with MYSQL Database
4) SAS Admin
5) SAP HANA Admin
Who is Database Administrator
Database administrators (DBAs) are primarily responsible for specific databases in the subsystem. In some companies, DBAs are given the special group authorization, SYSADM, which gives them the ability to do almost everything in the database subsystem and gives them jurisdiction over all the databases in the subsystem.
The DBA creates the hierarchy of data objects, beginning with the database, then tablespaces, tables, and any indexes or views that are required. This person also sets up referential integrity definitions and any necessary constraints. The centralization of data and control of access to this data is inherent to a database management system. One of the advantages of this centralization is the availability of consistent data to more than one application. As a consequence, this dictates tighter control of that data and its usage.
Roles & Responsibilities of a Database Administrator
Deciding the hardware device - Depending upon the cost, performance and efficiency of the hardware, it is DBA who has the duty of deciding which hardware device will suit the company requirement. It is hardware that is an interface between end-users and database so it needed to be of the best quality.
Managing Data Integrity - Data integrity should be managed accurately because it protects the data from unauthorized use. DBA manages the relationship between the data to maintain data consistency.
Tuning Database Performance - Database performance plays an important role in any business. If the user is not able to fetch data speedily then it may loss company business. So by tuning a modifying SQL commands a DBA can improve the performance of database.
Database Design - The logical design of the database is designed by the DBA. Also a DBA is responsible for physical design, external model design, and integrity control.
Monitoring Performance - If the database is working properly then it doesn’t mean that there is no task for the DBA. Yes f course, he has to monitor the performance of the database. A DBA monitors the CPU and memory usage.
Decides validation checks on data - DBA has to decide which data should be used and what kind of data is accurate for the company. So he always puts validation checks on data to make it more accurate and consistence.
Uplatz provides this end-to-end training on Database Administrator Career Path to make you well-versed with the leading tools & technologies in this area and to help you become a successful DBA.
Course/Topic 1 - Oracle 21c DBA - all lectures
-
Episode 1 - Installation of Oracle Linux 8 on Oracle VM
-
Episode 2 - Introduction to Oracle 21c Database
-
Episode 3 - Oracle 21c Architecture
-
Episode 4 - Practice 1 - Creating a CDB
-
Episode 5 - Practice 2 - Creating PDBs from the Seed
-
Episode 6 - Practice 3 - Performing Basic CDB Administration Tasks
-
Episode 7 - Practice 4 - Managing Common and Local Users
-
Episode 8 - Practice 5 - Backup and Recovery in CDB and PDBs
-
Episode 9 - Practice 6 - Flashback and Point-in-time Recovery
Course/Topic 2 - Oracle DBA - all lectures
-
This video comprehends the terms Oracle Database which is an object-relational database management system developed and marketed by Oracle Corporation. Oracle Database is commonly referred to as Oracle RDBMS or simply Oracle.
-
This topic will cover, DBCA which can create Standby Databases directly, but with some restrictions, like only for Single Instance Databases and only non-container Databases.
-
In this tutorial, you will learn how to use the Oracle create user statement to create a new user in the Oracle database. The create user statement allows you to create a new database user which you can use to log in to the Oracle database.
-
In this video you will learn about the an Oracle database which is made up of physical and logical structures. Physical structures can be seen and operated on from the operating system, such as the physical files that store data on a disk.
-
In this tutorial you will know about the Oracle Database creates and manages information that is used to roll back, or undo, changes to the database. Such information consists of records of the actions of transactions, primarily before they are committed. These records are collectively referred to as undo.
-
In this video you will learn about the Oracle Flashback Technology which is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.
-
In this tutorial you will learn about the installing Oracle Database, which is a fully functional database with a client/server network environment that has been minimally configured. This chapter helps you configure your server network.
-
In this tutorial we will learn about the Locking which protect table when several users are accessing the same table. Locking is a concurrency control technique in oracle. It helps in data integrity while allowing maximum concurrency access to data. Oracle offers automatic locking whenever situation requires.
-
In this video tutorial you will learn about the Auditing which is the monitoring and recording of configured database actions, from both database users and non-data base users.
-
In this session you will learn about the Oracle Data Pump technology which enables very high-speed movement of data and metadata from one database to another.
-
This tutorial teaches you about the Backup and recovery procedures which protect your database against data loss and reconstruct the data, should loss occur. The reconstructing of data is achieved through media recovery, which refers to the various operations involved in restoring, rolling forward, and rolling back a backup of database files.
-
In this video you will learn about the backup recovery scheme which you devise for an Oracle database, operating system backups of the database's datafiles and control files are absolutely necessary as part of the strategy to safeguard against potential media failures that can damage these files.
-
This tutorial teaches you the Recovery processes which are dependent on the type of failure that occurred, the structures affected, and the type of recovery that you perform. If no files are lost or damaged, recovery may amount to no more than restarting an instance. If data has been lost, recovery requires additional steps.
-
This session teaches you the Recovery Manager (RMAN which is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files.
-
In this video you will learn about the Oracle offers which is a wide range of migration services to help you optimize your usage of Oracle technology. Through the use of tools, resources, and proven best practices, Oracle can provide support for migrating from legacy or non-Oracle technologies to Oracle.
Course/Topic 3 - Oracle Multitenant DBA - all lectures
-
In this tutorial you will provides an overview of the Oracle Database DBA from which you will get to know about the multitenant which represents one of the biggest architectural changes in the history of the Oracle database.
-
This video describes step by step process of setting up Oracle Linux 7.8 in Oracle VirtualBox. This is the exactly same method we use every-time when we have to create a VM and practice Oracle.
-
In this video we will show you how to properly install Oracle Database 19c software. Just to make the installation less complex and easy to understand we create simple sections.
-
This tutorial shows you how to create the Container Database (CDB) and non-container database with a typical configuration. You can also create a non-CDB either automatically or manually. Oracle suggest that you can use the automatic creation procedure outlined in creating a Database automatically.
-
In this video you will know to about CREATE PLUGGABLE DATABASE statement to create a new PDB by using the files of the PDB seed or an application PDB from the files of an application seed or the PDB seed.The statement copies these files to a new location and associates them with the new PDB. The following figure illustrates how this technique creates a new PDB in a CDB with the CDB root as the current container.
-
As an Oracle database administrator (DBA), you can expect to be involved in the following tasks such as Installing Oracle software, Creating Oracle databases, Performing upgrades of the database and software to new release levels, Starting and shutting down the database instance, Managing the storage structures of the database and many more.
-
In this video you will learn how to Creating a PDB by Cloning from Local and Remote PDBs and how to use them.
-
In this session, Create and define a destination for the new data files, plug the unplugged PDB into the CDB, and then copy the data files of the unplugged PDB. Use the data files of the unplugged PDB to plug the PDB into the CDB and copy the data files to a new location.
-
In this video, you need to convert a non-CDB database into a CDB pluggable database. This video describes methods that you can use to convert a non-CDB database into a CDB database.
-
To Connect to the local database to initiate the relocate. Check the local CDB is in local undo mode and archive log mode. Create a public database link in the local CDB, pointing to the remote CDB. Remember to remove this once the relocate is complete.
-
A Common user is a user which have the same username and password authentication across of PDBs of CDB. Common users and Local users: This concept came with Oracle Database 12c. Common Users.
-
A backup of the root container is a backup of the CDB, excluding any of the PDBs. Connect to RMAN using OS authentication and backup the root container using the command in this video.
-
Oracle Flashback Database gives a more efficient direct alternative to database point-in-time recovery. It is unlike the other flashback features in that it operates at a physical level. When you use Flashback Database, your current datafiles revert to their contents at a past time.
-
In this video, you can use PL/SQL package procedures to administer Oracle Resource Manager (Resource Manager) to allocate resources to pluggable databases (PDBs) in a multitenant container database (CDB).
-
A PDB is a portable set of schemas, schema objects, and non-schema objects that appear to an Oracle Net client as a non-CDB. A multitenant container database (CDB) is an Oracle database that includes zero, one, or many user-created pluggable databases (PDBs).
-
In this last video You can learn the administer application containers, including application roots and application PDBs. You can also administer the applications installed in application containers.
Course/Topic 4 - Oracle PL/SQL - all lectures
-
Overview of PL/SQL
-
Declaring PL/SQL Variables
-
Writing Executable Statements
-
Interacting with Oracle DB Server
-
Writing Control Structure
-
Working with Composite Data Types
-
Using Explicit Cursors
-
Handling Exceptions
-
Creating Procedures
-
Creating Functions
-
Creating Packages
-
Working with Packages
-
Using Oracle-supplied Packages in Application Development
-
Using Dynamic SQL
-
Design considerations for PL/SQL Code
-
Creating Triggers - Creating Compound, DDL, and Event Database Triggers
-
Using PL/SQL Compiler
-
Managing PL/SQL Code
-
Managing Dependencies
Course/Topic 5 - SAS Admin - all lectures
-
In this lecture session we learn about SAS admin and also talk about features of SAS ADMIN.
-
In this lecture session we learn about exploring the client tier in SAS admin and also talk about platform administration.
-
In this lecture session we learn about the Data Integration (DI) Studio in SAS admin and also talk about features of integration studio.
-
In this lecture session we learn prompt value specification in SAS admin and also talk about features of specification.
-
In this lecture session we learn about SAS admin stored procedures and also talk about the function of stored procedures.
-
In this lecture session we learn about overview of SMC and also talk about function of SMC in SAS admin.
-
In this lecture session we learn about server console script and also talk about window service (Jboss only).
-
In this lecture session we learn about metadata server configuration files and also talk about features of metadata server configuration files.
-
In this lecture session we learn about monitoring SAS servers and spawners and also talk about features of SAS server and spawners.
-
In this lecture session we learn application & service logs in SAS and also talk about diagnostic levels in brief.
-
In this lecture session we learn about troubleshooting SAS server and also talk about features of objectives.
-
In this lecture session we learn about SAS management console in SAS admin and also talk about features solutions to exercise.
-
In this lecture session we learn about scheduling backups and also talk about features of scheduling backups.
-
In this lecture session we learn about connection profiles in SAS admin and also talk about features of connection profile.
-
In this lecture session we learn about defining regular users and groups and also talk about features of SAS admin.
-
In this lecture session we learn about registering libraries and tables in the SAS metadata.
-
In this lecture session we learn about introduction to metadata security in SAS admin and also talk about features of metadata security.
-
In this lecture session we learn about SAS environment configurations and also talk about features of updating the SAS environment.
-
In this lecture session we learn about create operating systems users and groups and designate ports.
Course/Topic 6 - SAP HANA Admin - all lectures
-
In this first video on SAP HANA Admin tutorial, you will get a brief introduction to what is SAP HANA, what is HANA database, how HANA overcomes the daily irritations like the sub-optimal execution speed, lack of transparency, reactivate business model, how HANA database is much more useful than the normal database and many more. You will also learn about the SAP HANA deployment view, the component Architecture view, the HANA individual components, a pictorial diagram showing the example of Deployment Landscape, and many more.
-
This video is about the installation of SAP HANA, starting with the SAP HANA Sizing, Main Memory Sizing, Disk Sizing, CPU Sizing, what is SAP Quicksizer, what are the requirements for the SAP HANA Single-Host and Multi-Host Database System, the basic components of the SAP HANA system, the installation of single and multiple-SID and lastly the Operating System and Hardware Requirements. Further, you will be learning about the important directories and their sizes and finally the File System Structure for a Multi-SID Installation.
-
This video is a tutorial on the SAP HANA appliance and the sizing of the components. You will get a practical demonstration on how to show certified SAP HANA appliance configurations throughout the session.
-
This tutorial will explain to you the various Lifecycle Management tools for installing SAP HANA starting with a brief introduction to SAP HANA Lifecycle Management Tools, explaining various installation methods, how to install SAP HANA as a single-host, installing and configuring SAP HANA Studio, installing the SAP HANA SHINE content and lastly, explaining a multi-host system installation.
-
This session is an exercise on installing your own standalone SAP HANA System. You will be shown the complete process during the session and lastly, how to update the SAP HANA Studio using an Update Site.
-
This session will teach you about the post-installation steps, updating SAP HANA, the revision strategy of SAP HANA and SHINE; SAP HANA Interactive Education. Here the target audience is taken as the System Administrator.
-
In this tutorial, you will learn how to update SAP HANA with a new support package along with installing the SAP HANA Interactive Education (SHINE) content. The complete and step-by-step work process will be shown throughout the session.