1. A subject introduction – methods of data collection, general 3-layer architecture and modern technological trend of software development.
2. Acquaint with MS SQL 2012 architecture and basic structure of T-SQL query.
3. Data acquisition from one or more data sources (SELECT, JOIN).
4. Sorting and data filtering. Working with data types. Application of system functions in query. Grouping and data aggregation.
5. Application of procedures for activation, using and working with saved procedures in SQL Server.
6. Query optimization, exceptions treatment, errors detection and transact data processing.
7. Introduction to MS .NET Framework, Object-Oriented Programming.
8. Core C# Programming.
9. Database applications design of in ADO .NET.
10. EDM (Entity Data Model) – working with entity data models in MS .NET environmnet.
11. SOA – Service Oriented Architecture.
12. WCF – distribute systems design in .NET.
13. ASP .NET- web technology for data presentation.
14. WPF, WinForm – data presentation in MS Windows.
2. Acquaint with MS SQL 2012 architecture and basic structure of T-SQL query.
3. Data acquisition from one or more data sources (SELECT, JOIN).
4. Sorting and data filtering. Working with data types. Application of system functions in query. Grouping and data aggregation.
5. Application of procedures for activation, using and working with saved procedures in SQL Server.
6. Query optimization, exceptions treatment, errors detection and transact data processing.
7. Introduction to MS .NET Framework, Object-Oriented Programming.
8. Core C# Programming.
9. Database applications design of in ADO .NET.
10. EDM (Entity Data Model) – working with entity data models in MS .NET environmnet.
11. SOA – Service Oriented Architecture.
12. WCF – distribute systems design in .NET.
13. ASP .NET- web technology for data presentation.
14. WPF, WinForm – data presentation in MS Windows.