Exam 70-761: Basic Database Concepts
Learn basic database concepts and SQL Server installation in this comprehensive course. Gain knowledge on creating databases, working with tables, and managing data using Transact-SQL. Perfect for beginners in IT looking to build a career. Prior knowledge of Windows Operating System is required.
What you’ll learn
- Knowledge about basic Database Concepts
- SQL Server Installation – Installing SQL Server various Versions, SSMS, Understand server instances
- Introduction to SQL SERVER and SQL
- Create Database – using User Interface, T-SQL
- Working With Table – CREATE/ALTER/DROP
This course Exam 70-761: Basic Database Concepts is the first part of the series-
Basic Database Concepts
Manage data with Transact-SQL
Query data with advanced Transact-SQL Components
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
Who this course is for:
- Any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.
User Reviews
Be the first to review “Exam 70-761: Basic Database Concepts”
You must be logged in to post a review.
There are no reviews yet.