Leason 1 Flashcards
RDBMS
Relational Database Management System
SSMS
SQL Server Management Studio- a Microsoft tool that allows users to manage SQL infrastructure
RDP
Remote Desktop Protocol - what the DBA uses to connect to a server.
OLTP
online Transactional Processing- Database - real life database transaction
OLAP
Online Analytical Processing Database - Not real life but it analyzes a large amount of data
Four Pillars- Four Server components
CPU/Processing, Storage, Memory, Network
SSMS
SQL Server Management Studio -
once a DBA download this on the server itself, the DBA does not need to use RDP to connect to server
Examples of RDBMS
Window SQL, Oracle, MySQL, DB2
Examples of RDBMS
Window SQL, Oracle, MySQL, DB2
Types of SQL Server Editions
Enterprise, Standard, Developer (Free), and Express
Examples of SQL Server versions
2012, 2014, 2016, 2017, 2019
Server types
P( production); T (test); D (Development)
CR1WinPSQL01
Cyrus One Data Center location
Window Operating system
Production line
SQL Server 01
Standard edition licensing - you can license in 2 ways
Per Core or Per Cal
CAL
Client Access License
Is it adding CPU or memory that affect Licensing?
Adding CPU
Servers are built by
System administrators
Relational databases are
Tables which are logically related to each other.
RDBMS is used to
Manage any database
Which Microsoft SQL server editions are used in real life
Enterprise or Standard
MSDN Subscription
Microsoft Domain Network Subscription-
RTM
Release to Manufacture -meaning software version is considered final and ready to be sent to the manufacturing team to be packaged and distributed to customers
3 Phases of Instalation
Pre-installation, Installation and post- installation
The main job of a DBA is
Safeguarding the whole database
