Complete guide to understanding Oracle SQL: Hands on course

Complete guide to understanding Oracle SQL: Hands on course

Complete guide to understanding Oracle SQL: Hands on course

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

Language: english

Note: 4.3/5 (17 notes) 7,943 students

Instructor(s): James Njoroge

Last update: 2022-03-15

What you’ll 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

 

Requirements

  • No prior SQL experience required, this is a comprehensive hands on training with easy to follow examples.

 

Complete guide to understanding Oracle SQL: Hands on courseComplete guide to understanding Oracle SQL: Hands on course

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.

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.

 

Complete guide to understanding Oracle SQL: Hands on courseComplete guide to understanding Oracle SQL: Hands on course

Who this course is for

  • Beginner in Oracle SQL, data scientist, data analysts and database managers

 

Course 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
    • Lab 1
  • Selection
    • Where Clause
    • IN and LIKE operators
    • NULL and LOGICAL operators
    • Recap
    • Lab 2
  • 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
    • Lab 3
  • Multiple Row functions
    • max, min, avg, sum group functions
    • count function
    • group by and having clause
    • Lab 4
  • 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
  • DDL Statements: Create Table
    • Introduction
    • Oracle Data Types
    • Create Table: Hands on Lab
    • Primary Key Vs Unique Key Constraints
    • Understanding Foreign Key Constraint
    • Foreign Key: Hands on Lab
    • Disabling & Deferring Constraints
    • Alter Table: Add Column | Drop Column | Set Column Unused
    • Alter Table: Rename Column | Modify Column
    • Drop Table | Set Table to Read Only

 


Time remaining or 116 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate