Back To Basics: Stored Procedures, the work horse of the database
Stored procedures are extremely useful objects. Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database. The security barrier is used to prevent the users from needing SELECT, INSERT, UPDATE and/or DELETE rights directly to the database tables and views.
Back To Basics: Views, what exactly are they?
Views are strange objects. They look like tables, can be queried like a table, but they don’t store any actual data. Think of them as a virtual table which has pointers back to the source tables.
Back To Basics: Tables, without them we have nothing to do
Tables are the core of any database platform. Without tables we would be able to process data, but we would have no way to store the data. In the simplest terms tables look like Excel sheets. They both have columns and rows.