Learn Databases, SQL and ORM

[nakov]

Learn database basics:

• MS SQL Server or MySQL
• Creating tables and relationships
• Basic SQL commands

Database Basics course @ SoftUni: https://softuni.bg/trainings/2495/databases-basics-ms-sql-server-september-2019

Learn database ORM technologies at basic level:

• CRUD operations using Entity Framework or other ORM

Entity Framework Core ORM course @ SoftUni: https://softuni.bg/trainings/2457/entity-framework-core-october-2019

[nakov]

Learning Databases and SQL

1. Install MS SQL Server: https://softuni.bg/trainings/resources/officedocument/42751/sql-server-installation-guide-win-10-databases-basics-ms-sql-server-september-2019/2495
2. Install SQL Server Management Studio: https://softuni.bg/trainings/resources/officedocument/42751/sql-server-installation-guide-win-10-databases-basics-ms-sql-server-september-2019/2495
3. Watch DB Intro video: https://softuni.bg/trainings/resources/video/42796/video-16-september-2019-stoyan-shopov-databases-basics-ms-sql-server-september-2019/2495
4. Watch the CRUD in SQL Server video: https://softuni.bg/trainings/resources/video/42895/video-19-september-2019-stoyan-shopov-databases-basics-ms-sql-server-september-2019/2495

[nakov]

Learning ORM and EF Core

1. Watch the EF Core Intro video: https://softuni.bg/trainings/resources/video/44024/video-28-october-2019-ivaylo-kenov-entity-framework-core-october-2019/2457

Also, take a detailed look at the presentation slides: https://softuni.bg/trainings/resources/officedocument/43991/presentation-entity-framework-core-october-2019/2457

2. Follow the guidelines and exercises about ORM with EF Core: https://softuni.bg/trainings/resources/officedocument/43993/exercise-problem-descriptions-entity-framework-core-october-2019/2457