Course Description:-

INTRODUCTION: 

In this course on Displaying and Aggregating Data, Sub queries, you will learn about Displaying Data from Multiple Tables, Aggregating Data Using Group Functions, Sub queries 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 concept 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.

What are the requirements?

• Knowledge of SQL
• Passion to learn

What am I going to get from this course?

• Hours of content!

What is the target audience?

• Anyone interested in SQL Programming
• Programmers
• Developers
• Students and Fresher
• Software Professionals

CURRICULUM

Section 1: Displaying Data from Multiple Tables

1. Cartesian Product, EquiJoin
2. Non Equi, Outer and Self Joins
3. SQL 1999 Complaint Joins
4. Creating Three-Way Joins with the ON Clause
5. Displaying Data from Multiple Tables 1
6. Displaying Data from Multiple Tables 2
7. Displaying Data from Multiple Tables 3
8. Create Query 01
9. Create Query 02

Section 2: Aggregating Data Using Group Functions

1. Group Functions Syntax
2. MIN and MAX Functions
3. Groups of Data and Having Clause
4. IIIegal Querise Using Group Function
5. Aggregating Data Using Group Functions-Practical Examples
6. Aggregating Data Using Group Functions-Additional Examples 01
7. Aggregating Data Using Group Functions-Additional Examples 02

Section 3: Sub queries

1. Subqueries
2. The HAVING Clause with Subqueries
3. Subqueries-Practical Examples-1
4. Subqueries-Practical Examples-2
5. Subqueries-Additional Examples 1
6. Subqueries-Additional Examples 2

For any query give a miss call:

08587999769