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 AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching 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 Retargeting
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

This course includes:

  • 8.5 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
IT & Software IT Certification Microsoft 70-762

Microsoft SQL Server 2016 Certification (70-762)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-762) exam.
Rating: 3.9 out of 53.9 (482 ratings)
3,264 students
Created by CubeTech Academy, LLC.
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

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

Requirements

  • A PC
  • Internet Access

Description

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 who ensure 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 developed the knowledge and skills necessary to pass the Developing SQL Databases Exam. So let's get started.

Who this course is for:

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

Course content

14 sections • 80 lectures • 8h 38m total length

  • Preview01:16

  • Introduction
    06:36
  • Getting Started - Overview: MS SQL Server
    05:53
  • Getting Started - The Certifications
    04:36
  • Getting Started - Microsoft SQL Server Examples
    03:57

  • Introduction
    08:41
  • Learn About SQL Server - Learn About Editions
    04:53
  • Learn About SQL Server - SQL Server Databases
    05:42
  • Learn and Understand Database Structures
    06:54
  • Learn About SQL Server - Transact-SQL
    06:10

  • Introduction
    06:57
  • Preview09:34
  • MS SQL Server 2016: Learn How To Install SQL Server Management Studio
    03:44
  • MS SQL Server 2016: Attaching The Sample Database
    06:24
  • MS SQL Server 2016: Verifying The Installation
    05:18

  • Introduction
    08:27
  • SQL Server 2016: Database Options
    09:44
  • SQL Server 2016: Database Options - Learn and Understand Tables
    06:06
  • SQL Server 2016: SQL Server Data Types
    09:10
  • SQL Server 2016: Choosing A Data Type
    05:24
  • SQL Server 2016: Database Options - Learn about Normalization
    10:13
  • SQL Server 2016: Database Options - Learn and Understand Relationships
    06:51
  • SQL Server 2016: Schemas
    09:36
  • SQL Server 2016: Table Design Basics
    06:50
  • SQL Server 2016: Creating Tables Using T-SQL
    07:39
  • SQL Server 2016: Creating Tables Graphically
    06:32
  • SQL Server - Using Identity Columns - 1
    06:28
  • SQL Server - Using Identity Columns - 2
    04:36
  • SQL Server - Altering Tables - 1
    08:44
  • SQL Server - Altering Tables - 2
    03:21

  • Introduction
    06:48
  • Table Design: Constraints
    09:14
  • Table Design: Primary and Foreign Keys
    06:00
  • Table Design: Adding Constraints - 1
    06:59
  • Table Design: Adding Constraints - 2
    05:11
  • Table Design: Understanding Filegroups
    07:39
  • Table Design: Table Partitions
    08:02
  • Table Design: Temporal Tables
    07:37
  • Table Design: Working With Temporal Tables - 1
    07:50
  • Table Design: Working With Temporal Tables - 2
    04:57
  • Table Design: In-Memory Tables - 1
    08:32
  • Table Design: In-Memory Tables - 2
    03:03
  • Table Design: Generating Scripts
    07:30

  • Introduction
    08:26
  • SQL Server Indexes - Clustered Or Nonclustered - 1
    08:31
  • SQL Server Indexes - Clustered Or Nonclustered - 2
    04:40
  • SQL Server Indexes - Covered Indexes
    05:07
  • SQL Server Indexes - Creating Indexes
    05:24
  • SQL Server Indexes - Columnstore Indexes
    08:32
  • SQL Server Indexes - Managing Indexes
    05:52
  • SQL Server Indexes - Rebuilding and Reorganizing
    05:11

  • Introduction
    08:42
  • SQL Server 2016 - Creating A View
    06:27
  • SQL Server 2016 - Updateable Views
    04:10
  • SQL Server 2016 - Indexed Views
    06:41

  • Introduction
    09:03
  • SQL Server 2016 - Understanding Transactions
    04:48
  • SQL Server 2016 - Transaction Log
    09:24
  • SQL Server 2016 - Using Explicit Transactions
    06:27
  • SQL Server 2016 - Savepoints - 1
    07:29
  • SQL Server 2016 - Savepoints - 2
    02:50

  • Introduction
    07:37
  • SQL Server 2016 - Creating Stored Procedures
    05:55
  • SQL Server 2016 - Using Input Parameters
    05:28
  • SQL Server 2016 - Using Output Parameters
    07:17
  • SQL Server 2016 - Table-Valued Parameters - 1
    07:56
  • SQL Server 2016 - Table-Valued Parameters - 2
    06:42
  • SQL Server 2016 - Return Status - 1
    07:46
  • SQL Server 2016 - Return Status - 2
    04:07
  • SQL Server 2016 - Natively Compiled Stored Procs
    06:48

Instructor

CubeTech Academy, LLC.
Learn Skills and Get Certified Easily
CubeTech Academy, LLC.
  • 4.2 Instructor Rating
  • 3,871 Reviews
  • 12,864 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
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.