SQL Tutorial > SQL FUNCTIONS

SQL Miscellaneous Functions

25.8k

Start a new search

To find content from modules and lessons

Learner's Ratings

4.3

Overall Rating

69%
12%
8%
0%
11%

Reviews

R

ruhina qureshi

5

Awesome Classes ,Both tutors explains the concept very nice

Y

Yadav Aakash

5

very useful thank you learnvern

A

Ashish

5

The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.

N

nayazbasha sk

5

very useful thank you learnvern

M

Mahima Patel

5

very usefull......thanks

P

Priya Kushwaha

5

Very Good trainer

C

chanchal singh

5

you guys are doing nice job. thanks

U

Umesh Wankhede

5

Not too much interactive

M

Monesh Ram

5

Well Explained in Every Chapters..

G

GAJANAN DIGAMBAR MODE

5

very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern

Show More

Recommended Courses

Free हिन्दी

MySQL Database Management System

17443

4.3 Enroll For Free

Course Content

Getting Started

SQL Datatypes

SQL Commands

What is DBMS

What is RDBMS

Database Relationships

Primary Key

Unique Key

Foreign Key

Difference between PK, UK and PK & FK

SQL Server Installation Step by Step

How to Create Database in SQL Server

Assignment : SQL Create Table

SQL Constraints

SQL Insert Statement and SQL Alias

Filtering Data using Selection Command

Filtering Data using Comparison Operator

SQL Order by Clause

Assignment : Ordering and Filtering

Aggregate Functions in SQL for Data Analysis

SQL Mathematical Functions for Data Analysis

SQL String Functions for Data Analysis

SQL Date & Time Functions for Data Analysis

SQL Window Functions for Data Analysis

SQL Miscellaneous Functions

Rollup and NTile Function

Row Number Function

DenseRank and Cumulative Distribution

How to use SQL Conditional Statements

How to use SQL Group by Clause

SQL Practical with Examples

Assignment : SQL Date and Time

Type of Joins in SQL - INNER, LEFT

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

SQL Joins Practical Session 1

SQL Joins Practical Session 2

SQL Joins Practical Session 3

SQL Joins Practical Session 4

SQL Joins Practical Session 5

Assignment : SQL Joins

Assignment : SQL Functions 1

Assignment : SQL Functions 2

Practice: SQL Subqueries

Practice: SQL Subqueries & Unions

SQL Correlated Subqueries Part 1

SQL Correlated Subqueries Part 2

SQL Correlated Subqueries Part 3

SQL Correlated Subqueries Part 4

SQL Correlated Subqueries Part 5

Correlated Select, Update & Delete Queries

SQL Union

SQL EXCEPT & INTERSECT

Assignment : SQL SubQueries

SQL Pivot, UnPivot Practical Example - 1

SQL Pivot, UnPivot Practical Example - 2

What are Views?

Examples of SQL Views Part -1

Examples of SQL Views Part -2

Assignment : SQL Views

What is SQL Index?

SQL Index types

Create Tables using Select Statement

Using Correlated Sub Query, Group By with Select Statement

Using Group By and Having Clauses with Select Statement

Using Index Optimizer with Select Statement

Using Union with Select Statement

Adding Multiple Records with Insert Statement

SQL Insert - Considerations and Best Practices

Insertion from Multiple Tables

SQL Delete - Types of Delete Operation Part -1

SQL Delete - Types of Delete Operation Part -2

Assignment : SQL Insert, Update & Delete

Loading & Connecting Different Files in SQL

Course Summary

Interview Questions Part 1

Interview Questions Part 2

Career Guideline

Enroll For Free