Database Administration Fundamentals (SF17SQL1001) – Day 8

We are almost done with the course. This means that we have one more day to learn new material and review all the material. Then we take care of our final (just another lab, but a tad longer).

In the meantime, we have covered how to CREATE and ALTER database objects — DATABASEs, SCHEMAs, TABLEs, VIEWs and COLUMNs.

CREATE object_type object_name
  [code_to_create_object]

DROP object_type object_name
  [code_to_drop_object]

ALTER object_type object_name
  ADD/DROP/ALTER object_type
  [code_to_alter_object]

Download the class notes for day 8.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.