L13: Running SQL commands in PostgreSQL | beginner guide to psql shell

Welcome to Lecture 13 of the course "Database Management Systems" by Prof. Partha Pratim Das. Full Course: https://study.iitm.ac.in/ds/course_pages/BSCS2001.html Video Overview Learn how to run essential SQL commands in PostgreSQL using the psql shell, perfect for beginners and those looking to refresh their skills. This step-by-step tutorial walks you through core database operations including:Creating and connecting to databases Designing tables with proper structure Inserting, querying, updating, and deleting data Using PostgreSQL on both Windows command prompt and Ubuntu terminal Whether you are just starting out or practicing for hands-on work, this video will help you build a solid foundation in PostgreSQL and SQL database management using real-world examples. About About IIT Madras' online Bachelor of Science programme IIT Madras offers four-year BS programmes that aim to provide quality education to all, irrespective of age, educational background, or location. The BS programme has multiple levels, which provide flexibility to students to exit at any of these levels. Depending on the courses completed and credits earned, the learner can receive a Foundation Certificate from IITM CODE (Centre for Outreach and Digital Education), Diploma(s) from IIT Madras, or BSc/BS Degrees from IIT Madras. For more details, Visit: https://www.iitm.ac.in/academics/study-at-iitm/non-campus-bs-programmes #PostgreSQL #SQL #Database #Tutorial #psql #CreateDatabase #CreateTable #Insert #Select #Update #Delete #Windows #Ubuntu #BeginnerFriendly #DataInsertion #TableDesign #CommandLine #LearnSQL #DatabaseBasics #PostgreSQLTutorial #DatabaseCommands #Linux