* Learn Database models
* Overview of SQL Server Management Studio and Transact-SQL language
* Master writing simple and complex queries that retrieve data from the database
* Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
* Insert, update, and delete data
* Retrieve data from tables
* Joins
* Sub-queries
* Working with Data Types
* Procedure and Functions
* Understand the different Views
* Working with Triggers
* Design a database
* Maintain databases, tables, and sequences with SQL statements
* Create and manage views
* Ensure the integrity of multiple, related database updates by using transactions
* Retrieve data using cursors
* Manage binary data using BLOBs
