In this course, students will learn the basic level of T-SQL programming on MS SQL Server 2012. Students learn basic DDL, DML, and DQL scripting. Additionally, students will be exposed to and gain an understanding of Joins, Sub-Queries. Set-Operators, and various other functions. Furthermore, students will learn a basic level of understanding of (and be able to manipulate and mange) multiple database objects such as tables, views, stored procedures, user-defined functions, triggers, indexes, and cursors.
- Create and manage database objects
- Learn how to use Microsoft Server SQL 2012
- Extract, manipulate, and analyze data