This course is only available for job-seekers and it is a free programme. Sign up at your local Department of Social Protection or Intreo office. (Click here to find your local office.)

Please quote course code: N94

Within this programme we provide access to entry-level Microsoft Technology Associate (MTA) certifications which cover three fundamental areas of Information Technology (IT), the three courses are as follows:

  1. Database administration fundamentals
  2. Networking fundamentals
  3. Software development fundamentals
The 'Changing Career to IT Sector' programme is a gateway to more advanced IT courses through the eCollege platform. The three courses will help the learner to decide what aspect of IT interests them the most. 
We encourage the learner to complete all three MTA courses. However, learners can complete one of two of the MTA courses and then advance to a higher certified course, which is available through eCollege. 
We support the learners in their decision and advise them on the best career path for them, taking into account other certifications and experience. eCollege have a wide range of subject matter experts which allow us to give the learner the best advice possible to ensure that the correct route is taken by the learner. 

Below is a roadmap we use to help in the decision making.

This course is free for job-seekers, please sign up at your local Department of Social Protection or INTREO office. (Click here to find your local office.)

Please quote course code: N94 (you will be enrolled on the Changing career to IT course)

The Microsoft Technology Associate (MTA) database administration fundamentals course is the first step to becoming a Microsoft-certified database administrator or database developer. This online training course will prepare you for the Microsoft exam 98-364.

MTA is a new entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. It can also serve as a stepping stone to the Microsoft-certified technology specialist exams.

When you successfully complete this course, you will earn an MTA certification as well as access to benefits of the Microsoft Certification Program.

This course will help you to become familiar with concepts and technologies relating to database administration. You will learn about relational databases, queries, stored procedures and the security requirement for databases and the data they store. If you are looking for a career in database administration, this is the first step in your certification journey.

On this course, you will learn how to:

  • Understand core database concepts
  • Create database objects
  • Manipulate data
  • Understand data storage
  • Administer a database

The course is divided into the following sections:

  • Getting started
  • Course resources
  • Understanding core database concepts
  • Creating database objects
  • Manipulating data
  • Understanding data storage
  • Administering a database
  • Test preparation
  • Exam booking

Exam: Database administration fundamentals (98-364)

Cost: €225 (free for job-seekers)

Fee paying information: Click here

Exam retirement date: No date specified

Recommended duration: 16 weeks

Course Prerequisites: None. 

Potential learners should research the course, relational databases, SQL, and Microsoft's SQL Server database management system prior to signing up to make sure they know what the course entails and are making the right choice.  

Recommended prerequisite: Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here, either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.  

 

This course is free for job-seekers, please sign up at your local Department of Social Protection or INTREO office. (Click here to find your local office.)

Please quote course code: N94 (you will be enrolled on the Changing career to IT course)

The Microsoft technology associate (MTA) networking course will provide you with an understanding of fundamental networking concepts. This online training course prepares students for Microsoft exam 98-366.

MTA is a new entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. It can also serve as a stepping stone to the Microsoft-certified technology specialist exams.

When you successfully complete this course, you will earn an MTA certification as well as access to benefits of the Microsoft Certification Program.

On this course, you will learn how about:

  • Network infrastructures
  • Network hardware
  • Protocols and services

The course is divided into the following sections:

  • Getting started
  • Course resources
  • Understanding local area networks (LANs)
  • Defining networks with the open systems interconnect (OSI) model
  • Understanding wired and wireless networks
  • Understanding internet protocol (IP)
  • Implementing transmission control protocol (TCP)/IP in the command line
  • Working with networking services
  • Understanding wide area networks (WANs)
  • Defining network infrastructures and network security
  • Test preparation
  • Exam booking

Exam:  Networking fundamentals (98-366)

Exam retirement date: No date specified

Cost: €225 (free for job-seekers)

Fee paying information: Click here

Recommended duration: 16 weeks

Recommended prerequisite: You should be computer literate, a logical thinker, a problem solver and have an eye for detail.

Suggested progression courses: CompTIA A+ 900 SeriesCompTIA Network+ N10-006

This course is free for job-seekers, please sign up at your local Department of Social Protection or INTREO office. (Click here to find your local office.)

Please quote course code: N94 (you will be enrolled on the Changing career to IT course)

The Microsoft technology associate (MTA) software development fundamentals (exam 98-361) course will teach you fundamental software development concepts and basic programming skills.  

This online course in software development covers the basics of the general-purpose programming language C#, web development with HTML, CSS, JavaScript and ASP.NET, as well as databases, program design and testing.

MTA is a new entry-level credential from Microsoft that validates the foundational knowledge needed to take the first step toward building a successful career in technology. It can also serve as a stepping stone to the Microsoft-certified technology specialist exams.

When you successfully complete this course, you will earn an MTA certification as well as access to benefits of the Microsoft Certification Program.

The course is divided into the following sections:

  • Getting started
  • Course resources
    • Introduction to programming 
    • Computer storage and data types
    • Computer decision structures
    • Handling repetition
    • Error handling
  • Introduction to object-oriented programming
    • Classes and objects
    • Inheritance
    • Polymorphism
    • Encapsulation
  • Understanding general software development
    • Application lifecycle management
    • Algorithms and data structures
  • Understanding web applications
    • Basic web page development
    • ASP.NET web page development
    • Web hostingWeb services
  • Understanding desktop applications
    • Windows Forms applications
    • Console-based applications 
    • Windows services
  • Understanding databases
      • Relational database management systems (RDBMS)
      • Database query methods
      • Database connection methods
  • Test preparation
  • Exam booking

For each section, you will find interactive tutorials, relevant videos, notes, quizzes and more. These should be studied in conjunction with the main text book, provided as part of your eBook library.

The course price includes:

  • All course content
  • 24/7 online access
  • Practice exercises and quizzes
  • Practice exam
  • A certification exam voucher (repeat exam(s) if applicable are not included – job-seekers can repeat the exam once without charge)

Test centres may charge an administration fee. This is not covered in the course price – job-seekers do not have to pay this fee. 

Exam: Software development fundamentals (Exam 98-361)

Exam retirement date: No date set

Cost: €225 (free for job-seekers)

Fee paying information: Click here

Recommended duration: 16 weeks

Prerequisites: No specific cert, although you should have a significant prior computer programming qualification as this is a large broad course.  See recommend prerequisites for options.

You must be highly computer literate, a logical thinker, a problem solver and have an eye for detail. You should have completed research on what computer programming entails, including having viewed some YouTube tutorials. You should want to study computer programming and code writing.

Recommended prerequisite: You should have previous experience in computer programming or programming related certificate.  If you are starting off and wish to study computer programming, you should consider starting with our course Java Foundations Junior Associate or HTML5 Application Development Fundamentals.  Java Foundations, although still challenging has a narrower scope than MTA Software and therefore most beginner programmers should start with Java Foundations over MTA Software.  As a second course learners can then choose from a number of our software development courses including this MTA Software Development course. 

Suggested progression courses: Microsoft Technology Associate (MTA) Networking FundamentalsMTA Database Fundamentals, Java Foundations Junior Associate, Software Testing: ISTQB-Certified Tester Foundation Level, MTA HTML5 Applications Development Fundamentals

Note: Consecutive courses are encouraged, however, only one eCollege computing course should be taken at a time. 

Course information video: