If you don’t know how databases work, start with the basic database tutorial first. There are sometimes special offers for a free second shot to take the exam. If the exam is in English and it is not your native language, you will have
extra time. This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multi-server jobs.

Review and consolidate your SQL skills with tons of interactive exercises! In this learning path, you’ll practice SQL JOINs, aggregation with GROUP BY and HAVING, and subqueries (including correlated subqueries). Uniting experts from our leading brands, we offer a holistic training experience, ensuring your team excels in today’s tech-driven economy.

SQL Tutorial

I am planning to take this exam in the near future and this should prive very useful for study aids.

• In this module, you will briefly explore tools and techniques so that you can import and export data to and from SQL Server.
• This module describes how data is stored in databases, how to create databases, how to manage database files, and how to move them.
• Dig into the vast amount of expert tutorials, blogs, guides, cheat sheets, and more.
• If the exam is in English and it is not your native language, you will have
  extra time.
• This module covers the configuration of database mail, alerts, and notifications.

This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server audit feature, and how to implement encryption. The examples in this tutorial are all SQL 2014 Admin Lessons done using the free version of SQL Server – SQL Server 2014 Express with Tools. You can download SQL Server 2014 Express with Tools from the Microsoft website (we’ll get to that in a minute).

Can I access virtual labs to practice for the exam?

In this module, you will be learn about the core concepts on which the SQL Server security architecture is based, and how to manage security at the server and database levels. This module describes how data is stored in databases, how to create databases, how to manage database files, and how to move them. Other tasks related to storage, include managing the tempdb database and using fast storage devices to extend the SQL Server buffer pool cache, are also discussed. Become a SQL master – even if you’ve never coded before. Learn all the necessary tools to freely and efficiently work with any type of data. Start from the basics, then discover advanced SQL functions and features.

In this module, you will consider how to create a backup strategy that is aligned with organizational needs, and learn how to perform the backup operations required by that strategy. Learn the basics of SQL, retrieve data from an SQL database and build simple reports. Explore our Resource Center, a hub for professional growth.