loader image
close slider

Contact US

RDBMS (Relational Database Management System)

Duration

4 Months

Eligibility

BE/BCA/MCA/MSc/BSc/B.Com

Fees

55,500/-

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Most commercial RDBMSes use Structured Query Language (SQL) to access the database, although SQL was invented after the initial development of the relational model and is not necessary for its use.

RDBMS vs. DBMS

In general, databases store sets of data that can be queried for use in other applications. A database management system supports the development, administration and use of database platforms.

An RDBMS is a type of DBMS with a row-based table structure that connects related data elements and includes functions that maintain the security, accuracy, integrity and consistency of the data.

COURSE CONTENT

    • Oracle 11g/12c
      • Oracle database architecture.
      • Writing Sql queries.
      • Installing Oracle databases on Windows/Unix/Linux.
      • Creating tablespaces.
      • ASM.
      • Creating tables.
      • Creating Indexes.
      • Memory tuning.
      • Writing PL/SQL programs (Procedures/Functions/Triggers/Web Services etc).
      • Using OEM.
      • Oracle RAC.
      • Preparation for OCP Database Administrator or OCP Developer 11g/12c.
    • Sql Server 2019 RC
      • SqlServer 2019 RC architecture.
      • Sqlserver Installation on Windows Server.
      • Writing Sql queries.
      • Performing Database Maintenance.
      • Database Storage Options.
      • Managing databases in the Cloud.
      • Preparation for MCDBA (Microsoft Certified Database Administrator) or MCSA (Microsoft Certified Solution Associate).
    • MySql 8.0
      • Starting, Stopping and Configuring MySQL.
      • Security-Related Configuration.
      • MySQL Database Creation.
      • Using Client Programs for MySQL DBA Work.
      • Using Storage Engines, including the MyISAM and InnoDB engines.
      • Table Maintenance.
      • Obtaining Data from the Information_Schema Database.
      • Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport).
      • Using Stored Procedures and Triggers for Database Administration Tasks.
      • User Management.
      • Optimizing Queries.
      • Optimizing Schemas.
      • Optimizing the Server.
      • The Event Scheduler.
      • Partitioned Tables.
      • Interpreting Error Messages.
      • Optimizing the MySQL Environment.
      • Scaling MySQL, including Replication.
      • Preparation for Mysqlserver DBA or Developer Certification.

PROJECTS

  •  Hands on training on UNIX/LINUX for Oracle and Mysql Databases.
  • Hands on training on Windows Servers for Sql Server Database.

ADD-ONS

  • Mock Interview Process for Fortune 500 Companies.
    • Pre – Placement Talk.
    • Educational Qualification.
    • Written Test.
    • HR Interview.
    • Post – Placement Talk.
  • Free Aptitude and Reasoning classes for Campus Recruitment.
  • Technical Interview Preparation.
  • Advance Communication Skill.
  • GD Practice.
  • Help in Resume Writing.
  • Job Assistance.
  • Email Writing.
  • Experience Certificate.
  • Training Certificate.

PARTNER WITH US

We should talk about your project!
E-Mail us at info@theexelligent.com or Call us at +91-6261900209 to get the best answer for all your project needs.
  • ABOUT US

    The Exelligent is a team that, with passion and experience, gives every day the best for your digital vision. We believe in Innovation in everything we deliver.

×