Library

Course: MCSA 70-762 Developing Databases

MCSA 70-762 Developing Databases

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Welcome to this course: Microsoft SQL Server 2016 Certification (70-762) - Developing SQL Databases. This exam is intended for database professionals who build and implement databases across organizations and maintain high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

In this course, you'll learn:

  • Design and implement database objects 
  • Implement programmability objects 
  • Manage database concurrency 
  • Optimize database objects and SQL infrastructure 

At the end of this course, you will have deep hands on knowledge and skills necessary to pass the Developing SQL Databases Exam. So let's get started.

Basic knowledge
  • Basic computer knowledge and willing to learn SQL server
What you will learn
  • Views
  • Indexes(Cluster,Non-cluster,Column store)
  • Manage database concurrency
  • To Study And Pass The Microsoft 70-762 Exam and Gain Certification For MCSA
Curriculum
Number of Lecture: 29
Total Duration: 01:36:15
Introduction
  • Introduction  

    Introduction

Fundamentals of SQL
  • What is Database?  

    What is Database?

  • What is schema?  

    What is schema?

  • Process of Database Design  

    Process of Database Design

  • Normalization  

    Normalization

  • Create And Alter Table Statement  

    Create And Alter Table Statement

  • Data Types  

    Data Types

  • Computed Columns  

    Computed Columns

  • Dynamic Data Masking  

    Dynamic Data Masking

Indexes
  • What is Index?  

    What is Index?

  • Terms Use In Indexes  

    Terms Use In Indexes

  • Clustered Index  

    Clustered Index

  • Non-Clustered Index  

    Non-Clustered Index

  • Filtered Index  

    Filtered Index

  • Unique Index  

    Unique Index

  • Columnstore Index  

    Columnstore Index

  • Clustered Columnstore Index  

    Clustered Columnstore Index

  • Non-Clustered Columnstore Index  

    Non-Clustered Columnstore Index

Views
  • What is View?  

    What is View?

  • Indexed View  

    Indexed View

  • Partitioned View  

    Partitioned View

Data Integrity with constraints
  • Data Integrity With Constraints  

    Data Integrity With Constraints

  • Primary Key  

    Primary Key

  • Foreign Key  

    Foreign Key

  • Cascading Operations  

    Cascading Operations

  • Unique Constraint  

    Unique Constraint

  • Check Constraint  

    Check Constraint

  • With Check, With Nocheck And Nocheck  

    With Check, With Nocheck And Nocheck

  • Default Constraint  

    Default Constraint

Reviews (0)