every day 1 hour class

Topics Covered

Outline 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

Who should attend

anyone who interested in building database application / to become DBA

Pre-requisites

basic programming kneowledge

What you need to bring

laptop/notebook

Key Takeaways

expertise in sql server