Sql With Prashant

Basic sql key points.

Differences between Delete,Drop and Truncate in sql | Postgresql | Oracle | Mysql Sql With Prashant

How to insert multiple rows using for loop in postgresql | Postgresql | Mysql | Oracle | Daily sql

How to save SQL queries in PG Admin tool.

How to filter/select json data. How to use json column in where clause.

SQL COMMAND - DDL (DATA DEFINATION LANGUAGE)

sql query optimization

Sql Commnad - DML Data Manipulation language.

How to select duplicate and delete duplicate records with 3rd min and max salary.

what questions will be asked during SQL developer interviews | Part 1 |

Sql aggregate functions Min(), Max(),Avg(),Count(),Sum().

12 April 2022

How coalesce function works in SQL | Made 2 mistakes while writing query | Postgresql | Oracle

Indexs

Channel review

HOW WE CAN GET 3 MAX SALARIES WITH THE EMPLOYEE NAME

Sql server to Postgresql manual Code migration

Difference between functions and procedures

What is subquery in sql?

How does ETL process work? extract, transform and load

PL/ SQL Block: STRUCTURE, Syntax, ANONYMOUS Example

How to take backup and restore in PgAdmin 4 using command prompt

How to alter/change datatype of any column in sql | Postgresql | Mysql | Oracle | Basic sql

BASIC SQL DELETE STATEMENTS

Database triggers

Basic sql table creation || primary key || foreign key constraints

Pg-admin 3 || basic server introduction

BASIC SQL UPDATE STATEMENTS ||

Basic sql joins || Inner || left || Right || Full join

Basics of Sql subquery.

Basic sql key points.

Basics of SQL Performance.

Difference between views and materialized view

Default name of a Primary key

Basic Concept Of Temporary Tables | How to create temporary tables| SQL |PLSQL|POSTGRESQL|TEMP TABLE

Refcursor # Return multiple rows using refcursor

Database Developer Motivational Video.

Basic sql clauses || From || where || group by || having || order by

PostgreSQL Upsert Using INSERT ON CONFLICT statement