Week 1: SQL Server Basics

• Client-Server database architecture and SQL Server architecture
• Tables, relational databases, SQL and database objects
• Design and develop MS SQL Server databases and tables
• Referencing objects in SQL Server databases
• Obtaining information from database tables
• SQL Server security

Week 2: Understanding Tables and Databases

• Creating databases manually
• Creating databases with database wizard
• Defining a maintenance plan wizard
• Databases using Transact-SQL
• Database manipulation: characteristics and deletions
• Working with tables

Week 3: Indexes and Views

• The basics of index structures
• Creating and working with indexes
• Indexes and table architecture
• Creating views (including using view manager)
• Working with views
• Indexed views

Week 4: Database Diagrams, The Query Analyzer and SQL Basics

• Working with diagrams
• Diagramming for pubs database
• Server connectivity and Sscreen management
• Working with queries
• SQL essentials (select, create table, insert, delete, update)

Week 5: Stored Procedures, Triggers and Replication

• Components of stored procedures
• Creating and working with stored procedures/system stored procedures
• Components of triggers
• Creating and working with triggers
• Replication model and types of replication
• Merge replication

Week 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager

• Creating, importing and exporting DTS
• Creating, scheduling backups and restores
• Authentication types, users, roles, security plans
• Configuring DSN, loading analysis manager and working with cubes
• Work on a final project