0(0)

MCSA: SQL 2016 (Development)

  • by admin
  • Course level: Intermediate
  • Categories Microsoft
  • Total Enrolled 0
  • Last Update August 30, 2020

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.

What Will I Learn?

  • Demonstrate your competency as a Database Development expert.
  • Knowledge and skills of designing, building, maintaining and querying the cloud-ready database and information solutions.
  • Understanding on the basic architecture and concepts of SQL Server 2016
  • Knowledge on Transact-SQL and its unique features and how it is similar to other query languages.
  • Execution of stored procedures, transactions, and error handling.

Topics for this course

36 Lessons

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

Module 4: Querying Multiple Tables
Module 1: Introduction to Microsoft SQL Server00:00:00
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
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

Free

Material Includes

  • Duration: Full-time-10 Days
  • Duration: Part-time-10 Saturdays
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Requirements

  • No coding experience is necessary to take this course!
  • Any computer and OS will work — Windows, macOS or Linux.
  • A basic understanding of HTML and CSS is a plus.

Target Audience

  • Practice your new skills with coding challenges.
  • Organize and structure your code using software.
  • Get friendly and fast support in the course.