Microsoft Certifications - Portuguese Study Material for Your First Certification (MTA)

First of all, let's take a look at Microsoft's current certifications for the Data Platform and start getting familiar with the acronyms:

• Microsoft Technology Associate (MTA): This is Microsoft's first and easiest certification exam, designed for people just starting their careers and still getting familiar with the technology. With just 1 proof, you already get MTA certification in the desired field.

  As an incentive to take the MTA test, Microsoft gives you a small discount on taking this exam (you pay $ 77 instead of $ 100 for other MCSA and MCSE tests)

  Remember that the MTA exam does not guarantee you the title of MCP and is not a prerequisite for taking the MCSA and MCSE exams and therefore doing it is optional.

• Microsoft Certified Solutions Associate (MCSA): Medium / high level test, aimed at people who already have experience with the technologies involved. Once you pass any MCSA exam, you earn the Microsoft Certified Professional (MCP) title.

  In addition, MCSA certification is a prerequisite for MCSE certification. You can even take the MCSE exams before you have the MCSA title,
  but will only effectively win the title when you earn the MCSA (if you have already passed the MCSE exam, you will earn the 2 certifications together)

• Microsoft Certified Solutions Expert (MCSE): Microsoft's latest level of certification exams, MCSE exams are often the most difficult of Microsoft exams, and should be performed by highly-skilled professionals with extensive experience and expertise in the technologies in question.

As I commented here in the post, the MTA exams are more theoretical than the MCSA and MCSE exams, charging more theory than everyday, more general real scenarios, not going much deeper into a specific technology. Generally speaking, the target audience for MTA certification is students who want to enter the job market through internship and are looking for a way to stand out, or even JR analysts who are trying to demonstrate to their company that they are looking to improve and study more.

I believe this proof should not be much sought after by analysts PL, SR or above, since these professionals must already be seeking (or already have) MCSA and MCSE certifications, which are more difficult to obtain and much more technical titles. , already focused on technologies and very specific subjects and with much more practice and scenarios that occur in the daily lives of these professionals.

Sure! Regardless of your career level, I believe a certification is always welcome. Just above, I mentioned the target audience for MTA certification.

If you are a student and now entering the job market, this is definitely the first certification exam you should look for, as it is more theoretical and the exam is not so complicated. This helps a lot and learn more about how the certification process works and what Microsoft evidence is like.

I have had some acquaintances who, already in their first test, tried to do an MCSA test without having much experience in the subject. These people did not do very well in the test and took a certain fear of certification tests. For this reason, I always recommend that the person who starts trying to get their certifications should start with the MTA.

If you already have a high degree of knowledge and experience and are now seeking to specialize in certifications, I recommend obtaining MCSA / MCSE titles and then, if you wish, seek MTA certification. An MTA certification doesn't really add much to the curriculum of those who already have an MCSA / MCSE, but I usually say that certification is addictive (and really addictive! Lol), so it's something to think about when you already have all the certifications you are aiming for. .

There are several MTA tests for you to do according to your area of ​​expertise. You can learn more about the evidence. accessing this link.

• Exam 98-349 - Fundamentals of the Windows operating system: Candidates for this exam should be aware of the fundamental concepts of the Windows operating system in a Windows 10 environment.

  Exam Link
  Course Link

• Exam 98-361 - Software Development Fundamentals: Candidates for this exam seek to prove their knowledge of software development. Applicants are recommended to be familiar with the concepts and have hands-on experience with the technologies described here, either by relevant courses or by working with tutorials and examples available on MSDN and Microsoft Visual Studio. Applicants must have experience with C # or Microsoft Visual Basic .NET.

  Exam Link

• Exam 98-364 - Database Fundamentals: Candidates for this exam want to prove basic knowledge and skills with databases, including relational databases, such as Microsoft SQL Server. Applicants are recommended to be familiar with the concepts and have hands-on experience with the technologies described here, either by relevant courses or by working with tutorials and examples available on MSDN and Microsoft Visual Studio. While minimal hands-on technology experience is recommended, these exams do not assume work experience.

  Exam Link
  Course Link

• Exam 98-365 - Windows Server Administration Fundamentals: This exam is intended to provide candidates with an assessment of their knowledge of fundamental concepts of server administration. It is recommended that applicants become familiar with the concepts and technologies described here by taking relevant training courses. Candidates are expected to have some practical experience with Windows Server, Windows-based networks, Active Directory, account management, and system recovery tools and concepts.

  Exam Link

• Exam 98-366 - Networking Fundamentals: This exam is designed to provide candidates with an assessment of their knowledge of fundamental networking concepts. Candidates for this exam seek to prove fundamental networking knowledge and skills. Before taking the exam, candidates should have a solid basic knowledge of the topics described in this preparation guide. It is recommended that applicants become familiar with the concepts and technologies described here by taking relevant training courses. Candidates are expected to have hands-on experience with Windows Server, Windows-based networking, network management tools, DNS, TCP / IP, protocol and name resolution processes, and network topologies.

  Exam Link

• Exam 98-367 - Security Fundamentals: This exam validates the applicant's safety skills and knowledge. It can serve as a step toward Microsoft Certified Solutions Associate (MCSA) exams. It is recommended that applicants become familiar with the concepts and technologies described here by taking relevant training courses. Candidates are expected to have some practical experience with Windows Server, Windows-based networks, Active Directory, antimalware products, firewalls, devices, topologies, and network ports.

  Exam Link

• Exam 98-368 - Mobility and Devices Fundamentals: This exam validates the candidate's skills and knowledge regarding Windows devices and mobility. It can serve as a step toward Microsoft Certified Solutions Associate (MCSA) exams. It is recommended that applicants become familiar with the concepts and technologies described here by taking relevant training courses. Candidates are expected to have some practical experience with Windows devices, Windows-based networks, Active Directory, antimalware products, firewalls, devices, topologies, and network ports.

  Exam Link
  Course Link

• Exam 98-369 - Cloud Fundamentals: This exam is designed for candidates who want to demonstrate basic knowledge and skills in using Microsoft cloud services. The exam can serve as a step toward Microsoft Certified Solutions Associate (MCSA) exams. It is recommended that applicants become familiar with the concepts and technologies described here by taking relevant training courses. Applicants should have some hands-on experience with Office 365, Microsoft Intune, firewalls, network devices and topologies, and network ports.

  Exam Link
  Course Link

• Exam 98-375 - Fundamentals of HTML5 Application Development: Candidates for this exam are seeking to demonstrate core HTML5 client application development skills that will run on current touch devices (PCs, tablets, and phones). While HTML is often viewed as a web technology that is rendered in a browser to produce a UI, this exam focuses on using HTML5, CSS3, and JavaScript to develop client applications. Before taking the exam, candidates should have a solid basic knowledge of the topics described in the preparation guide, including CSS and JavaScript. Candidates should be familiar with the concepts and have hands-on experience with related technologies, either through relevant courses or working with tutorials and examples available on MSDN and Microsoft Visual Studio.

  Exam Link

• Exam 98-380 - Introduction to Programming Using Block-Based Languages ​​(Touch Develop): Candidates for this exam should understand algorithm flow and implement common program control frameworks. Candidates should have experience with block-based programming languages ​​such as Touch Develop, Scratch, and Blockly. Candidates are expected to have some practical experience of designing, authoring, and publishing code within a block-based programming language.

  Exam Link

• Exam 98-381 - Introduction to programming using Python: Candidates for this exam must be able to recognize and write Python code correctly syntactically, recognize the data types supported by Python, and be able to recognize and write Python code that will logically solve a particular problem. Candidates are expected to have at least approximately 100 hours of instruction and / or practical experience with the Python programming language, be familiar with its features and capabilities, and understand how to write, debug, and maintain well-documented Python code. and well formed.

  Exam Link

• Exam 98-382 - Introduction to programming using JavaScript: Candidates for this exam must be able to recognize and write syntactically correct JavaScript code, use JavaScript-supported data types, and be able to recognize and write JavaScript code that will logically solve a particular problem. Candidates are expected to have at least 100 hours of instruction or practical experience with the JavaScript programming language. Candidates should also be familiar with JavaScript capabilities and capabilities and understand how to write, debug, and maintain well-formed and well-documented JavaScript code.

  Exam Link

• Exam 98-383 - Introduction to programming using HTML and CSS: Candidates for this exam should be able to recognize and write syntactically correct HTML and CSS, structure data using HTML elements, and create and apply styles using CSS. Applicants must have at least 100 hours of instruction or hands-on experience with HTML and CSS, be familiar with its features and capabilities, and understand how to write, debug, and maintain well-formed HTML and CSS code.

  Exam Link

The MTA exam is Microsoft's first and easiest certification exam, suitable for people just starting their careers and still getting familiar with the technology, so there is no prerequisite to do it. Anyone can take this test. With just 1 proof, you already get MTA certification in the desired field.

However, passing the MTA does not guarantee you the title of Microsoft Certified Professional (MCP) and is not a prerequisite for taking the MCSA and MCSE exams. You can take the MCSA / MCSE exams without having the MTA title.

To become an MCP, you simply have to pass any MCSA or MCSE exam.

As you know, all Microsoft certification exams are billed in US dollars. The value of the MTA exam is 77 dollars, while an MCSA / MCSE exam costs 100 dollars. Microsoft gives this small discount to encourage people to earn this certification and also to slightly lower the cost for a student, who is largely the target audience of MTA certification.

As the companies offering the exams are American (Certiport and PearsonVue), the exam can only be paid using an international credit card under Visa, MasterCard, American Express or JCB. If you don't have one, there are several companies that offer cards with no annual fee and fees, such as NuBank and Banco Inter. You can also opt for an international Prepaid credit card (no bank account required), such as the PagSeguro Prepaid Card. That is, no excuses to postpone your certification test .. lol

It is worth remembering that 50% discount for students NO applies to MTA tests.

Yes! Yes you can!

The vast majority of Microsoft certification exams have several languages ​​to choose from, and one of them is Portuguese (EN). This helps a lot when the person taking the exam has no command of the original language of the test, which is English, because the texts of the tests are usually a little long and
The person may become confused.

However, beta tests, or even newly released official tests, usually do not have multi-language options early on. They take a few months to translate and this may prevent you, who don't know English, from taking these tests for a long time.

Also, I need to tell you that in some cases, proofs in Portuguese may even confuse you, as the technical terms are also translated.

Some examples:
- Stored Procedure
- View
- Trigger
- Job
- Log Shipping

However, I have to warn you that English is ESSENTIAL, not just to take certification exams, but throughout his IT career. The overwhelming majority of books and technical articles are usually in English, many technical terms are still in English, and most IT giants are in the US.

That said, it's hard to find a great IT professional who doesn't even know how to read English texts. If you don't have this ability yet, don't waste any more time! Start TODAY studying English for the sake of your career.

To take Microsoft certification exams, the first step is to have a Microsoft account and email (outlook.live.com).

Once you have your Microsoft account, you should go to the exam page you want to take and schedule at the Microsoft partner who conducts the exams (Certiport or PearsonVue) what date and time you would like to take the exam. At the same site, you will choose the training center that is closest to you (or you can arrange to do it at home) and the payment method.

On the scheduled day, simply attend the indicated location with a photo document.

Following are the MTA exam pages to begin the exam scheduling and scheduling process:

• Exam 98-349 - Fundamentals of the Windows operating system
• Exam 98-361 - Software Development Fundamentals
• Exam 98-364 - Database Fundamentals
• Exam 98-365 - Windows Server Administration Fundamentals
• Exam 98-366 - Networking Fundamentals
• Exam 98-367 - Security Fundamentals
• Exam 98-368 - Mobility and Devices Fundamentals
• Exam 98-369 - Cloud Fundamentals
• Exam 98-375 - Fundamentals of HTML5 Application Development
• Exam 98-380 - Introduction to Programming Using Block-Based Languages ​​(Touch Develop)
• Exam 98-381 - Introduction to programming using Python
• Exam 98-382 - Introduction to programming using JavaScript
• Exam 98-383 - Introduction to programming using HTML and CSS

The MTA test (at least 98-364) is composed of 35 questions, where a minimum of 70% accuracy is required for approval.

The time limit for reading the exam rules is 15 min and the exam time is 45 min (summing up gives 1h). If you have studied hard, this will not be a problem as the questions are quite simple.

If you are a student, make sure the school has been established as a Certiport testing center and enrolled to conduct MTA exams. If so, the teacher or supervisor may send the exam to you.

If you are not a student, Microsoft certification exams can be taken in 2 environments (described below). You will choose whether to take the test at home or at an official training center during the test schedule, where the website itself shows you which training center is closest to you.

• Official Training Center: One of the places to take a certification test is at an official training center. These Microsoft partner sites often offer official training and also provide a framework for the general public to take their certification exams.

  The exams must be scheduled in advance (I explained in the previous question) and are done on an Internet-connected computer with cameras in the room and an on-site instructor. Your belongings, including bags, backpacks and cell phones, should be collected before the start of the test, and removed by you only at the end of the exam.

  The whole structure is the responsibility of the company and in case of any problem they should help you solve it on time.

• Your home: Another option for those who do not want to move to a training center, whether for convenience, lack of time or even living far from one, is to take the test in the comfort of your home.

  Although this option seems very comfortable at first, I should warn you that it has a number of rules to make it an interesting and really practical option:
  - A Microsoft employee will monitor you throughout the exam via a webcam or cell phone with the camera on.
  - You will have to show the entire place in your home where you will take the exam, so that he can make sure that the place has nothing against the rules and policies of the exam, such as a camera or paper with notes and tips. remove objects from the place where you will take the test.
  - No one from your home will be able to appear on camera images or speak to you during the race.
  - If the internet connection goes down or there is a problem with your computer, try it for yourself, with no right to redo (only paying again)

If you are studying materials to take an MTA test, you can use the Microsoft Virtual Academy, which offers free online training in IT, development, and data science from world-class experts to help you develop your skills and advance your career.

In addition, there are several free materials I will make available (all in Portuguese / EN):

• 98-361: Fundamental Software Development
• 98-364: Database Administration Fundamentals
• 98-365: Windows Server Administration Fundamentals
• 98-366: Networking Fundamentals
• 98-367: Security Fundamentals

The exam 98-349: Windows Operating System Fundamentals I only found it in English, but for those who want it, it's here.

Are you looking for English materials or proof material that I have not listed above? Visit this link.

For those taking the 98-364: Database Administration Fundamentals exam (which I did), I have also prepared some links that may be helpful in your studies, according to the required skills:

Simulated DBA Academy

98-364 Exam: Database Fundamentals (Exam Link)
Understanding Core Database Concepts

• Understand how data is stored in tables
  • Tables
  • Tables, Records, and Fields
• Understand relational database concepts
  • The Relational Database Overview
  • Introduction to RDBMS
  • Relational Database Model
  • Integrity Rules In Relational Database Model
  • Primary and Foreign Key Constraints
  • Designing Tables
  • Implementing a Relational Database
• Understand data manipulation language
  • Data Manipulation Language (DML)
  • Basic SQL statements: DDL and DML
  • Data Manipulation Language (DML) Statements (Transact-SQL)
• Understand data definition language (DDL)
  • Data Definition Language (DDL) Statements (Transact-SQL)
  • Data Definition Language (DDL)

Create Database Objects

• Choose data types
  • SQL General Data Types
  • Data type
  • Data Types (Transact-SQL)
• Understand tables and how to create them
  • Table
  • SQL CREATE TABLE Statement
  • CREATE TABLE (Transact-SQL)
  • Publishing Data and Database Objects
• Create views
  • views
  • How to create a view using Microsoft SQL Server Management Studio
  • How to: Create Views (Visual Database Tools)
• Create stored procedures and functions
  • SQL Functions
  • SQL Server Stored Procedure Tutorial
  • Stored procedure

Manipulate Data

• Select data
  • Walkthrough: Retrieving, Updating, Inserting, and Deleting Data with the LinqDataSource and DetailsView Controls
  • Selecting Data Using the SqlDataSource Control
  • SELECT Column Example
  • SELECT Examples (Transact-SQL)
  • Types of Joins
  • SQL Joins
  • UNION (Transact-SQL)
  • EXCEPT and INTERSECT (Transact-SQL)
• Insert data
  • SQL INSERT INTO Statement
  • INSERT (Transact-SQL)
• Update data
  • SQL UPDATE Statement
  • UPDATE (Transact-SQL)
• Delete data
  • SQL DELETE Statement
  • DELETE (Transact-SQL)
  • How to: Delete Rows From the Database (LINQ to SQL)

Understand Data Storage

• Understand normalization
  • Database Normalization Basics
  • Database normalization
• Understand primary, foreign, and composite keys
  • Primary and Foreign Key Constraints
  • Working with keys
  • SQL PRIMARY KEY Constraint
  • SQL FOREIGN KEY Constraint
  • SQL by Design: How to Choose a Primary Key
  • Composite Key In SQL
  • How to: Handle Composite Keys in Queries (LINQ to SQL)
• Understand indexes
  • Defining a Clustered Index
  • Clustered and Nonclustered Indexes Described
  • Choosing Non-Clustered Indexes
  • Stairway to indexes
  • Working with Indexes

Administer a Database

• Understand database security concepts
  • Database Security
  • Permissions (Database Engine)
  • Server-Level Roles
  • Database-Level Roles
  • CREATE USER (Transact-SQL)
  • Security Considerations for a SQL Server installation
  • SQL Server Security (ADO.NET)
• Understand database backups and restore
  • Backing Up and Restoring Databases in SQL Server
  • Types of SQL Server Backups
  • World Backup Day: Best Practices to Back Up Your Data