Programming Diploma



    How to become a programmer? This Diploma has been designed specifically to answer this question and to achieve this goal. As programming languages and techniques have been multiplied and specialized, it becomes very difficult to decide the preferable programming language to be studied in order to become a professional developer. That is why; We are very keen while preparing this Diploma to choose a set of programming tools that you can after studying it, become a professional programmer in .


    NET Technology; and also to identify the correct way to design and test the required program. Our focus and attention have been on the selection of the latest and most advanced programs that will be suitable for labor market mechanisms, and continuous requirements, and ongoing changes in the concepts of information systems and software. Thus, we have organized a selection of homogeneous programs that puts you in the track of professionalism in the field of .NET Technology and Microsoft databases. In addition, the Diploma Graduation Project offers you hands-on experience under supervision of trained and certified specialists.


    • Introducing the trainee to the fundamentals and concepts of object oriented programming.
    • Since most software application use databases one way or the other, it was mandatory to include this field of study in our programming diploma. Our database management system of choice was, of course, Microsoft SQL Server 2008.
    • Due to the success and appeal of C#, whether in desktop application or in web programming, we have it as our programming language of choice.
    • Since it was necessary to introduce a mechanism for the programming language to interact with the related database, ADO.Net 3.5 is an integral part of our programming diploma.


    This Diploma is very significant to:

    • People wishing to become developers of web applications, software and databases •People who work in Programming field and willing to enhance their abilities with computer; to develop of their career.
    • People who have self-studied computer and wish to enrich their knowledge throughout learning advanced skills and finding faster and easier ways to accomplish tasks assigned to them.


    Mastery of Windows operating system (any version) and Internet



    Getting to know the comparison between object-oriented programming and procedural programming Understanding the meaning of an object Recognizing the concept of a class Learning the object-oriented programming main principles: abstraction, encapsulation, inheritance and polymorphism Mastering the implementation of OOP main principles Exploring the relations between classes Topics Concepts of Object-Oriented Programming oDefining object-oriented programming oPitfalls of traditional (procedural) programming oMajor features of object-oriented programming Principles of Object-Oriented Programming oAbstraction oEncapsulation oInheritance oPolymorphism Making the Paradigm Shift oDefining the object oCertain problems in action-oriented approach oObject-oriented thinking What is Abstraction? oDefining abstraction oThe importance of good abstraction oImplementing data abstraction What is Encapsulation? oDefining encapsulation oThe importance of encapsulation oImplementing encapsulation Classes and Objects oDefining the class oClass vs. object oBuilding a class Relations among Classes oThe need for class relations oFinding class relations oBuilding class relations What is Inheritance? oDefining inheritance oThe importance of inheritance oAbstract class, concrete class, and interface oMethod overloading Applying Inheritance oFinding “is a” relationship oA review of abstraction oBuilding class hierarchy What is Polymorphism? oDefining polymorphism oMethod overriding oAbstract methods Applying Polymorphism oPreliminary design, design & redesign oGo after polymorphism oOverloading vs. overriding Aggregation oBig objects are composed of smaller objects oMaking use of aggregation Friend Classes oDefining “friendship” oMaking use of the friendship Nested Classes oDefining nested classes oMaking use of nested classes Some of the Most Famous OOP Languages The Need for Software Engineering oExamples of software errors and failures oEconomy oMaintenance oClear Planning Scope of Software Engineering oRelationship between software engineering and computer science oTeam formation oProject planning oDevelopment process Software Creation Process oRequirements phase oSpecification phase oImplementation phase oMaintenance phase Software Life-Cycle Models oWaterfall model oObject-oriented models Common Steps to Build an Object-Oriented Software System oForming the work team oSelecting a methodology oGathering requirements oPlanning classes oWriting code oDocumenting the project oDeployment Object-Oriented Analysis and Design oDefinition of analysis & design oThe need for analysis & design oObject-oriented analysis & design techniques Design Patterns oDefinition of design patterns oA few examples of design patterns Software Frameworks oDefinition of software frameworks oThe need for software frameworks oExamples of software frameworks Component Programming oDefinition of component programming oThe need for component programming Web Services oDefinition of Web services oThe need for Web services

    SQL Server 2008 Core

    Objectives Learning the basic concepts of database Getting familiar with using Microsoft SQL Server 2008 Designing and developing databases through SQL Server 2008  Creating and customizing the main objects of SQL Server databases Topics Introduction to Databases oBasic Concepts oTable Elements oDatabase Constraints oSystem Development Life Cycle oTable Relationships and Integration oNormalization Overview oNormal Forms SQL Server 2008 Fundamentals oSQL Server 2008 Editions oSQL Server 2008 Overview oThe SQL Server 2008 Environment oManagement Studio Components oPredefined Databases oTransact-SQL Basic Concepts oTransact-SQL Commands oData Type Significance oData Type Categories Basic Data Operations oWriting SELECT Statements oUsing SQL Operators oCustomizing Data Display oGrouping Data oSet Operators oJoin Syntax and Types oInserting Data oUpdating and Deleting Data Managing Databases oDatabase Files oCreating Databases oDetaching and Attaching Databases oCreating Tables oModifying Tables oRemoving Tables oConstraint Guides and Considerations oApplying and Testing Constraints oDatabase Diagram Basics oUsing Database Diagrams oBasic Concepts of Database Transaction oControlling Database Transactions oCreating and Modifying Views oControlling and Removing Views Programming and Administering Databases oBasic Concepts of Stored Procedure oCreating and Executing Stored Procedures oModifying and Removing Stored Procedures oBasic Concepts of Functions oCreating and Calling Functions oModifying and Removing Functions oBasic Concepts of Triggers oManaging INSTEAD OF triggers oBasic Concepts of XML oXML Related Technologies oSQL Server Interaction with XML oInteracting with Scripts oUsing Database Tools oBasic Concepts of Permissions oControlling Database Access

    Visual C# 2008 Core

    Objectives  Getting familiar with Microsoft Visual Studio 2008 IDE and its components. Getting familiar with Visual Studio 2008. Getting an overview of Visual C# 2008 Getting familiar with Visual C# 2008 different applications Getting started with first Visual C# 2008 project Getting familiar with Visual C# 2008 Windows Form Controls Creating Visual C# 2008 forms and projects Adding controls to Visual C# 2008 applications Change the properties of Windows forms and Controls at design time and runtime Enhancing the user interface of Visual C# 2008 applications Recognizing Visual C# 2008 Basic units Learning Visual C# 2008 programming language from scratch Writing simple Visual C# 2008 programming codes Controlling the execution flow of the programming code Repeating the required programming codes automatically Storing, retrieving, and manipulating multiple values Adding functionality to form controls through programming Learning highly developed Visual C# 2008 programming skills Forming and building integrated applications Getting an overview about exception handling Implementing the most important object-oriented programming issues Control the accessibility of members by using the public and private keywords. Creating Microsoft Windows Presentation Foundation applications. Getting familiar with common WPF controls Changing WPF forms and controls properties Defining styles for WPF controls Handling WPF forms events Topics Introduction to Microsoft Visual C# 2008 oMicrosoft Visual Studio 2008 Environment oMicrosoft Visual Studio 2008 Components oIntroduction to Visual C# 2008 oGetting Started with Visual C# 2008 Visual C# 2008 Windows Applications oForm Controls Overview oText Controls oInteraction Controls oDesigning Menus oAdding Functionality to Menus oWorking with View Structure oWorking with the Hierarchical Structure oColors and Fonts Dialog Components oFiles and Folders Dialog Components   Visual C# 2008 Programming Essentials oIntroduction to Variables oReferencing and Using Variables oDeclare Method oCall Method oDefining Scope oOperators oConditional Statements oIteration Statement types oIteration statement usage oIntroduction to arrays oWorking with arrays Visual C# 2008 Programming Techniques oClasses oConstructors oWorking with inheritance oWorking with methods oInterfaces oabstract Classes osealed Classes oIntroduction to LINQ oWorking with LINQ to SQL oLINQ Sample queries oError types oDealing with Error Types Windows Presentation Foundation (WPF) oWPF oText Controls oInteraction Controls oMenus WPF in depth oWPF Events Handling

    ADO.NET 3.5 Core

    Objectives Describe ADO.Net Architecture and Object Model Connect to SQL and other data sources Perform connected database operations Perform disconnected database operations Implement multiple Data View Implement transactions Topics Introduction to ADO.NET oWhat is ADO.NET? oADO.NET and the .NET Framework oADO.NET components o.NET Framework Data Providers oADO.NET object model oConnected objects oDisconnected objects Connecting to Data Sources oSpecifying the data source oSpecifying the server and the database oChoosing the database objects oProgrammatic connection oCreating connection objects oManaging the connection oEstablishing and testing the connection oCustomizing connection strings Retrieving Scalar Values and Result Sets oInstantiating the command object oSpecifying the SQL statement oExecuting the command oRetrieving a result set oSpecifying the SQL query command oReading the result set Working with Data Sets oWhat is a Data Set? oData Set object model oData Set versus Data Tables oData Columns and Data Rows oData Sets properties & constraints oFilling Data Sets manually oFilling Data Sets programmatically oFinding data in Data Sets oRelational Data Sets oCreating relations between Data Tables Working with Data Adapters oWhat is Data Adapter? oData Adapter structure oFilling Data Sets with fetched data oUpdating data sources with Data Sets Working with Data Views oWhat is Data View? oCreating a Data View oManipulating data through Data Views oConverting a Data View to a Data Table Data Sets & Data Sources Integration oManipulating disconnected data oSql Command Builder object oSending disconnected data to applications ADO.NET Transactions oACID properties oConnected mode transactions oDisconnected mode transactions oImplementing transactions


    Course Reviews

    No Reviews found for this course.

    • course Hours: 80
    • course price: EGP
    • Course Dates: