Microsoft SQL Server
Skill level: Beginner
To Study and pass Exam 70-761
Querying Data with Transact-SQL
To Study and pass Exam 70-762
Developing SQL Databases
This Microsoft SQL Server course by Sky Databank teaches you everything you need to know to pass the SQL 2016 Database Development Exam. It is required that you pass the 70-761 and 70-762 Exam in order to earn your MCSA: SQL Server certification from Microsoft.
The course takes you through each of the topics that you will need to master in order to pass the SQL Server 2016 70-761 exam. Throughout this video tutorial, you will learn how to setup the interface, create and alter tables using T-SQL, and understand SQL queries. You will learn about select statements, how to modify data, and use joins and subqueries. This course will teach you about triggers and different trigger types, how to work with XML, and how to optimize queries. Finally, you will run through the exam basics and what you can expect from the exam.
Once you have completed this computer based training course for the Microsoft SQL Server 70-761 exam, you will have developed the knowledge and skills necessary to pass the Querying Microsoft SQL Server 2012 Exam and continue towards earning your SQL Server MCSA certification.
How to take the Microsoft SQL 2016 Database Development Exam:
1. Find a test center near you to take the SQL Server 70-761 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.
2. Study the required material to pass the 70-761 examination. This course covers the material that is within the 70-761 certification exam, and will help put you in a great position to succeed in the exam
3. Pass your exam!
- Lectures 48
- Quizzes 5
- Students 40
- Assessments Yes
Basic SQL Queries
SQL Best Practices
SQL Project 1
SQL Project 2
ADVANCED SQL Project 3
ADVANCED SQL Project 4
FINAL PROJECT -Enterprise Level Data Analyst Task