Terms You Need to Know in Database Administration

21 Jan, 2022

1. Table (row, column, primary key, foreign key)

2.View

3. Index (Clustered, non-clustered, composite) -can have either clustered or non-clustered -using sql to create, edit, -index is useful for somthing that is going to be used a lot, only necessary -increase the speed of JOINS

4. Stored Procedure