فتح باب التسجيل فى Business Application using VB.Net + SQL Server

[adorehearts]

فتح باب التسجيل فى كورس
Business Application using VB.Net + SQL Server
للأستعلام والحجز
2311408
info@it4h.com
الزقازيق - وسط البلد - برج كمال الصارمى امام مجلس المدينة

تفاصيل الكورس

---------------------------------------------Session 1-. 4

INTRODUCTION.. 4

Introduction to programming. 4

The programming as logical process.4

What is the .net framework,why !4

Main components to run the .net application.4

BCL, CTS,CLS,ILC,Metadata,Manifest and CLR.4

CHAPTER 1: Fundamentals. 4

Working with IDE. 4

Install your first copy of VS 2008.4

What is IDE.4

What if we have no IDE.4

Primitive controls. 4

Form.4

TextBox.4

Button.4

ComboBox.4

ListBox.4

---------------------------------------------Session 2-. 4

Understanding variables.4

Constants and variables.4

Declaring variables.4

Visibility of variables.4

Numerical variables. 4

Operators and mathematical manipulating.4

Strings variables.4

Strings properties and functions .4

Casting and converting.4

Date and time variables.4

Date properties and functions .4

Condition statements.4

If statements.4

---------------------------------------------Session 3-. 4

Switch statement – (select case).4

Combine conditions.4

Loops and jump statements. 4

For Next.4

Do While.4

Do Until.4

Goto !.4

---------------------------------------------Session 4-. 5

CHAPTER 2: Calculator project.5

Calculator project.5

Understanding functions ,methods and event handlers.5

get benefit from button Click event to execute something.5

Write your first function to get sum of tow numbers.5

Write your first method to empty text box values.5

Passing parameters to functions and methods.5

---------------------------------------------Session 5-. 5

Arrays. 5

What is array.5

Build your first array.5

For each loop throw the array.5

Multi dimension array.5

Handling exceptions. 5

Syntax errors,Logical errors,Bugs.5

Try,Catch,Finally.5

On error goto.5

Testing and debugging.5

---------------------------------------------Session 6-. 6

CHAPTER 2: OOP. 6

Build your first class.6

Constructor.6

Destructors.6

Access modifiers.6

Write functions,methods and properties.6

Using OverLoad,Override.6

OOP concepts. 6

Inheritance.6

Polymorphism.6

Encapsulation.6

CHAPTER 3: Introduction to SQL Server 2005.7

---------------------------------------------Session 7-. 7

Database concepts.7

SQL Server concepts. 7

Create Database. 7

Attach Database. 7

Create table , define PK , define Index.7

---------------------------------------------Session 8-. 7

Standers SQL. 7

Select , Select Where , Select where Order By,Insert into,Update and Delete.7

TSQL. 7

Create view, table valued Function.7

Create Stored procedure,7

Create trigger.7

ADO .net7

---------------------------------------------Session 9-. 7

Connected mode.7

SqlConnection object7

SqlCommand.7

SqlDataReader object for connected mode. 7

---------------------------------------------Session 10-. 7

. Disconnected mode.7

SqlDatadapter object for connected mode.7

Using Dataset.7

Create Datatable. 7

DataTable members .. DataRow, DataColumn. 7

Dataview.. 7

---------------------------------------------Session 11,12 and 13-. 8

CHAPTER 4: Project Phonebook and organizer8

Advanced Controls.8

Datagridview.8

ListView.8

RichTextBox.8

Arrange objects using object containers.8

MDI concept.8

Filtring and Sorting data .8

Filtering data with standard SQL.8

Filtering data using DataView filter and DataTable select method.8

User experience Enhancements.8

Mouse and keyboard events.8

Using System.IO.. 8

Working with files,directories and drivers.8

Working with windows registry.---------------------------------------------Session 14-. 8

---------------------------------------------Session 14-. 9

CHAPTER 5: Advanced programming. 9

Interfaces.9

Override a function or method.9

Collections. 9

ArrayList.9

HashTable.9

Queue.9

Stack.9

Threading. 9

Background worker.9

Create thread.9

Invoking method within your thread.9

---------------------------------------------Session 15-. 9

Introduction to Crystal reports 9. 9

Create a simple report.9

Using crystal reports experts.9

Using formulas.9

Select expert.9

Sort expert.9

Highlight expert.9

Group expert.9

Implement mail label.9

---------------------------------------------Session 16,17-. 10

Chapter 8 Introduction to software engineering.10

Project Stores - sales and purchase. 10

Project features.10

System analysis overview.10

Planning steps to implement your project.10

Execute the project !!10

---------------------------------------------Session 18-. 11

Chapter 7 Get free from your computer !11

Package and deploy your program.. 11

Create your first package application.11

PreBuildEvent and PostBuildEvent.11

Custom Actions.11

Working with registry.11

.NET COURSE

TABLE OF CONTENT

---------------------------------------------Session 1-

INTRODUCTION

Introduction to programming

The programming as logical process.

What is the .net framework,why !

Main components to run the .net application.

BCL, CTS,CLS,ILC,Metadata,Manifest and CLR.

CHAPTER 1: Fundamentals

Working with IDE

Install your first copy of VS 2008.

What is IDE.

What if we have no IDE.

Primitive controls

Form.

TextBox.

Button.

ComboBox.

ListBox.

---------------------------------------------Session 2-

Understanding variables.

Constants and variables.

Declaring variables.

Visibility of variables.

Numerical variables

Operators and mathematical manipulating.

Strings variables.

Strings properties and functions .

Casting and converting.

Date and time variables.

Date properties and functions .

Condition statements.

If statements.

---------------------------------------------Session 3-

Switch statement – (select case).

Combine conditions.

Loops and jump statements

For Next.

Do While.

Do Until.

Goto !.

---------------------------------------------Session 4-

CHAPTER 2: Calculator project.

Calculator project.

Understanding functions ,methods and event handlers.

get benefit from button Click event to execute something.

Write your first function to get sum of tow numbers.

Write your first method to empty text box values.

Passing parameters to functions and methods.

---------------------------------------------Session 5-

Arrays

What is array.

Build your first array.

For each loop throw the array.

Multi dimension array.

Handling exceptions

Syntax errors,Logical errors,Bugs.

Try,Catch,Finally.

On error goto.

Testing and debugging.

---------------------------------------------Session 6-

CHAPTER 2: OOP

Build your first class.

Constructor.

Destructors.

Access modifiers.

Write functions,methods and properties.

Using OverLoad,Override.

OOP concepts

Inheritance.

Polymorphism.

Encapsulation.

CHAPTER 3: Introduction to SQL Server 2005.

---------------------------------------------Session 7-

Database concepts.

SQL Server concepts

Create Database

Attach Database

Create table , define PK , define Index.

---------------------------------------------Session 8-

Standers SQL

Select , Select Where , Select where Order By,Insert into,Update and Delete.

TSQL

Create view, table valued Function.

Create Stored procedure,

Create trigger.

ADO .net

---------------------------------------------Session 9-

Connected mode.

SqlConnection object

SqlCommand.

SqlDataReader object for connected mode

---------------------------------------------Session 10-

. Disconnected mode.

SqlDatadapter object for connected mode.

Using Dataset.

Create Datatable

DataTable members .. DataRow, DataColumn

Dataview

---------------------------------------------Session 11,12 and 13-

CHAPTER 4: Project Phonebook and organizer

Advanced Controls.

Datagridview.

ListView.

RichTextBox.

Arrange objects using object containers.

MDI concept.

Filtring and Sorting data .

Filtering data with standard SQL.

Filtering data using DataView filter and DataTable select method.

User experience Enhancements.

Menus ,Toolbars

Mouse and keyboard events.

Using System.IO

Working with files,directories and drivers.

Working with windows registry.
---------------------------------------------Session 14-

CHAPTER 5: Advanced programming

Interfaces.

Override a function or method.

Collections

ArrayList.

HashTable.

Queue.

Stack.

Threading

Background worker.

Create thread.

Invoking method within your thread.

---------------------------------------------Session 15-

Introduction to Crystal reports 9

Create a simple report.

Using crystal reports experts.

Using formulas.

Select expert.

Sort expert.

Highlight expert.

Group expert.

Implement mail label.

---------------------------------------------Session 16,17-

Chapter 8 Introduction to software engineering.

Project Stores - sales and purchase

Project features.

System analysis overview.

Planning steps to implement your project.

Execute the project !!

---------------------------------------------Session 18-

Chapter 7 Get free from your computer !

Package and deploy your program

Create your first package application.

PreBuildEvent and PostBuildEvent.

Custom Actions.

Working with registry.