Информация за курса:
Съдържание:
1. Programming .NET Framework Fundamentals
1.1. .NET Framework Architecture
- Common Language Runtime (CLR)
- Intermediate language (MSIL)
- Assemblies and .NET Framework execution model
- Creating, compiling and running .NET applications
1.2. The C# Programming Language – Review
- Primitive data types; Enumerations; Typecasting and conversion
- Variables; Declarations
- Operators
- Expressions; Statements
- Control structures, conditionals, loops (if, switch, for, while, do … while)
- Console input/output
- Creating and using objects
- Defining classes and class members (fields, properties, constants, methods, constructors)
- Static members and static constructor
- Structures
1.3. Inheritance and Polymorphism
- Inheritance and polymorphism
- Abstract classes
- Namespaces
1.4. Interfaces, Indexers and Operators
- Defining, implementing and using interfaces
- Defining and using indexers
- Overloading operators
1.5. Generics
- Generic methods and generic classes
1.6. The C# Programming Language – Part 3
- New enhancements in C# 3.0
- Automatic properties
- Object and collections initializers
- Implicit typed local variables (var keyword)
- Lambda expressions
- Extension methods
- Anonymous types
1.7. Common Type System (CTS) and System.Object
- Built-in types hierarchy
- The base type System.Object; Overriding equality and hash code methods
- Object cloning and ICloneable
- Implementing IComparable
1.8. Value Types and Reference Types
- Value types and reference types; Representation in the memory
- Boxing and unboxing value types
- Passing arguments by value, reference and as output (in, out and ref parameters)
- Nullable types
1.9. Exceptions Handling
- Error handling and exceptions
- Catching and throwing exceptions
- Defining and using custom exception classes
1.10. Arrays and Array Manipulation
- Creating, initializing and using arrays
- Jagged and multidimensional arrays
- Standard algorithms on arrays: sorting, binary search, printing
1.11. String Formatting, Cultures and Internationalization
- String, numbers and date formatting
- Cultures
- Parsing numbers and dates
- Encodings and conversions
1.12. Regular Expressions
- The regular expressions language – literals and meta-characters, character classes, quantifiers, grouping characters, etc.
- Regular expressions API in .NET Framework
- Searching, extracting, validating, splitting and replacing text by regular expressions
1.13. Delegates and Events
- Defining and using delegates and events
- Anonymous delegates
- Predicate methods
- Generic EventHandler delegate
1.14. Collections Classes
- Lists and representation – ArrayList, List
- Queues and representation – Queue, Queue
- Stacks and representation – Stack, Stack
- Hash-tables and representation – HashTable, Dictionary
- Sets and HashSet
- Collections Interfaces: IEnumerable
- Iterators: IEnumerable
1.5. Memory and Resource Management
- Memory management, managed heap and garbage collection
- Resource management, IDisposable and finalizers
1.23. Input/Output
- Binary streams and text streams
- File streams
- Files and directories
2. Databases
2.1. Relational Databases – Fundamental Concepts
- Basic database concepts: database systems, relational databases
- Tables, relationships, multiplicity, primary keys, foreign keys, E/R diagrams, normalization
- Database constraints, indexes, views, triggers, stored procedures
- Database transactions
2.2. Introduction to SQL Server
- Introduction to Microsoft SQL Server 2005
- Using SQL Server Management Studio
2.3. Data Modeling and E/R Diagrams
- Database modeling and entity/relationship diagrams
- SQL Server data types
- Creating E/R models with SQL Server Management Studio
2.4. Introduction to SQL Language – Part 1
- Data manipulation language (DML): SELECT, INSERT, UPDATE and DELETE statements
- Joining tables, inner and outer join
2.5. Introduction to SQL Language – Part 2
- Nested queries
- Aggregate functions and grouping
- Data definition language (DDL): CREATE, ALTER, DROP statements
2.6. Introduction to Transact-SQL
- Introduction to T-SQL
- Stored procedures, functions and triggers
- Transactions management
2.7. Data Access with ADO.NET
- ADO.NET architecture: data providers, connected and disconnected data models
- Using the connected data model: connections, commands, data readers
- Using SQL Server data provider
- Transaction management (Transaction, TransactionScope)
- Using the OLDDB data provider
- Best practices using ADO.NET
2.8. Language Integrated Query (LINQ)
- LINQ building blocks
- Sequences
- Query operators and expressions
- Query expression trees
- LINQ to objects
- Querying collections
- Projection, conversion, aggregation
- Sorting, grouping, joins, nested queries
2.9. LINQ to SQL
- Introduction to object-relational mapping (ORM) technologies
- Introduction to LINQ to SQL
- Using Visual Studio LINQ to SQL Designer
- Using DataContext
- Reading data from LINQ to SQL
- Creating, updating and deleting data from LINQ to SQL
2.10. Introduction to XML
- Basic XML concepts
- Well-formed XML, namespaces
- XML schemas: DTD and XSD
2.11. Processing XML in .NET Framework
- XML Processing in .NET Framework
- Using the DOM parser (XmlDocument): parsing, processing, modifying and creating XML documents
- Using the high performance streaming parser: XmlReader and XmlWriter
- Querying XML documents with XPath
- Performing XSL transformations
- LINQ to XML
2.12. Reflection
- Loading assemblies and classes
- Exploring metadata – assemblies, classes and class members
- Dynamically instantiating classes and invoking methods
2.13. Serialization
- Automatic and custom serialization; Formatters
- XML and binary serialization
Кандидатствай
Назад