Week 2 curriculum - 1909-sep30-net/trainer-code GitHub Wiki
- RDBMS
(Table, Row, Column, PK, FK, Referential Integrity, Anomalies, Multiplicity)
- Normalization
(Dependency, Candidate Key, 1NF, 2NF, 3NF)
- DML
(Select, Insert, Update, Delete, Truncate)
- DDL
(Create, Alter, Drop)
- 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)
- Transaction
(Commit, Rollback, Savepoint)
- Isolation
(Read-Uncommitted, Read-Committed, Repeatable-Read, Serializable)
- Test Driven Development
(Unit-Testing)
- ACID
(Atomicity, Consistency, Isolation, Durability)
- Design Techniques
(Repository-Pattern)
- ADO.NET
(Connected-Architecture, Disconnected-Architecture, DataReader, DataAdapter, DataSet)
- Entity Framework
(ORM, Database-First Approach, DbContext, DbSet, LINQ, Deferred Execution, Tracking)