CodeStar[1403]-SE-Phase07-Team[01]

[AmirRezaZahedi]

• Read the introduction to SQL
• Understand basic concepts
• Install required softwares
  • Download PostgreSQL
  • Download Azure Data Studio
  • Install PostgreSQL with default configs
  • Install ADS
  • Run and configure ADS to work with Postgres
  • Create connection to the Postgres instance
• Create your own database
• Get familiar with different data types in Postgres
  • Write a suitable data type for each of the fields below:
    • [INTERVAL] for flight time
    • [VARCHAR] for email address
    • [BOOLEAN] for a boolean variable
    • [NUMERIC ] for stature
• Store some data
  • Create a table with arbitrary columns with data types you learned in the previous section
  • Insert some sample data into your table
  • Retrieve your data with different SELECT statements and different conditions
  • Try to change at least one of your table columns attributes using ALTER statement
• Perceive the importance and usage of each key
  • Add primary key constraint to your table
  • Try inserting different values for primary key and check whether it produces error or not
    • Try inserting duplicate primary key. Error [ ]
    • Try inserting NULL primary key. Error [ ]
  • Create a new table which is related to your existing table with a foreign key
  • Try inserting different values for foreign key to produce different errors
    • Try inserting none existing foreign key. Error [ ]
    • Try inserting duplicate foreign key. Error [ ]
    • Try inserting NULL foreign key. Error [ ]
• Perceive different types of joins
  • Write the corresponding set operation for each join like the given example
    • A Inner Join B : A ∩ B
    • A Left Outer Join B : A
    • A Right Outer Join B : B
    • A Full Outer Join B : A ∪ B
  • Test different joins on you tables
• Work with functions
  • Write a query for each present function in the document