Best Database Administration Courses

Find the best online Database Administration Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Database Administration Courses.

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

Students: 379414, Price:  Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 198265, Price: Free

Students: 198265, Price:  Free

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

Oracle SQL – A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

Created by Ben Brumm - IT Software Consultant

"]

Students: 68457, Price: Free

Students: 68457, Price:  Free

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

Database Engineer/DBA – (MySQL, MongoDB, SQLite)

Practical Database Administration and Engineering Step by Step

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 25403, Price: $89.99

Students: 25403, Price:  Paid

The MySQL is the world's most popular open source database.This course will teach you  a lot to  start using this incredibly popular MySQL database and gain useful skills in the process.  In learning about MySQL you will also gain an understanding of relational databases in general.  Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.

MongoDB is a document-oriented DBMS, with JSON-like  objects comprising the data model, rather  than RDBMS tables. MongoDB does not support joins nor transactions. However, it features  secondary indexes, an expressive query language,atomic writes on a per-document level, and fully-consistent reads. MongoDB uses JSON, a binary object format similar to, but more expressive than JSON.
.
MongoDB uses dynamic schema. We can create collections without defining the structure,i.e. the fields or the types of their values, of the documents. You can change the structure of documents simply by adding new fields or deleting existing ones. Documents in a collection need unique set of fields.

MongoDB database stores its data in collections  not in tables The collections are the rough equivalent of RDBMS tables. 
A collection holds one or more documents, which corresponds to a record or a row in a relational database table, and each document  has one or more fields, which corresponds  to a column in a relational database table.

SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.  SQLite does NOT require a server to run.

Because of the serverless architecture, you don’t need to “install” SQLite before using it. There is no server process that needs to be configured, started, and stopped. SQLite uses dynamic types for tables. It means you can store any value in any column, regardless of the data type.

SQLite is self-contained means it requires minimal support from the operating system or external library. This makes SQLite usable in any environments especially in embedded devices like iPhones, Android phones, game consoles, handheld media players, etc.

SQLite is capable of creating in-memory databases which are very fast to work with.

SQLite database is integrated with the application that accesses the database. The applications interact with the SQLite database read and write directly from the database files stored on disk.

Oracle DBA 11g/12c – Database Administration for Junior DBA

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 24920, Price: $119.99

Students: 24920, Price:  Paid

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA.

'Oracle 11g/12c DBA' course follows a step by step methodology in introducing concepts and Demo's to the students so that they can learn with ease.

If you want to become an Oracle Database Administrator(Oracle DBA), this course is right for you!!!!

Almost in every organization, you will find Database Administrator's (DBA's) to maintain the organization's database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database.

In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g.

Step by Step methodology followed is...

  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  •  Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

Let's start and I will take you step by step to lead your journey into the DBA world!!!

Oracle Database Architecture

Concepts of Oracle Database Architecture

Created by TISYA Software Solutions Private Limited - Technology Learning Services

"]

Students: 15707, Price: Free

Students: 15707, Price:  Free

In this course you will learn about the architectural components of Oracle Database. You will learn about the various Processes , Memory areas, Files that are involved in the Architecture of Oracle Database. This course will help you to get a deep understanding of the fundamentals of Oracle Database Architecture and will lay the foundation for skills on the job as a DBA and also help you in taking up the DBA certification.

Oracle Cloud: Oracle cloud database administration

Become expert on the new features of Oracle cloud Release 2 and have hands on release experience using Oracle Cloud,PBDs

Created by Zulqarnain Hayat - Enterprise Database Architect

"]

Students: 15331, Price: $94.99

Students: 15331, Price:  Paid

After completing this course  you will be become expert on the new features of Oracle 12c Release 2 and have hands on release experience in creating databases using the Oracle Cloud.

1-  How to Create new databases in the Oracle Cloud, start and stop Oracle database using the Oracle Cloud web interface. 

2-  How to Hot clone PBDs without down time, flash back PBDs to a previous point in time, create automatically list partition tables and more.

3-  How to  resources management in oracle 12.2 database

70-462: SQL Server Database Administration (DBA)

Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 15122, Price: $124.99

Students: 15122, Price:  Paid

Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.

Do you want to gain practical experience in Database Administration in SQL Server? Welcome.

In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.

SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.

We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.

We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.

The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.

The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I'll introduce every component as we go on.

No knowledge of T-SQL is required, as I'll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.

The course is recorded on SQL Server 2017, but will also work fully in 2016, 2014 and 2012, and mostly in 2008R2 and 2008.

Oracle Database Administration : Oracle Express Edition 18c

Step by step instructions for Installation, Configuration & Administration of Oracle Express Edition 18c Database

Created by Wysheid Learning Portal - Place for quality training experience

"]

Students: 11436, Price: $19.99

Students: 11436, Price:  Paid

Oracle Express Edition ( Oracle XE)  is the free version of Oracle RDBMS Software. In this course, We, Wysheid, will teach you how to administrate Oracle XE Database. We designed the course for the beginners, and no prior knowledge on Oracle is necessary.

After the completion of the course, you will learn the following.

1) Configure the Linux OS for Oracle RDBMS Software installation

2) Installation of Oracle Database pre-install rpm

3) Installation of Oracle Express Edition 18c Installation

4) Creating Oracle Express Edition 18c ( Oracle XE)  Database

5) Setting up the operating system variables for database connection

6) Connecting to the database using Oracle Networking

7) Start and stop of the XE database.

8) Taking the backup of Oracle XE Database.

This course is for :

Anyone who wants to build the career as Oracle Database Administrator

Microsoft SQL Server 2014 Database Administration

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

Created by Tarang B. Patel - Web Developer and CEO at ValsadMarket

"]

Students: 9304, Price: Free

Students: 9304, Price:  Free

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.

  • General knowledge of what a Database is.

  • Different versions of SQL Server 2014

  • How to install SQL Server Express 2014

  • Create a database in SQL Server

  • Create tables in SQL Server

  • Add data into tables in SQL Server

  • Set foreign key relationships between tables

  • Delete data from tables

  • Update data in tables.

  • backup and restore database

MySQL Database Administration: Beginner SQL Database Design

Learn Database Design with MySQL Workbench. SQL DBA for Beginners: A Relational Database Management System Introduction.

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 6911, Price: $109.99

Students: 6911, Price:  Paid

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

If you’re looking to develop practical, real-world analytics and BI skills, and learn how to create and maintain databases, you’ve come to the right place.

This course is unlike anything you’ve seen before, guaranteed. We'll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.

You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you’ll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    For students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Creating, Altering, and Deleting Schemas & Tables

    In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).

  • Inserting, Updating, and Deleting Records

    After we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed.

  • Database Design

    Now that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models.


    ***MID-COURSE PROJECT:
    Normalize this database for your client! 

  • Advanced Concepts
    In this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff! 

  • Server & User Management
    In our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA.

    ***FINAL COURSE PROJECT: Design and build an entire database from scratch! 

IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

______________________________

Enroll today and get LIFETIME access to:

  • 7 hours of high-quality video

  • Downloadable MySQL ebook and cheat sheets

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you!

Happy administering!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Oracle Database Administration Workshop ( 12c and Higher)

Very helpful course for exam 1Z0-072 or 1Z0-082 ,more than 27 Hours that Prepare You to be a good DBA

Created by Khaled Alkhudari - Sr Oracle Developer/ Sr system analyst

"]

Students: 6284, Price: $109.99

Students: 6284, Price:  Paid

This Course is one of the best courses ever in Oracle Administration (12c, 18c, 19c ).

Be ready to become very good Oracle DBA after finishing this course .

The course is more than 27 Hours of HD videos.

Very helpful course for exam 1Z0-072 or 1Z0-082.

All the presentations , PDFS and scripts are available for download.

my courses are the best seller and the highest rated in udemy, i do not create content that you find it easily in free websites and YouTube.

The course start from zero knowledge in Oracle Administration , but remember that SQL is a must.

simply this course is the best.

PostgreSQL Database Administration (DBA) for Beginners

Learn Practical Database Administration

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 5235, Price: $94.99

Students: 5235, Price:  Paid

PostgreSQL is commonly known as Postgres and it is also  open source database.

PostgreSQL is a powerful, open source object-relational database system.

A database administrator’s (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.

The PostgreSQL administration covers some of  the most important PostgreSQL database server administration activities.

Some of the Key Responsibilities of a Database Administrator includes:

  • Database Management

  • Database Backup and restore

  • Tablespace management

  • Role Management

  • Managing users

  • Securing database via proper role management

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database.

In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.

 The course also covers the basics of creating tables, storing data with data types, and working with expressions,  operators, and strings.

Topics also includes:

  • Installing PostgreSQL

  • Loading sample database

  • Creating database and tables

  • Performing CRUD operations

  • Joining Tables

  • Using aggregate and analytic functions

  • Creating views and triggers

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

PostgreSQL v12 Database Administration on Windows and Linux

Comprehensive Guide to PostgreSQL v12 Database Administration : Walk-in a Beginner, Walk-Out an Expert

Created by Sadiq Basha - Senior Production Database Administrator

"]

Students: 2983, Price: $34.99

Students: 2983, Price:  Paid

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

  • PostgreSQL Process and Memory Architecture

  • Installation of PostgreSQL v12 - Windows and Linux

  • Setup PostgreSQL v12 Environment Variables - Windows and Linux

  • PostgreSQL Page Layout

  • Database Directory Layout

  • PostgreSQL Configuration Files

  • Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)

  • Createdb/Dropdb, Createuser/Dropuser Utility

  • Create Schema and Schema Search Path

  • Psql Interface Commands

  • Pg System Catalogs

  • Working with PostgreSQL Objects

  • CRUD Operations

  • Table Inheritance

  • Table Partitioning

  • Tablespace in PostgreSQL

  • Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)

  • Explain plan and Query Execution Cost

  • Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)

  • Data Fragmentation

  • Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon

  • Pgadmin 4

  • Uninstall PostgreSQL v12 on Windows and Linux

  • Bonus Module

Oracle Database: Oracle 12C R2 RAC Administration

Learn Oracle Database, 12C R2 RAC Administration and become a RAC expert with Oracle DBA `s favourite online RAC course

Created by Oak Academy - Web & Mobile Development, IOS, Android, Ethical Hacking, IT

"]

Students: 2571, Price: $94.99

Students: 2571, Price:  Paid

Hello there,

Welcome to "Oracle RAC: Oracle Database 12C R2 RAC Administration" online course.

  • Are you a junior Oracle DBA?

  • Are you DBA who is managing other RDBMS and want to immigrate to Oracle?  or

  • Do you want to become an Oracle DBA at an international company?

If you think so, you are at the right place.

This time I’ve designed for you "Oracle RAC: Oracle Database 12C R2 RAC Administration” straight-forward course for the Oracle Database 12C Release 2 (12.2). In the course, you will have a down-to-earth way explanations with hands-on examples. With my course, you will learn Oracle RAC step-by-step. I made RAC simple and easy with real-life examples.

This course is expertly designed to teach everyone from complete beginners, right through to professionals ( as a refresher). 

In this course you will learn;

  • What is RAC ( Real Application Cluster )

  • Installing Oracle Virtualbox

  • Setting Up Oracle Enterprise Linux

  • Installing Oracle Software

  • Oracle RAC

  • Creating Virtual Machines

  • Installing Oracle RAC Database to VMs

  • Installing Grid Infrastructure, Database Software and Creating Database

  • Administer Database Instances and Cluster Databases

  • Oracle RAC One Node

  • How to Convert RAC Database to RAC One Node

  • Workload Management

  • Monitoring Performance

  • Design and Deployment Techniques

  • Cloning Oracle RAC

  • Managing backup, and restoring cluster database

  • Add and Delete Node From Cluster

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers expertise.

This course will take you from a beginner to a more experienced level.

If you are a DBA or familiar to the Oracle Database / Oracle SQL or if you want to become an Oracle DBA at an international company or

you are a DBA that manage other RDBMS and want to immigrate Oracle or you are already in the field and active RAC user but you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Fresh Content

Oracle RAC is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. But DBAs also should aware of the recent development and it’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends.

Video and Audio Production Quality

All our content is created/produced as high-quality video/audio to provide you the best learning experience.

You will be,

· Seeing clearly

· Hearing clearly

· Moving through the course without distractions

You'll also get:

  • Lifetime Access to The Course

  • Fast & Friendly Support in the Q&A section

  • Udemy Certificate of Completion Ready for Download

Dive in now!

We offer full support, answering any questions.

See you in the course!

Oracle Database RAC Administration (12c and 19c)

An extensive course that develops your skills to be professional on managing Oracle RAC databases (12c and 19c)

Created by Ahmed Baraka - Snr. Database Administrator

"]

Students: 2536, Price: $39.99

Students: 2536, Price:  Paid

Learn how to build and manage Oracle RAC databases (including releases 12c and 19c) of types: administrator-managed, policy-managed, CDB and RAC One node.

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them. 

  • Describe Oracle RAC database architecture   

  • Install and create Oracle 12c and 19c RAC database   

  • Perform the administration tasks on Oracle RAC   

  • Manage backup and recovery in Oracle RAC   

  • Monitor and tune Oracle RAC databases   

  • Manage dynamic database services   

  • Implement load balancing, TAF, FAN,and application continuity     

  • Apply patch sets on Oracle RAC   

  • Upgrade Oracle RAC   

  • Create and manage the following:   

    • Oracle RAC One Node databases   

    • Oracle RAC CDB databases   

    • Oracle Policy-managed RAC databases   

  • Describe Oracle Flex Cluster

  • Remove and Add a node to an Oracle cluster

     

Content and Overview 

Information presented in this course provides Oracle Database Administrators the knowledge  and experience to manage Oracle 12c and 19c RAC databases, including administrator-managed, policy-managed, CDB and RAC One node databases.

Through this extensive course of good 58 lectures and more than 18 hours of video-based sessions, you’ll learn all of the managing Oracle 12c RAC databases. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing the Oracle RAC Architecture, this course will take you all the away from creating Oracle 12c and 19c two-node RAC databases on a Linux platform of any type: administrator-managed, policy-managed, and CDB, performing administration tasks on Oracle RAC databases, managing backup and recovery in Oracle RAC, managing dynamic database services, implementing load balancing, TAF, FAN, and application continuity, applying patch sets on Oracle RA, upgrading Oracle RAC, and understanding Oracle Flex Cluster.

This is an opportunity for the students to gain practical experience on this Oracle cutting-edge technology without the need for complex hardware components.

Upon completing this course, you will be able to build up an Oracle 12c and 19c RAC database and have the knowledge and experience to manage it.

Join the author in this learning journey to experience this amazing technology!

Oracle Database Data Guard Administration (12c and 19c)

Take your Oracle DBA knowledge and experience to the next level and become a professional on Data Guard administration

Created by Ahmed Baraka - Snr. Database Administrator

"]

Students: 2200, Price: $34.99

Students: 2200, Price:  Paid

Learn all about administering Oracle Data Guard (12c and 19c) environments. You will gain hands-on experience on performing all the fundamental administration tasks a DBA may need to manage a Data Guard environment.

The course is built-up of lectures that describe the concepts of a subject and practice lectures that allow you to practically implement what you have learnt in the concepts lecture. They are all demonstrated by videos and supported with downloadable files, such as scripts and code examples. The practice lectures do not leave you implement the exercises alone, they are all accompanied with demonstration videos.

If your target is learning all about the fundamental Oracle Data Guard administration with concentration on the practical side, then you are in the right place.

Advanced SQL Database Administration with MySQL Workbench

Master SQL database design & advanced database management systems to build and maintain databases w/ real-world projects

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 1889, Price: $129.99

Students: 1889, Price:  Paid

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you'll take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security.

We'll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we'll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events.

Throughout the course, you'll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    For students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Importing Data to the Database

    We'll quickly review some basic concepts like creating, inserting, and deleting records. Then we'll learn how to tackle large data imports with ease, using the table data import wizard. We'll be using this handy tool throughout the course. You will construct and populate a database from the ground up as the business grows, just like a real DBA as part of the course project.

  • Altering, Updating & Mapping Keys

    We'll briefly review critical concepts like altering tables and updating records, discuss the ins and outs of primary and foreign keys, and from there you'll jump right into your assignments and quizzes for this section.

  • Replication, Backup & Recovery

    Here we'll introduce the critical DBA concepts of replication, backup and recovery. We'll discuss the various benefits of replication, different methods of backing up your databases, and you'll learn how to restore your data should the need arise. This is getting into some pretty serious stuff! 

    ***MID-COURSE PROJECT
    You will need all of the skills you've learned so far to complete this hands on mid-course project. You'll help your CEO by enhancing the data structure to accommodate changing business needs, and insert new data into various places within your database.

  • Trigger Automation
    Here we'll dive into one of the most powerful automation tools you'll use as a DBA...triggers! You'll learn how you can create triggers to look for changes in the database via create, update, and delete statements, and then automatically enact changes on one of more of your tables. Triggers will be your best friend as a DBA, and can be extremely handy for Analysts to understand as well.

  • Creating Views
    Sometimes you don't need to create a table, and a view (aka "a virtual table) is a better option. We'll walk through what views are, how you create them, and some of the major benefits of using views in certain situations.

  • The EER Diagram Editor
    One of the best tools at your disposal for understanding your database and communicating its structure to others in your organization is leveraging EER Diagrams. We'll review some of the basics that we discussed in the Beginner course, and we'll also learn how to use the EER Diagram Editor to reverse engineer your schema, which is an extremely handy tool!

  • Stored Procedures & Scheduled Events
    Next, we'll dive deeper into automation by learning how to create stored procedures and scheduled events. If you liked triggers, you're going to love these! You can use stored procedures to simplify your processes, make your code more modular and easier to understand, and centralize certain parts of complex queries that you can leverage throughout your organization. Scheduled events will allow you to run one-time or recurring processes on your database, which you can schedule on whatever cadence you want. These are really fun! 

  • Automating Data from Website Activity
    Here we'll be talking about the different types of data businesses typically track from their website activity, including traffic source data, on-site behavior, product purchases, and more. We'll discuss the various methods used to capture the various data types, and discuss the DBA's role in partnering with Engineering to make sure this is all working as it should.

  • Database Security
    In the last section before the final project, we'll discuss some of the most common types of database security threats you should be aware of as a DBA, as well as security best practices to mitigate your risk. Again, we'll discuss the DBA's role in the organization, how a DBA will partner with Engineering here, and who typically owns what.

    ***FINAL COURSE PROJECT
    This hands-on project will test all of your DBA skills. You will need to alter tables, import lots of data, design an optimal structure for an entirely new set of tables for a new business initiative, create an EER Diagram describing your new tables, and then you'll actually create them. After that, you'll need to create a stored procedure and a view, which will both used for reporting on the new data the company will be collecting. Finally, you'll need to come up with a comprehensive security plan to make sure your organization is aware of threats and following best practices. I know this sounds like a lot, but at this point you'll be ready for it! 

IMPORTANT NOTE: This course does NOT go deep on data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

______________________________

Enroll today and get LIFETIME access to:

  • 8 hours of high-quality video

  • Downloadable MySQL ebook and cheat sheets

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you're looking for a unique and engaging way to develop advanced MySQL database administration skills, this is the course for you.

Happy administering!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Professional Azure SQL Database Administration

Master your skills to efficiently manage and maintain data on the cloud

Created by Packt Publishing - Tech Knowledge in Motion

"]

Students: 1558, Price: $149.99

Students: 1558, Price:  Paid

Azure SQL Database is the  cloud version of SQL Server. It differs in terms of management,  maintenance and administration.  It’s important to know how to  administer SQL Database so that you can get the most out of the features  that it provides. You will learn different management aspects of an  Azure SQL Database, such as migration, backup and restoration, pricing,  security, scalability, monitoring and performance optimization, high  availability and disaster recovery. You’ll start by understanding the  architecture of the Azure SQL Database and its service tiers. Through a  narrative of a DBA, who is migrating from a traditional on-premises  system to Azure SQL Database, this course will explain the concepts by  using different scenarios you might come across while working with Azure  SQL Database. If you are interested in developing new or migrating  existing applications with Azure SQL Database, then this course is for  you.

About the Authors

Gethyn Ellis has over eighteen years of experience wit SQL Server and for past ten years he has been working on Azure. He is Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" and, "Microsoft Azure laaS Essentials".

Ahmad Osama is an independent consultant for Microsoft data platform stack. He has provided consulting, training, content development and SQL support services to more than 120 SQL Server customers globally. An expert in SQL Server and related technologies, he frequently speaks at user group events and conferences. Over the last 9 years, he has worked on countless SQL Server projects, consulted, trained, and mentored more than 1000 IT professionals on SQL Server, delivered more than 50 workshops. Ahmad has been a Microsoft Most Valuable Professional (MVP) awardee for SQL Server from 2014 - 2016.

Currently, he works for Pitney Bowes Pvt. Ltd. as a database engineer and is a Microsoft Data Platform rMVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premise and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation.

Other than his day to day work, Ahmad has written over 100 blogs, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.

PostgreSQL v12 Database Administration on Win/Linux- Part 2

Comprehensive Guide to PostgreSQL v12 Database Replication : Walk-in a Beginner, Walk-Out an Expert

Created by Sadiq Basha - Senior Production Database Administrator

"]

Students: 345, Price: $44.99

Students: 345, Price:  Paid

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

  • Introduction to Replication & It's Terminalogies

  • Master and Slave Configuration

  • Warm & Hot Standby

  • Types of Replication

  • Modes of Replication

  • Models of Replication

  • Log Based Shipping Standby Initial Setup

  • Log Based Shipping Standby on Windows and Linux

  • Log Based Shipping Standby Failover

  • Streaming Replication Setup

  • Monitoring Streaming Replication

  • Synchronous Streaming Replication

  • Configure Physical Replication Slots

  • Failover Streaming Replication

  • Repmgr – Replication Manager

  • Automatic Failover using Repmgr

  • Node Rejoin of Failed Primary

  • Add New Node and Standby Follow

  • Switch Over From Primary to Standby

  • Cascading Streaming Replication

  • Witness Server

  • Uninstall Replication Manager

  • Logical Replication Setup

  • Publication and Subscription

  • Logical Replication Slots

  • Add Table to Publication

  • Refresh Subscription

  • Cascading Logical Replication

  • Uninstall Publication and Subscription.

  • Tune PostgreSQL Server parameters

  • Shared Buffers

  • Work_Mem

  • Maintenance_Work_Mem

Learn Secure Database Administration: MS SQL Server Security

Installing, configuring and hardening Microsoft SQL Server

Created by FeltSecure Labs - FeltSecure Labs: Cyber Security Courses with 10000+ Students

"]

Students: 184, Price: $94.99

Students: 184, Price:  Paid

Database management is so essential and critical for the enterprises but making it secure is more crucial than that. MS SQL Server is one of the most popular commercial RDBMSs recently. 

In this course, MS SQL database management concepts will be explained with security in mind 

All crucial security measures will be explained throughout the course and will be implemented during the hands-on practice labs.

With a hands-on style, we'll
cover topics such as

  • Preparing a windows server
    for secure installation,
  • MS SQL server configuration
  • Surface area reduction with
    sp_configure,
  • Extended protection against
    luring attacks and spoofing attacks,
  • Static and dynamic port
    configurations,
  • Channel and service binding
    techniques,
  • Hiding SQL instance
  • Policy based management and
    preventative policy examples
  • Patching and compliance
  • And many more best practices
    in this domain.

We will also have 2 lab
assignments about creating a table name policy and a powershell proxy job
on MS SQL Server, which we will solve the problems together.

By
the end of the course, you'll know how to install and manage secure MS SQL
server with confidence, which gives you the skills to prevent data leakages
even if the cyber attacks can bypass other security mechanisms in place.

Full Oracle Database Administration with RAC

Learn Oracle Database Administration, 12C R2 RAC Administration, Oracle Backup and Recovery concepts in this course

Created by Oak Academy - Web & Mobile Development, IOS, Android, Ethical Hacking, IT

"]

Students: 142, Price: $89.99

Students: 142, Price:  Paid

Hello there,

Welcome to the Full Oracle Database Administration with RAC course.

We prepared this course of Oracle Database which includes not only database administration but also RAC (Real Application Clusters). While preparing the course, we first covered the basic issues of database management.  Then you will find a detailed explanation of Backup and Recovery concepts in Oracle as a part of database administration.

Backup and recovery is a life-saving topic for DBAs so we tried to explain this topic as detailed as possible. Finally, you will see the administration of the RAC database system.  You can run two or more servers on a database as if one server by using RAC.  You will set up a two-node cluster database during the course. Then you will see many hands-on practices to administer the RAC environment.

In this course, you will learn everything with hands-on practices.  I'll also teach you the best practices and shortcuts. All my students will have a chance to learn not only the whats but also learn the whys and hows.

One of the things you will learn in this course Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates the administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files.

RMAN also reduces the administration work associated with your backup strategy. RMAN keeps an extensive record of metadata about backups, archived logs, and its own activities, known as the RMAN repository. In restore operations, RMAN can use this information to eliminate the need for you to identify backup files for use in restores in most situations. You can also generate reports of backup activity using the information in the repository.

Fresh Content

Oracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. But DBAs also should aware of the recent development and it’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends.

In this course you will learn;

  • Downloading Oracle Software,

  • Database and RDBMS Concepts,

  • DML ( Data Manipulating Language ) and TCL ( Transaction Control Language ),

  • Retrieving Data,

  • Restricting And Sorting Data,

  • Using Single-Row Functions and Customize Output,

  • Using Conversion Functions and Conditional Expressions,

  • Reporting Aggregated Data Using The Group Functions,

  • Defining Table Joins and Displaying Data from Multiple Tables,

  • Using Subqueries,

  • Using The Set Operators,

  • Schema Objects And Managing Schema,

  • Controlling User Access,

  • Manipulating Large Data Sets

  • What is RAC ( Real Application Cluster )

  • Installing Oracle Virtualbox

  • Setting Up Oracle Enterprise Linux

  • Installing Oracle Software

  • Oracle RAC

  • Creating Virtual Machines

  • Installing Oracle RAC Database to VMs

  • Installing Grid Infrastructure, Database Software, and Creating Database

  • Administer Database Instances and Cluster Databases

  • Oracle RAC One Node

  • How to Convert RAC Database to RAC One Node

  • Workload Management

  • Monitoring Performance

  • Design and Deployment Techniques

  • Cloning Oracle RAC

  • Managing backup, and restoring cluster database

  • Add and Delete Node From Cluster

  • Backup and recovery concepts in Oracle

  • Setting up the laboratory environment

  • Creating and managing the recovery catalog

  • Using flashback Technologies in Oracle

  • Backing up the database

  • Reporting on RMAN operations.

  • Managing RMAN backups

  • Using Data Recovery Advisor of Oracle

  • Restoring and recovering database and database objects.

  • The point-in-time recovery concept in Oracle will be crystal clear for you.

  • Managing Physical Standby Database

  • Basic usage of Data Guard Broker Utility

  • Creating and managing snapshot databases

  • Switchover and failover operations on physical standby database via both SQLPlus and Data Guard Broker

  • Creating Far Sync Instance

  • Configuring primary and standby databases for far sync instance

  • Creating Logical Standby database

  • Managing Logical Standby database

  • Switchover and failover operations on logical standby database via both SQLPlus and Data Guard Broker

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers' expertise.

No Previous Knowledge is needed!

This course will take you from a beginner to a more experienced level.

If you are new to Oracle Database or have no idea about what a DBA does no problem, you will learn anything you need to start Oracle Database.

If you are a DBA or familiar with the Oracle Database / Oracle SQL  and you just need a refresher, you are also in the right place. You will learn step by step with hands-on examples.

Video and Audio Production Quality

All our content is created/produced as high-quality video/audio to provide you the best learning experience.

You will be,

  • Seeing clearly

  • Hearing clearly

  • Moving through the course without distractions

You'll also get:

  • Lifetime Access to The Course

  • Fast & Friendly Support in the Q&A section

  • Udemy Certificate of Completion Ready for Download

Dive in now!

We offer full support, answering any questions.

See you in the course!

MongoDB : A Complete Database Administration Course

Designed specifically for database administrators who work on RDBMS like Oracle, SQL Server, MySQL, Postgresql

Created by Wysheid Learning Portal - Place for quality training experience

"]

Students: 81, Price: $94.99

Students: 81, Price:  Paid

MongoDB is one of the leading NO-SQL database . MongoDB is designed for handing  high volume data , while providing high performace. Most courses available in the market are designed for developers and has very less course for database admistrators, especially for those who comes with RDBMS background. This course tries to fill that gap.

This course on MongoDB administration is designed for DBAs,escpecially for those who comes with RDBMS backgroud . I have tried to include almost all the common administrative tasks performed by DBAs on a daily basis.

In this course, you'll learn all about MongoDB Administration from scratch. No prior MongoDB  experience is required!.  But refreshing your unix skills will give added advantage . You will find this course more  enagaing if you are database administration working on RDBMS liks Oracle , SQL Server, Db2, PostgreSQL etc .

This course is covered with Udemy's 30 days refund policy , so you can try this course risk-free.

We will  be covering the following topics

  • Installation and configuration of mongoDB

  • Database Creation and Management

  • CRUD oprations ie Data insert/select/Update/Delete Operations

  • Securing MongoDB

  • Authentication and Authorization

  • Auditing

  • Backup and Recovery

  • Disaster Recovery  & High Availability

  • Replication

  • Sharding or distributed data management

  • Enabling Journelling & Encryption

  • Common day to day  database administration activities

This course is a hands-on course - you'll learn by writing  commands. But to make certain concepts clear , I have included theory classes as well . I am sure that you will find this combination of theory and practical as engaging . 

This course is for you ..

  • If you are absolutely new to MongoDB

  • You have some basic understanding on mongoDB , but looking forward to learn in detail

  • If You are DBA working with RDBMS liks Oracle , SQL Server etc and want to learn MongoDB administration 

PostgreSQL v13 Database Administration & High Availability

PostgreSQL v13 Database Administration with High Availability

Created by Data Leads - Senior Database Administrator

"]

Students: 42, Price: $89.99

Students: 42, Price:  Paid

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

The course provides the candidate with an extensive knowledge of PostgreSQL Database Administration with real life scenarios .

Topics discussed are:

PostgreSQL v13 Overview

PostgreSQL and its history

Installing PostgreSQL v13 on Red Hat Linux 8

PostgreSQL Architecture

Database Cluster

PostgreSQL Database Administration

PostgreSQL Configuration Files

PSQL utility and commands

PG System Catalog

CRUD Operations

Backup & Restore

Physical Backup

Logical Backup

Archie mode enabling

Overview of Barman

Different use cases in Barman

Streaming backup vs rsync/SSH

Requirements for backup

Requirements for recovery

Configuration in Barman

PostgreSQL connection

SSH configuration of postgres user

From PostgreSQL to Barman

From Barman to PostgreSQL

WAL streaming

Replication slots

How to configure the WAL streaming

Verification of WAL archiving configuration

PostgreSQL Maintenance

PostgreSQL  Database Upgrade

PgAdmin 4

User Management

Grants/Revoking privileges

High Availability

Failover

Log Shipping

Alternative method of Log Shipping

Hot Standby

Types of Replication

Demos on:

Understand PostgreSQL Process and Memory Architecture.

Partitioning in PostgreSQL using Table Inheritance.

Copy table from/to PostgreSQL.

How to Create/Move/Drop Tablespace.

Logical (pg dump, pgdumpall), Physical backup (Offline, Online).

Continuous Archiving and PITR.

Install PostgreSQL v13 on  Linux.

PostgreSQL Directory Structure.

PostgreSQL Configuration Files.

How to use PSQL command line interface to connect to PostgreSQL.

How to Create Database/User/Schema from utility and Psql commands.

Learn how to use pg system catalogs.

CRUD operations on PostgreSQL.

Table Inheritance in PostgreSQL.

Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster).

What is Transaction Id Wraparound Failure and Vacuum Freeze.

How to use Pgadmin 4 Interface.

Test Exam 1ZO-082 – Oracle Database Administration I

Test Exam 1ZO-082 - Oracle Database Administration I

Created by FABRICIO DOUGLAS VAZ - Adm Banco de Dados e BI - Database Administrator and BI

"]

Students: 27, Price: $29.99

Students: 27, Price:  Paid

Become an Oracle Database 19c Administrator I

Test Exam 1ZO-082 - Oracle Database Administration I

Oracle Database Administration 2019 Certified Professional

Certification Details

• Credential Awarded: Oracle Database Administration 2019 Certified Professional

• Exam Numbers: 1Z0-082

• Target Audience: Oracle Database Administrators

• Platform: Delivered via Pearson VUE

• Digital Badge: Oracle Certified Professional – 2019 Database Administrator

Understanding Oracle Database Architecture - Oracle Database: Administration Workshop

  • Understanding Oracle Database Instance Configurations

  • Understanding Oracle Database Memory and Process Structures

  • Understanding Logical and Physical Database Structures

  • Understanding Oracle Database Server Architecture

Managing Database Instances - Oracle Database: Administration Workshop

  • Starting Up Oracle Database Instances

  • Using Data Dictionary Views

  • Shutting Down Oracle Database Instances

  • Using Dynamic Performance Views

  • Using the Automatic Diagnostic Repository (ADR)

  • Using the Alert Log and Trace Files

  • Managing Initialization Parameter Files

Managing Users, Roles and Privileges - Oracle Database: Administration Workshop

  • Assigning Quotas to Users

  • Applying the Principal of Least Privilege

  • Creating and Assigning Profiles

  • Administering User Authentication Methods

  • Managing Oracle Database Users, Privileges, and Roles

Managing Storage - Oracle Database: Administration Workshop

  • Managing Resumable Space Allocation

  • Shrinking Segments

  • Deferring Segment Creation

  • Using Space-Saving Features

  • Deploying Oracle Database Space Management Features

  • Managing Different Types of Segments

  • Using Table and Row Compression

  • Understanding Block Space Management

Moving Data - Oracle Database: Administration Workshop

  • Using External Tables

  • Using Oracle Data Pump

  • Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop

  • Using the Database Configuration Assistant (DBCA)

  • Using Oracle Enterprise Manager Cloud Control

  • Using racle enterprise Manager Database Express

  • Using SQL Developer

  • Using SQL Plus

Configuring Oracle Net Services - Oracle Database: Administration Workshop

  • Using Oracle Net Services Administration Tools

  • Configuring Communication Between Database Instances

  • Configuring the Oracle Net Listener

  • Connecting to an Oracle Database Instance

  • Comparing Dedicated and Shared Server Configurations

  • Administering Naming Methods

Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop

  • Viewing Tablespace Information

  • Creating, Altering and Dropping Tablespaces

  • Managing Table Data Storage

  • Implementing Oracle Managed Files

  • Moving and Renaming Online Data Files

Managing Undo - Oracle Database: Administration Workshop

  • Understanding Transactions and Undo Data

  • Storing Undo Information

  • Configuring Undo Rentention

  • Comparing Undo Data and Redo Data

  • Understanding Temporary Undo

Restricting and Sorting Data - Oracle Database: Introduction to SQL

  • Applying Rules of precedence for operators in an expression

  • Limiting Rows Returned in a SQL Statement

  • Using Substitution Variables

  • Using the DEFINE and VERIFY commands

Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL

  • Applying the NVL, NULLIF, and COALESCE functions to data

  • Understanding implicit and explicit data type conversion

  • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

  • Nesting multiple functions

Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL

  • Using Self-joins

  • Using Various Types of Joins

  • Using Non equijoins

  • Using OUTER joins

Using SET Operators - Oracle Database: Introduction to SQL

  • Matching the SELECT statements

  • Using the ORDER BY clause in set operations

  • Using The INTERSECT operator

  • Using The MINUS operator

  • Using The UNION and UNION ALL operators

Understanding Data Definition Language - Oracle Database: Introduction to SQL

  • Using Data Definition Language

Managing Views - Oracle Database: Introduction to SQL

  • Managing Views

Managing Data in Different Time Zones - Oracle Database: Introduction to SQL

  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

  • Working with INTERVAL data types

Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL

  • Using Column aliases

  • Using The DESCRIBE command

  • Using The SQL SELECT statement

  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

  • Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL

  • Manipulating strings with character functions in SQL SELECT and WHERE clauses

  • Performing arithmetic with date data

  • Manipulating numbers with the ROUND, TRUNC and MOD functions

  • Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL

  • Restricting Group Results

  • Creating Groups of Data

  • Using Group Functions

Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL

  • Using Single Row Subqueries

  • Using Multiple Row Subqueries

Managing Tables using DML statements - Oracle Database: Introduction to SQL

  • Managing Database Transactions

  • Using Data Manipulation Language

  • Controlling transactions

Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL

  • Managing Indexes

  • Managing Synonyms

  • Managing Sequences

Managing Schema Objects - Oracle Database: Introduction to SQL

  • Creating and using temporary tables

  • Managing constraints