Microsoft SQL Server Development for Everyone [FREE]

Free Certification Course Title: Microsoft SQL Server Development for Everyone

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

Microsoft SQL Server Development for Everyone

What you’ll learn:

  • Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
  • Using Microsoft SQL Management Studio
  • SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
  • DELETE: How to remove data from a database
  • INSERT INTO: How to insert data into a table
  • UPDATE: How to update existing data
  • Overall Database Development Best Practices
  • Creating Relationships and Foreign Keys
  • How to query related data from multiple tables
  • Using Aggregate Functions in SQL
  • How to export Query Results to Excel
  • How to craft SQL statements based on real scenarios
  • Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
  • Backup and Restore Databases
  • Generate Database Scripts for Automation

Requirements:

  • A Computer
  • A desire to learn database development

Who this course is for:

  • Beginner Database Developer
  • Intermediate Database Developers
  • Potential Database Administrators
  • Those who work in organizations where the company typically uses Microsoft databases.

Description:

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started at a Database Developer or Junior Database Administrator.

Why Learn Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications

This course includes:

  • 6 hours on-demand video
  • 1 article
  • 18 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion