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
