Arich Infotech

Database Administration

Database Administration

TopicLearnings
IntroductionWhy database, ACID and BASE properties, E.F. Codd’s Rule, Cardinality, CAP Theorem, Difference between RDBMS and NoSQL database
Database DesignNormalization Rules, ER diagrams
ArchitectureIntroduction to Oracle, Oracle Architecture
Data TypesOracle Data types
SQLCreation and Manipulation of objects using DML, DDL, DCL, TQL & TCL statements Functions (Single Row, Group, Conversion, Analytic) in Oracle, Oracle Constraints, Oracle Views, Sequences, Synonyms, Indexes, Views
SQL ObjectsCreation of Types, Nested Table, Insertion & Retrieving data from Nested Table
PL/SQLCreation of Procedures, Functions, Triggers and Packages in PL/SQL
DBA OverviewArchitecture Overview, Multi-Tenant Architecture, Instance Parameters, Listener Control Overview, Starting up and shutting down database
DB CreationCreation of Database using DBCA, Creating a CDB, Creating a PDB from Seed, Other Techniques to create a PDB, Opening and Closing a PDB, Managing PDB
NetworkConfiguring Oracle Net Service, Administering Listener, Shared Server Architecture
DBA Account ManagementUser Creation, Granting of Roles, Privileges, User Profile, Auditing, Resource Limits
DBA – Data ManagementStorage Structure, Tablespace, UNDO tablespace management, Improving Space Usage
Backup & RecoveryRMAN, Flashback
Data TransportationExternal Tables, SQL Loader, Data Pump
MaintenanceAutomated Maintenance Tasks,
Performance TuningPerformance Tuning and SQL Optimization, Statspack, using ADDM for Performance Monitoring, Automatic SQL Tuning, SQL Advisor, Real Time DB monitoring, TKPROF
UpgradeSoftware upgrade Methods

    Enquire About Our Courses

    If you have any questions about our courses or need more information, please fill out the form below, and we'll get back to you shortly!