Microsoft SQL Server for Beginners | Crash Course

Boot-camp for SQL Query Writing Skills | sql fundamentals for beginners | Database Crash course | Database Programming
4.33 (1802 reviews)
Udemy
platform
English
language
Databases
category
instructor
Microsoft SQL Server for Beginners | Crash Course
170,800
students
2.5 hours
content
Jul 2023
last update
$44.99
regular price

What you will 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

Screenshots

Microsoft SQL Server for Beginners | Crash Course - Screenshot_01Microsoft SQL Server for Beginners | Crash Course - Screenshot_02Microsoft SQL Server for Beginners | Crash Course - Screenshot_03Microsoft SQL Server for Beginners | Crash Course - Screenshot_04
Related Topics
1326916
udemy ID
8/21/2017
course created date
1/19/2020
course indexed date
Lee Jia Cheng
course submited by