0(0)

MCSA: SQL 2016 (Development)

  • Course level: Intermediate
  • Total Enrolled 0
  • Last Update March 5, 2021

Description

The demand for organizational or individual data is never going to cease any time. Database development has simplified the analyzing and processing of reports. Database developers are the most demanding professionals in every modern work environment. MCSA SQL 2016 Database Development course is designed to give you the skills to demonstrate you as a database professional in both Cloud-based and on-premises databases.

MCSA: SQL 2016 (Development) exam is intended for SQL Server database administrators, developers and system engineers, with two or more years of experience and seeking to validate their skills and knowledge in writing queries.

Prerequisites

  • Basic knowledge of Microsoft Windows operating system and its core functionalities.
  • Working knowledge of relational databases.

Exam 70-762/Course 20762: Developing SQL Databases

This exam is intended for database professionals those build and implement databases across business organizations ensuring high levels of data availability. The candidate will be responsible for building database files, data types, and tables; plan, create, and optimize indexes; make sure data integrity; store procedures, implement views, and functions; and manage transactions and locks.

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionalities.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.

Topics for this course

36 Lessons

Exam 70-761/Course 20761: Querying Data with Transact-SQL

Module 1: Introduction to Microsoft SQL Server00:00:00
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
.Module 6: Working with SQL Server Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Windows Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Executing Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions

Exam 70-762/Course 20762: Developing SQL Databases