Course Code:
sqladvancedcusto
Duration:
35 hours
Prerequisites:
Basics of T-SQL
Course Outline:
1. DBDev: SQL, SELECT, GROUP, JOIN, modify data, Transactions, Handling date
2. DBDev/DBA: (rest of 1st day), Instance & DB configuration
3. DBA:, system databases, security, permissions
4. DBA: Recovery models, backups, sql server agent (automation)
5. DBA/Dev: Performance: Indexes- types, fragmentation, rebuild