Introduction to SQL Server
MS SQL Server is a “world-class” Relational Database Information System platform. Incorporating a tremendous power to scale data as well as the ability to transcend an array of data sources, scaling desktops, portable devices (phones, tablets), and data centers as well as private and/or public clouds. This course is for anyone who is interested in gaining an understanding and a working knowledge of SQL via the flexible MS SQL Server toolset.
Designed to facilitate beginners and/or knowledgeable SQL enthusiasts, this is a hands-on course, which de-mystifies the basics of Administering Microsoft SQL. Topics include: learning how to create and manipulate database objects such as tables, indexes, views, and triggers. Students will learn SQL basics that apply to MS SQL as well as to any major Relational Database Management System (RDBMS); the students will also be introduced to the basics of using SQL Server on the Web. Students will enhance problem solving, analytical and implementation abilities worth maximum currency. Upon completion of this course, students will be a valuable, revenue producing resource on the job and/or in business.
Applicable Job Roles: web programmers, web application developers, database administrators, web designers and data management stakeholders of any sort.
Week 1: SQL Server Basics
Week 2: Understanding Tables and Databases
Week 3: Indexes and Views
Week 4: Database Diagrams, The Query Analyzer and SQL Basics
Week 5: Stored Procedures, Triggers and Replication
Week 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager
MS SQL Server 2012 or previous version, installed on a Windows computer. Download a free copy of Microsoft SQL Server 2012 R2 Express at: http://www.microsoft.com/en-us/download/details.aspx?id=29062
At no Additional Cost, Multimedia (Audio/Video/Gaming), content may be used as part of this courses learning resources.