Oracle SQL Hands-On Experience for beginners

Oracle SQL Hands-On Experience for beginners, available at $19.99, has an average rating of 4, with 38 lectures, based on 6 reviews, and has 569 subscribers.

You will learn about Extract data from multiple tables with Table Joins Retrieve Data with SQL SELECT Use Aliases with SQL Statements Remove Duplicates with SQL DISTINCT Write SQL Queries with WHERE Clause Create Views Update data with SQL Add new data with SQL INSERT Use SQL to Sort data Use various operators in your queries This course is ideal for individuals who are Beginner database administrators or Data Analyst or Data Scientist or Students or Graduates who want to explore something new It is particularly useful for Beginner database administrators or Data Analyst or Data Scientist or Students or Graduates who want to explore something new.

Enroll now: Oracle SQL Hands-On Experience for beginners

Summary

Title: Oracle SQL Hands-On Experience for beginners

Price: $19.99

Average Rating: 4

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Extract data from multiple tables with Table Joins
Retrieve Data with SQL SELECT
Use Aliases with SQL Statements
Remove Duplicates with SQL DISTINCT
Write SQL Queries with WHERE Clause
Create Views
Update data with SQL
Add new data with SQL INSERT
Use SQL to Sort data
Use various operators in your queries

Who Should Attend

Beginner database administrators
Data Analyst
Data Scientist
Students
Graduates who want to explore something new

Target Audiences

Beginner database administrators
Data Analyst
Data Scientist
Students
Graduates who want to explore something new

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user’s request.

The strengths of SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Technically speaking, SQL is a data sub language. The purpose of SQL is to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database.

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 simple to complex 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 .

This is a practical hands on video based course designed for beginners.

You will Learn how to :

Retrieve Data with SQL SELECT
Use Aliases
Remove Duplicates with SQL DISTINCT
Write SQL Queries with WHERE Clause
Create Views
Update data with SQL
Add new data with SQL INSERT
Use ORDER BY clause
Use SQL to Sort data
Use SQL IN operator
Use SQL NULL Use LIKE Operator
Write SQL Queries with ISNULL
Extract data from multiple tables with table joins

Course Curriculum

Chapter 1: Oracle Database Setup

Lecture 1: Introduction

Lecture 2: Importance of oracle and SQL

Lecture 3: What is SQL

Lecture 4: What is Oracle

Lecture 5: Download Oracle 11g Database

Lecture 6: Install Oracle 11g Database

Lecture 7: Unlock Schema for Oracle 11g

Lecture 8: Oracle 18c Installation

Lecture 9: SQLplus

Lecture 10: Unlock Schema for Oracle 18c

Lecture 11: Install Oracle Developer

Lecture 12: Connect to Oracle with SQL Developer

Lecture 13: Download TOAD

Lecture 14: Install TOAD

Lecture 15: Connect TOAD to Oracle

Lecture 16: Database Concepts

Lecture 17: What are TNSNames

Lecture 18: Creating TNSNames

Chapter 2: Practical Hands-on SQL

Lecture 1: Retrieving Data with SQL SELECT

Lecture 2: Using Aliases

Lecture 3: Removing Duplicates with SQL DISTINCT

Lecture 4: Writing SQL Queries with WHERE Clause

Lecture 5: Creating Views

Lecture 6: Updating data with SQL

Lecture 7: Adding new data with SQL INSERT

Lecture 8: Using ORDER BY clause

Lecture 9: Using SQL to Sort data

Lecture 10: SQL IN operator

Lecture 11: SQL NULL

Lecture 12: LIKE Operator

Lecture 13: Writing SQL Queries with ISNULL

Chapter 3: Extracting Data From Multiple Tables Using Table Joins

Lecture 1: Introduction

Lecture 2: Equi Join

Lecture 3: Non Equi Join

Lecture 4: Cartesian Join

Lecture 5: Outer Join

Lecture 6: Self Join

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 2 votes
5 stars: 3 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!

Menu