Microsoft SQL Server 2016 Essential Training

Microsoft SQL Server 2016 Essential Training

Microsoft SQL Server 2016 Essential Training is an Intermediate level course on Business, produced by an expert, Martin Guidry. This course is an essential base for anyone who needs to get better at his/her Business talent. It gives you a thorough grip on Business, IT and Hardware, Developer, IT, Web, Databases, SQL Server, Business, IT and Hardware, Developer, IT, Web, Databases and SQL Server.

Free Download - Microsoft SQL Server 2016 Essential Training
Author Martin Guidry
Publish Date 11/16/2016
Skill Intermediate
Duration 3h 18m
Topic Business
Video Tutorials 60
Last Update N/A

SQL Server supports mission-critical applications and big data solutions—without having to buy expensive add-ons or high-end appliances. Learn the essentials of Microsoft’s latest release, SQL Server 2016. Use tools like SQL Management Studio and the Configuration Monitor to deploy and manage databases both on premises and in the cloud. Learn how to create new databases, build tables, define relationships, write queries, and use stored procedures and built-in functions. Instructor Martin Guidry—a SQL Server veteran—also shows how to manipulate XML and JSON data, and perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring. Plus, find out how to extend SQL Server by integrating it with cloud services like Microsoft Azure.

Topics include:

  • Installing SQL Management Studio
  • Using SQL Server Configuration Monitor
  • Creating a database
  • Creating tables with SMS and T-SQL
  • Creating relationships between tables
  • Creating views
  • Writing queries to return XML
  • Working with XML and JSON
  • Backing up and restoring SQL Server
  • Monitoring and management
  • Security
  • Performance
  • Integrating SQL Server with cloud services like Azure

Microsoft SQL Server 2016 Essential Training : Video Lessons

  • Welcome1m
  • What you should know before starting44s
  • Using the exercise files26s
  • Understanding core concepts of SQL Server 20162m 1s
  • SQL Server editions2m 22s
  • Basic installation6m 22s
  • Advanced installation options7m 6s
  • Install SQL Management Studio1m 56s
  • Using SQL Server Configuration Manager4m 17s
  • Basics SQL Server Management Studio6m 4s
  • More about SQL Server Management Studio5m 23s
  • Activity Monitor3m 31s
  • Profiler4m 20s
  • Create a database3m 16s
  • Advanced database configuration options3m 32s
  • Install a sample database3m 12s
  • Create a table using Management Studio3m 2s
  • Understanding data column options2m 52s
  • Create a table using T-SQL1m 41s
  • Create relationships between tables3m 44s
  • In-memory tables3m 34s
  • Temporal tables5m 19s
  • Create a view3m 17s
  • Understanding the advanced options of views4m 5s
  • Stored procedures3m 23s
  • Parameterized stored procedures4m 14s
  • Built-in functions1m 50s
  • Scalar functions2m 10s
  • Introduction to XML1m 29s
  • Write queries to return XML2m 38s
  • Shred XML2m 23s
  • Working with XML schemas1m 48s
  • Storing XML3m 38s
  • Working with JSON2m 29s
  • Converting JSON to tabular data1m 34s
  • Storing JSON2m 19s
  • Overview of backup and restore in SQL Server5m 29s
  • Basic backups2m 32s
  • Basic restore2m 48s
  • Create maintenance plans to automate backups4m 45s
  • Add a cleanup task to a maintenance plan3m 15s
  • Review logs in SQL Server 20162m 32s
  • Audit logins2m 35s
  • Understanding dynamic management views2m 47s
  • Using database console commands (DBCC)2m 51s
  • Overview of high availability in SQL Server 20168m 42s
  • Overview of authentication in SQL Server2m 45s
  • Instance-level logins2m 47s
  • Database-level users2m 24s
  • Encrypt data5m 24s
  • Dynamic masking3m
  • Basics of indexes3m 4s
  • Create an index6m 18s
  • Columnstore index3m 12s
  • Explore execution plans5m 1s
  • Overview of Query Store3m 18s
  • Back up to Azure3m 9s
  • Set up Stretch Database4m 46s
  • Monitor Stretch Database1m 24s
  • Next steps33s

Recommended video tutorials from YouTube.

  • SQL Server 2016 Tutorial for Beginners
  • Gain real-time insights across your transactional and analytical data with SQL Server 2016—a secure, scalable database platform that has everything built in, ...

  • DateTime : 2016-10-24 08:43:58
  • Source : TechKeka
  • Learn SQL in 1 Hour - SQL Basics for Beginners
  • A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management ...

  • DateTime : 2017-09-14 00:48:28
  • Source : Joey Blue
  • SQL Server Tutorial For Beginners | Learn Basic to Advance
  • SQL Server Tutorial For Beginners Enroll Now: https://goo.gl/qgsCAA Learn SQL Server Tutorial For Beginners, Guys, I developed Complete Course For ...

  • DateTime : 2018-05-07 13:57:25
  • Source : OnlineITtuts Tutorials
HELP THE AUTHOR

Please consider buying this course - Microsoft SQL Server 2016 Essential Training directly from the author - Martin Guidry. This way you could help the author create more great content, also you may get personal help.

The links being shared are only for poor students who really cannot afford to pay. So, if you are capable of paying please do consider it once before trying the free download links.

Categorised in: , , , , , ,

Kindly note, we have recently migrated to a new server. In case of download links not working at all it means that we are undergoing maintenance at the backend. In such case please try after 24 hours. Also make sure your internet connection is persistant else the file may endup corrupted.