MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 7 lectures (1 hours, 54 mins) | Size: 249 MB

This course is designed for those students who want to learn the basic concepts of database as well as to improve their SQL Query writing skills instantly.

What you'll learn

Basic Concepts of Database

Structured Query Language (SQL)

Type of SQL Joins

Type of Relationships

Installation guide of Microsoft SQL Server

Creation of Database by using Microsoft SQL Server

SQL Development

Database Development

Requirements

A Personal Computer

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

Willingness to learn

Description

After completing the course, you will have the sufficient knowledge of the following key areas:

What is RDBMS

Famous RDBMS that are being used in modern age.

Basic Concepts of Primary Key,Composite Key and For Key

Fundamentals of SQL

Concepts of Data Models ( One to One, One to Many , Many to Many)

Step by Step guide to install SQL Server

Steps to create a Database in Microsoft SQL Server

SELECT statement

Applying Data filters

Insertion

Update existing data in a table

Delete data of a table

Types of SQL Joins

Who this course is for:

Anyone with basic knowledge of computer



DOWNLOAD
uploadgig