PostgreSQL full Course for Business analyst (BA) and Postgres beginners with pgAdmin free
PostgreSQL full Course for Business analyst (BA) and Postgres beginners with pgAdmin completely free
PostgreSQL for beginners
DQL, DML, DCL, DDL, Select, Create , Update, Insert, Excepts, Limit, Join, Inner join, Postgres installation, PGADMIN tricks, Data Type, Like, merged, etc..
⌨️ (0:00) Introduction
⌨️ (1:00) Agenda
⌨️(3:30) PostgreSQL Installation
⌨️(6:16) pgAdmin details
⌨️(8:40) PostgreSQL DQLs SELECT
⌨️(10:36) PostgreSQL DQLs WHERE
⌨️(13:20) PostgreSQL DQLs LIMIT
⌨️(14:34) ORDER BY ASC & DESC
⌨️(16:34) Fetch
⌨️(19:34) OFFSET
⌨️(20:34) DISTINCT
⌨️(22:55) AGGRIGATE FN
⌨️(30:55) IN and NOT IN
⌨️(34:55) Like and ILIKE
⌨️(39:55) GROUP BY
⌨️(1:15:55) JOINS
⌨️(1:36:55) Set Operations
⌨️(1:51:55) LIKE & ILIKE
⌨️(2:02:55) IN & Not IN
⌨️(2:08:55) CAST
⌨️(25:32) DDL examples
⌨️(36:47) Create
⌨️ (39:33) Data Type
⌨️(2:09:55) Aggregate FN
⌨️(2:20:55) Maths Operations
⌨️(2:30:55) Important Information Tables
--PostgreSQL: Show tables in PostgreSQL
SELECT * FROM pg_catalog.pg_tables;
SELECT *FROM information_schema.tables;
SELECT distinct table_name FROM information_schema.columns
where upper(table_schema) ='DEMO_TEST';
select column_name, data_type, character_maximum_length, column_default, is_nullable
from INFORMATION_SCHEMA.COLUMNS
where table_name = 'employee';
Describe employee
SELECT * FROM pg_attribute,pg_class WHERE attrelid=pg_class.oid AND relname='employee'
Copy Select * From demo_test.emp To 'C:/RKMALVIYA/emp_bkp.csv'
With CSV DELIMITER ',' HEADER;
If you liked the video - please hit the like button. Thanks for watching and thank you for all your support!!
Always looking for suggestions on what video to make next you can type class and chapter.
Please below URL for my other video:-कृपया मेरे अन्य वीडियो के लिए नीचे URL देखें:-
PostgreSQL Aggregation, CUBE, and ROLLUP | PostgreSQL: Group By CUBE, CUBE Aggregate , Power BI CUBE
• PostgreSQL Aggregation, CUBE, and ROLLUP |...
PostgreSQL Variable, How to define Variables in PostgreSQL | %TYPE Variable definition in Hindi
• PostgreSQL Variable, How to define Variabl...
PostgreSQL exception handling, User define exception handling (English, Hindi)
• PostgreSQL exception handling, User define...
PostgreSQL Real life ETL Procedure and Function for All type's of DATA Loading in Hindi Part 2
• PostgreSQL Real life ETL Procedure and Fun...
PostgreSQL Simple Procedure or Function for All type's of DATA Loading in Hindi
• PostgreSQL Simple Procedure or Function fo...
PostgreSQL Real life automate function examples | PostgreSQL Parent Child relationship Function
• Video '
PostgreSQL Parent Child relationship Function | PostgreSQL Real life automate function examples
• PostgreSQL Parent Child relationship Funct...
PostgreSQL Parent Child relationship Function | Hierarchy Rollup Child to Parents real life example
• PostgreSQL Parent Child relationship Funct...
Introduction to PostgreSQL STRING_AGG() function | PostgreSQL Aggregate function in Hindi
• Introduction to PostgreSQL STRING_AGG() fu...
Cursors in PostgreSQL | Cursor best explanation in Hindi | Cursor uses inside Function and Procedure
• Cursors in PostgreSQL | Cursor best explan...
POSTGRESQL SELECT LATEST ROW IN EACH GROUP, COLLECT LATEST RECORD FROM ALL HISTORY IN HINDI
• POSTGRESQL SELECT LATEST ROW IN EACH GROUP...
PostgreSQL DROP SCHEMA TABLES, CLEAN SET OF TABLES | Delete data from specific tables in Hindi'
• PostgreSQL DROP SCHEMA TABLES, CLEAN SET O...
PostgreSQL Save output/result from PostgreSQL to a CSV file | PostgreSQL Copy option | Copy command
• PostgreSQL Save output/result from Postgre...
PostgreSQL: Show tables in PostgreSQL || How do I see all tables in PostgreSQL (English, Hindi)
• PostgreSQL: Show tables in PostgreSQL || H...
PostgreSQL DATE, DATETIME, CAST, DATE CONVERSION. NOW,TIME ZONE, EXTRACT, Covert datetime in Hindi
• PostgreSQL DATE, DATETIME, CAST, DATE CONV...
CREATE FUNCTIONS IN POSTGRESQL with Return Single row, Multiple row and return table in Hindi
• CREATE FUNCTIONS IN POSTGRESQL with Return...
PostgreSQL WITH Recursive Queries | CTE (Common Table Expressions) Recursive in Hindi
• PostgreSQL WITH Recursive Queries | CTE (C...
PostgreSQL Trigger with Simple Examples | PostgreSQL Triggers in Hindi | Trigger pros and cons
• PostgreSQL Trigger with Simple Examples | ...
PostgreSQL backup, restore, Import, Export & debug CSV Import Issues database with Pgadmin
• PostgreSQL backup, restore, Import, Export...
PostgreSQL EXPLAIN , EXPLAIN ANALYZE & VERBOSE | PostgreSQL DB File system | Performance Tuning
• PostgreSQL EXPLAIN , EXPLAIN ANALYZE & VER...
PostgreSQL Set Operations | UNION | UNION ALL | EXCEPTS | INTERSECT in HINDI
• PostgreSQL Set Operations | UNION | UNION ...