Every Thursday 17:00 -21:00

Description

2.NET targeting students who already know Object Oriented Programming and C#. During 10 sessions the course presents advanced threading and app security notions, working with files and object collections. During the laboratory you will develop complex applications, using your new knowledge. The course is 40 hours, including a final exam.

Objectives

  • App development using system’s types and collections

  • Implementing service processes, threading and application domains in order to allow app’s isolation and multithreading

  • Creating serializable classes to allow their easy stock and share

  • Creating and implementing applications that are easy to maintain

  • Implementing applications that use Input /Output

  • Implementing the searching, modifying and encryption of a text

  • Using collections and generic data types

  • Getting to know a series of classes used for graphics, serialization and threading

  • Implementing application domains and services

Prerequisites:

  • You should have gone through our 1.NET class or equivalent courses.

  • You should already handle C# syntax and OOP concepts.

  • You  must have a passion for complex topics such as security, multi-threading and services.

  • Personal laptop with Visual Studio Community 2017 is not mandatory, but instructors won’t stop you from bringing it.

Lecture Structure:

  • The class will take 40 hours in total;

  • 10 sessions: 8 lecture sessions, 1 session for the partial exam, 1 session for the final exam;

  • a session is  structured in 2 hours of teaching and 2 hours of laboratory

  • Grading system will be decided by each instructor and will be presented at your first lecture.

Price

  • Students: 400 RON

  • Individuals: 500 RON

  • Legal entities: academia.mic.upb@outlook.ro



Every Saturday 10:00 - 14:00

Description

During ten sessions, 1.NET covers the necessary basics for creating a .Net application of medium complexity. The course presents both the structure and syntax of a C# program and the fundamentals of Object Oriented Programming. During the laboratory, you will realize applications in order to test your new knowledge. The class takes 40 hours, including both a partial and a final exam.

Objectives - Curriculum

  • Enumeration of .NET principal concepts and explaining the link between .NET platform and C# programming language

  • Analysis of a basic C# application, including debugging and compilation

  • Creating, naming and attributing values to variables

  • Using instructions to implement flow control operations, cycles and error handling

  • Creating methods (functions and subroutines) that can return values and use parameters

  • Creating, initializing and using arrays and multidimensional matrices

  • Basic Object Oriented Programming concepts

  • Using objects and references

  • Creating, initialization and destruction of C# objects

  • Creating new classes using existing ones

  • Creating autonomous classes and frameworks in a C# application

  • Defining operators and specifications for events

  • Implementing proprieties and indexes

  • Using attributes (existing and personalized)

  • Lambda expressions, extension methods and anonymous methods

Prerequisites:

  • No prior knowledge of programming is required.  This class will begin by presenting you data types and will advance in more complex OOP concepts.

  • You should be eager to learn C# at your own pace.

  • Personal laptop with Visual Studio Community 2017 is not mandatory, but instructors won’t stop you from bringing it.

Lecture Structure:

  • The class will take 40 hours in total;

  • 10 sessions: 8 lecture sessions, 1 session for the partial exam, 1 session for the final exam;

  • a session is  structured in 2 hours of teaching and 2 hours of laboratory

  • The grading system will be decided by each instructor and will be presented at your first lecture.

Price

  • Students: 400 RON

  • Individuals: 500 RON

  • Legal entities: academia.mic.upb@outlook.ro



Every Tuesday 17:00-21:00

Description

This course is divided into ten sessions, two of them checking the understanding, and its target is to teach the students advanced Microsoft SQL Server, starting from basic T-SQL instructions and finishing with advanced concepts, like creating a complex object or using advanced elements.


Its main focus is the efficient and correct use of instructions, in order to achieve a performance as high as possible.


Objectives are Basic Transact-SQL knowledge including:

  • Capacity of using the SELECT instruction to access one or more tables (linked or not) using different relationships in normal, aggregated or hierarchical form

  • Using DML instructions to add, delete or modify database entries

  • Capacity of performing complex searches in large text data

  • Getting information about objects in a database or about a SQL Server 2017 instance

  • Creating tables and custom data types in order to fulfill any data structure, both from Code and UI

  • Improving performance using indexes

  • Assure the integrity of data using restrictions and triggers

  • Creating an interface for applications to use the database independently, using functions

  • Controlling access to database using transactions and lock-ups

  • Basic XML Knowledge


Prerequisites:

  • No previous SQL knowledge required.

Lecture Structure:

  • The class will take 40 hours in total;

  • 10 sessions: 8 lecture sessions, 1 session for the partial exam, 1 session for the final exam;

  • a session is  structured in 2 hours of teaching and 2 hours of laboratory

  • The grading system will be decided by each instructor and will be presented at your first lecture.

Price

Students: 400 RON

Individuals: 500 RON

Legal entities: academia.mic.upb@outlook.ro