Mastering SQL Table Joins from scratch- Real World Examples

Mastering SQL Table Joins from scratch: Real World Examples, available at $39.99, has an average rating of 3.65, with 55 lectures, based on 20 reviews, and has 2549 subscribers.

You will learn about Install Relational Database Management System Install TOAD Connect TOAD to Oracle database Install SQL Developer Connect SQL Developer to Oracle database Create various types of table joins Build real world table joins with SQL Generate ERD Use concatenation operator Use comparison operators Use various logical operators Use Aliases in building quries Use various Join clauses and keywords Use GROUP BY clause to group data sets. This course is ideal for individuals who are Beginner database administrators or Beginner data analyst or Anyone who wants to learn how to join tables It is particularly useful for Beginner database administrators or Beginner data analyst or Anyone who wants to learn how to join tables.

Enroll now: Mastering SQL Table Joins from scratch: Real World Examples

Summary

Title: Mastering SQL Table Joins from scratch: Real World Examples

Price: $39.99

Average Rating: 3.65

Number of Lectures: 55

Number of Published Lectures: 55

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Install Relational Database Management System

Install TOAD

Connect TOAD to Oracle database

Install SQL Developer

Connect SQL Developer to Oracle database

Create various types of table joins

Build real world table joins with SQL

Generate ERD

Use concatenation operator

Use comparison operators

Use various logical operators

Use Aliases in building quries

Use various Join clauses and keywords

Use GROUP BY clause to group data sets.

Who Should Attend

Beginner database administrators

Beginner data analyst

Anyone who wants to learn how to join tables

Target Audiences

Beginner database administrators

Beginner data analyst

Anyone who wants to learn how to join tables

SQL is a special-purpose programming language designed for managing information in a relational database management system (RDBMS). The word relational here is key; it specifies that the database management system is organised in such a way that there are clear relations defined between different sets of data. Join makes relational database systems relational.

Joins allow you to link data from two or more tables together into a single query result–from one single SELECT statement.

.When combining rows from multiple tables in one query, you need to use the JOIN command. There are a few different types of joins, and the following should help explain the differences between them.

The syntax will vary depending on which database type you are using. In this course i have used Oracle database.

The JOIN operations, which are among the possible Table Expressions in a FROM clause, perform joins between two tables.

Below is a brief description of the various types of joins used in Oracle.

INNER JOIN operation

Specifies a join between two tables with an explicit join clause.

LEFT OUTER JOIN operation

Specifies a join between two tables with an explicit join clause, preserving unmatched rows from the first table.

RIGHT OUTER JOIN operation

Specifies a join between two tables with an explicit join clause, preserving unmatched rows from the second table.

CROSS JOIN operation

Specifies a join that produces the Cartesian product of two tables. It has no explicit join clause.

NATURAL JOIN operation

Specifies an inner or outer join between two tables. It has no explicit join clause. Instead, one is created implicitly using the common columns from the two tables.

In all cases, you can specify additional restrictions on one or both of the tables being joined in outer join clauses or in the WHERE clause.

In this course there will be lots of hands-on real world examples of SQL table joins.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: Tools used to execute queries and scripts

Lecture 3: Download and installation of Oracle

Lecture 4: How to unlock sample oracle hr schema account

Lecture 5: Download and install TOAD

Lecture 6: Connect TOAD to Oracle database

Lecture 7: Download and install Oracle SQL Developer

Lecture 8: Connect SQL Developer to Oracle database

Lecture 9: Introduction to database concepts

Lecture 10: Introduction to ERD

Lecture 11: How to generate ERD using SQL Developer

Lecture 12: How to generate ERD using TOAD

Lecture 13: Using Character Functions

Chapter 2: Introduction to Table Joins

Lecture 1: Introduction

Lecture 2: Creating Equi Joins

Lecture 3: Creating Non – Equi oins

Lecture 4: Creating Natural Joins

Lecture 5: Creating Self Joins

Lecture 6: Creating Cartesian Join

Lecture 7: Creating Outer Joins

Lecture 8: Using Aliases

Lecture 9: Keywords used in Join Operations

Chapter 3: Some SQL Key Clauses

Lecture 1: WHERE clause

Lecture 2: FROM clause

Lecture 3: ORDER BY clause

Lecture 4: GROUP BY and HAVING clause

Chapter 4: SQL Operators

Lecture 1: Introduction to logical operators

Lecture 2: ALL operator

Lecture 3: ANY operator

Lecture 4: NOT operator

Lecture 5: IS NULL Operator

Lecture 6: AND operator

Lecture 7: IN operator

Lecture 8: OR operator

Lecture 9: Comparison Operators

Lecture 10: LIKE operator

Chapter 5: Practical Real World SQL Table Joins Examples

Lecture 1: Introduction

Lecture 2: Exercise 1

Lecture 3: Exercise 2

Lecture 4: Exercise 3

Lecture 5: Exercise 4

Lecture 6: Exercise 5

Lecture 7: Exercise 6

Lecture 8: Exercise 7

Lecture 9: Exercise 8

Lecture 10: Exercise 9

Lecture 11: Exercise 10

Lecture 12: Exercise 11

Lecture 13: Exercise 12

Lecture 14: Exercise 13

Lecture 15: Exercise 14

Lecture 16: Exercise 15

Lecture 17: Exercise 16

Lecture 18: Exercise 17

Lecture 19: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 3 votes

3 stars: 4 votes

4 stars: 7 votes

5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!