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 FreeDelivering modern software? Atomist automates your software delivery experience.
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 !!!
Start automating your delivery right there on your own laptop, today! Get the open source Atomist Software Delivery Machine.
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 }}