Learn SQL (Microsoft SQL) - Beginner's Course

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

4.25 (76 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
Learn SQL (Microsoft SQL) - Beginner's Course
2,536
students
2 hours
content
Mar 2020
last update
FREE
regular price

What you will learn

What is Database, RDBMS and why do we need it?

SQL fundamentals and Types of commands (DDL,DML,DCL and TCL)

What are constraints and how to use these constraints (such as Primary key, Foreign Key along with some more)

Various Datatypes and Operators

Grouping of data using Group By and Order By

What is Inner Query and Co-related query with an example

Types of Joins with Example (Inner Join, Outer Join, Left, Right and Cross Join)

Why take this course?

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—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

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.

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. This tutorial explains some basic.

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.


Due to time constraint for free videos some videos are unpublished, pls go to you tube channel Raj Tech-Trainer and subscribe the channel for upcoming videos

Reviews

Bogdan
November 17, 2023
Very detailed explanations of fundamental database concepts. Hands-on sessions were provided to exemplify the theory
Sk
September 3, 2020
Reading own slides block understanding. more explanation required apart from what ever written on slides.
Rodney
August 14, 2020
A little repetitious. Some word pronunciation issues, but it's fine so far. I'm able to back up if I miss something.

Charts

Price

Learn SQL (Microsoft SQL) - Beginner's Course - Price chart

Rating

Learn SQL (Microsoft SQL) - Beginner's Course - Ratings chart

Enrollment distribution

Learn SQL (Microsoft SQL) - Beginner's Course - Distribution chart

Related Topics

2836896
udemy ID
2/26/2020
course created date
3/15/2020
course indexed date
Bot
course submited by