SQL SQL Case Study - Displaying and Aggregating Data

SQL Case Study - Displaying and Aggregating Data

Catalog: SQL
Short name: Displaying and Aggregating Data
Course start date: 2024-07-02
Paystack
Enroll Me

Description

In this course on Displaying and Aggregating Data, Subqueries, you will learn about Displaying Data from Multiple Tables, Aggregating Data Using Group Functions, Subqueries etc.. The course starts from scratch and hence a beginner can also take and enjoy this course.


The course is designed in such a manner that after each major concepts we have included Practical examples in the software. The trainer has carried out step by step understanding of the example which makes it easy to understand the concepts.

Course Duration:-3h 36m

Sections

General
0 activities

Cartesian Product‚ EquiJoin
Non Equi‚ Outer and Self Joins
SQL 1999 Complaint Joins
Creating Three-Way Joins with the ON Clause
Displaying Data from Multiple Tables 1
Displaying Data from Multiple Tables 2
Displaying Data from Multiple Tables 3
Create Query 01
Create Query 02
Group Functions Syntax
MIN and MAX Functions
Groups of Data and Having Clause
IIIegal Querise Using Group Function
Aggregating Data Using Group Functions-Practical Examples
Aggregating Data Using Group Functions-Additional Examples 01
Aggregating Data Using Group Functions-Additional Examples 02
Subqueries
The HAVING Clause with Subqueries
Subqueries-Practical Examples-1
Subqueries-Practical Examples-2
Subqueries-Additional Examples 1
Subqueries-Additional Examples 2
Secure Video
22
Cost: 5000
Enroll Me

Tag

Course Duration:-3h 36m