Course overview
The Microsoft Certified Solutions Associate (MCSA) certification focuses on the ability to design and build technology solutions, which may include integrating multiple technology products, and span multiple versions of a single technology, whether on-premises or in the cloud.
An individual can choose to become a certified Associate in one or several Microsoft technology specialisations. This certification bundle is ‘SQL 2016 Database Development’ focused.
By gaining this MCSA certification you can prove your mastery of the primary set of SQL 2016 Database Development skills required to reduce IT costs and deliver more business value.
Recognition
Study method
- Online
- Blended
- In-class
Duration study load
Learners can finish a single course from anywhere between 1-3 months. You will have full access to the resources for 12 months and must take your exams within this period.
Entry requirements
By enrolling on this course, it is assumed you have you have experience working with SQL Server as a Database Administrator, System Engineer, or Developer; plus you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases.
Course features
- Text Book
- Practice Lab
- MeasureUP Practice Exam
- Official Exam
This bundle contains two separate MCSA certification courses and two official Microsoft MCSA certification exams, that are both valid for 12 months from the time of purchase. As part of this bundle, you will get access to a MeasureUP practice test for each Microsoft certification course.
Assessment
Certification exams included:
- Microsoft 70-761 Querying Data with Transact-SQL (MCSA: 1 of 2 exams)
- Microsoft 70-762 Developing SQL Databases (MCSA: 2 of 2 exams)
MeasureUP practice tests included:
- Microsoft 70-761 Querying Data with Transact-SQL
- Microsoft 70-762 Developing SQL Databases
Materials
As explained above, an element of the course is delivered via text book. The remainder is online with 24/7 access. You can do it from any where in the world, any time of the day providing you have an internet connection.
Delivery
This course bundle is made up of four main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x text book, 1 x practice lab, 1 x MeasureUP practice exam, 1 x official exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses. Once you have passed the exams, you will be officially certified by Microsoft as an MCSA in SQL 2016 Database Development. Read below to learn more about the resources that make up this course.
Subjects
- Filter, sort, join, aggregate, and modify data
- Use subqueries, table expressions, grouping sets, and pivoting
- Query temporal and non-relational data, and output XML or JSON
- Create views, user-defined functions, and stored procedures
- Implement error handling, transactions, data types, and nulls
- Design and implement database objects
- Implement programmability objects
- Manage database concurrency
- Optimize database objects and SQL infrastructure
About Hudson
In the confusing world of e-learning, Hudson is quite simply one of the best at what they do. Why? Because they offer first-class customer service. The Hudson Learning Center puts their customers’ needs before anything else. If there’s something they can do to help you, Hudson will climb mountains to do it.
The Hudson online courses, certifications, and diplomas are highly effective, offering a whole range of features designed to get you certified faster. Some of these incredible features include video and audio based training so you can see and hear your tutor, 24/7 online tutor support, and online labs to practice your skills in a simulated environment.
Come and give Hudson a try. They’ll change the way you think about learning.
