Скачать с ютуб Oracle SQL 11g Installation Guide for ETL Testing в хорошем качестве

Oracle SQL 11g Installation Guide for ETL Testing

Oracle SQL 11g Installation Guide for ETL Testing ---------------Oracle SQL Installation-------------------------------- Step 1: Download Oracle SQL 11g Express Edition and Java JDK Link for Oracle SQL for 64 Bit and 32 Bit:: https://www.oracle.com/database/techn...  For Downloading we need to create Our Oracle Account with your mail id as User ID and password. Once You have created Oracle Account, Then You will receive a mail. We need to verify from mail. Click on Verify in our Mail.  Once Verified Downloading will start automatically. If Downloading is not happening then close every thing again login with your Mail id and Password to Oracle. And Start Downloading. Step 2:: Download SQL Developer JDK:: https://www.oracle.com/tools/download... Step 3: Unzip the downloaded file in Download folder only. Use any software like 7Zip or WinRar. If you don’t have 7Zip or WinRar..then downloaded it from Google. Its free. https://www.7-zip.org/download.html Step 4: Install Oracle XE software, click on SETUP application and follow the comments. Step 5: While Installing, Give password as admin and install. So that you can remember this password. Step 6: Open SQL Developer and set Connection or Add Schema as per below. 1. ADMIN- UserName_ system, pwd—admin Above is first Schema we have to add. Refer above UserName and Password. Step 7: Grant access to HR database. Run Below Query in Admin Schema Database Worksheet alter user hr IDENTIFIED by hr account unlock; Step 8:: Add HR Schema as per below: 2. Name: HR —UserName-hr, Pwd - - hr Connect to HR and Write below Query: Select * from Employees;