Containing homeworks and lab exercices from "Databases Basics - MS SQL Server" and "Databases Advanced - Entity Framework" courses @ SoftUni December 2017

   The “ Databases Fundamentals” module includes 2 courses:

    1. Databases Basics - MS SQL Server course covers:

• Databases Introduction - What are DBs, RDBMS. MSSQL installation. Using databases Playground

• Data Definition and Datatypes - Common datatypes, CREATE syntax, SSMS DDL + Basic DML

• Basic CRUD operations - INSERT, UPDATE, SELECT, DELETE (+ GUI) and WHERE clauses, ALIASES, SEQUENCES

• Built-in functions - String, Math, Date, etc. functions, Wildcards, LIKE

• Data Aggregation - GROUP, HAVING, GROUP with Aggregation functions (MIN, MAX, SUM, COUNT, AVG…)

• Table Relations - Database Design, Table Relations, Foreign keys, Cascade, E/R Diagram

• Joins and Subqueries - Joins (LEFT, RIGHT, INNER), Subqueries, Common-Table-Expression, INDICES (clustered and non-clustured)

• Functions, Procedures, Triggers and Transactions - User-defined Functions, Procedures and Triggers, Transactions

    2. Databases Advanced - Entity Framework course covers:

• DB Apps Introduction - What is an ORM, popular ORMs, Native way to connect to DB (ADO.NET)

• Introduction to Entity Framework - Nuget package, Installation, Connection strings, Configuration

• Code-First - Setting up code-first framework, Entities, DB context, Persisting, Fetching, Initialization strategies, Migrations, Database seeding

• Entity Relations - Object composition, Relational entities, Collections, Navigation properties, Attributes

• Advanced Querying - Manipulating how EF accesses data, Query optimization, Caching, Concurrency

• Best Practices and Architecture - Code organization patterns, Application layers, Splitting large codebases

• C# Auto Mapping Objects - Auto Mapping - data transition objects and domain objects

• External Format Processing - JSON and XML standard, Parsing files, Exporting to files, using a framework