The Complete Oracle SQL course for Data Analysts -A-Z of SQL

The Complete Oracle SQL course for Data Analysts -A-Z of SQL, available at Free, has an average rating of 4.35, with 33 lectures, 6 quizzes, based on 165 reviews, and has 13343 subscribers.

You will learn about How to Download and Install Oracle developer Download and Install Oracle SQL Developer How to create table in Oracle Learning different Oracle statement How to analyze data Aggregate result data with aggregate functions Grouping data of any table oracle database sql oracle sql developer oracle database select statement This course is ideal for individuals who are Who wanted to Analyze data in SQL or wannabe data analyst or data analyst course or data scientist or data analysis or mis or dba or database or sql or oracle or advance database feature in sql or advance database feature in oracle or sql for data analysis or advance sql or database developer or Advanced SQL or Free SQL Tutorial or Oracle SQL Tutorial or PL/SQL or oracle course or Oracle tutorial or Learn SQL or SQL for beginners or Advanced SQL or SQL Beginners to Advanced Learning It is particularly useful for Who wanted to Analyze data in SQL or wannabe data analyst or data analyst course or data scientist or data analysis or mis or dba or database or sql or oracle or advance database feature in sql or advance database feature in oracle or sql for data analysis or advance sql or database developer or Advanced SQL or Free SQL Tutorial or Oracle SQL Tutorial or PL/SQL or oracle course or Oracle tutorial or Learn SQL or SQL for beginners or Advanced SQL or SQL Beginners to Advanced Learning.

Enroll now: The Complete Oracle SQL course for Data Analysts -A-Z of SQL

Summary

Title: The Complete Oracle SQL course for Data Analysts -A-Z of SQL

Price: Free

Average Rating: 4.35

Number of Lectures: 33

Number of Quizzes: 6

Number of Published Lectures: 27

Number of Published Quizzes: 6

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 33

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

How to Download and Install Oracle developer
Download and Install Oracle SQL Developer
How to create table in Oracle
Learning different Oracle statement
How to analyze data
Aggregate result data with aggregate functions
Grouping data of any table
oracle database
sql oracle
sql developer
oracle database
select statement

Who Should Attend

Who wanted to Analyze data in SQL or wannabe data analyst
data analyst course
data scientist
data analysis
mis
dba
database
sql
oracle
advance database feature in sql
advance database feature in oracle
sql for data analysis
advance sql
database developer
Advanced SQL
Free SQL Tutorial
Oracle SQL Tutorial
PL/SQL
oracle course
Oracle tutorial
Learn SQL
SQL for beginners
Advanced SQL
SQL Beginners to Advanced Learning

Target Audiences

Who wanted to Analyze data in SQL or wannabe data analyst
data analyst course
data scientist
data analysis
mis
dba
database
sql
oracle
advance database feature in sql
advance database feature in oracle
sql for data analysis
advance sql
database developer
Advanced SQL
Free SQL Tutorial
Oracle SQL Tutorial
PL/SQL
oracle course
Oracle tutorial
Learn SQL
SQL for beginners
Advanced SQL
SQL Beginners to Advanced Learning

Oracle database is one of the top and most widely used relational database management systems in the world .

This more advanced beginners course will teach you how to retrieve data from an oracle database.

We will start off by downloading and installing oracle database 21c express which is free to use.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard – BUT Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Setting up Environment

Lecture 1: Oracle Database Download

Lecture 2: OPENING SQL DEVELOPER

Lecture 3: CREATING CONNECTION

Chapter 3: Database Operations

Lecture 1: Creating a new table

Lecture 2: Altering an existing Table

Lecture 3: Understanding Primary and Foreign Key

Chapter 4: Data Manipulation

Lecture 1: Insert data in Table

Lecture 2: SELECT Command

Lecture 3: Updating values in Table

Lecture 4: DELETE data from table

Lecture 5: WHERE Clause

Lecture 6: ORDER BY Clause

Lecture 7: DROP a Table

Chapter 5: Logical and Mathematical Operation

Lecture 1: Use of AND & OR

Lecture 2: How to use IN and NULL

Lecture 3: Use of LIKE function

Lecture 4: Mathematical Functions

Chapter 6: Dealing with Characters

Lecture 1: SUBSTR & INSTR Function

Lecture 2: LAPD,RPAD & TRIM Function

Lecture 3: How to CONCATENATE

Lecture 4: LOWER & UPPER Function

Lecture 5: How to replace character in a string

Lecture 6: FETCH FIRST N ROWS ONLY & ROWNUM Function

Chapter 7: JOINS IN SQL

Lecture 1: JOIN AND ITS TYPE

Chapter 8: GROUP BY AND HAVING

Lecture 1: GROUP BY AND ITS USE

Lecture 2: HAVING CLAUSE

Instructors

IJTABA HUSSAIN
Data Enthusiastic

Rating Distribution

1 stars: 10 votes
2 stars: 12 votes
3 stars: 23 votes
4 stars: 59 votes
5 stars: 61 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