Roll Name Class Address
1 Rahul Kumar Tiwari Class9 Varanasi UP India
2 Babita class7 Delhi
4 Master Jojo Class7 Kanpur India
Select * from tbl_Student;
create procedure sp_InsertStudent
@Name nvarchar(50),
@Class nvarchar(50),
@Address nvarchar(50)
as
begin
insert into tbl_Student(Name,Class,Address) values(@Name,@Class,@Address)
end
go
-----------
create procedure sp_UpdateStudent
@Roll int,
@Name nvarchar(50),
@Class nvarchar(50),
@Address nvarchar(50)
as
begin
update tbl_Student set Name=@Name,Class=@Class,Address=@Address where Roll=@Roll
end
go
--------
create procedure sp_DeleteStudent
@Roll int
as
begin
Delete from tbl_Student where Roll=@Roll
end
go
1 Rahul Kumar Tiwari Class9 Varanasi UP India
2 Babita class7 Delhi
4 Master Jojo Class7 Kanpur India
Select * from tbl_Student;
create procedure sp_InsertStudent
@Name nvarchar(50),
@Class nvarchar(50),
@Address nvarchar(50)
as
begin
insert into tbl_Student(Name,Class,Address) values(@Name,@Class,@Address)
end
go
-----------
create procedure sp_UpdateStudent
@Roll int,
@Name nvarchar(50),
@Class nvarchar(50),
@Address nvarchar(50)
as
begin
update tbl_Student set Name=@Name,Class=@Class,Address=@Address where Roll=@Roll
end
go
--------
create procedure sp_DeleteStudent
@Roll int
as
begin
Delete from tbl_Student where Roll=@Roll
end
go
ππ»What is RDBMS And Normalization?
Relational Data Base Management Systems (RDBMS) are
database management systems that maintain data records
and indices in tables. Relationships may be created and
maintained across and among the data and tables. In a
relational database, relationships between data items are
expressed by means of tables. Interdependencies among
these tables are expressed by data values rather than by
pointers. This allows a high degree of data independence. An
RDBMS has the capability to recombine the data items from
different files, providing powerful tools for data usage.
What are the properties of the relational tables?
Relational tables have the following five properties:
πΒ· Values are atomic.
πΒ· Column values are of the same kind.
πΒ· The sequence of columns is insignificant.
πΒ· The sequence of rows is insignificant.
πΒ· Each column must have a unique name.
Relational Data Base Management Systems (RDBMS) are
database management systems that maintain data records
and indices in tables. Relationships may be created and
maintained across and among the data and tables. In a
relational database, relationships between data items are
expressed by means of tables. Interdependencies among
these tables are expressed by data values rather than by
pointers. This allows a high degree of data independence. An
RDBMS has the capability to recombine the data items from
different files, providing powerful tools for data usage.
What are the properties of the relational tables?
Relational tables have the following five properties:
πΒ· Values are atomic.
πΒ· Column values are of the same kind.
πΒ· The sequence of columns is insignificant.
πΒ· The sequence of rows is insignificant.
πΒ· Each column must have a unique name.
ππ»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
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.
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
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
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.
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.
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
πΉ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
πΉ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
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
- 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
π1
Todayβs the day: letβs write some code and change the world.
#CoderBaba #programmers.
Follow @Coder_Baba
#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
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
π 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.
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.