Explore

Learn SQL (Microsoft SQL) - Beginner's Course

2.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

A detailed step by step course for learning SQL using Microsoft SQL Server

Description

SQL (Structured Query Language) is a language which is used to interact with databases which stores data. Microsoft provides SQL Server to manage the data and the query language which enables to store and retrieve the data with ease. With the emergence of Big Data and Business Intelligence there is an extensive demand for the resources who has basic SQL skills.

This course will teach you how to use the SQL language with Microsoft SQL Server, one of the popular database server in the world.

In this course we will learn the following topics

Introduction to SQL

SQL Constraints

SQL Data types

DDL, DML, DCL & TCL

SQL Operators

Groups in SQL

Built-in Functions in SQL

Sub-Query, Inner Query, Co-related Query

Joins, Inner,Outer,Left and Cross Join

At the end of the course, you will gain a good knowledge and will be able to write SQL queries with ease.

Requirements

Requirements
Microsoft SQL Express 2017 installed
SQL Server Management Studio 2017 installed
SQL Server management studio must be configured to connect to SQL Express instance.

Recommended for you

SQL Server Reporting Services Part 1 (SSRS)

Learn how to create from simple to complex reports for your business decision making needs...

Save Course

Learn Hadoop and Azure HDInsight basics this evening in 2 hr

Learn basics of Hadoop and how to implement Hadoop components in Azure cloud through HDInsight Expected Outcomes Hadoop Basics Microsoft Azure HDInsight...

Save Course