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. ·        User Define functions that return tables can be treated as another row set and this can be used in Joins with other tables. What are the sub sets in SQL? Following are the SQL sub sets: 1.         DDL (Data Definition Language) 2.         DML (Data Manipulation Language) 3.         DCL (Data Control Language) Web API 2- .Net Core In depth In

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 only. Wh

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 description of the key, delete them to a different table. All elements must be directly dependent on the primary key. 4.  

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 without common field. There are four most important types of joins available in SQL – 1.         Inner Join – It returns match rows in both tables.

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 option fo