Week 2 curriculum

• LINQ (IEnumerable, IQueryable)

• Logging

• RDBMS (Table, Row, Column, PK, FK, Referential Integrity, Multiplicity)

• Normalization (Anomalies, Dependency, Candidate Key, 1NF, 2NF, 3NF)

• DML (Select, Insert, Update, Delete, Truncate)

• DDL (Create, Alter, Drop)

• Constraints (PK, FK, Unique, Check, Null, Not-Null, Default)

• JOIN (Inner-Join, Left-Join, Right-Join, Full-Join, Cross-Join, Self-Join)

• UNION (Union, Union-All, Intersect, Except)

• Subquery (CTE, Using-From, Using-Where)

• Aggregate (Average, Count, Sum, Min, Max)

• View (Schema-Binding)

• Function (Parameter, Scalar, Tabular)

• Stored Procedure (Variable, If-Else, Try-Catch, Throw, RaiseError, Print)

• Trigger (For, After, Instead-Of, Insert, Update, Delete)

• ACID (Atomicity, Consistency, Isolation, Durability)

• Transaction (Commit, Rollback, Savepoint)

• Isolation (Read-Uncommitted, Read-Committed, Repeatable-Read, Serializable)

• ORM (Entity Framework)

• EF model (Database-First Approach, DbContext, DbSet)

• EF querying (Eager Loading, LINQ, Deferred Execution)

• EF saving (Tracking, SaveChanges)

• Design Techniques (Repository-Pattern)

pushed to next week: EF Code-First Approach, Lazy Loading, Explicit Loading