Course Outline |
Module-I: Database concept |
Database and database types Business Application and Integrated database modelsBusiness Process and Data Entity ModelsBusiness Processing Data Flow DiagramData and Table Keys StructureData Normalization and data integrationEntity Relationship DiagramsERD and Data Dictionary Model |
Module-II: Business Analysis Modules (Accounts and Inventory Control) |
Accounts- Multi-Level Chart of Account Accounts-Business Voucher Accounts-Double Entry System Accounts-Business Leger Accounts-General Ledgers Accounts-Trial Balance Accounts-Balance Sheet Accounts-Account ReportingInventory-Product and Product Sale NetworkInventory-Material Management and Purchase SystemInventory-Warehouse and Martial & Product managementInventory-Inventory System and IntegrationInventory-Inventory Reports |
Module-III: Software Engineering Pattern |
Software Development Models and Business ImplementationDesign Pattern TechniquesRequirement Analysis and Design PatternAlgorithm DesignSoftware Testing PatternObject Oriented Software Implementation Techniques |
Module-IV: Database Tool: SQL Server 2008 / Oracle 11g |
SQL Basic Structure of SQL Server 2010Business Data processing Quires Database TablesData Tables and RelationshipsRelation Database System Designing Database ScriptStore ProcedureData Connection ParameterWeb Report and Store ProcedureServer-Data ConstraintsDatabase Import/Export Crystal Report Designing with Data Table Crystal Report Designing with Store Procedure SQL Server Management and Data Commands |
Module-V: Implantation Tool: Asp.Net 2010 / C# 2010 |
Introduction to Asp.netAsp.net Application ArchitectureClient and Server Programming DifferenceServer ControlsClient ControlsHTML Controls and Programming Tags Asp.Net ProgrammingServer Side ProgrammingClient Side Programming Basic Java ScriptAsp.net Properties and MethodsDatabase Connectivity with SQL Server 2008, Oracle and Microsoft AccessCrystal Report DesigningCrystal mater and Child Report StructureCrystal Sub Report DesigningCrystal Report Connectivity with visual basic .NetCrystal Report Database Connectivity with SQL Server 2008, Oracle and Microsoft Access |