Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software IT Certification Microsoft Certification

Microsoft SQL Server 2016 Certification (70-764)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-764) exam.
Bestseller
Rating: 4.4 out of 54.4 (1,276 ratings)
4,879 students
Created by CubeTech Academy, LLC.
Last updated 8/2020
English
English [Auto], Portuguese [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Configure data access and auditing
  • Manage backup and restore of databases
  • Manage and monitor SQL Server instances
  • Manage high availability and disaster recovery

Requirements

  • A PC
  • Internet Access

Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure. This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

In this course, you'll learn:
  • Configure data access and auditing 
  • Manage backup and restore of databases 
  • Manage and monitor SQL Server instances 
  • Manage high availability and disaster recovery 

At the end of this course, you will have developed the knowledge and skills necessary to pass the Administering a SQL Database Infrastructure Exam. So let's get started.

Who this course is for:

  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-764

Course content

12 sections • 79 lectures • 9h 11m total length

  • Preview02:31

  • Introduction
    07:05
  • Getting Started - Overview: MS SQL Server
    08:11
  • Getting Started - The Certifications
    07:54
  • Getting Started - Microsoft SQL Server Examples
    03:17

  • Introduction
    07:20
  • Learn About SQL Server - Learn About Editions
    06:15
  • Learn About SQL Server - SQL Server Databases
    08:18
  • Learn About SQL Server - Learn and Understand Database Structures
    08:21
  • Learn About SQL Server - SQL Server: Transact-SQL
    05:37

  • Preview08:15
  • MS SQL Server 2016: Learn How To Install SQL Server 2016
    10:26
  • MS SQL Server 2016: Learn How To Install SQL Server Management Studio
    04:47
  • MS SQL Server 2016: Attaching The Sample Database
    07:35
  • MS SQL Server 2016: Verifying The Installation
    05:07

  • Introduction
    07:29
  • Learning Microsoft SQL Server Level Security
    08:50
  • SQL Server Security: Restarting SQL Server
    05:14
  • SQL Server Security: Creating Logins
    07:55
  • SQL Server Security: Database Level Security
    06:49
  • SQL Server Security: Database User Account Types
    08:27
  • SQL Server Security: Cross Server Authorization
    07:51
  • SQL Server Security: Partially Contained Databases
    06:25
  • SQL Server Security: Dynamic Data Masking
    06:46
  • SQL Server Security: DDM Example - 1
    05:43
  • SQL Server Security: DDM Example - 2
    08:04

  • Introduction
    07:33
  • SQL Server Roles: Fixed Server Roles
    06:25
  • SQL Server Roles: Fixed Database Roles
    05:30
  • SQL Server Roles: User-Defined Roles
    06:04
  • SQL Server Roles: Grant, Revoke, And Deny
    04:37
  • SQL Server Roles: Schema Level Permissions
    05:52

  • Introduction
    10:00
  • Learn and Understand SQL Server Encryption
    08:25
  • SQL Server Encryption: Dark Side Of Encryption
    07:00
  • SQL Server Encryption: Asymmetric Vs. Symmetric
    06:25
  • SQL Server Encryption: Encryption Options
    06:14
  • SQL Server Encryption: Encrypting Backups - 1
    07:12
  • SQL Server Encryption: Encrypting Backups - 2
    06:18
  • SQL Server Encryption: Transparent Data Encryption
    07:31
  • SQL Server Encryption: Implementing TDE
    08:26
  • SQL Server Encryption: Always Encrypted
    09:47
  • SQL Server Encryption: Implementing Always Encrypted
    05:49

  • Introduction
    10:17
  • SQL Server - Learn and Understand Index Management
    04:16
  • Index Management - Identifying Fragmentation
    06:45
  • Index Management - Repairing Fragmentation
    06:20
  • Index Management - Database Engine Tuning Advisor - 1
    10:44
  • Index Management - Database Engine Tuning Advisor - 2
    05:15

  • Introduction
    09:50
  • MS SQL Server - Backup: Backup Types
    07:40
  • MS SQL Server - Backup: Understanding Recovery Models
    09:49
  • MS SQL Server - Backup: Copy-Only Backups
    10:12
  • MS SQL Server - Backup: Backup Terminology
    05:42
  • MS SQL Server - Backup: System Database Backups
    06:46
  • MS SQL Server - Backup: Transaction Log Basics
    09:22
  • MS SQL Server - Backup: Transaction Log Backups
    08:58
  • MS SQL Server - Backup: Tail-Log Backups
    04:38
  • MS SQL Server - Restore: Restoring Databases
    10:52
  • MS SQL Server - Restore: Restoring With SSMS
    05:00
  • MS SQL Server - Restore: Recovering The Master DB
    07:39
  • MS SQL Server - Restore: Point In Time Recovery
    06:25
  • MS SQL Server - Restore: Understanding Log Shipping
    05:36

  • Introduction
    10:10
  • Monitoring Microsoft SQL Server: Performance & Monitoring
    05:48
  • Monitoring Microsoft SQL Server: Session Identification
    07:38
  • Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 1
    09:34
  • Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 2
    05:51
  • Monitoring Microsoft SQL Server: Understanding UCPs
    07:49
  • Monitoring Microsoft SQL Server: Data Collector
    05:26
  • Monitoring Microsoft SQL Server: Data Collector Configuration
    07:40
  • Monitoring Microsoft SQL Server: Query Store
    08:25
  • Monitoring Microsoft SQL Server: Understanding Extended Events
    06:46
  • Monitoring Microsoft SQL Server: Creating An Extended Event - 1
    08:52
  • Monitoring Microsoft SQL Server: Creating An Extended Event - 2
    02:43
  • Monitoring Microsoft SQL Server: Editing An Extended Event
    07:10

Instructor

CubeTech Academy, LLC.
Learn Skills and Get Certified Easily
CubeTech Academy, LLC.
  • 4.3 Instructor Rating
  • 3,973 Reviews
  • 13,117 Students
  • 6 Courses

CubeTech Academy is surely one of the most effective ways for you to acquire all the necessary skills in web development and programming since we truly wish all of our students to become really talented professionals.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Every course has been designed after careful planning and research. They are structured for all levels of students and help them to become an expert in areas like Project management and Web development.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.