Oracle DBA Workshop-I

Duration: 2 days

Course Objective :

This Oracle Database 11g: Administration Workshop I course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

  • Install Oracle Grid Infrastructure 
  • Install and configure Oracle Database 11g 
  • Configure Oracle Net services 
  • Monitor and administer undo data 
  • Manage the database storage structures 
  • Create and administer user accounts 
  • Perform basic backup and recovery of a database 
  • Manage data concurrency 
  • Monitor performance 
  • Describe Oracle Database Architecture

Target Audience :

This course is designed to cater to a broad range of participants who want to establish a strong foundation in SQL within the SQL Server ecosystem.

  • Beginners with No Database Experience
  • Database Beginners with SQL Server Exposure
  • Database Administrators (DBAs)
  • Data Analysts
  • Developers
  • IT Professionals and System Administrators
  • Business Professionals
  • Students and Enthusiasts
  • Career Changers
  • Small Business Owners

Pre – Requisites :

It assumes little to no prior knowledge of databases or SQL, making it accessible to beginners. However, it can also serve as a refresher for those with some prior exposure to SQL Server. The course’s content and pace should be tailored to the specific needs and background of the target audience.

Course Outline :

Introduction to SQL Server

  • Overview of Microsoft SQL Server and its editions.
  • Understanding relational databases and the role of SQL in managing data.

Getting Started with SQL Server Management Studio (SSMS)

  • Introduction to the SQL Server Management Studio (SSMS) interface.
  • Connecting to SQL Server instances.
  • Writing and executing basic SQL queries.

Basic SQL Queries

  • Writing simple SELECT statements to retrieve data from tables.
  • Sorting and filtering data using the WHERE and ORDER BY clauses.
  • Using the DISTINCT keyword to retrieve unique values.
  • Handling NULL values.

Data Modification

  • Inserting new data into tables using the INSERT statement.
  • Updating and deleting records with the UPDATE and DELETE statements.
  • Understanding transactions and their importance in data integrity.

Working with Tables

  • Creating tables with appropriate data types and constraints.
  • Modifying table structures with the ALTER TABLE statement.
  • Deleting tables using the DROP TABLE statement.

Joining Tables

  • Understanding the concept of joins.
  • Performing inner joins, left joins, right joins, and full outer joins.
  • Using aliases to simplify queries.

Aggregating Data

  • Grouping data with the GROUP BY clause.
  • Applying aggregate functions (e.g., SUM, AVG, COUNT) to grouped data.
  • Filtering grouped data using the HAVING clause.

Subqueries and Derived Tables

  • Working with subqueries in SELECT, WHERE, and FROM clauses.
  • Using correlated subqueries.
  • Introduction to common table expressions (CTEs).

Views and Indexes

  • Creating and managing views for data abstraction.
  • Understanding indexes and their impact on query performance.

Introduction to Stored Procedures and Functions

  • Overview of stored procedures and user-defined functions.
  • Creating and executing basic stored procedures.
  • Writing simple scalar functions.

Security and Permissions

  • Managing security through logins and users.
  • Assigning permissions and roles.
  • Implementing basic security best practices.