DBMS ( Database Management Systems)

Database Management Systems:
- MIcrosoft Access
- Microsoft SQL server

TSQL -> TRANSACT STRUCTURED QUERY LANGUAGE
ENTERPRISE MANAGER: VISUAL/ GRAPHICAL  INTERFACE TO CREATE AND MANAGE DATABASES

QUERY ANALYZER: window to work with databases using SQL statements

Creating new database using ENTERPRISE MANAGER:
- Expand registered SQL server group
- Right click on  databases and select New database
- specify new database name

inventory -> database name

inventory_Data ->inventory_Data.MDF -> data file

inventory_Log ->inventory_Log.LDF  -> transaction log file


Creating new TABLES using ENTERPRISE MANAGER:
- Select and expand database
- select tables from objects list
- right click and select New Table
- Design table structure


Importing/ exporting Data from Other Databases:
- right click on database, select All tasks, select import/export data
- Follow wizard steps