• Post category:StudyBullet-5
  • Reading time:7 mins read


The ultimate, complete with examples and hands on Labs SQL training plus guide to Oracle exam 1z0-071.

What you will learn

What is SQL and its importance in databases

Access Oracle database and its development environment

Write efficient SQL queries to produce accurate reports

Understand the different types of SQL statements and how to use them.

Use of SQL Functions

Working with Subqueries

Working with Joins

Using set operators

Description

These days, almost everyone has to work with data in some form or another. Usually it’s through spreadsheets or databases, but if you can learn a little SQL, you can become so much more powerful in your job.

Data analytics spans every aspect of business, from research and development to marketing, accounting, and beyond. And data analytics would be impossible without the efficient querying of the massive databases holding the data.

SQL is a powerful and robust tool for extracting relevant and useful data from a large dataset. While SQL has traditionally been the specialty of highly-trained data analysts and programmers, it’s finding greater acceptance among non-technical personnel. And there are many good reasons for that.

SQL has remained a consistently popular choice for database users over the years primarily due to its ease of use and the highly effective manner in which it queries, manipulates, aggregates data and performs a wide range of other functions to turn massive collections of structured data into usable information.


Get Instant Notification of New Courses on our Telegram channel.


While different iterations of SQL may utilize different syntax for key operations, in general, basic commands like select, insert, update and create are common to all SQL releases. This makes it very easy for someone with a basic knowledge of SQL to work in many different environments and perform a wide variety of tasks.

Why study SQL?

  • Data Mining
  • Data Manipulation
  • Combine Data from Multiple Sources
  • Manage Large Pools of Data
  • Manage Databases and Servers
  • Job market: SQL Programmers in High Demand

You can go through my Udemy training on how to install Oracle database 12c or 19c. Apart from following the videos it would be important for you to execute the statements yourself.

English
language

Content

Introduction

Introduction
Definitions
What is structured query language?
SQL development environment
hr-schema

Projection

1_basic_select, describe, projection
2_arithmetics, null, column alias, concatenation and distinct

Selection

Where Clause
IN and LIKE operators
NULL and LOGICAL operators
Recap

SQL Single row Functions

Introduction to sql functions
character single row functions
CONCAT and SUBSTR
TRIM single row functions
REPLACE single row functions
INSTR single row function
LPAD, RPAD AND LENGTH single row functions
Dual table

number single row functions

Trunc and Round functions
mod, abs, ceil, floor, cos, power, sqrt

Date single row functions

intro current_date and sysdate
arithmetic with dates
months_between, add_months, next_day, last_day functions
round and trunc with dates

Conversion single row functions

introduction
to_char, to_date, to_number functions

General single row functions

nvl, nvl2, nullif, coalesce functions
decode and case functions

Multiple Row functions

max, min, avg, sum group functions
count function
group by and having clause

Working with Joins

natural join clause
using clause
on clause
n-way join clause
self and non-equijoins clause
outer joins
cross join

Subqueries

introduction to subqueries
single row subqueries labs
having clause

Multiple Row subquery

Multiple Row subqueries
Multiple column subqueries

Set Operators

introduction
UNION operator
UNION ALL operator
INTERSECT-MINUS operator