This course Exam 70-761: Basic Database Concepts is the first part of the series-

1. Basic Database Concepts

2. Manage data with Transact-SQL

3. Query data with advanced Transact-SQL Components

4. Program Database by using Transact-SQL

In this course, you will learn-

Basic Database Concepts

• What is Data, Field, Record and database?

• Limitations of File Management System.

• Basic Concepts of Advantages of DBMS

• Levels of Abstraction

• Exploring Relational DBMS

• Understanding E-R Modeling With Example

• Understanding Normalization with Example

SQL Server Installation

• Installing SQL Server various Versions

• Installing SQL Server Mangement Studio

• Understanding SQL Server Instances

• Connecting to SQL Server Instance using SSMS

Introduction to SQL SERVER and SQL

• History and Editions of SQL Server

• Server Components and Tools

• Instance and Browser Service

• Starting and Stopping SQL Server Service

• Types of Authentication

• Management Studio

• Types of System Databases

• Introduction to SQL

Create Database

• Create Database Using User Interface

• Understanding Files and FileGroup

• Create Database Using T-SQL

• Alter Database

Working With Table

• Working With SCHEMA

• CREATE/ALTER/DROP SCHEMA