Copyright IntelliPaat.

All rights reserved

 Agenda
01 DBA & Roles of 02 Types of DBA
DBA

03 Intro to MS SQL 04 Evolution & Editions of SQL Server

Server

05 Instances in SQL Server 06 SQL Server System Databases

Copyright IntelliPaat, All rights reserved

Data Base Administrator

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment

Copyright IntelliPaat. All rights reserved

Roles of Data Base Administrator

1 Software Installation and Maintenance

2 Taking care of Database backup & recovery

3 Maintaining security of the database

4 Take care of Access Control for different users

5 Monitor databases for performance issues

Copyright IntelliPaat. All rights reserved

Types of DBA

Data Marketing
Production Application Development
UAT DBA warehouse DBA
DBA DBA DBA
DBA

Copyright IntelliPaat. All rights reserved

Intro to MS SQL SERVER

Copyright IntelliPaat. All rights reserved

Intro to MS SQL Server

SQL Server is Microsoft's relational database management system (RDBMS). It is a full-featured database primarily designed to compete
against competitors Oracle Database (DB) and MySQL

It is also an ORDBMS

It is both GUI and Command based software

Copyright IntelliPaat. All rights reserved

Evolution of SQL Server

Copyright IntelliPaat. All rights reserved

Editions of SQL Server

Enterprise Standard Web Developer Express

Edition Edition Edition Edition Edition

Copyright IntelliPaat. All rights reserved

Instances in SQL Server

An instance is a collection of SQL Server databases run by a single SQL Server service

SQL Server Instance

Database 1 Database 2 Database 3

Copyright IntelliPaat. All rights reserved

Default & Named Instances

Instance

1 If you plan to install a single instance of SQL Server on a database server, go with a default instance

Use a named instance for situations where you plan to have multiple instances on the same server
2
computer

3 A computer can host only one default instance; all other instances must be named

Copyright IntelliPaat. All rights reserved

Installing MS SQL SERVER

Copyright IntelliPaat. All rights reserved

Installing MS SQL Server

You can install MS SQL Server from here -> https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Copyright IntelliPaat. All rights reserved

Installing MS SQL Server

Download Developer Edition

Copyright IntelliPaat. All rights reserved

SQL Server System
Databases

Copyright IntelliPaat. All rights reserved

SQL Server System Databases

System databases are defined by Microsoft and are needed for SQL Server to operate. These databases include Master, Model, MSDB &
TempDB

Master Model MSDB TempDB

Copyright IntelliPaat. All rights reserved

Master Database

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon
accounts, endpoints, linked servers, and system configuration settings

Copyright IntelliPaat. All rights reserved

Model Database

The model database is used as a template whenever a new user database is created. You can change most database properties, create
users, stored procedures, tables, views, etc – whatever you do will be applied to any new databases

Copyright IntelliPaat. All rights reserved

msdb Database

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management
Studio, Service Broker and Database Mail

Copyright IntelliPaat. All rights reserved

tempDB Database

Tempdb is the workhorse of the system databases. It is the workspace that SQL Server uses to store the intermediate results of query
processing and sorting

Copyright IntelliPaat. All rights reserved

Quiz

Copyright IntelliPaat. All rights reserved

Quiz

Which of these is an edition of SQL Server:

A Enterprise Edition

B Standard Edition

C Web Edition

D All of these

Copyright IntelliPaat. All rights reserved

Answer

Which of these is an edition of SQL Server:

A Enterprise Edition

B Standard Edition

C Web Edition

D All of these

Copyright IntelliPaat. All rights reserved

Quiz

Which of these is not a SQL Server System Database:

A Master Database

B Slave Database

C Model Database

D tempDB

Copyright IntelliPaat. All rights reserved

Quiz

Which of these is not a SQL Server System Database:

A Master Database

B Slave Database

C Model Database

D tempDB

Copyright IntelliPaat. All rights reserved

Thanks!!!

Copyright IntelliPaat. All rights reserved

India: +91-7847955955

US: 1-800-216-8930 (TOLL FREE)

sales@intellipaat.com

24/7 Chat with Our Course Advisor

Copyright IntelliPaat. All rights reserved