MCSA Certification Bundle With 2 Exams: SQL 2016 Database Development

MCSA Certification Bundle With 2 Exams: SQL 2016 Database Development

From: £139.83 Inc. VAT per month for 6 months

Clear

Description

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.
 

An example of an MCSA certification you can gain through this course bundle.

 

Do you have more questions about the MCSA? Click here to read Microsoft’s FAQs.

 

Considering upgrading to an MCSE? Watch this video to find out what it means to have an MCSE certification.

 
What’s included in this certification bundle?
 
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.
 
Certification courses included:
 
Click on a course title to see the areas covered.



Chapter 1. Manage data with Transact-SQL
Skill 1.1: Create Transact-SQL SELECT queries
• Understanding the foundations of T-SQL
• Understanding logical query processing
• Getting started with the SELECT statement
• Filtering data with predicates
• Sorting data
• Filtering data with TOP and OFFSET-FETCH
• Combining sets with set operators
Skill 1.2: Query multiple tables by using joins
• Cross joins
• Inner joins
• Outer joins
• Queries with composite joins and NULLs in join columns
• Multi-join queries
Skill 1.3: Implement functions and aggregate data
• Type conversion functions
• Date and time functions
• Character functions
• CASE expressions and related functions
• System functions
• Arithmetic operators and aggregate functions
• Search arguments
• Function determinism
Skill 1.4: Modify data
• Inserting data
• Updating data
• Deleting data
• Merging data
• Using the OUTPUT option
• Impact of structural changes on data
• Chapter summary
• Thought experiment
• Thought experiment answer
Chapter 2. Query data with advanced Transact-SQL components
Skill 2.1: Query data by using subqueries and APPLY
• Subqueries
• The APPLY operator
Skill 2.2: Query data by using table expressions
• Table expressions, described
• Table expressions or temporary tables?
• Derived tables
• Common table expressions
• Views and inline table-valued functions
Skill 2.3: Group and pivot data by using queries
• Writing grouped queries
• Pivoting and Unpivoting Data
• Using Window Functions
Skill 2.4: Query temporal data and non-relational data
• System-versioned temporal tables
• Query and output XML data
• Query and output JSON data
• Chapter summary
• Thought experiment
• Thought experiment answer
Chapter 3. Program databases by using Transact-SQL
Skill 3.1: Create database programmability objects by using Transact-SQL
• Views
• User-defined functions
• Stored procedures
Skill 3.2: Implement error handling and transactions
• Understanding transactions
• Error handling with TRY-CATCH
Skill 3.3: Implement data types and NULLs
• Working with data types
• Handling NULLs
• Chapter summary
• Thought experiment
• Thought experiment answer


Chapter 1. Design and implement database objects
Skill 1.1: Design and implement a relational database schema
• Designing tables and schemas based on business requirements
• Improving the design of tables by using normalization
• Writing table create statements
• Determining the most efficient data types to use
Skill 1.2: Design and implement indexes
• Design new indexes based on provided tables, queries, or plans
• Distinguish between indexed columns and included columns
• Implement clustered index columns by using best practices
• Recommend new indexes based on query plans
Skill 1.3: Design and implement views
• Design a view structure to select data based on user or business requirements
• Identify the steps necessary to design an updateable view
• Implement partitioned views
• Implement indexed views
Skill 1.4: Implement columnstore indexes
• Determine use cases that support the use of columnstore indexes
• Identify proper usage of clustered and non-clustered columnstore indexes
• Design standard non-clustered indexes in conjunction with clustered columnstore indexes
• Implement columnstore index maintenance
• Chapter summary
• Thought experiment
• Thought experiment answer
Chapter 2. Implement programmability objects
Skill 2.1 Ensure data integrity with constraints
• Define table and foreign-key constraints to enforce business rules
• Write Transact-SQL statements to add constraints to tables
• Identify results of Data Manipulation Language (DML) statements given existing tables and constraints
• Identify proper usage of PRIMARY KEY constraints
Skill 2.2 Create stored procedures
• Design stored procedure components and structure based on business requirements
• Implement input and output parameters
• Implement table-valued parameters
• Implement return codes
• Streamline existing stored procedure logic
• Implement error handling and transaction control logic within stored procedures
• Skill 2.3 Create triggers and user-defined functions
• Design trigger logic based on business requirements
• Determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers
• Recognize results based on execution of AFTER or INSTEAD OF triggers
• Design scalar-valued and table-valued user-defined functions based on business requirements
• Identify differences between deterministic and non-deterministic functions
• Chapter summary
• Thought Experiment
• Though Experiment Answer
Chapter 3. Manage database concurrency
Skill 3.1: Implement transactions
• Identify DML statement results based on transaction behavior
• Recognize differences between and identify usage of explicit and implicit transactions
• Implement savepoints within transactions
• Determine the role of transactions in high-concurrency databases
Skill 3.2: Manage isolation levels
• Identify differences between isolation levels
• Define results of concurrent queries based on isolation level
• Identify the resource and performance impact of given isolation levels
Skill 3.3: Optimize concurrency and locking behavior
• Troubleshoot locking issues
• Identify lock escalation behaviors
• Capture and analyze deadlock graphs
• Identify ways to remediate deadlocks
Skill 3.4: Implement memory-optimized tables and native stored procedures
• Define use cases for memory-optimized tables
• Optimize performance of in-memory tables
• Determine best case usage scenarios for natively compiled stored procedures
• Enable collection of execution statistics for natively compiled stored procedures
• Chapter summary
• Thought experiment
• Thought experiment answers
Chapter 4. Optimize database objects and SQL infrastructure
Skill 4.1: Optimize statistics and indexes
• Determine the accuracy of statistics and the associated impact to query plans and performance
• Design statistics maintenance tasks
• Use dynamic management objects to review current index usage and identify missing indexes
• Consolidate overlapping indexes
Skill 4.2: Analyze and troubleshoot query plans
• Capture query plans using extended events and traces
• Identify poorly performing query plan operators
• Compare estimated and actual query plans and related metadata
• Configure Azure SQL Database Performance Insight
Skill 4.3: Manage performance for database instances
• Manage database workload in SQL Server
• Design and implement Elastic Scale for Azure SQL Database
• Select an appropriate service tier or edition
• Optimize database file and tempdb configuration
• Optimize memory configuration
• Monitor and diagnose schedule and wait statistics using dynamic management objects
• Troubleshoot and analyze storage, IO, and cache issues
• Monitor Azure SQL Database query plans
Skill 4.4: Monitor and trace SQL Server baseline performance metrics
• Monitor operating system and SQL Server performance metrics
• Compare baseline metrics to observed metrics while troubleshooting performance issues
• Identify differences between performance monitoring and logging tools
• Monitor Azure SQL Database performance
• Determine best practice use cases for extended events
• Distinguish between Extended Events targets
• Compare the impact of Extended Events and SQL Trace
• Define differences between Extended Events Packages, Targets, Actions, and Sessions
• Chapter summary
• Thought experiment
• Thought experiment answer

 Certification exams included:

  1. Microsoft 70-761 Querying Data with Transact-SQL (MCSA: 1 of 2 exams)
  2. Microsoft 70-762 Developing SQL Databases (MCSA: 2 of 2 exams)

 
MeasureUP practice tests included:
 

  1. Microsoft 70-761 Querying Data with Transact-SQL
  2. Microsoft 70-762 Developing SQL Databases

 
Salary and job prospect information
 
We use two excellent third-party resources to allow you to check your earning potential and job prospects before starting this course.
 

 
The first is IT JobsWatch, which allows you to check what employers are paying people on average with specific certifications, such as the one contained in this bundle. Click here and enter the name of the certification you would like to see salary information on.
 

 
The second is Payscale, which also does the above, but allows you to see what types of job titles are paying more based around the certification you enquire about. Click here and enter the name of the certification you would like to see salary and job title information on.
 
What are the prerequisites?
 
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.
 
How does this course work?
 
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.
 
 Text Book
 
Each official Microsoft text book will be delivered to you by post. You will receive the first text book upon enrolling on the course and subsequent text books after completing the official exam for the course before. These text books are to be used in conjunction with the practice labs. Covering exam objectives, they also feature strategic, what-if scenarios to challenge you. The books include downloadable sample databases and codes for SQL Server 2016 SP1 (or later) and Azure SQL Database.
 
 Practice Lab
 
The hands-on live practice labs allow you to experience practical application of course concepts in an authentic online environment 24/7, all from the comfort of your home or office. The lab environments allow you to test and apply your skills as you learn. These labs also come with tasks challenging what you have learnt. To learn more about practice labs, click here.
 
 MeasureUP Practice Exam
 
After working your way through the text books and practice labs, you should be ready to start revising for your official exams. To do this, we provide you with MeasureUP practice tests. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exams you’ll be taking. Scroll down to learn more about MeasureUP and the practice tests.
 
 Official Exam
 
Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams – which we will book on your behalf. These are known as ‘online, web-proctored exams’. This means they can be taken at home. One of the requirements of taking this type of exam is that you must have a web camera so a proctor can observe you during the exam. This is to ensure no cheating takes place.
 
How long will it take me to complete each course?
 

This is dependent on several factors such as your level of experience of the subject matter, the amount of time you can dedicate to the course each week, and how quickly you absorb information. 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.
 
What do I need?
 
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. No apps are required to access the course resources. You simply do it from your browser. For the best user experience, we recommend Google Chrome.
 

 
MeasureUP practice tests
 
As part of this course, you will get access to MeasureUP practice tests to help prepare you for the Microsoft exams as part of this bundle. MeasureUP practice tests are endorsed by Microsoft and used as the official practice tests of Microsoft certification exams.
 
Features of MeasureUP practice tests:
 

  • Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
  • Detailed explanations for both correct and distractor answers reinforce the material
  • ‘Study Mode’ covers all objectives ensuring topics are covered
  • ‘Certification Mode’ (timed) prepares students for exam taking conditions
  • Instant, drill-down score reports tell you exactly the areas to focus on

 

Watch this video to learn more about MeasureUP practice tests.

 
How do I book my exams?
 
When you’re ready to sit your exams, email [email protected] with your request along with the title of the exam you wish to take. We will then send you an email with instructions on how to complete your exam booking.
 
Non-cancellation of course
 
Please note that this course is not covered by our standard 7 day guarantee/cancellation/refund policy.

Additional information

Payment options

4 monthly installments, 5 monthly installments, 6 monthly installments, Single payment