Learn PostgreSQL Tutorial - Full Course for Beginners

Опис:

Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems. The course covers a wide range of topics, starting with an introduction to databases at 0:03:16, then explaining SQL and relational databases at 0:05:17, and detailing PostgreSQL at 0:09:10. It includes installation guides for Mac OS at 0:10:53 and Windows at 0:14:21, a comparison of GUI and terminal clients at 0:17:38, and setup instructions for PSQL on both platforms at 0:21:39 and 0:25:22. The curriculum then moves through database creation at 0:30:15, connection procedures at 0:33:35, a warning about a dangerous command at 0:38:12, and table creation techniques at 0:41:37, 0:45:46, and 0:49:12. It covers data insertion at 0:55:55 and 0:59:14, generating mock data at 1:02:36, and various SELECT operations at 1:12:28, 1:15:18, 1:19:53, 1:21:59, 1:25:29, 1:29:35, 1:32:43, 1:35:43, 1:37:45, 1:43:10, 1:46:41, 1:52:08, 1:55:40, 1:59:48, 2:01:55, 2:05:59, 2:09:43, 2:12:32, 2:16:15, 2:20:21, 2:23:21, 2:25:58, 2:27:28, 2:29:24, 2:31:23, 2:36:26, 2:40:55, 2:49:15, 2:54:45, 3:01:36, 3:05:55, 3:11:09, 3:16:41, 3:19:48, 3:25:04, 3:29:30, 3:35:17, 3:40:53, 3:47:27, 3:50:42, 3:57:18, 3:59:39, 4:05:54, and 4:16:30, concluding with a wrap-up at 4:16:30.