Oracle 21c Express Setup with TOAD and SQL Developer

Focused View

Bluelime Learning Solutions

59:46

4 View

1. Oracle 21c Express Installation

1. Introduction.mp4

00:20

2. What is Oracle.html

3. Oracle installation requirements.mp4

01:27

4. Download Oracle.mp4

03:59

5. Install Oracle.mp4

01:58

6. Connect to Oracle with SQLPlus.mp4

03:13

7. Create a new database user.mp4

01:56

8. Create table.mp4

02:23

9. How to stop and start Oracle.mp4

01:26

2. Oracle Setup with TOAD and SQL Developer

1. What is SQL Developer.mp4

02:41

2. Download SQL Developer.mp4

03:41

3. Connect SQL Developer to Oracle.mp4

02:29

4. Download sample schemas.mp4

02:12

5. Unlock sample HR Schema account.mp4

05:18

6. Unlock sample schema tables.mp4

04:39

7. Connect sample schema account to Oracle.mp4

01:49

8. What is TNSNames.mp4

04:09

9. Creating TNSNames.mp4

06:43

10. Connect Oracle with TNS Names.mp4

03:20

11. What is TOAD.html

12. Install TOAD.mp4

03:21

13. Connect TOAD to Oracle.mp4

02:42

Description

Install Oracle Database Server, connect TOAD and Oracle SQL Developer

What You'll Learn?

Download and install Oracle Database Server 21c Express
Create a new database user
Create a new database table
Connect SQL Developer to Oracle Database
Connect TOAD to Oracle Database
Create TNSNames
Connect to Oracle Database with TNSNames
Unlock sample schema

Who is this for?

Beginners to Oracle Database

What You Need to Know?

A Computer is required with internet connection

No Oracle Database experience required

More details

Description
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.

Oracle 21c Express is a free database server provided by Oracle. Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database Express Edition (XE) is the ideal way to get started. It is the same powerful Oracle Database that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a full-featured experience. You get an Oracle Database to use in any environment, plus the ability to embed and redistribute .

Below is what is included with Oracle21c Express:

Multitenant: Get isolation, agility, and economies of scale by managing multiple PluggableÂ Â Â Â Databases inside your Oracle Multitenant Container Database
In-Memory: Support real-time analytics, business intelligence, and reports by keeping your important data in the Oracle Database In-Memory column store
Partitioning: Enhance performance, availability, and manageability of your database with data partitioning that meets diverse business requirements
Advanced Analytics: Get valuable insights and deliver predictions from your data using Data Mining SQL, R programming, and the Oracle Data Miner UI .
Advanced Security: Protect your sensitive data at the source and build end-to-end encrypted apps with layers of security including Oracle Transparent Data Encryption and Data Redaction.

Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2, SAP and MySQL.
Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development K
In this course we will connect TOAD and SQL Developer to Oracle Database.

Who this course is for:
Beginners to Oracle Database

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.