Expert-With-Sagar-Jaybhay

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  What are the important SQL elements? Following are the different type elements: 1.         Identifiers. 2.         Data type. 3.         Constants. 4.         Operators. 5.         Functions. 6.         Clauses. 7.         Expressions. 8.         Queries. 9.         Statements. What is the difference between Function and Stored Procedure? ·        User defines functions can be used in the SQL statements in the Where or Having or Select section where as Stored Procedures cannot be used in the SQL statements. ·   ...

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  In this article we will learn C# Access Modifiers (Access Specifiers) and what their purpose is. Firstly we learn what is an Access Modifier? Why use access modifiers? Access Modifiers Access Specifiers or Access Modifiers is used to describe the visibility of a method or class property. Access modifiers are delineated as the scope of intelligibility of an Object and its members. We can ascendancy the scope of the member object of a class using access modifiers. We can provide security for our application using access modifiers.   When we use class modifiers then it restricts access so that other programs cannot see the properties. Access Modifiers keyword used to specify the define accessibility of a member or a type. For example, when we declare a public method in the class is accessible to everyone without any diminution, while an internal class may be accessible to the body onl...

SQL server Interview Question – Part 3 What is Normalization? Normalization is a data design and organizes process to data structures based on rules that help building relational database. The process of organizing data and relational database design to minimize redundancy is called as normalization. Normalization usually includes dividing a database into two or more tables and it defining relationships between the tables.     What are different normalization forms? 1.         First Normal Form Make a different tale for each set of related attributes, and give every one table a primary key. Every one field contains at most one value from its attribute domain. 2.         Second Normal Form If an attribute depends on only part of a multi values key, delete it to a different table. 3.         Third Normal Form If element do not contribute to a descriptio...

What is the difference between a Where clause and a Having Clause? ·        Where clause is using before result retrieving. Having clause is using after retrieving the data. ·        Where is used to check conditions before the aggregation takes place. Having is used to check conditions after the aggregation takes place. ·        Where clause is used before Group by clause. Having clause is used after Group by clause. ·        Where clause uses with Select, Insert, Update and Delete clause. Having clause can only use with Select clause. If you perform Having clause with other clause like Insert, Update, and Delete clause it will returns an error. ·        Where clause is used for filtering rows. Having clause is used to filter groups. What is Join? Join used to combine two or more tables logically with or witho...

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ What is data? Data is a collection of information. Data means data can be any information. For example there is an employee and all the information about the employee like (Emp id, Emp Name, Emp Age, Emp Mobile Number, Emp Address, Emp Salary, Emp Designation).   What is Data Base? Database is a systematic collection of data, if you considering employee all the information about employee like Emp id, Emp Name, Emp Age, Emp Mobile Number, Emp Address, Emp Salary, Emp Designation these all details are data and if you are organizing that data in a systematic collection of manner then that is called Database. Why we organizing data systematically? Data can be easily accessed, managed and updated. What is DBMS (Data Base Management System)? Data Base Management System is software like SQL server, MySQL, and Oracle, they provide optio...