What you'll learn:
- Learn how to INSERT, DELETE, UPDATE and QUERY from tables
- Learn about many of the useful built in T-SQL functions (SUM, CNT, AVG...)
- Learn about temp tables and table variables
- Learn about the power of STORED PROCEDURES
This is an in depth course about using and programming with SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.
This course will get you up to speed on executing queries. The final part of the course briefly touches on stored procedures and user defined functions.