How to build SQL Queries with Logical and SET Operator
4.4 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,260 students enrolled
Wishlisted Wishlist

Please confirm that you want to add How to build SQL Queries with Logical and SET Operator to your Wishlist.

Add to Wishlist

How to build SQL Queries with Logical and SET Operator

Learn to create SQL Queries from scratch using Logical and SET Operators
4.4 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,260 students enrolled
Last updated 4/2017
English
Current price: $12 Original price: $135 Discount: 91% off
3 days left at this price!
30-Day Money-Back Guarantee
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 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
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 is the target audience?
  • d
  • D
  • sTUDEN
  • Data warehouse engineer
Compare to Other SQL Courses
Curriculum For This Course
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
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,780 Reviews
39,063 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.