SQL Server Essentials for Developers

collapse

Course Details

This course can only be taken as part of the Certificate in SQL Server & Database Development.

Get Program Details

About this Course


This course lays the foundations for understanding the basics of SQL programming. We’ll accomplish this by examining the various data estate professions. Additionally, we'll discuss the fundamentals of database planning and modeling, primary database objects, SQL syntax basics and relational data access. 

What You'll Learn

  • Fundamentals of Relational Theory and the Normalization process 
  • Techniques for using graphical and command-line tools to work with SQL Server and its objects 
  • How to connect to SQL Server databases 
  • Methods for writing, testing and tuning advanced T-SQL language elements 
  • How to design relational database structures from a set of business requirements 
  • The basics of Microsoft Cloud Data Services 

Get Hands-On Experience

  • Build and deploy a database as your final project, delivered as a series of scripts, along with the entity relationship diagram (ERD) and pertinent conceptual documents
  • Practice using tools such as SQL Server Management Studio, Microsoft PowerShell, and Git source code control

Program Overview

This course is part of the Certificate in SQL Server & Database Development.

  Get our email newsletter with career tips, event invites and upcoming program info.       Sign Up Now