Installing And Manipulating Oracle Database Using Sql

[LeeAndro]

Last updated 6/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 652.24 MB | Duration: 1h 40m

Hands-On Practical Examples

What you'll learn
Remove Data from a database
Add Data into a database
Update existing records inside a database
Create Report from extracted data
Requirements
You should have a sample database and connection to the database.​

We 'll cover this in section one of this course
Description
Oracle Databases are among the most widely used in the world. You will find oracle databases in large to medium size organizations to store various types of information. This course will teach you how to install an oracle database step by step from scratch with no steps skipped. You will also be getting access to a sample schema object and database tables. But before you can access the tables in the schema it has to be unlocked. I will show you the special code used to unlock that in this course. Once the database is installed you will need a tool to connect to it and perform data manipulation. The tool you will need to install is Oracle SQL developer developed by oracle. This is a free tool that can somes be tricky to install. I will show you how to install it step by step. You will be using SQL (Structured Query Language) to talk to and give instructions to the database to perform various types of data manipulation. This course is for those who have some very basic knowledge of database fundamentals as well as basic SQL knowledge. However the course is also easy enough for anyone who just has a basic knowledge of how to use a computer. This format of this course is video based and the duration of the course is under 2hours long The examples are practical hands on easy to follow and resembles a real life environment. .What You Learn in this course: How to add new data into a databaseHow to remove data from a databaseHow to update existing data in a databaseHow to get data from a database and create a report from itHow to Get Unique Data Values from a database

Overview

Section 1: Setting Up Your Database Environment

Lecture 1 Introduction

Lecture 2 Oracle Database

Lecture 3 Install Oracle Database

Lecture 4 Unlock Sample Database Tables

Lecture 5 Installing Java JDK

Lecture 6 Oracle SQL Developer

Lecture 7 Installing Oracle SQL Developer

Lecture 8 Oracle SQL Developer Tour

Section 2: Manipulating Oracle Database

Lecture 9 Adding New Data To A Database

Lecture 10 DDL Create Part1

Lecture 11 DDL Create -Part 2

Lecture 12 Deleting Data -DDL

Lecture 13 Chag Data

Lecture 14 Reading Data and Generating a Report

Lecture 15 Retrieving Unique Data Values From A Database

Lecture 16 Thank You

This course is meant for those that have a basic understanding of databases and some very basic SQL

HomePage:

Https://anonymz.com/https://www.udemy.com/course/installing-and-manipulating-oracle-database-using-sql/

DOWNLOAD

https://1dl.net/h2dk8ii1fnea/T9rxVw84__Installing.rar.html