Book 3 Server Side

Question 1

What is PostgreSQL?

Answer 1

software system designed to manage databases. open source, relational, database management system ( RDBMS ).

Question 2

RDBMS

Answer 2

relational database management system, meaning it follows a relational model. It organizes databases into tables , where each table consists of rows and columns. Tables can have relationships with each other.

Question 3

What is SQL

Answer 3

structured query language , a language used to interact with databases.

Question 4

EF Core

Answer 4

Entity Framework Core . A framework that helps bridge the gap between our c# .NET API and our database. EF Core translates our linq methods in our endpoints into SQL queries to our database.

Question 5

what is a connection string?

Answer 5

the connection string tells our program how to find and interact with the database .. the connection string is a set of instructions that tells your application how to reach the database server, authenticate itself, and establish a connection.

Question 6

what is an Attribute in c#?

Answer 6

keywords or annotations that assign metadata to code elements.

Question 7

What is a reference type?

Answer 7

Classes would be considered reference types in c# … reference types is a type of data, where the variable holds a reference to where the data is stored in memory, rather than holding the data itself.

Question 8

What is Db Context

Answer 8

a class we inherit from EF Core that allows us to update, manage, and interact with our database

Question 9

What is Db Set

Answer 9

a property on the Db Context class from EF Core that represents a database table in our code. Represents a collection of entities of a specific type.

Question 10

What is inheritance in c#

Answer 10

a fundamental concept in object oriented programming that allows properties, methods, fields, and behavior to be passed down from a parent class to a child class… or in other words from a class to a sub class or derived class

Question 11

what is dotnet user secrets ?

Answer 11

tool for managing sensitive configuration data during development .. it allows us to store our connection string

Question 12

what is a constructor?

Answer 12

a special method that belongs to a class that is automatically called when an instance of that class is created.

Question 13

what are access modifiers ?

Answer 13

keywords to specify the accessibility level of classes, properties, fields, or other members of a program. They control what parts of the program are visible and accessible to other parts.

Question 14

what are overrides?

Answer 14

code that replaces other code …keyword to explicitly indicate that you are providing a new implementation for a method or property inherited from a base class.

Question 15

what is a base class?

Answer 15

also known as a parent class or super class, is a class in which subclasses or derived class inherit properties, methods, and behavior from

Question 16

what is encapsulation?

Answer 16

This means keeping code that is only safe or useful to use inside a particular context inaccessible to other parts of the program

Question 17

object initializer

Answer 17

syntax feature that allows you to initialize the properties or fields of an object directly at the point of its creation