Course Content

Getting Started

18m 54s

How to use LearnVern

3m 20s

SQL Datatypes

10m 5s

SQL Commands

21m 59s

What is DBMS

27m 51s

What is RDBMS

5m 23s

Database Relationships

11m 35s

Primary Key

6m 50s

Unique Key

3m 34s

Foreign Key

4m 2s

Difference between PK, UK and PK & FK

6m 6s

SQL Server Installation Step by Step

8m 2s

How to Create Database in SQL Server

13m 2s

Assignment : SQL Create Table

5m 5s

SQL Constraints

29m 1s

SQL Insert Statement and SQL Alias

28m 12s

Quiz : SQL Constraints & Alias

6m

Filtering Data using Selection Command

31m 53s

Filtering Data using Comparison Operator

28m 52s

SQL Order by Clause

25m 56s

Assignment : Ordering and Filtering

26m 58s

Quiz : Selection Commands Ordering & Filtering

18m

Aggregate Functions in SQL for Data Analysis

22m 31s

SQL Mathematical Functions for Data Analysis

21m 31s

SQL String Functions for Data Analysis

15m 51s

SQL Date & Time Functions for Data Analysis

17m 20s

SQL Window Functions for Data Analysis

23m 34s

SQL Miscellaneous Functions

20m 10s

Rollup and NTile Function

26m 32s

Row Number Function

8m 3s

DenseRank and Cumulative Distribution

29m 12s

How to use SQL Conditional Statements

4m 22s

How to use SQL Group by Clause

4m 55s

SQL Practical with Examples

49m 46s

Assignment : SQL Date and Time

15m 16s

Quiz : SQL Functions

16m

Type of Joins in SQL - INNER, LEFT

21m 24s

Type of Joins in SQL - RIGHT,SELF,FULL, CARTESIAN

15m 14s

SQL Joins Practical Session 1

22m 17s

SQL Joins Practical Session 2

23m 29s

SQL Joins Practical Session 3

27m 43s

SQL Joins Practical Session 4

22m 26s

SQL Joins Practical Session 5

29m 41s

Assignment : SQL Joins

15m 5s

Assignment : SQL Functions 1

13m 25s

Assignment : SQL Functions 2

9m 25s

Quiz : SQL Join Functions

5m

Practice: SQL Subqueries

26m 41s

Practice: SQL Subqueries & Unions

22m 29s

SQL Correlated Subqueries Part 1

20m 21s

SQL Correlated Subqueries Part 2

30m 51s

SQL Correlated Subqueries Part 3

30m 45s

SQL Correlated Subqueries Part 4

25m 7s

SQL Correlated Subqueries Part 5

19m 42s

Correlated Select, Update & Delete Queries

33m 15s

SQL Union

18m 3s

SQL EXCEPT & INTERSECT

14m 33s

Assignment : SQL SubQueries

30m 7s

Quiz : SQL Sub Queries

5m

SQL Pivot, UnPivot Practical Example - 1

37m 28s

SQL Pivot, UnPivot Practical Example - 2

27m 40s

What are Views?

22m 19s

Examples of SQL Views Part -1

16m 41s

Examples of SQL Views Part -2

17m 47s

Assignment : SQL Views

10m 17s

Quiz : SQL Views

6m

What is SQL Index?

13m 29s

SQL Index types

24m 50s

Quiz : SQL Indexes

3m

Create Tables using Select Statement

41m 2s

Using Correlated Sub Query, Group By with Select Statement

40m 2s

Using Group By and Having Clauses with Select Statement

23m 32s

Using Index Optimizer with Select Statement

23m 24s

Using Union with Select Statement

35m 4s

Adding Multiple Records with Insert Statement

22m 42s

SQL Insert - Considerations and Best Practices

9m 19s

Insertion from Multiple Tables

22m 11s

SQL Delete - Types of Delete Operation Part -1

16m 41s

SQL Delete - Types of Delete Operation Part -2

11m 38s

Assignment : SQL Insert, Update & Delete

7m 24s

Quiz : Advanced SQL

12m

Loading & Connecting Different Files in SQL

11m 18s

Course Summary

9m 6s

Interview Questions Part 1

22m 2s

Interview Questions Part 2

20m 56s

Career Guideline

1m 35s

DenseRank and Cumulative Distribution

SQL Tutorial SQL FUNCTIONS

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next

Course Content

Getting Started

18m 54s

How to use LearnVern

3m 20s

SQL Datatypes

10m 5s

SQL Commands

21m 59s

What is DBMS

27m 51s

What is RDBMS

5m 23s

Database Relationships

11m 35s

Primary Key

6m 50s

Unique Key

3m 34s

Foreign Key

4m 2s

Difference between PK, UK and PK & FK

6m 6s

SQL Server Installation Step by Step

8m 2s

How to Create Database in SQL Server

13m 2s

Assignment : SQL Create Table

5m 5s

SQL Constraints

29m 1s

SQL Insert Statement and SQL Alias

28m 12s

Filtering Data using Selection Command

31m 53s

Filtering Data using Comparison Operator

28m 52s

SQL Order by Clause

25m 56s

Assignment : Ordering and Filtering

26m 58s

Aggregate Functions in SQL for Data Analysis

22m 31s

SQL Mathematical Functions for Data Analysis

21m 31s

SQL String Functions for Data Analysis

15m 51s

SQL Date & Time Functions for Data Analysis

17m 20s

SQL Window Functions for Data Analysis

23m 34s

SQL Miscellaneous Functions

20m 10s

Rollup and NTile Function

26m 32s

Row Number Function

8m 3s

DenseRank and Cumulative Distribution

29m 12s

How to use SQL Conditional Statements

4m 22s

How to use SQL Group by Clause

4m 55s

SQL Practical with Examples

49m 46s

Assignment : SQL Date and Time

15m 16s

Type of Joins in SQL - INNER, LEFT

21m 24s

Type of Joins in SQL - RIGHT,SELF,FULL, CARTESIAN

15m 14s

SQL Joins Practical Session 1

22m 17s

SQL Joins Practical Session 2

23m 29s

SQL Joins Practical Session 3

27m 43s

SQL Joins Practical Session 4

22m 26s

SQL Joins Practical Session 5

29m 41s

Assignment : SQL Joins

15m 5s

Assignment : SQL Functions 1

13m 25s

Assignment : SQL Functions 2

9m 25s

Practice: SQL Subqueries

26m 41s

Practice: SQL Subqueries & Unions

22m 29s

SQL Correlated Subqueries Part 1

20m 21s

SQL Correlated Subqueries Part 2

30m 51s

SQL Correlated Subqueries Part 3

30m 45s

SQL Correlated Subqueries Part 4

25m 7s

SQL Correlated Subqueries Part 5

19m 42s

Correlated Select, Update & Delete Queries

33m 15s

SQL Union

18m 3s

SQL EXCEPT & INTERSECT

14m 33s

Assignment : SQL SubQueries

30m 7s

SQL Pivot, UnPivot Practical Example - 1

37m 28s

SQL Pivot, UnPivot Practical Example - 2

27m 40s

What are Views?

22m 19s

Examples of SQL Views Part -1

16m 41s

Examples of SQL Views Part -2

17m 47s

Assignment : SQL Views

10m 17s

What is SQL Index?

13m 29s

SQL Index types

24m 50s

Create Tables using Select Statement

41m 2s

Using Correlated Sub Query, Group By with Select Statement

40m 2s

Using Group By and Having Clauses with Select Statement

23m 32s

Using Index Optimizer with Select Statement

23m 24s

Using Union with Select Statement

35m 4s

Adding Multiple Records with Insert Statement

22m 42s

SQL Insert - Considerations and Best Practices

9m 19s

Insertion from Multiple Tables

22m 11s

SQL Delete - Types of Delete Operation Part -1

16m 41s

SQL Delete - Types of Delete Operation Part -2

11m 38s

Assignment : SQL Insert, Update & Delete

7m 24s

Loading & Connecting Different Files in SQL

11m 18s

Course Summary

9m 6s

Interview Questions Part 1

22m 2s

Interview Questions Part 2

20m 56s

Career Guideline

1m 35s

FAQs

The function DENSE RANK returns the rank of a row in an ordered collection of rows as a NUMBER. The ranks are in ascending order, starting with 1. The number of unique values returned by the query is the highest rank value.

Because they encapsulate the table's name, views are utilised for security. Data is kept in a virtual table rather than being saved permanently. Views show only the info that you want to see. In order to derive the data for the view, we may also use Sql Joins in the Select statement.

With no gaps in the ranking data, this method delivers the rank of each row within a result set division.

There are two ways to calculate the density of a cumulative distribution:

  • Using its marginal density, which is positive in the range 0< X< c and negative in the range c< X< ∞
  • Using its cumulative density function, which is equal to one minus the derivative of its marginal density with respect to x.

  • A density can be calculated by taking the total number of items and dividing it by the total volume. A cumulative distribution can be calculated by taking the number of items that fall into any given interval and dividing it by the length of that interval.
  • The difference between these two statistics lies in their calculation methods. A density is calculated by multiplying all items together, while a cumulative distribution is calculated using only one item at a time.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere