Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 10 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Oracle SQL

SQL From Scratch Using Oracle SQL Developer and TOAD

Learn how to query databases using SQL
Rating: 4.4 out of 54.4 (155 ratings)
12,917 students
Created by 247 Learning
Last updated 2/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Choose the right logical operators for your queries
  • Choose the right logical SET operators for your queries
  • Write SQL Queries to extract data
  • Write SQL Queries to modify data
  • Write SQL Queries to delete data
  • Write SQL Queries to create tables
  • Write SQL Queries to extract data from multiple tables
  • Write Advanced SQL Queries using analytic functions
  • Write SQL Queries to generate reports

Course content

11 sections • 105 lectures • 10h 13m total length

  • Preview06:05
  • What is SQL ?
    01:57
  • Professional Tools
    08:39
  • Preview08:11
  • Unlock Sample Database Schema and Objects
    05:04
  • Download and Install TOAD
    07:09
  • Connect TOAD to Oracle database
    06:38
  • Exploring TOAD
    05:41
  • Download and install Oracle SQL Developer
    08:55
  • Connect SQL Developer to Oracle database
    06:05

  • Database Concepts
    07:09
  • Database Views and Dual Tables
    06:06
  • Using Describe
    03:18
  • Using Synonyms
    06:05
  • Creating and using Indexes
    06:17
  • What is an ERD
    05:32
  • Generating ERD with TOAD
    03:59
  • Generating ERD with SQL Developer
    13:02

  • Introduction to SQL Sub-languages
    03:05
  • Data Definition Language :DDL CREATE
    08:50
  • Data Definition Language :DDL CREATE Continued
    08:03
  • Data Definition Language :DDL DROP,TRUNCATE and ALTER
    08:38
  • Data Manipulation Language: DML SELECT
    09:15
  • Data Manipulation Language: DML INSERT
    09:32
  • Data Manipulation Language: DML UPDATE and DELETE
    07:02

  • What are Single Row Functions
    00:59
  • Character Functions
    07:50
  • Conversions Functions
    06:48
  • Date Functions
    05:02
  • Numeric Functions
    05:25

  • Data Types and Constraints
    09:37
  • NULL Values
    07:51
  • What are Sequences
    06:34
  • How to create Sequences
    04:57
  • How to use Sequences
    07:48
  • Using Aliases
    07:47
  • Restricting and Sorting Data
    07:18
  • Using Sub -Queries
    08:38
  • Removing Duplicate records
    05:52
  • Using SQL FROM Clause
    02:51
  • Using SQL WHERE Clause
    05:22
  • Using SQL ORDER BY Clause
    05:48
  • Using SQL GROUP BY & HAVING Clause
    07:35
  • SQL LIKE Operator
    09:18

  • Why the need to join tables
    04:11
  • Table Join Keywords
    08:40
  • Equi Join
    07:46
  • Non Equi Join
    07:26
  • Cartesian Join
    06:19
  • Outer Join
    08:14
  • Self Join
    09:53
  • Natural Joins
    07:04

  • What are Aggregate Functions
    01:38
  • AVG () Aggregate Functions
    03:20
  • COUNT () Aggregate Function
    04:40
  • MAX () Aggregate Function
    03:13
  • MIN () Aggregate Function
    02:48

  • What are SET Operators
    04:35
  • Union All SET Operator
    05:23
  • INTERSECT SET Operator
    02:50
  • MINUS SET Operator
    01:48
  • SET Operators Summary
    03:31

  • What are Analytic Functions
    06:43
  • How to write Analytic Functions
    04:07
  • The PARTITION BY Clause
    08:04
  • ORDER BY Clause
    05:48
  • Windowing Clause
    02:10
  • Row number Functions
    09:26
  • Rank Function
    06:04
  • Dense Rank Function
    05:57
  • Lag Function
    03:37
  • ListAgg Function
    06:14
  • Lead Function
    06:43
  • First and Last Functions
    08:56
  • What is a Flashback Query
    05:18
  • Undo Parameters
    05:11
  • Session level flashback
    08:59
  • Rolling Back Data
    05:35
  • Rolling Back Data Continued
    10:57
  • Session Flashback
    06:57

  • Introduction
    00:40
  • ANY Operator
    04:01
  • ALL Operator
    04:01
  • SQL IN Operator
    04:48
  • SQL IS NULL Operator
    02:42
  • AND operator
    04:46
  • NOT Operator
    02:49
  • OR Operator
    04:12

Requirements

  • Download Oracle Database and Tools. We will cover this in the course

Description

Learning SQL is a very useful skill to have as every business and organisation is so dependent on data. There are not enough skilled SQL professionals hence the demand and pay rate for SQL professionals is quite high. 

SQL stands for structured query language. It is an international standard language
used to query and manipulate databases. There are different types of database 
vendors like Oracle, Microsoft ,MySQL and so on . They all support SQL and
performs certain operations in the same way. Keywords like CREATE,SELECT,UPDATE,
DELETE,WHERE and FROM are used the same way with various database vendors.

This course will teach you the skills you need to get your foot in the door
 as an SQL professional. With the skills you learn on this course you can work 
confidently as a data analyst or even progress to be a database administrator.
This course will take from scratch to more advanced SQL using TOAD and SQL Developer TOOL

Some of what you will learn on this course includes:

  • Database concepts
  • SQL SUB Languages -DDL and DML
  • Aggregate Functions
  • Logical Operators
  • SET Operators
  • Table Joins
  • Analytic Functions
  • Single Row Functions
  • Creating Tables
  • Creating Views
  • Creating Sequences
  • Creating Indexes
  • Using Aliases
  • Using Sub Queries
  • NULL Values
  • Restricting and Limiting Data

By the end of this course you will confidently be able to write SQL queries
to create,read,update and delete data which are the key functions that are performed
on a database.

Who this course is for:

  • Anyone who wants to learn SQL
  • Anyone who is interested in databases
  • This course is meant for those not familiar with SQL syntax
  • Beginner DBA

Instructor

247 Learning
An investment in knowledge pays the best interest
247 Learning
  • 4.1 Instructor Rating
  • 242 Reviews
  • 15,644 Students
  • 7 Courses

Hello and welcome to 247 Learning.

We are a small company from the united kingdom that create and teach designs.Our teaching style is designed to be simple and step by step.

We have taught courses like Adobe Photoshop, Adobe Illustrator,Adobe Indesign as well as web design related courses .
Our very first Udemy course was "How to create resume /cv for profit" which has over 500 students.
We will continue to add more courses on the Udemy platform.
Our tutors have  over 7 years of a wide range of industry experience and understand how to teach in a way that students can understand.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.