How to build SQL Queries with Logical and SET Operator
4.2 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,265 students enrolled

How to build SQL Queries with Logical and SET Operator

Learn to create SQL Queries from scratch using Logical and SET Operators
4.2 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,265 students enrolled
Last updated 4/2017
English
English [Auto-generated]
Current price: $11.99 Original price: $134.99 Discount: 91% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build Queries with IN Operators
  • Build Queries with OR Operators

  • Build Queries with AND Operators

  • Build Queries with NOT Operators
  • Build Queries with ISNULL Operators
  • Build Queries with UNION SET Operators
  • Build Queries with UNION ALL SET Operators
  • Build Queries with INTERSECT SET Operators
  • Build Queries with MINUS SET Operators
Course content
Expand all 22 lectures 01:20:29
+ Test Environment Setup
9 lectures 35:04
Hardware Requirements
00:19
Software Requirements
00:22
Unlock Sample HR Schema Account
03:30
Download TOAD
05:29
Install TOAD
03:33
Connect TOAD to Oracle Database
08:11
+ Writing SQL Queries with Logical Operators
8 lectures 28:01
Introduction
00:41
IN Operator
04:48
ALL Operator
04:01
AND Operator
04:46
OR Operator
04:12
ANY Operator
04:01
ISNULL Operator
02:43
NOT Operator
02:49
+ Writing SQL Queries with SET Operator
5 lectures 17:30
Introduction
04:36
MINUS operator
01:48
INTERSECT Operator
02:50
UNION Operator
05:23
UNION ALL Operator
02:53
Requirements
  • Y
  • Y
  • You should have an understanding of basic SQL
Description

Oracle is a relational database management system used by a lot of fortune 100 companies  for their data solutions.
SQL -Structural query language is the language used to interact and manipulate the data stored inside oracle database. SQL is also referred to as sequel by a lot of technical professionals.

For you to be able to effectively work with databases you must be comfortable building simple to complex
SQL queries to interact with databases.

In this beginners practical hands-on  course you will learn how to build SQL queries with both logical and SET  operators.

if you are new to writing SQL queries, this  introductory course  will help build up your skills. In
this course , we'll cover the basics of how incorporate logical and set operators in your queries.

The logical operators we will be using to build our SQL queries include:

    • ANY
    • OR
    • IN
    • ISNULL
    • NOT
    • AND  

The SET operators we will be using to build our SQL queries include:
    • INTERSECT
    • UNION
    • UNION ALL
    • MINUS


After the end of this course , you will know how to :

  • Backup and restore a database
  • Manage database user access and security
  • Recover dropped tables
  • Use Oracle flashback technology.


Who this course is for:
  • d
  • D
  • sTUDEN
  • Data warehouse engineer