This Program has been designed to give you the necessary skills to excel as Database Administrator (DBA) Database Administrator (DBA) curriculum offers you the opportunity to acquire a combination of both operating system and Database Administration skills, making you more competitive as an employable professional. Given the demand for professionals with these skills, with this program, you are well on your way to a great career to it. DBA program also gives you an ideal opportunity to practice what you have learned through real life case studies. The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. Learn To: ·Create and manage an Oracle Database Instance. ·Create and manage Storage Structures. ·Configure the Oracle Network Environment. ·Create and manage users. ·Monitor the database and manage performance. ·Learn basic information on backup and recovery techniques. ·Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Participate in Hands-On Practices and Demonstrations Expert instruction and hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database. Required Prerequisites: ·Working knowledge of SQL and use of PL/SQL packages ·Basic knowledge of Linux operating system Oracle 12c SQL Workshop 1 [24 Hours] lIntroduction lRetrieving Data using the SQL SELECT Statement lRestricting and Sorting Data lUsing Single-Row Functions to Customize Output lUsing Conversion Functions and Conditional Expressions lReporting Aggregated Data Using the Group Functions lDisplaying Data from Multiple Tables Using Joins lUsing Sub queries to Solve Queries lUsing the SET Operators lManaging Tables using DML statements lIntroduction to Data Definition Language Oracle 12c SQL Workshop 11 [24Hours] lIntroduction lIntroduction to Data Dictionary Views lCreating Sequences, Synonyms, Indexes lCreating Views lManaging Schema Objects lRetrieving Data by Using Sub queries lManipulating Data by Using Sub queries lControlling User Access lManipulating Data lManaging Data in Different Time Zones.