Good to Know SQL JARGON - An interview TIP #56
Good to Know SQL JARGON - An interview TIP #56
Join the DZone community and get the full member experience.
Join For FreeDownload Microservices for Java Developers: A hands-on introduction to frameworks and containers. Brought to you in partnership with Red Hat.
Hello friends,
Just wanted to share some technical words here again it is good to know.
1) OLAP : On Line Analytical Processing
2) MOLAP :- Multidimensional On Line Analytical Processing
3) ROLAP :- Relational On Line Analytical Processing
4) HOLAP :- Hybrid On Line Analytical Processing
5) RTOLAP :- Real Time On Line Analytical Processing
6) DOLAP :- Desktop On Line Analytical Processing
8) SSIS :- SQL Server Integration Services
9) SSAS :- SQL Server Analysis Services
10) SSMS :- SQL Server Management Studio
11) SSRS :- SQL Server Reporting Services
12) Magic Table:- A temporary table use at the time of trigger
13) DML :- Data Manipulation Language (Insert/Update/Delete)
14) DDL :- Data Definition Language (Create /Alter /Drop)
15) DCL :- Data Control Language (Grant /Revoke)
16) TCL:- Transaction Control Language (Rollback /Commit)
17) ACID :- Atomicity, Consistency , Isolation ,Durability
18) PK- Primary Key
19) FK – Foreign Key
20) NF:- Normal Form (1NF,2NF,3NF)
21) ODBC :- Open Database Connectivity
22) OLEDB :- Object Linking and Embedding Database
23) RDBMS :- Relational Database Management System
24) CRUD:- Create, Read , Update, Delete
25) ETL :- Extract Transform Load
26) BI :- Business Intelligence
27) SP :- Stored Procedure
28) VLDB :- Very Large Data Base
29) CTE:- Common Table Expression
30) CDC :- Change Data Capture
31) TDE :- Transparent Data Encryption
I will add more in future.
Thanks & Enjoy !!!
RJ !!!
Download Building Reactive Microservices in Java: Asynchronous and Event-Based Application Design. Brought to you in partnership with Red Hat.
Like This Article? Read More From DZone
Published at DZone with permission of Rajat Jaiswal , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}