Like any other form of programming, doing everything in the interpreter is slow and cumbersome, you want to write code
All the commands we have discussed and will discuss can be coded into SQL Scripts and loaded all at the same time
This uses text editors as our application for creation
Linux/Unix
gedit
Vim
Mac/(Unix BSD)
TextEdit
Brackets
Windows
notepad
notepad++