Databases Advanced - EntityFrameworkCore

Containing the tasks from Softuni's course DB Advanced:

• working with ORM EF Core
• database-first design
• code-first design
• relations between tables
• querying using LINQ
• mapping DTOs with Automapper
• export and import data from JSON
• export and import data from XML

Tasks

1. Defining Classes
2. Encapsulation and Validation
3. Inheritance
4. OOP Introduction Exercise
5. Intro to EF Core
6. Code-first
7. Entity relations
8. Advanced relations
9. Advanced querying
10. Best practices and architecture
11. Auto-mapping
12. External format processing
13. Workshop
14. Exam preparation - Instagraph with annotations
15. Exam preparation - Stations

Exam

• Exam 10th Dec 2017 - FastFood

Databases Basics - MS SQL Server

The course includes working with MSSQL Server, T-SQL:

• creating tables and relations between them
• queries and nested queries
• built-in functions
• user-defined functions
• stored procedures
• transactions
• triggers

Exercises

• Data Definition And Datatypes
• Basics CRUD
• Built-in Functions
• Data Aggregation
• Table Relations
• Joins and Subqueries
• Functions and Procedures
• Triggers and Transactions
• Additional Exercises

Exam

• Exam - 22 October 2017