Programming Microsoft SQL Server for Beginners

[Odin]

What you’ll learn
Introduction to Database Management System (DBMS)

Understand and Use Databases

Data Models

Relational Database Management System (RDBMS)

How Primary Key works

How Composite Key works

How Foreign Key works

Structured Query Language (SQL)

Type of Relationships e.g. One to One relationship , One to Many relationship and Many to Many Relationship

Step by Step guide to install Microsoft SQL Server

Create new Database by using Microsoft SQL Server Management Studio

CRUD Operations

Selection of DISTINCT Records

Writing SQL Queries to learn different type of SQL Joins

SQL Development by using Microsoft SQL Server

Database Development

Definition of Aggregate Functions

Count function

Min Aggregate function

Max Aggregate function

Sum Aggregate Function

Different variations of Group By Clause

Converting values in Upper case

Converting values in Lower Case

Substring function

TOP keyword

Understand and Use SQL with Databases

Requirements
A Personal Computer

SQL Server installation on Student’s PC will be preferred but it is not mandatory

Willingness to learn the Microsoft SQL Server

Who this course is for:
Anyone with basic knowledge of computer

Any One willing to learn SQL Server​

To view the content, you need to Sign In or Register.