SQL Fundamentals

1.1) SQL Fundamentals 2 – Lesson 1 (Users) [20]
Write a summary report (2-4 pages) on the users of a database. Also show examples of the
SQL instructions used to manage users, privileges and roles.
1.2) SQL Fundamentals 2 – Lesson 2 (Changes to tables) [20]
Write a summary report (2-4 pages) to describe the below changes that can be made to
tables with examples of possible scenarios, the SQL instructions used and the results
thereof.
• Add-, alter-, and remove columns
• Change the name of columns
• Add-, and remove constraints
1.3) SQL Fundamentals 2 – Lesson 3 (Objects and data dictionary views) [20]
Write a summary report (2-4 pages) on the use of data dictionary views in your database.
Also show examples of the SQL instructions used to create and use them.

Sample Solution

The post SQL Fundamentals appeared first on homework handlers.