SQL Server 2008

ACCORD INFO MATRIX PVT.LTD
chennai, Tamilnadu, India

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: A Team of Professional and Corporate trainers
Term: 120 HRS

Course Description:

'' TECHNOLOGY CURRICULUM

1. CERTIFIED DOT NET APPLICATION DEVELOPER
Fundamental Programming Concepts:
Primitive Methods of writing programs in Machine Code �Disadvantages �Emergence of Middle Level & High Level Languages �Introduction to object �Oriented method of writing programs (OOPs) �Features of OOPs concepts

MICROSOFT.NET
Introduction to .Net Framework �Framework Architecture �Types of Applications - .Net Languages - Common Language Runtime - Memory Management under CLR - Common Type System (CTS) - Base Class Libraries, Assemblies �JIT Compilation �Advantages over other Languages �Memory Management �Managed Code �CTS and CLS �Language Differences and New Features.

Data Presentation:
Introduction to Reports �Introduction to Crystal Engine �Advantages of Crystal Reports over conventional Data Reports - Creation of Crystal Report Format �Crystal report Integration with Windows & Web Applications �Discussion on Data Handling and Reports.

ADO .NET 3.5:
Getting Started with ADO.NET 3.5 - The Structure of ADO.NET 3.5 - Connecting to a Database and Retrieving Data -Best Practices for Managing Connections and Performing Queries. Modifying Data by Using ADO.NET Commands - Inserting, Updating, and Deleting Data - Managing Data Integrity and Concurrency Querying and Maintaining Data by Using DataSets - Creating and Using a DataSet to Retrieve Data - Updating a Database by Using a DataSet -Using a DataSet in an Occasionally Connected Environment Querying and Maintaining Data by Using LINQ - Querying In-Memory Data by Using LINQ Query Expressions Retrieving Data by Using LINQ to SQL - Modifying Data by Using LINQ to SQL . Implementing an Entity Model by Using the ADO.NET Entity Framework - Creating an Entity Data Model by Using the ADO.NET Entity Framework - Querying and Modifying Data by Using the ADO.NET Entity Framework. Building Occasionally Connected Solutions by Using Synchronization Services - Understanding Microsoft Synchronization Services - Downloading Data by Using Synchronization Services - Uploading Data by Using Synchronization Services

ASP.Net:

Client Server Communication �Three-tier Architecture �Namespaces & Objects �Controls: HTML Controls, Server Controls, Validation Controls, Web Forms, Master Pages �Building Controls �Binding Data to ASP.Net Server Controls �Accessing data from a database using ADO.Net �State Management and Web Configuration - Debugging and Tracing Errors �Template Controls �Security in ASP.Net using Website Administration Tool �Relationship between IIS and ASP.Net �Authentication Methods �Authorization & Impersonation �Code Access Security �State Management �Themes & Skins �Creating a Web Application by using ASP.Net.

Visual C#.Net

Getting Started - Introduction to .NET and the .NET Framework - Exploring Visual Studio .NET -Creating a Windows Application Project. Understanding C# Language Fundamentals - Understanding the Fundamentals of a C# Program - Using C# Predefined Types - Writing Expressions - Creating Conditional Statements - Creating Iteration Statements .Creating Objects in C# - Defining a Class - Declaring Methods - Using Constructors - Using Static Class Members. Implementing Object-Oriented Programming Techniques in C# -Designing Objects - Using Inheritance - Using Polymorphism Programming with C# - Using Arrays - Using Collections - Using Interfaces - Using Exception Handling - Using Delegates and Events. Building .NET-based Applications with C# - Examining the .NET Framework Class Library - Overriding Methods from System. Object - Formatting Strings and Numbers - Using Streams and Files Using ADO.NET to Access Data - ADO.NET Architecture - Creating an Application that uses ADO.NET to Access Data - Changing Database Records. Creating Windows-based Applications - Creating the Main Menu - Creating and Using Common Dialog Boxes - Creating and Using Custom Dialog Boxes -Creating and Using Toolbars - Creating the Status Bar - Creating and Using Combo Boxes - Using XML Web Services in a C# Program -Consuming an XML Web Service - Building an XML Web Service. Creating a Web Application with Web Forms -Creating a Web Forms Application

SQL Server:

Introduction to Structured Query Language (SQL) �Identifying different SQL Data types �Adding and Removing rows with INSERT and DELETE �Modifying Existing Data with UPDATE �Retrieving data from tables using Joins & GROUP �Building Stored Routines and Employing Triggers �Creating User Variables �Building User �Defined Functions �Writing Stored Procedures �Passing Data to and from Stored Procedures �Introduction to Client �Server Architecture –SQL Server Setup and Configuration �Creating Virtual Directory - Deploying the Application �Testing the URL �Database Design.

Defining RDBMS Concepts �Mapping Real �world object to Databases and Tables �Determining appropriate Table Schemas �Normalizing Database Tables for Optimal Data Management –Building and Altering Tables �Building Relationships �Adding Indexes to tables for Best Performance �Creating User Accounts �Allocating User Privileges with GRANT and REVOKE - Back up & Recovery Process using Back up Utility �Remote Database Accessibility �SQL Server 2005 msdn �Web casts support �Database upgrade utility �Business Intelligence projects �Supportive Provider for Oracle �Default Options for Oracle connectivity.

XML

Web Services - Alternative Solutions - Evolution of the Web - Benefits - Application Model - Introducing Extensible Markup Language - DTD to define XML Documents - Validating XML documents against a DTD - XML Schemas to define the structure of XML documents - XSL to transform the XML documents and Presenting the data in a Web Browser - XML Document Object Model - Active Server Pages with XML - SOAP, WDSL, DISCO, UDDI, XSD - ADO.Net & XML - Publishing Web Services - Discovery of Web Services - Consuming Web Services - Invoking: HTTP-GET and POST - Invoking: HTTP-SOAP - Creating a Proxy - State & Security - State Management - Security Model - HTTP and Firewalls - Secure Sockets Layer (SSL)- Developing High Performance Applications - Consuming Web Service in Real Time Applications - Integrating Applications - Deploying and Managing Applications.

ADVANCED DOT NET
Windows Presentation Foundation :

Creating an Application by Using WPF - Overview of WPF - Creating a Simple WPF Application - Handling Events and Commands - Navigating Between Pages . Building User Interfaces Defining Layout - Using Content Controls - Using Item Controls -Hosting Windows Forms Controls. Customizing Appearance - Sharing Logical Resources in an Application - Creating Consistent User Interfaces Using Styles - Changing the Appearance of Controls Using Templates - Using Triggers and Animations. Data Binding - Overview of Data Binding - Create a Data Binding - Implementing Property Change Notification - Converting Data - Validating Data. Data Binding to Collections - Binding to Collections of Objects - Using Collection Views -Create Master-Detail User Interfaces - Using Data Templates. Creating New Controls - Overview of Control Authoring - Creating Controls. Managing Documents - Working with Flow Documents - Working with Fixed Documents - Packaging Documents - Printing Documents. Graphics and Multimedia - Displaying 2D graphics - Displaying Images - Displaying 3D Graphics - Going Further with 3D Graphics -Adding Multimedia Support . Configure and Deploy WPF Applications - Deployment Options - Deploying a Standalone WPF Application - Deploying an XBAP Application - Configuring Security Settings .

SilverLight FrameWork:

Understanding Silverlight-Architecture and Versions-Silverlight Hosting-Supported Platform & Browsers-Future Platforms-Silverlight VsWPF-Installing Silverlight-Silverlight Tools-Silverlight Lan ...''

Elements of this syllabus are subject to change.

Phone:044-42328182

School Address/Venue(s):

37/20,Little Mount,MOunt Road
[opp to checkers hotel]
Chennai-600015

Jobs & Resumes: chennai
Houses & Roommates: chennai
Travel Agencies: chennai

Search other schools for SQL Server 2008 training resources.

.NET
ASP .NET
C# .Net
Visual Studio 2008
WCF
WF

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.