Practical SQL with Oracle Database 18c

Practical SQL with Oracle Database 18c, available at $19.99, has an average rating of 4.55, with 20 lectures, based on 14 reviews, and has 3079 subscribers.

You will learn about Install Oracle 18c Database Server Unlock sample hr schema Install Oracle SQL Developer Connect to Oracle using SQL Developer Basic Database Concepts This course is ideal for individuals who are Beginners to SQL with Oracle Databases It is particularly useful for Beginners to SQL with Oracle Databases.

Enroll now: Practical SQL with Oracle Database 18c

Summary

Title: Practical SQL with Oracle Database 18c

Price: $19.99

Average Rating: 4.55

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 20

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Install Oracle 18c Database Server

Unlock sample hr schema

Install Oracle SQL Developer

Connect to Oracle using SQL Developer

Basic Database Concepts

Who Should Attend

Beginners to SQL with Oracle Databases

Target Audiences

Beginners to SQL with Oracle Databases

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write  queries for Oracle databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.

SQL Skills will greatly improve your job prospects either as a contractor
or full time employment. It is a useful skill that is always in demand .

Oracle is one of the top database management systems used in the world by companies of various sizes in a variety of sectors.

There is so much data in the world today and the volume is growing each day. SQL is the language used to interrogate and interact with various types of databases.

This is a practical hands on video based course designed for  beginners to learn practical SQL skills that can be used across multiple databases.

You will Learn how to :

Download and install Oracle Database

Install SQL Developer

Connect to Oracle Database

How to create a database table

How to use count aggregate function

Updating exiting records in database

How to add new records into database

How to delete records from database

How to generate reports based on certain conditions.

Course Curriculum

Chapter 1: Setting Up Oracle Database 18c

Lecture 1: Introduction

Lecture 2: Overview of SQL

Lecture 3: What is SQL

Lecture 4: Download and Install Oracle

Lecture 5: What is SQLPlus

Lecture 6: Unlock Sample Schema

Lecture 7: Install Oracle Developer

Lecture 8: Connect to Oracle Database

Lecture 9: Database concepts

Lecture 10: What are TNSNames

Lecture 11: How to create TNSNames

Chapter 2: Practical Real World SQL Queries

Lecture 1: Determine total employees

Lecture 2: Update employee salaries

Lecture 3: How to produce a report of employee salaries

Lecture 4: Add new record into database

Lecture 5: How to create a new table

Lecture 6: Delete record from database

Lecture 7: How to produce a report of hire date

Lecture 8: Generate a report of employee job title and salary

Lecture 9: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 4 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!