Microsoft SQL Server for Beginners | Crash Course For Free
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