Click here to Skip to main content
15,867,686 members
Articles / Programming Languages / SQL

Good to Know SQL JARGON – An Interview TIP #56

Rate me:
Please Sign up or sign in to vote.
4.67/5 (5 votes)
9 Oct 2014CPOL1 min read 7.1K   3  
Good to know SQL jargon

In this post, I 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
  7. SSIS: SQL Server Integration Services
  8. SSAS: SQL Server Analysis Services
  9. SSMS: SQL Server Management Studio
  10. SSRS: SQL Server Reporting Services
  11. Magic Table: A temporary table use at the time of trigger
  12. DML: Data Manipulation Language (Insert/Update/Delete)
  13. DDL: Data Definition Language (Create /Alter /Drop)
  14. DCL: Data Control Language (Grant /Revoke)
  15. TCL: Transaction Control Language (Rollback /Commit)
  16. ACID: Atomicity, Consistency , Isolation ,Durability
  17. PK: Primary Key
  18. FK: Foreign Key
  19. NF: Normal Form (1NF,2NF,3NF)
  20. ODBC: Open Database Connectivity
  21. OLEDB: Object Linking and Embedding Database
  22. RDBMS: Relational Database Management System
  23. CRUD: Create, Read , Update, Delete
  24. ETL: Extract Transform Load
  25. BI: Business Intelligence
  26. SP: Stored Procedure
  27. VLDB: Very Large Data Base
  28. CTE: Common Table Expression
  29. CDC: Change Data Capture
  30. TDE: Transparent Data Encryption

I will add more in future.

Thanks & enjoy !!!

Filed under: CodeProject, Database, DENALI, SQL Server, SQL SERVER 2008 - R2, SQL SERVER 2014, SSIS, SSRS, TIPS
Tagged: SQL JARGON, Sql server, TIPS

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Team Leader
India India
I am Rajat Jaiswal from India. I am working as a Technology specialist in one of the reputed company in India with 12+ years of experience. I am a Microsoft Data Platform MVP & Alibaba Cloud MVP.
I have always had an affinity to learn something new in technology. Database, Web development, Cloud computing are the areas of my interests always.
I have been a regular contributor to technologies with more than 300+ tips. Learning & Sharing is one of my aims always. Writing blogs, delivering sessions, helping on forums is my hobby.

Comments and Discussions

 
-- There are no messages in this forum --