Day: January 21, 2022

DML or CRUD Operations using Postgresql¶ Let’s create a table and perform database operations using direct SQL. In [1]: %%HTML <iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/pqtKUUI5cCo?rel=0&amp;controls=1&amp;showinfo=0″ frameborder=”0″ allowfullscreen></iframe> Exercise 1 – Create Table¶ Create table – courses course_id – sequence generated integer and primary key course_name – which holds alpha numeric or string values up to 60 characters …

Solutions – DML or CRUD Operations using Postgresql Read More »

Getting Started¶ Here is the exercise related to getting started module. Exercise – Loading Data¶ As part of this exercise, you need to take care of loading data using COPY Command. You can connect to the database using following details in the environment provided by us. Host: localhost Port: 5342 Database Name: YOUR_OS_USER_hr_db User Name: …

Solutions – Loading Data into Postgres Tables Read More »