👉🏻What is normalization?

Database normalization is a data design and organizational
process applied to data structures based on rules that help
build relational databases. In relational database design, the
process of organizing data to minimize redundancy is called
normalization. Normalization usually involves dividing
database data into different tables and defining relationships
between the tables. The objective is to isolate data so that
additions, deletions, and modifications of a field can be made
in just one table and then retrieved through the rest of the
database via the defined relationships.
The key traits for Normalization are eliminating redundant data and
ensuring data dependencies.

follow @coder_baba

👉🏻What is de-normalization?

De-normalization is the process of attempting to optimize the
performance of a database by adding redundant data. It is
sometimes necessary because current DBMSs implement the
relational model poorly. A true relational DBMS would allow
for a fully normalized database at the logical level, while
providing physical storage of data that is tuned for high
performance. De-normalization is a technique to move from
higher to lower normal forms of database modeling in order
to speed up database access.

De-normalizing the database design allows for fewer joins with
tables and foreign key requirements. This method is commonly used
for Reporting and OLAP workloads.

👉🏻How is the ACID property related to databases?

ACID (an acronym for Atomicity Consistency Isolation
Durability) is a concept that database professionals generally
look for while evaluating relational databases and application
architectures. For a reliable database, all four of these
attributes should be achieved:

🌱Atomicity is an all-or-none rule for database modifications.

🌱Consistency guarantees that a transaction never leaves your
database in a half-finished state.

🌱Isolation keeps transactions separated from each other until
they are finished.

🌱Durability guarantees that the database will keep track of
pending changes in such a way that the server can recover
from an abnormal termination and committed transactions
will not be lost.

follow @coder_baba

Design Pattern in C# PDF Notes👆👆👆

What is Asp.Net:- Asp.net is abbreviated as "Active Server Pages .Network enable technology".
Active-An ASP page provides dynamic content that's updated every time that is accessed.
Server- An ASP page contains script code that the Web server executes.
Pages-An ASP page is a Web page that the user navigates to and is displayed in his or her browser.

How many types of Validation control in Asp.Net:-
 Required Field Validator
 Range Validator
 Compare Validator
 Regular Expression Validator
 Custom Validator
 Validation Summary

Required Field Validator:-It checks whether the control have any value. It is used when you want the control should not be empty.
Range Validator:-It checks if the value in validated controls is in that specific range.
Compare Validator:-It checks that the value in controls should match some specific value.
Regular Expression Validator:-When we want the control, value should match with a specific regular expression.
Custom Validator:-It is used to define user defined validation.
Validation Summary:-It displays summary of all current validation errors on an Asp.Net page.
How can you redirect user to different page.
By Useing the Response.Redirect method to direct users to different pages.
How can you redirect user to same page.
By Useing the Server.Transfer method to direct users to different pages.

please subscribe
https://www.youtube.com/@thekrkv

New video out
📹How to Integrate ChatGPT using C# | Visual Studio 2022 | OpenAI Code with ChatGPT in ASP .NET Csharp
🔗🕸https://youtu.be/kM89QkY-XbU

New video out
📹How to Integrate ChatGPT using C# | Visual Studio 2022 | OpenAI Code with ChatGPT in ASP .NET Csharp
🔗🕸 https://youtu.be/kM89QkY-XbU

Check out this new post 🎓 and Follow me for more
https://www.instagram.com/p/CrOUFrfhnNk/?utm_source=ig_web_copy_link

👩‍💻List of all errors 🔰

- 400 (Bad request)

- 401 (Authorization required)

- 402 (Payment required)

- 403 (Forbidden)

- 404 (Not found)

- 405 (Method not allowed)

- 406 (Not acceptable)

- 407 (Proxy authentication required)

- 408 (Request Timeout)

- 409 (Conflict)

- 410 (Gone)

- 411 (Length required)

- 412 (Precondition failed)

- 413 (Request entity too large)

- 414 (Request URI too large)

- 415 (Unsupported media type)

- 416 (Request range not satisfiable)

- 417 (Expectation failed)

- 422 (Unprocessable entity)

- 423 (Locked)

- 424 (Failed dependency)

- 500 (Internal server error)

- 501 (Not Implemented)

- 502 (Bad gateway)

- 503 (Service unavailable)

- 504 (Gateway timeout)

- 505 (HTTP version not supported)

- 506 (Variant also negotiates)

- 507 (Insufficient storage)

- 510 (Not extended)

React to this message if you need more Interesting Content Like this ❤️
Follow 👉🏻 @coder_baba
#CoderBaba

Today’s the day: let’s write some code and change the world.
#CoderBaba #programmers.
Follow @Coder_Baba

❇️ IS PROGRAMMING JUST A MYTH ?

While math is often used in programming, it is not the only aspect of the field.

👉 Programming involves skills and concepts i.e -

╰┈➤ Design
╰┈➤ Communication
╰┈➤ Project management
╰┈➤ Logic Building
╰┈➤ Problem Solving Skills
╰┈➤ Various tools and technologies
╰┈➤ Etc.

So programming involves several other skills rather than just Maths.

Subscribe My channel @Coder_Baba

🏄‍♂️ Some cool facts about Coding

🚀 Coding has over 700 languages.

🚀 The first programming language was called FORTRAN

🚀 The world’s first computer programmer was a renowned female mathematician

🚀 The first computer virus was created by a 15-year-old in 1982

🚀 The first computer didn’t use any electricity.

Which of these points had already known to you?😎

Comment👩‍💻
https://www.instagram.com/p/CrOUFrfhnNk/?utm_source=ig_web_button_share_sheet

What is the difference between a web developer and a full stack developer?

i. Web Designer
Technologies: Web graphics and animation (Adobe Photoshop, Illustrator, etc., Flash animation)

ii. Web Developer (Front-end)
Technologies: HTML, CSS, JavaScript, ActionScript (for Flash)

iii. Web Developer (Back-end)
Technologies:

One or more Server-side scripting language ~ PHP, JSP, CFM, NodeJS, Ruby (for Ruby on Rails framework ~ ROR), C# (.Net), Python, Perl, etc.
One or more databases (SQL) ~ MySql/MariaDB, PostgreSql, MS SQL, Oracle, etc.


Full stack developer:
‘Stack’ means a particular combo of technologies frequently used by a community of software or web application developers. My choice was the LAMP platform or stack: Linux OS, Apache Web server, MySql Database and PHP server side scripting. To be a full stack developer, not only you have to know front-end and back-end languages and SQL for database, you have to also have a very good working knowledge of server OS and web server administration. While a web developer might concentrate on one or two languages, a full stack developer will know the ins and outs of the web environment and all aspects of the web application. Frequently they are the ones who are responsible for building the architecture of an application from ground up.

A full stack developer will also additionally have knowledge of various other technologies and frameworks like JSON, XML, XSLT, JavaScript libraries (JQuery, Angular, BootStrap, PrototypeJS, ReactJS), NodeJs, Shell scripting, etc.

Q-What are exampls of a Full-Stack Web Developers?

As of now:

👉🏻Frontend:

HTML (Jade)
CSS (SASS/LESS)
Javascript (Angular.js, jQuery, CoffeeScript, Backbone.js, React.js)

👉🏻Database:

Postgresql 9.4
MongoDB
MySql

👉🏻Backend:

Node.js
Ruby On Rails
PHP
Python

👉🏻Tools:

GIT
GULP
ATOM
SUBLIME
AWS
HEROKU
SITEPRISM

👉🏻Web Design:

Photoshop
Illustrator

👉🏻Dot Net full stack developer will be a person who has complete knowledge of both Front End and Back End required to build a fully functional Dot Net application.

Skills required:

HTML
CSS
Bootstrap
JavaScript
jQuery/ Angular JS
AJAX
Web API
C#
SQL Server (database)
ASP .NET( Ado .Net + Stack Management Techniques)
MVC/ Asp .Net Core

If you want to be a Microsoft full stack developer. Few skills will get added to the list

MSBI Tools ( SSIS, SSRS, SSAS)
Microsoft Azure (Cloud)

Share this short video 👇👇
https://youtube.com/shorts/hBXVbIZMByA?feature=share