Enrolment and Course Supply

Education field specific Course Offering and the enrollment periods can be found from the bottom of the page. 

Enrollment for studies

The student selection for all Open studies is done based on the order of enrollment. Some paths may also have an interview, written exam or some other method to ensure the student is suitable to study. In this case, the final acceptance to the path is dependent on successfull  accomplishment. Those left to the waiting list will be connected via email, if there are available places in the course. If the student cannot be reached with reasonable time (usually 24 hours), the study place will be offered further. Remember to follow also your Trash-file!

An open studies student must not enroll to courses in the OMA service. Enrollment is always done according the instructions given in the webpages of the Open studies. Unauthorised self-directed enrollment can lead to losing the study right in the Open UAS education.

Note. The degree students of Metropolia University of Applied Sciences cannot study in the Open UAS education of Metropolia, however studying in the Open UAS education of some other UAS is possible. 

To be noted before enrollment

After enrolling you are bind to the payment if you are accepted, so please pay attention carefully to the:

Make sure before enrolling that the studies are not scheduled one on the other!

All parts of the Dialang language test is recommended to complete in support of the self-evaluation for all those who are uncertain of their language level.

Please note, that if you have enrolled to study module or path, you can enroll to only one at a time, so prioritize your primary wish. When enrolling you are immediately bound to the payment, if you are accepted to study, so do not enroll to another path or module before you receive the confirmation of the study place.

Foreign students

Depending on citizenship, foreign students (i.e. students without citizenship of Finland) may need a visa or a residence permit for Open Studies in Finland. Admission of the permit can however be difficult for Open UAS studies as the studies do not lead to a degree. For further information, please visit the website of the Finnish Immigration Service.

Metropolia does not provide foreign students any certificates about Open UAS studies for the application of visa/residence permit.

The studies in Open UAS often contain contact lessons and require attendance in Metropolia UAS (Helsinki, Finland). Studies also require sufficient study and language skills.

Enrolment times

Courses

The enrollment period for the spring 2018 courses has begun in 18.12.2017 at 12:00. The enrollment ends either 14 days before the beginning of the course or is non-stop. This has been stated for each course in the table. 

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

The course offering for the autumn 2018 will be published after 14.5.2018.

Study paths and modules

The enrollment period for the spring 2018 study paths and modules (except for the possible non-stop 100% virtual courses) has ended and enrollments are no longer accepted.

The study paths and modules for the autumn 2018 will be published on 14.5.2018. The enrollment period for the autumn study paths and modules is between 23.7. at 12 am - 29.7.2018. Enrollment happens via an e-form. The e-form link will be in connection to the field specific supply above the path/module table. The link will become active when the enrollment begins.

Course descriptions

Individual courses

The detailed descriptions of the individual courses can be found in the Study Guide. The link to the guide is above the course supply table of each field.

Study Paths and Modules

The detailed descriptions of the study paths and modules for spring 2018 can still be found on the course supply pages by the field of study. The path and module info pages are linked to the supply page, from which there is further a link to the descriptions of the courses in the Study Guide.
In Open UAS there are available individual courses, modules and paths. Modules and paths are combined from courses.

The certain version at a given time is called an "implementation".

There is general information attached to the course, e.g.:

  • assessment criteria
  • learning objectives
  • contents
  • prior knowledge requirements

There is additional Information attached to the implementation are e.g.:

  • evaluation scale
  • evaluation criteria
  • literature
  • location
  • student's workload
  • teacher
  • teaching methods
  • timing
  • tuition language
  • virtual vs. contact

Instructions on how to use the Study Guide:

  1. Copy the beginning of the course code, of that course which you wish to search from the Study Guide, e.g. TX00DG07-3001, copy TX00DG07. You can find the codes from the course offering.
  2. Use the link to access the Study Guide and search for the course with CRTL + F with the code on question.
  3. Choose the course.
  4. In the top of the course information you can see in orange all the different implementations of the course that are offered. Click the implementation that you wish to see, e.g. course TX00DG07, click the implementation 3001. NB! The other implementations might not be offered as open studies.
  5. Please note, that some of the information is for the degree students only, e.g. enrollment periods mentioned in the implementation info are only for the degree students. The enrollment periods for open studies are mentioned in connection to the open studies course offering.

Schedules

How to use Lukkarikone

  1. Type the course code (eg. SX00BN69-3001) in the field "Search word" and press "Search".
  2. Click the symbol before the course name and you'll get a list of the calendar reservations for the course. NB! The timing period in the course information is not always accurate. Always check the actual schedule.
  3. Add the course to the "Study basket" by pressing the "+" sign before the name of the course.
  4. The course is transferred to the course basket in the left bottom.
  5. Repeat the steps 1.-2. with all courses you are interested in.
  6. When you have all courses in the study basket, press "View schedule".
  7. Now you can see the calendar view for the current week. By browsing the weeks you can see the teaching times for each week. If you wish to see all teaching times at once, choose the list –view. In the calendar view you can see the possible overlaps the easiest.
    Please note, that you are not able to save the schedule in the Schedule Machine, but you can print it (pdf online or paper).

To be noted

  • There may always be changes in the schedules, so check the schedules few days before the course starts.
  • The list view in the calendar shows only classes ahead.
  • The overall information about the Study Paths and Modules may be published earlier than the schedules. Only the timing period and the method of implementation (contact teaching / virtual) are mentioned in the information.

If you have already been accepted to studies and have activated your Student ID:

  1. Log in to Lukkarikone with your Student ID and password in the upper right corner.
  2. Choose Settings –tab, where you can choose e.g. your default schedule. The view shows you those courses where you have been accepted.

You can also create and save your own schedule:

  1. Log in to Lukkarikone with your Student ID and password in the upper right corner.
  2. Type the course code (eg. SX00BN69-3001) in the field "Search word" and press "Search".
  3. Add the course to the "Study basket" by pressing the "+" sign before the name of the course.
  4. Repeat the steps 2.-3. with all courses you are interested in.
  5. When you have all courses in the study basket, press "View schedule". Now you can see the calendar view for the current week. By browsing the weeks you can see the teaching times for each week. If you wish to see all teaching times at once, choose the list –view. In the calendar view you can easily check if there are some courses overlapping timewise.
  6. Go to the SETTINGS –tab and save the schedule with the name of your choosing.

Course supply: Culture

Important before enrolling

Before enrolling familiarize yourself carefully with

All parts of the Dialang language test are recommended to everyone planning studies.

Courses

The enrollment period for the spring 2018 courses is course-spesific. The enrollment ends either 14 days before the beginning of the course or is non-stop. This has been stated for each course in the table. The course offering for the autumn 2018 will be published after 14.5.2018.

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

The studies are listed in the table below in alphabetical order primarily by the degree programme and inside the degree by the course name. If the supply includes elective studies for Metropolia degree students (ie. aimed for several degrees), this is mentioned in the degree programme field.

Degree Programme Bachelor/
Master
Course cr Code language 1.st contact lesson OR 100 % virtual Last enrollment day OR non-stop enrollment
No courses left for spring 2018              

Open Study Paths and Modules

The study paths and modules for autumn 2018 will be published on 14.5.2018. The enrollment period for the autumn study paths and modules is between 23.7. at 12 am - 29.7.2018. Enrollment happens via an e-form. The e-form link will be in connection to the field specific supply above the path/module table. The link will become active when the enrollment begins. 

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

Course supply: Business and Administration

Important before enrolling

Before enrolling familiarize yourself carefully with

All parts of the Dialang language test are recommended to everyone planning studies.

Courses

The enrollment period for the spring 2018 courses is course-spesific. The enrollment ends either 14 days before the beginning of the course or is non-stop. This has been stated for each course in the table. The course offering for the autumn 2018 will be published after 14.5.2018.

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

The studies are listed in the table below in alphabetical order primarily by the degree programme and inside the degree by the course name. If the supply includes elective studies for Metropolia degree students (ie. aimed for several degrees), this is mentioned in the degree programme field.

Degree Programme Bachelor/
Master
Course cr Code language 1.st contact lesson OR 100 % virtual Last enrollment day OR non-stop enrollment
Degree Programme in European Business Administration, Degree Programme in International Business and Logistics Bachelor Publications, Digital Imaging and process documentation 3 LX00AD85-3005 en 28.05.2018 14.05.2018
Master's Degree Programme in Business Informatics Master Innovation and Renewal 5 L000DA21-3001 en 13.04.2018 30.03.2018

Open Study Paths and Modules

The study paths and modules for autumn 2018 will be published on 14.5.2018. The enrollment period for the autumn study paths and modules is between 23.7. at 12 am - 29.7.2018. Enrollment happens via an e-form. The e-form link will be in connection to the field specific supply above the path/module table. The link will become active when the enrollment begins. 

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

  • Enrolment form for Business Study Paths and Modules
  • Below you can see the information of study paths and modules. The more detailes can be found from the path/module information, which are linked to the Curriculum Guide. See the instructions on how to use the Curriculum Guide.
  • The schedules can be found from the Schedule Machine.

Alternative for study path

You can also collect a 60 credit module from individual courses, and apply for degree student via the open path application. It is recommended to begin with the core requirement studies that are listed below. Please note that the courses in question are not necessarily always offered for open studies or the course can be already full.

  • Kansantalous 5 op
  • Laskentatoimi 5 op
  • Liike-elämän viestintä 5 op
  • Liike-elämän viestintä englanniksi 5 op
  • Liikejuridiikka 5 op
  • Liiketalouden matematiikka ja tilastollinen analyysi 5 op
  • Logistiikka ja toimitusketjun hallinta 5 op
  • Markkinointi 5 op
  • Rahoitus 5 op
  • Tietotekniikka ja toiminnanohjaus 5 op
  • Tulevaisuuden työyhteisö 5 op
  • Yritystoiminta 5 op

Course supply: Health Care and Social Services

Important before enrolling

Before enrolling familiarize yourself carefully with

All parts of the Dialang language test are recommended to everyone planning studies.

Courses

The enrollment period for the spring 2018 courses is course-spesific. The enrollment ends either 14 days before the beginning of the course or is non-stop. This has been stated for each course in the table. The course offering for the autumn 2018 will be published after 14.5.2018.

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

The studies are listed in the table below in alphabetical order primarily by the degree programme and inside the degree by the course name. If the supply includes elective studies for Metropolia degree students (ie. aimed for several degrees), this is mentioned in the degree programme field.

Degree Programme Bachelor/
Master
Course cr Code language 1.st contact lesson OR 100 % virtual Last enrollment day OR non-stop enrollment
No courses left for spring 2018              

Open Study Paths and Modules

The study paths and modules for the autumn 2018 will be published on 14.5.2018. The enrollment period for the autumn study paths and modules is between 23.7. at 12 am - 29.7.2018. Enrollment happens via an e-form. The e-form link will be in connection to the field specific supply above the path/module table. The link will become active when the enrollment begins. 

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

Students in Open UAS path studies usually aim to become degree students later. It's a good idea to check the health requirements of the degree students already before enrolling to the Open Study Path.

Course supply: Technology

Important before enrolling

Before enrolling familiarize yourself carefully with

All parts of the Dialang language test are recommended to everyone planning studies.

Courses

The enrollment period for the spring 2018 courses is course-spesific. The enrollment ends either 14 days before the beginning of the course or is non-stop. This has been stated for each course in the table. The course offering for the autumn 2018 will be published after 14.5.2018.

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

The studies are listed in the table below in alphabetical order primarily by the degree programme and inside the degree by the course name. If the supply includes elective studies for Metropolia degree students (ie. aimed for several degrees), this is mentioned in the degree programme field.

Degree Programme Bachelor/
Master
Course cr Code language 1.st contact lesson OR 100 % virtual Last enrollment day OR non-stop enrollment
Master's Degree Programme in Business Informatics Master Innovation and Renewal 5 L000DA21-3001 en 13.04.2018 30.03.2018

Open Study Paths and Modules

The study paths and modules for the autumn 2018 will be published on 14.5.2018. The enrollment period for the autumn study paths and modules is between 23.7. at 12 am - 29.7.2018. Enrollment happens via an e-form. The e-form link will be in connection to the field specific supply above the path/module table. The link will become active when the enrollment begins. 

There are also 100% virtual courses available in Open Studies offering which are offered non-stop round the year. The enrollment is also non-stop for these studies. Virtuality has been mentioned in connection with the studies.

See also

There are two free of charge study modules in the Information Technology degree (see links below). Enrol in the modules via the links. All information on the modules: Mira Myllärinen, mira.myllarinen metropolia fi.

Study module: Game Artist (30 cr)
Study module: Game Business (25 cr)

Course supply: NonStop Virtual Studies (Information and Communication Technology)

Information and Communication Technology

Our courses are NonStop courses and they are 100 % online.

You can enroll and start them whenever it is suitable for you. All you need is a web browser and working network connection. 

Contact information

Virve Prami, Programme Coordinator
virve.prami metropolia fi
tel. +358 40 195 9770

Contacts primarily via email.

Open UAS Students Enrolments with eform

NOTICE! Open UAS cost 15 euros/credit

Course descriptions

The Cisco CCNA Training Package 16 ECTS (240 euros)

Training package provides students the knowledge and skills of from Local Area Networks, Internetworks, Virtual Local Area Networks and Wide Area Networks, as in certification CCNA 200-125. Whole course is done in the web environment, which contains instruction and teaching videos, labs, practise exams. Web environment works with web browser, no additional installation is required. Contact person: Mrs. Virve Prami.

Microsoft Certified Solutions Associate (MCSA) 18 ECTS (270 euros)

Now you have an excellent opportunity tuo complete the whole Microsoft Certified Solutions Associate (MCSA) certification degree 100% in virtual environment. This environment includes certifications 70-710, 70-711 and 70-712 (Windows Server 2016, and all of them are part of Bachelor of Science Degree. Each course in 6 credits, so the whole degree is totally 18 credits. You can start whenever you want. Whole package is done virtual environment just with web browser. This virtual environment contains concrete labs for skills, and instructional videos and practise exams for knowledge. Contact: Mrs. Virve Prami.

Security Solutions (SSCP certification) 8 ECTS (120 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practise tests. All you need is a web browser and working network connection. The course can be included to Master Degree Programme in Information Technology  Contact: Mrs. Virve Prami.

CSSIP Certified Information System Security Professional 8 op (120 euroa)                     

This course is an review course that contains information security concepts and industry best practices, covering the 8 domains of the CISSP Common Body of Knowledge (CBK)®:

  • Security and Risk Management
  • Asset Security
  • Security Engineering
  • Communications and Network Security
  • Identity and Access Management
  • Security Assessment and Testing
  • Security Operations
  • Software Development Security

This course will expand upon your knowledge by addressing the essential elements of those eight domains that comprise a Common Body of Knowledge (CBK)® for information systems security professionals. The course offers a job-related approach to the security process and will prepare you to pass the 2015 version of the CISSP® exam. Contact: Mrs. Virve Prami.

Administration Essentials for Salesforce 8 ECTS (120 euros)

Administration Essentials for Salesforce course is designed for individuals who want to learn configure and maintain Salesforce. The course is based on official Salesforce administrator certificate (please look detailed information here).   Contact: Mrs. Virve Prami.

Introduction to Computing 5 ECTS (75 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practise tests. All you need is a web browser and working network connection. The aim of the course is to practise CompTIA A+ 220-801 and CompTIA A+ 220-802 certificates, which you can do in our Testing Center. Contact: Mrs. Virve Prami.

Basic and advanced Unix/Linux 8 ECTS (120 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practise tests. All you need is a web browser and working network connection. Contact: Mrs. Virve Prami.

Advanced Usage of Office Programs 6 ects (90 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practise tests. All you need is a web browser and working network connection. Contact: Mrs. Virve Prami.

IT Service Management 6 ects (90 euros)

The foundation for the course is the Information Technology Infrastructure Library (ITIL). The ITIL is a set of concepts and policies for managing information technology (IT) infrastructure, development and operations. ITIL's best practices (an approach or a method that has proven itself in practise) in IT service management have been globally accepted in both private and public sectors and they have become de-facto standards. After completing the course, you receive a free try of EXIN's official ITIL foundation certification in our testing center. Contact: Mrs. Virve Prami.

Prep course for TOEFL language test 5 ETCS (75 euros)

More than 30 million people from all over the world have taken the TOEFL® test to demonstrate their English-language proficiency. It is used more than 9,000 colleges, agencies and other institutions in over 130 countries as an admission criteria. Metropolia provides online course, which is 100 % distance learning. Contact: Mrs. Virve Prami.

Google Apps for Education 3 ECTS (45 euros)

Google Apps for Education (GAFE) is a core suite of productivity applications that Google offers to schools and educational institutions for free.  These communication and collaboration apps include Gmail, Calendar, Drive, Docs and Sites, and a GAFE account unlocks access to dozens of other collaborative tools supported by Google. Google Classroom was released in the Fall of 2014, to enhance the workflow of teachers using Google Apps for Education in the Classroom.

All of these applications exists completely online (or in the cloud), meaning that all creations can be accessed from any device with an Internet connection. Whether your school has laptops, Android tablets, iPads, MacBooks, desktop PCs or any other device, Google Apps will work for you. With Google Apps you can work anytime, anywhere on any device. Offline Gmail and Docs mean you don’t always need internet access.

The Google for Education training offers in-depth training for educators at every level. The course is self-paced, guided, and designed to address real classroom needs.  Contact: Mr. Ari Moilanen

Google Apps for Works 3 ECTS (45 euros)

Google Apps for Work is a suite of cloud computing productivity and collaboration software tools and software offered on a subscription basis by Google. It includes Google's popular web applications including Gmail, Google Drive, Google Hangouts, Google Calendar, and Google Docs.

Ideally suited for small businesses, Google Apps will provide you with many tools to help you succeed. One benefit is that Google Apps includes some great mobile tools. All of the apps are available on mobile phones and tablets (iOS or Android), as well as Windows, Mac, or Linux computers Contact: Mr. Ari Moilanen.

Ethical Hacking 6 ECTS (90 euros)

As the security mindset in any organization must not be limited to the silos of a certain vendor, technologies or pieces of equipment.

This course was designed to provide you with the tools and techniques used by hackers and information security professionals alike to break into an organization. As we put it, “To beat a hacker, you need to think like a hacker”. This course will immerse you into the Hacker Mindset so that you will be able to defend against future attacks. It puts you in the driver’s seat of a hands-on environment with a systematic ethical hacking process:

Establish and govern minimum standards for credentialing professional information security specialists in ethical hacking measures.
Inform the public that credentialed individuals meet or exceed the minimum standards.
Reinforce ethical hacking as a unique and self-regulating profession.
The labs are performed in a protected web-based training environment, Practice Labs.

The course can be included in Metropolia’s Master studies. Course materials are in English. . Contact Kari Järvi

Basic Network Analyzing with Wireshark 3 ECTS (45 euros)

Wireshark (formerly “Ethereal”) has become the de facto industry standard open source product for network analysis, troubleshooting and security. Wireshark network analyzer is quickly becoming the industry standard. The Wireshark Certified Network Analyst Test (WCNA) recognizes knowledge of network sniffing and analysis using Wireshark, as well as TCP/IP network communications, network troubleshooting and network security. To achieve this credential, candidates must pass one multiple-choice exam. The labs are performed in a protected web-based training environment, Practice Labs. Course materials are in English.

Contact:: Kari Järvi

Administering and Deploying System Center 2012 Configuration Manager, 70-243), Remote/Etäopetus 5 ECTS (75 euros)

Get detailed instruction and hands-on practice planning and deploying Microsoft System Center 2012 R2 Configuration Manager and its associated site systems. This  course is designed for IT Professionals who are responsible for designing and deploying one or more System Center 2012 R2 Configuration Manager sites and all supporting systems, as well as configuring and managing endpoints in those systems.

You will learn how to plan for the deployment of the central administration site, one or more primary sites and secondary sites, and all associated site systems. You will also learn how to migrate from System Center 2012 Configuration Manager to System Center 2012 R2 Configuration Manager.

This course also helps candidates prepare for Exam 70-243, MCTS: Administering and Deploying System Center 2012 Configuration Manager. Contact Tapio Wikström

Advanced Solutions of Microsoft SharePoint Server 2013, remote/etäopetus 6 ECTS (90 euroa) (not for Metropolia’s degree students)

This course examines how to plan, configure, and manage a Microsoft SharePoint Server 2013 environment.  

Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the Search experience, how to develop and implement a governance plan, and how to perform an upgrade or migration to SharePoint Server 2013.

This course will help you understand the objectives and competencies required by the MCSE/MSCM: 70-332 certification.

This course utilizes web-based laboratory exercises. An exercise key is required to activate exercises.

Contact Kari Järvi

Configuring Windows 10 Devices, 20697-1/2, 6 op (90 euroa)

This course is intended for IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. The networks with which these professionals typically work are configured as Windows Server domain-based environments with managed access to the Internet and cloud services. Students who seek certification in the 70-697: Managing Windows 10 Devices exam also will benefit from taking this course.

Contact: Kari Järvi

Installing and Configuring Windows 10, 70-698), remote/etäopetus, 6 op (90 euros)

This course is intended for IT pros who are seeking certification in the 70-698 Installing and Configuring Windows 10 exam. These professionals typically administer and support Windows 10 devices in corporate, Windows Server domain-based environments with managed access to the Internet and cloud services.

Prerequisites Windows 10 -käyttö ja hallinta (20697-1: Installing and Configuring Windows 10) and Windows 10 ‑ylläpito (20697-2: Deploying and Managing Windows 10 Using Enterprise Services).

Earning the MCSA: Windows 10 certification validates your skills configuring devices running Windows 10. This foundational certification proves that you have the core skills to understand Windows 10 security and integrate Azure features. This course is a part of requirements for the MCSA: Windows 10 certification.

This course utilizes web-based laboratory exercises. The labs are performed in a web-based training environment, Practice Labs. An exercise key is required to activate exercises.

Contact  Kari Järvi

Installing and Configuring Windows Server 6 ECTS (90 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practice tests. All you need is a web browser and working network connection. Course is 100% in virtual environment and it includes certifications 70-410.  Contact: Mrs. Virve Prami.

Administering Windows Server 6 ECTS (90 euros)

The course is delivered in virtual learning environment which includes learning videos, hands-on labs, learning material and practice tests. All you need is a web browser and working network connection. Course is 100% in virtual environment and it includes certifications 70-411.  Contact: Mrs. Virve Prami.

Microprocessors 5 ECTS (75 euros)

  • basic CPU structure
  • machine language and instruction set
  • data types
  • storage of data in memory
  • addressing modes
  • interrupts
  • principles of assembler programming
  • CISC vs RISC and load/store architecture
  • Intel 8086 and 80186 (or similar) microprocessor
  • Basic ideas of other processor architectures

 Contact: Mrs. Virve Prami.

Introduction to Database Management 5 ECTS (75 euros)

Data models and information systems. Conceptual modelling. Principles of relational databases. Implementation and normalisation of a relational database. Data definition language. Data manipulation language. SQL. Relational algebra.

 Contact: Mrs. Virve Prami.

Excel Basics 3 ECTS (45 euros)

Excel is included in the Microsoft Office suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.

In addition to its standard spreadsheet features, Excel also offers programming support via Microsoft's Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE), and extensive graphing and charting capabilities.  Contact Tapio Wikström

Querying Data with Transact-SQL 6 ects (90 euros)

After taking the Querying Data with Transact-SQL course, which prepares for 70-761 certification, student knows how to manage data with Transact-SQL, Query data with Advanced Transact-SQL components and Program databases using Transact-SQL. Course is done using web browser and virtual machines in the web Contact: Mrs. Virve Prami.

SQL Server Developer 6 ects (90 euros)

After taking the SQL Server Developer, which prepares for 70-762 certification, student knows how to design and implement database objects, implement programmability objects, manage database concurrency and optimize database objects and SQL infrastructure. Course is done using web browser and virtual machines in the web Contact: Mrs. Virve Prami.

Administering a SQL Database Infrastructure 6 ects (90 euros)

After taking Administering a SQL Database Infrastructure course, which prepares for 70-764 certification, student knows how-to configure data access and auditing, manage backup and restore of databases, manage and monitor SQL Server instances, manage high availability and disaster recovery. Course is done using web browser and virtual machines in the web.  Contact: Mrs. Virve Prami.

Introduction to ASP.NET Web Forms 5 ECTS (75 euros) 

The goal of this course is for the student to be familiar with ASP.NET Web Forms as one of the most powerful server-side Web application framework. After passing this course, the student will have sufficient knowledge and understanding over characteristics, abilities, and features of ASP.NET and .NET Framework. The students will be able to create a whole new project and work with all the major ASP.NET server controls. To finalize the getting best out of ASP.NET features, the students will be familiar with user controls, state management, master pages. Finally, by understanding the difference between dynamic and static applications and websites, the students will be able to have the knowledge of creating dynamic applications and websites.

This course is 100% virtual thanks to the comprehensive tutorial videos made for this course.

The student will pass this course after submitting required assignments and project. Contact:Farhad Eftekhari

Mastering Search Engine Optimization (SEO) 5 ECTS (75 euros)

The goal of this course is for the student to be familiar with process of Search Engine Optimization (SEO) and learn to affect the visibility of a website or a web page in search engines results to increase the number of visitors coming from search engines. SEO is one of the most practical concepts of web development. After passing this course, the student will be able to analyze the SEO status of a web application and provide solutions to empower such web application in SEO concepts.

This course is 100% virtual thanks to the comprehensive tutorial videos made for this course.

The student will pass this course after submitting required assignments and project. Contact:Farhad Eftekhari

Mastering the Fundamentals of RESTful API Design  (90 euros)

Designing APIs for use over the web is a key part of most web development projects these days. Knowing the best way to design them with longevity, testability and reliability in mind is important. The goal of this course is for the student to be familiar with APIs, the concept of API Design and what is essential to design of an API-based solution. By explaining API Design steps and API Design approaches, the student will be familiar with all these concepts in a practical way. Then the student will be familiar with different API styles, and obtain a deeper level of knowledge about REST and its key difference and advantageous over the other styles. Finally, the student will understand security and performance concerns.

This course is 100% virtual thanks to the comprehensive tutorial videos and content made for this course.

The student will pass this course after submitting required assignments, quiz and projects.  Contact teacher: Contact:Farhad Eftekhari

Developing Modern Web Platforms (HTML,CSS,JS) 15 ECTS (225 euros) 

The goal of this course is for the student to be familiar with required technologies to develop modern web platforms. After passing this course, the student will be able to select between primary technologies in web designing to work with them, and also develop projects and websites using such technologies. The student will be introduced to HTML as a markup language for describing web documents, and then will be familiar with CSS to apply styles on HTML elements, and finally learn JavaScript as an interpreted language to add dynamic functionalities to web applications. Together, they are among the essential technologies of World Wide Web content production.

This course is 100% virtual thanks to the comprehensive tutorial videos and content made for this course.

The student will pass this course after submitting required assignments and project. Contact:Farhad Eftekhari

Mastering Version Control with Git 6 ECTS (90 euros)

The goal of this course is for the student to be familiar with the concept of Version Control and the advantageous of using such systems in software development. Then the student will be fully introduced to Git as one of the most powerful and popular version control systems. After passing this course, the student will be able to work in teams of development and fully be able to participate simultaneously in order to add features to a software developing project in parallel with other team members. Finally, the student will get familiar with Github as a web-based Git repository hosting service.

This course is 100% virtual thanks to the comprehensive tutorial videos made for this course.

The student will pass this course after submitting required assignments and project. Contact:Farhad Eftekhari

Developing Chatbots using Microsoft Bot Framework (6 ECTS) (90 euros)

The goal of this course is for the student to be familiar with Microsoft Bot Framework as one of the widely used chatbot frameworks. After passing this course, the student will be able to understand different components of the framework and will be able to build intelligent chatbot using LUIS a NLU service by Microsoft and connect with different communication channels like Facebook, Website, slack etc. And also, will be able to deploy chatbot to production and get an idea about managing bot using Azure services.

This course is 100% virtual thanks to the comprehensive tutorial videos made for this course.

The student will pass this course after submitting required assignments and project. 

Contact:Farhad Eftekhari

Responsive Web Applications with Bootstrap & CSS (8 ECTS) (120 euros)                                

Nowadays, developing mobile-first web applications is a necessary approach. Not only the websites need to be fully functional, but also the User Experience and User Interface need to be fully compatible to the web standards. In this course, the student gets familiar with Bootstrap as one of the most powerful and popular CSS frameworks, and will be able to get the best out of various features and functionalities of such framework to develop elegant and responsive web applications.

This course is 100% virtual thanks to the comprehensive tutorial videos and content made for this course. The student will pass this course after submitting required assignments, quiz and projects. Contact:Farhad Eftekhari

Basics of Android Programming 4 ECTS (60 euros)

Introduction, Setting up the Working Environment, Activities and Intents, Layouts and Views, Events and Notifications, Storing Data, Broadcast Receivers, Services, Modified User Interfaces, Using a Database Contact: Mrs. Virve Prami.

Microsoft Windows PowerShell 5 ECTS (75 euros)

  • Windows PowerShell 3.0 Fundamentals and using as an Interactive command-Line Shell
  • PowerShell Cmdlets and PowerShell Pipeline
  • Windows Management Instrumentation
  • Windows PowerShell Scripts
  • Background Jobs and PowerShell Remoting
  • Automating Workstation/Active Directory Administration.

Contact: Mrs. Virve Prami.

PHP Programming 3 ECTS (45 euros)

Introduction to PHP, www and PHP, variables, statements and control structures, tables and other data structures in PHP, using functions, files, data security, examples  Contact: Mrs. Virve Prami.

Game Programming with Unity 5 ETCS (75 euros)

This course is aimed at anyone willing to learn about game programming with a game engine. The course includes 8 chapters of theory material, which is first giving an introduction to different topics and then followed by a laboratory-like approach. You will be creating a fully playable Arkanoid -style game during the course. Elementary skills of computer programming is required. The programming language for this course is JavaScript. Contact: Mrs. Virve Prami.

Generic Software courses 18 ECTS (270 euros)

(you can also pick up single courses from this package)

  • SQL and Relation Databases (3 ects)
  • Python Programming (3 ects)
  • PHP Programming (3 ects)
  • Introduction to Java Programming (3 ects)
  • C++ Programming (3 ects)
  • C Programming (3 ects)

Contact Teacher for all Generic Software courses Contact: Mrs. Virve Prami.

Finnish