Sql server-concepts

Sirisha K

8y915

Can anyone tell me useful and important concepts in SQL server.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa8y ago
https://www.essentialsql.com/what-are-ten-things-a-junior-dba-should-know/
0
Sirisha K8y ago
Thank You
0
Tushar Dikshit8y ago
Hi,
Here is the listing of topics that you can go through from application developer perspective-

1. RDBMS - relational data, tables, relations E-R etc.
2. SQL server is RDBMS
3. Tables, - Keys, constraints.
4. Table relationships - primary and foreign keys.
5. DCL,DDL, DML statements in SQL
6. SQL queries
7. JOINS, UNIONS
8. Stored procedures
9. Group by, having
10.Aggregate functions
11. with clause
12. CTE- Common Table Expressions
13. Temp tables, variables
14. User defined Functions
15.Cursors
16.Triggers
17. ACID
18. Transactions, Locks
Also you can refer to -
http://www.c-sharpcorner.com/article/most-asked-sql-queries-in-interview-questions/

Thanks
+2
Dharmraj Thakur8y ago
You should learn following thing if your sql basics are fine...

Relationships
Types of Joins and Realtime usage
Clauses
Constrains
Triggers
Indexes
Partitions
Normalization
ACID transactions
And the most important Query Optimization techniques

Thanks
+1