1. WHAT IS DATABASE?
DATABASE IS A PLATFORM TO STORE ANY TYPE OF DATA, ANY AMOUNT OF DATA. EXCEL
FOR EASY, FASTER & SECURED ACCESS.
2. WHAT IS SQL SERVER?
A DATABASE MANAGEMENT SYSTEM (DBMS SOFTWARE) USED TO STORE DATABASES OF ANY SIZE. UNLIMITTED USERS. OFFICE
3. WHY SQL SERVER?
CHEAPER (14500 USD PPL) EASY USAGE FREE TECHNICAL SUPPORT
FREE UPDATES HIGHLY SCALABLE FREE BI TOOLS (ex: MSBI)
SUPPORTS NON-CLOUD & CLOUD * Business Intelligence for Analysis, Reporting
4. WHAT ARE THE DIFFERENT “VERSIONS” OF SQL SERVER?
SQL SERVER 2017*, SQL SERVER 2016, SQL SERVER 2014, SQL SERVER 2012
SQL SERVER 2008 R2, SQL SERVER 2008, SQL SERVER 2015, SQL SERVER 2000
5. WHAT ARE THE DIFFERENT “EDITIONS” OF SQL SERVER?
DATA CENTER EDITION, ENTERPRISE*, EVALUATION, STANDARD, DEVELOPER, EXPRESS EDITON
6. WHAT DOES SQL SERVER CONTAIN?
SQL SERVER CONTAINS DATABASES
DATABASES CONTAIN TABLES
TABLES CONTAIN ACTUAL DATA
7. WHAT IS SQL?
STRUCTURED QUERY LANGUAGE: A LANGUAGE USED TO COMMUNICATE WITH ANY DATABASE FOR DESIGN, STORAGE, TESTING & MANAGMENT ACTIVITIES.
8. WHAT IS T-SQL?
TRANSACT SQL: A LANGUAGE USED TO COMMUNICATE EXCLUSIVELY WITH SQL SERVER DATABASES FOR DESIGN, STORAGE & MANAGMENT ACTIVITIES.
9. WHAT ARE THE COMPONENTS IN SQL SERVER?
1. DATABASE ENGINE : TO DESIGN AND MANAGE OLTP DATABASES. ONLINE TRANSACTION PROCESSING DATABASE. LIVE DATA
2. ANALYSIS SERVICES : TO DESIGN AND MANAGE OLAP DATABASES. ONLINE ANALYTICAL PROCESSING DATABASE. FORECAST
3. INTEGRATION SERVICES : TO DESIGN AND MANAGE DWH DATABASES. DATAWAREHOUSE = TO STORE HISTORICAL DATA. SSIS.
4. DATA SCIENCE TOOLS : NEW FROM SQL SERVER 2017 VERSION. THIS CONTAINS “R” AND “PYTHON”.
++++
5. REPORTING SERVICES : AUTO INSTALLED WITH SQL SERVER 2016 AND EARLIER VERSIONS