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 FreeTake 60 minutes to understand the Power of the Actor Model with "Designing Reactive Systems: The Role Of Actors In Distributed Architecture". Brought to you in partnership with Lightbend.
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 !!!
Learn how the Actor model provides a simple but powerful way to design and implement reactive applications that can distribute work across clusters of cores and servers. Brought to you in partnership with Lightbend.
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 }}