Software methodologies
- SDLC
- Waterfall model
- Agile methodology
- Iterative development
- SCRUM
Database Concepts
- Entities & relationships
- Database design methodologies: OLTP
- Datawarehouse design methodologies:OLAP
- Normalisation & Denormalisation
- Optimising Database performance
- Types of Authentication
T-SQL
- Logins/Data types/Conversions
- Tables
- DDL: CREATE,alter,drop,truncate
- DML: Insert,update,delete
- DCL: Grant,revoke
- Constraints,Indexes
- Views, Synonyms
- Exception handling
- Transactions -TCL :Commit,rollback,savepoint
- Cursor
- Variables/Control structure
- Stored procedures
- Functions
- Triggers
- Virtual tables/Magic tables
- Challenges Faced and Solutions
SQL Queries
- DQL: Sql functions
- Sql operators
- Group by,having
- Select, From, Where, select into
- Distinct,Order by,top,set operators, output, XML
- Joins
- Sub-queries
- Dynamic queries
- Logical order of query processing
- Challenges Faced and Solutions
