C# Programming (Intermediate) - Lecture 6: Database Design, Identity & Foreign Keys, Salted Hashing

C# Programming (Advanced/Intermediate) Lectures (6/14) will teach you #CSharp #programming from beginner to intermediate/expert level. This course is an excellent source to learn advanced concepts in C# #coding. If you are a beginner to C#, watch our previous course lectures. The playlist link of the previous course is below.

Full playlist of the previous course: C# For Beginners ⤵️ https://www.youtube.com/playlist?list=PL_pbwdIyffskoSXySh0MdiayPJsBZ7m2o

Discord ➡️ https://bit.ly/SECoursesDiscord Patreon ➡️ https://www.patreon.com/SECourses

Technology Playlist (30+ Tutorial / Guide / News / Review Videos) ⤵️ https://www.youtube.com/playlist?list=PL_pbwdIyffsnkay6X91BWb9rrfLATUMr3

Stable Diffusion Playlist (30+ Tutorial / Guide Videos) ⤵️ https://www.youtube.com/playlist?list=PL_pbwdIyffsmclLl0O144nQRnezKlNdx3

Please join discord, mention me and ask me any questions. Thank you for like, subscribe, share and Patreon support. I am open to private consulting with Patreon subscription.

Full playlist of this course ⤵️ https://www.youtube.com/playlist?list=PL_pbwdIyffslHaBdS3RUW26RKzSjkl8m4

You can watch for free our C# Programming, ASP .NET Core MVC programming, Machine Learning and Software Engineering related courses on our playlists page ⤵️ https://www.youtube.com/@SECourses/playlists

GitHub code repository of this course (source codes of the lectures) ⤵️ https://github.com/FurkanGozukara/Introduction-to-Programming-2-2021

In lecture 6:

• How to compose a database in MS-SQL server
• How to design a database in MS-SQL server properly
• What is identity column
• How to reseed identity column
• What is a foreign key
• What is foreign key update delete cascade
• How design a full database with proper primary keys, identity keys and foreign keys
• How to design a database for Patient Management System which includes Users, User types, treatments, drugs, prescriptions, and diseases tables
• How to not write code in main window but compose proper classes to reduce complexity of your MainWindow written code
• What is the purpose of salted password hashing?
• How to do salted SHA256 password hashing?
• How to bind list of custom class elements to a ComboBox and read the value of selected item of that custom class
• How to generate entity framework classes in .NET Core application of existing database with using OnConfiguring builder.UseSqlServer
• How to properly insert a record to the database with Entity framework and handle errors properly
• How to program a register screen for patient management system

Introduction MS-SQL Server is a relational database management system (RDBMS) developed by Microsoft Corporation. It is one of the most popular RDBMS systems in the world and is widely used for various applications. In this article, we will discuss the various aspects of designing and composing a database in MS-SQL Server, including the design process, the various types of database elements, and best practices for creating a comprehensive database.

Composing a Database in MS-SQL Server To compose a database in MS-SQL Server, you need to follow a few steps. Firstly, you need to decide on the schema of the database, which includes the structure and relationships between the various elements of the database. Secondly, you need to create the database and tables using Transact-SQL (T-SQL) commands. Finally, you need to populate the tables with data.

Designing a Database in MS-SQL Server Properly To design a database in MS-SQL Server properly, you need to follow some best practices. These include using appropriate data types, defining primary keys, and using foreign keys to establish relationships between tables. It is also important to normalize the database to reduce redundancy and improve data consistency.

What is Identity Column? An identity column is a column in a database table that automatically generates a unique value for each row. It is typically used as a primary key or as a surrogate key when there is no natural primary key available.

How to Reseed Identity Column To reseed an identity column in MS-SQL Server, you need to use the DBCC CHECKIDENT command. This command allows you to reset the identity value of a table to a specified value. It is useful when you want to reuse previously deleted identity values.

What is a Foreign Key? A foreign key is a column or a set of columns in a database table that references the primary key of another table. It is used to establish a relationship between the two tables.

What is Foreign Key Update Delete Cascade? Foreign key update delete cascade is a feature in MS-SQL Server that automatically updates or deletes related records in a child table when a record in the parent table is updated or deleted. This feature ensures data consistency and helps to maintain referential integrity.

Designing a Full Database with Proper Primary Keys, Identity Keys, and Foreign Keys ... https://www.youtube.com/watch?v=sfVi14PI0f8