/Advanced-Database-Management-Course

This course covered advanced database design, development and administration. Covered the following topics: • Application of ERDs to complex database design decisions. • Knowledge of, and implementation of, the 7 normal forms to table designs. • Use of complex operators such as Apply, Intersect, Except, Over, Partition BY, CTE, Nested Queries, Temp Tables. 2 • Knowledge and use of: UDF, Parameterized SQL, SQL Injection, SQL Agent Jobs, Optimization, DM_Exec, Query Performance, Execution plans, Hints. • Creating an Azure SQL database with logins, users and roles. • Creating schemas and permissions. • Concurrency c

This repository is not active