Master POSTGRESQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant скачать в хорошем качестве

Master POSTGRESQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant

‪@MPrashant‬ #postgres #postgresql #sql PostGreSQL FULL COURSE PostGreSQL COURSE IN HINDI PostGreSQL FOR BEGINNERS PostGreSQL Tutorial in Hindi POSTGRES In Hindi SQL in Hindi Complete SQL Course for Beginners Link for the Notes/Slides of this Video - https://www.canva.com/design/DAGGQI3j... Queries- TaskDB https://www.canva.com/design/DAGQjSCN... Want to learn PostGreSQL but don't know where to start? Then this is the video for you! In this beginner to advanced PostGreSQL course, you'll learn everything you need to know to start using PostGreSQL from the ground up. From beginner basics to more advanced features, this video will teach you everything you need to get started with PostGreSQL. By the end of this course, you'll be able to use PostGreSQL to create, manage, and query databases with ease. So whether you're a beginner or an expert, this video is a great way to get started with PostGreSQL! Topics and Timeline 00:00 Introduction to PostGreSQL Course 02:25 What is database? 04:00 Database vs DBMS 06:32 What is RDBMS? 08:36 Postgres Installation on Windows 15:36 Postgres Installation on MAC 20:40 Postgres Installation on Linux 25:40 Database vs Schema vs Table 27:33 Section 1 - Database and CRUD 27:56 Database Create, DROP, List & Switch 34:35 What is CRUD 36:23 CREATE Table 39:43 INSERT Data 43:52 READING (SELECT) 45:21 UPDATING 48:16 DELETE 51:22 Section 3 - Datatypes and Contraint 52:00 Datatypes 59:39 Constraint 57:00 Primary Key 58:13 NOT NULL and Default 01:01:04 Task1 Create a Employee Table 01:17:15 Data Refining - WHERE, ORDER BY, DISTINCT, LIMIT, LIKE 01:25:25 Operators - Relational and Logical 01:38:56 Aggregate Functions - Count, Min, Max, Avg etc 01:43:19 GROUP BY 01:49:59 String Functions - Concat, Replace, Substr etc 02:17:19 Exercises 02:22:45 ALTER Query - Modify Table 02:30:46 CHECK Constraint 02:37:23 CASE Expression 02:46:41 Relationship and its type 02:54:48 Foreign Key 02:55:49 One to One Relationship Example 03:00:41 JOINS and its types 03:12:25 MANY to MANY Relationship Example 03:25:42 Project of E-STORE 03:45:05 VIEWS 03:48:57 HAVING Clause 03:54:00 Stored Procedure 04:03:05 User Defined Function 04:13:39 WINDOW Functions 04:27:06 CTE (Common Table Expressioon) 04:39:34 TRIGGERS PostGreSQL tutorial in Hindi Learn PostGreSQL in Hindi PostGreSQL for beginners Hindi Advanced PostGreSQL Hindi PostGreSQL database course Hindi PostGreSQL programming in Hindi PostGreSQL training videos Hindi Hindi PostGreSQL lessons PostGreSQL full course in Hindi PostGreSQL in Hindi for beginners PostGreSQL database tutorial Hindi Hindi PostGreSQL database guide SQL in Hindi PostGreSQL query tutorial Hindi PostGreSQL video series Hindi PostGreSQL basics in Hindi PostGreSQL advanced concepts Hindi PostGreSQL Hindi lectures PostGreSQL practical tutorial Hindi PostGreSQL Hindi tutorial for beginners PostGreSQL step by step tutorial Hindi Complete PostGreSQL guide in Hindi SQL database course in Hindi PostGreSQL hands-on training Hindi PostGreSQL Hindi explanation sql for beginners, SQL Full Course in Hindi, sql basics for beginners, sql tutorial for beginners, learn sql for beginners, free sql course, sql crash course, sql full course, sql tutorial for beginners in hindi, sql in hindi, sql server full course, sql learning for beginners, how to learn sql for beginners, sql beginners, sql programming for beginners, sql queries, learn sql in 1 hour, how to learn sql, learn sql, what is sql, sql course in hindi, sql interview