IN THIS PROGRAM STUDENT WILL LEARN THE BASIC CONCEPTS OF RELATIONAL DATABASES AND THE POWERFUL SQL LANGUAGE.. CANDIDATES ALSO LEARNS SQL SKILLS THAT ALLOW DEVELOPERS TO WRITE QUERIES AGAINST SINGLE AND MULTIPLE TABLES, MANIPULATE DATA IN TABLES, AND CREATE DATABASE OBJECTS. THE STUDENTS ALSO LEARN TO USE SINGLE ROW FUNCTIONS TO CUSTOMIZE OUTPUT, USE CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS AND USE GROUP FUNCTIONS TO REPORT AGGREGATED DATA. DEMONSTRATIONS AND HANDS-ON PRACTICE REINFORCE THE FUNDAMENTAL CONCEPTS.


  • STUDENTS WILL ALSO HAVE A CHOICE OF ONE OF OBJECT ORIENTED PROGRAMMING (C#, VB.NET OR ASP.NET) LANGUAGE. THE .NET FRAMEWORK

  • C# - LANGUAGE FUNDAMENTALS

  • C# OBJECT ORIENTED (OOPS) WINDOWS APP/WEB APPLICATION USING ADO.NET

  • WEB SERVICES - SOAP, WSDL, ASP.NET WEB SERVICES

  • STREAMS

  • ASSEMBLIES AND VERSIONING

  • ATTRIBUTES AND REFLECTION

  • THREADS

  • .NET AND COM

  • INTRODUCTION – JAVASCRIPT, AJAX AND WEB SERVICES

  • VB.NET: COURSE CONTENT: DEVELOPING MULTITIER APPLICATIONS

  • DIVIDING LOGICAL LAYERS INTO MULTIPLE COMPONENTS

  • REUSING COMPONENTS WITH DIFFERENT UIS

  • PERSISTING COMPONENT DATA INTO DATABASES

  • THE .NET FRAMEWORK

  • COMMON LANGUAGE RUNTIME (CLR)

  • CLR ARCHITECTURE AND SERVICES

  • COMPILING VB CODE INTO INTERMEDIATE LANGUAGE

  • FRAMEWORK CLASS LIBRARY (FCL)

  • WINDOWS AND WEB FORMS AND CONTROLS

  • FILE I/O

  • REGULAR EXPRESSIONS

  • DATA ACCESS WITH ADO.NET

  • HETEROGENEOUS AND GENERIC COLLECTIONS

  • KEY VISUAL BASIC ADVANTAGES

  • USER INTERFACE DESIGN

  • WEB AND WINDOWS FORMS AND CONTROLS

  • AUTOMATING DATA-DRIVEN APPLICATION CONSTRUCTION

  • LEVERAGING DATA BINDING WITH BINDING SOURCES

  • WEB FORMS WITH ASP.NET

  • VALIDATING WEB FORMS DECLARATIVELY

  • VB PRODUCTIVITY ENHANCEMENTS

  • DOCUMENTING WITH XML CODE COMMENTS

  • EDIT AND CONTINUE DEBUGGING

  • CODE SNIPPETS

  • DEBUGGER VISUALIZATION

  • MY NAMESPACE CHARACTERISTICS

  • INTEGRATED UNIT TESTING

  • VB LANGUAGE ENHANCEMENTS

Week-1: Read chapter 1, 2 and 3

  • SQL Server Basics

  •     Client-Server database architecture and SQL Server architecture

  •     Installing MS SQL Server (2008, 2012 or earlier)

  •     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: Read chapter 4, 5 and 6 and Complete all exercise of chapter 3 and 4

  • 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

  • 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-3: Read Chapter 7, 8 and Complete all exercise of chapter 6 and 7

  • Database Diagrams, The Query Analyzer and SQL Basics

  •     Working with diagrams

  •     Diagramming for pubs database

  •     Server connectivity and Screen management

  •     Working with queries

  •     SQL essentials (select, create table, insert, delete, update)

  • Stored Procedures, Triggers and Replication

  •     Components of stored procedures

  •     Creating and working with stored procedures/system stored procedures

  •     Components of triggers


Week-4: Read Chapter 9

  • 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


Week-5: Read Chapter 10

  •     Creating, scheduling backups and restores

  •     Authentication types, users, roles, security plans

  •     Configuring DSN, loading analysis manager and working with cubes


Week-6: Read Chapter 11

  •     Creating and working with triggers

  •     Replication model and types of replication

  •     Merge replication


Week-7: Read Chapters 1-2 of  textbook; do the questions at the end of chapters 1 and 2

  • The .NET Framework

  • C# - Language Fundamentals


Week-8: Read Chapters 3-4 of  textbook; do the questions at the end of chapters 3 and 4

  • OOPS Part I – Making Classes and objects, Boxing and UnBoxing

  • OOPS Part II – Inheritance, Polymorphism, Overloading


Week-9: Read Chapters 5-6 of  textbook; do the questions at the end of chapters 5 and 6

  • Array, Indexers and Collections

  • String and StringBuilder


Week-10: Read Chapters 7-8 of  textbook; do the questions at the end of chapters 7 and 8

  • Structs

  • Interfaces

  • Introduction to Exceptions

  • Introduction to Delegates and Events


Week-11: Read Chapters 9-10 of  textbook; do the questions at the end of chapters 9 and 10

  • Revision of C# and Introduction to Exception and Delegates

  • Exceptions Details

  • Delegates and Events Details

  • Windows App/Web Application using ADO.NET

  • Web Services - SOAP, WSDL, ASP.NET Web Services


Week-12: Read Chapters 11-12 of  textbook; do the questions at the end of chapters 11 and 12

  • Streams

  • Assemblies and Versioning

  • Attributes and Reflection

  • Threads

  • .NET and COM