Videos uploaded by user “Learn Everything”
Sql triggers tutorial in hindi
What is a Trigger : A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. It is a database object which is bound to a table and is executed automatically. Types Of Triggers 1. After Triggers (For Triggers) : After Insert, After Update, After Delete 2. Instead Of Triggers CREATE TABLE tblemployee(Emp_ID INT Identity,Emp_name Varchar(100),Emp_Sal Decimal (10,2)) INSERT INTO tblemployee VALUES ('Anand',15000); INSERT INTO tblemployee VALUES ('Neha',12400); INSERT INTO tblemployee VALUES ('Sohan',11500); INSERT INTO tblemployee VALUES ('Vijay',15500); INSERT INTO tblemployee VALUES ('Sapna',14000); I will be creating an AFTER INSERT TRIGGER which will insert the rows inserted into the table into another log table. The main purpose of this log table is to record the changes in the main table. Now, create the log table as:- CREATE TABLE Employee_Log (Emp_ID int,Emp_name varchar(100),Emp_Sal decimal (10,2),Log_Action varchar(100),log_Timestamp datetime) (a) After Insert Trigger This trigger is fired after an INSERT on the table. Let’s create the trigger as: CREATE TRIGGER trgAfterInsert ON tblemployee After INSERT AS declare @empid int declare @empname varchar(100) declare @empsal decimal(10,2) declare @log_action varchar(100) select @empid=i.Emp_ID, @empname=i.Emp_Name, @empsal=i.Emp_Sal from inserted i; set @log_action='Inserted Record -- After Insert Trigger.'; insert into Employee_log (Emp_ID,Emp_Name,Emp_Sal,Log_Action,Log_Timestamp) values(@empid,@empname,@empsal,@log_action,getdate()); PRINT 'AFTER INSERT trigger fired.' GO The CREATE TRIGGER statement is used to create the trigger. THE ON clause specifies the table name on which the trigger is to be attached. The after INSERT specifies that this is an AFTER INSERT trigger. In the trigger body, table named inserted has been used. This table is a logical table and contains the row that has been inserted. I have selected the fields from the logical inserted table from the row that has been inserted into different variables, and finally inserted those values into the log table. To see the newly created trigger in action, lets insert a row into the main table as: insert into tblemployee values('Ram',10500); Now, a record has been inserted into the tblemployee table. The AFTER INSERT trigger attached tothis table has inserted the record into the Employee_Log as: 6 Ram 10500.00 Inserted Record -- After Insert Trigger. 2016-10-10 08:28:00.500 (b) AFTER UPDATE Trigger This trigger is fired after an update on the table. Let’s create the trigger as: CREATE TRIGGER trgAfterUpdate ON tblemployee After UPDATE AS declare @empid int; declare @empname varchar(100); declare @empsal decimal(10,2); declare @log_action varchar(100); select @empid=i.Emp_ID, select @empname=i.Emp_Name, select @empsal=i.Emp_Sal from inserted i; if update(Emp_Name) set @alog_action='Updated Record -- After Update Trigger.'; if update(Emp_Sal) set @log_action='Updated Record -- After Update Trigger.'; insert into Employee_Log(Emp_ID,Emp_Name,Emp_Sal,Log_Action,Log_Timestamp) values(@empid,@empname,@empsal,@log_action,getdate()); PRINT 'AFTER UPDATE Trigger fired.' GO The AFTER UPDATE Trigger is created in which the updated record is inserted into the log table. There is no logical table updated like the logical table inserted. We can obtain the updated value of a field from theupdate(column_name) function. In our trigger, we have used, if update(Emp_Name) to check if the column Emp_Name has been updated. We have similarly checked the column Emp_Sal for an update. Let’s update a record column and see what happens. update tblemployee set Emp_Sal=15000 where Emp_ID=6 This inserts the row into the audit table as: 6 Ram 15000.00 Updated Record -- After Update Trigger. 2016-10-10 08:28:00.500 (c) AFTER DELETE Trigger This trigger is fired after a delete on the table. Let’s create the trigger as: CREATE TRIGGER trgAfterDelete ON tblemployee AFTER DELETE AS declare @empid int; declare @empname varchar(100); declare @empsal decimal(10,2); declare @log_action varchar(100); select @empid=d.Emp_ID, @empname=d.Emp_Name, select @empsal=d.Emp_Sal from deleted d; set @log_action='Deleted -- After Delete Trigger.'; insert into Employee_log (Emp_ID,Emp_Name,Emp_Sal,Log_Action,Log_Timestamp) values(@empid,@empname,@empsal,@Log_action,getdate()); PRINT 'AFTER DELETE TRIGGER fired.' GO In this trigger, the deleted record’s data is picked from the logical deleted table and inserted into the Log table. Let’s fire a delete on the main table. A record has been inserted into the audit table as: 6 Ram 15000.00 Deleted -- After Delete Trigger. 2016-10-10 08:28:00.500 http://www.libitsolutions.com
Views: 55917 Learn Everything
Part 13 Sub Query in Sql in Hindi
What is subquery in SQL Server with examples? You can define a T-SQL subquery wherever an expression is permitted in a statement. For example, you can embed a subquery in the SELECT list of a SELECT statement, or include one in the search condition of the WHERE clause. ... NOTE: A subquery is sometimes referred to as an inner select or inner query. What is the use of subquery? A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved. ... A subquery cannot be immediately enclosed in a set function. Which is better join or subquery? The good thing in sub-queries is that they are more readable than JOIN s: that's why most new SQL people prefer them; it is the easy way; but when it comes to performance, JOINS are better in most cases even though they are not hard to read too. ... a class of subqueries that can not be rewritten using joins.
Views: 3343 Learn Everything
Learn Store Procedure in SQL in Hindi tutorial for beginners
Stored Procedure: Stored Procedure in SQL Server can be defined as the set of logical group of SQL statements which are grouped to perform a specific task. There are many benefits of using a stored procedure. The main benefit of using a stored procedure is that it increases the performance of the database.The other benefits of using the Stored Procedure are given below. Benefits of Using the Stored Procedure One of the main benefits of using the Stored procedure is that it reduces the amount of information sent to the database server. It can become a more important benefit when the bandwidth of the network is less. Since if we send the SQL query (statement) which is executing in a loop to the server through network and the network gets disconnected, then the execution of the SQL statement doesn't return the expected results, if the SQL query is not used between Transaction statement and rollback statement is not used. Compilation step is required only once when the stored procedure is created. Then after it does not require recompilation before executing unless it is modified and reutilizes the same execution plan whereas the SQL statements need to be compiled every time whenever it is sent for execution even if we send the same SQL statement every time. It helps in re usability of the SQL code because it can be used by multiple users and by multiple clients since we need to just call the stored procedure instead of writing the same SQL statement every time. It helps in reducing the development time. Stored procedure is helpful in enhancing the security since we can grant permission to the user for executing the Stored procedure instead of giving permission on the tables used in the Stored procedure. Sometimes, it is useful to use the database for storing the business logic in the form of stored procedure since it makes it secure and if any change is needed in the business logic, then we may only need to make changes in the stored procedure and not in the files contained on the web server.
Views: 29504 Learn Everything
Part 21 Learn If , Case, While in Sql Server in Hindi tutorial for beginners
The IF…ELSE statement imposes conditions on the execution of a Transact-SQL (T-SQL) statement. The T-SQL statement that follows an IF keyword is executed if its condition is satisfied. In that case the Boolean expression returns a TRUE value. When the IF condition is not satisfied and the Boolean expression returns FALSE, the optional ELSE keyword introduces another Transact-SQL statement and condition which is executed. This IF…ELSE statement is very similar to that of C Programming. he SQL Server (Transact-SQL) CASE statement has the functionality of an IF-THEN-ELSE statement. You can use the CASE statement within a SQL statement. Syntax The syntax for the CASE statement in SQL Server (Transact-SQL) is: CASE expression WHEN value_1 THEN result_1 WHEN value_2 THEN result_2 ... WHEN value_n THEN result_n ELSE result END
Views: 2469 Learn Everything
Checkbox Conrol in .Net in Hindi
A CheckBox control allows users to select a single or multiple options from a list of options. In this article, I will discuss how to create a CheckBox control in Windows Forms at design-time as well as run-time. After that, I will continue discussing various properties and methods available for the CheckBox control The CheckBox control can display an image or text or both. Usually CheckBox comes with a caption, which you can set in the Text property. checkBox1.Text = "Net-informations.com"; You can use the CheckBox control ThreeState property to direct the control to return the Checked, Unchecked, and Indeterminate values. You need to set the check boxs ThreeState property to True to indicate that you want it to support three states. checkBox1.ThreeState = true; The radio button and the check box are used for different functions. Use a radio button when you want the user to choose only one option.When you want the user to choose all appropriate options, use a check box
Views: 739 Learn Everything
how to start making software in .net
in this video we will start new project in net and will some introduction about .net
Views: 460 Learn Everything
Sql Functions tutorial in Hindi
this video contains how to create tabular function and scalar function in sql server in hindi A table-valued function returns a single rowset (unlike stored procedures, which can return multiple result shapes). Because the return type of a table-valued function is Table, you can use a table-valued function anywhere in SQL that you can use a table. You can also treat the table-valued function just as you would a table. SQL scalar functions return a single value, based on the input value.
Views: 6668 Learn Everything
Part 15 Foreign Key in sql Server in Hindi
The SQL FOREIGN KEY CONSTRAINT is used to ensure the referential integrity of the data in one table to match values in another table. The FOREIGN KEYCONSTRAINT is a column or list of columns which points to the PRIMARY KEY of another What is a foreign key in a database? In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.
Views: 631 Learn Everything
Chapter 19 View in Sql Server in Hindi
SQL CREATE VIEW Statement. In SQL, a view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database. Why do we use views in SQL? SQL - Using Views. A view is nothing more than a SQL statement that is stored in the database with an associated name. ... A view can contain all rows of a table or select rows from a table. A view can be created from one or many tables which depends on the written SQL query to create a view. What do you mean by view in SQL? A database view is a searchable object in a database that is defined by a query. Though a view doesn't store data, some refer to a views as “virtual tables,” you canquery a view like you can a table. A view can combine data from two or more table, using joins, and also just contain a subset of information. What are views used for? Views can be used as security mechanisms by letting users access data through the view, without granting the users permissions to directly access the underlying base tables of the view. Views can be used to provide a backward compatible interface to emulate a table that used to exist but whose schema has changed.
Views: 536 Learn Everything
Login and Create Database in Sql Server  in hindi
To access Sql Server we have to login to server. As we need to login username and password to access mail and other thigs. SQL Server allows four types of logins − • A login based on Windows credentials. • A login specific to SQL Server. • A login mapped to a certificate. • A login mapped to asymmetric key. In this tutorial we will learn login based on windows and login specific to sql server With Windows credential you can log in to sql by windows username and password Or if you want to login by system administrator or your username you can create a login specific to sql servererver. Database is a collection of table, view, stored procedure, function, trigger, etc. In MS SQL two types of databases are available. • System databases : Automatic created by sql • User Databases : User Database created by us. • We can create database by two method Using Query : Create database databasename Or by Management Studio (refer video how to crate database by gui) create database db_test Use db_test
Views: 626 Learn Everything
Sql In Hindi #Part 3 - Insert , Update and Delete in Sql Server
How to: Insert, Update, and Delete Records From a Table Using Inserting Records into a Table There are essentially two methods for adding records to a table. The first is to add one record at a time; the second is to add many records at a time. In both cases, you use the SQL statement INSERT INTO to accomplish the task. INSERT INTO statements are commonly referred to as append queries. To add one record to a table, you must use the field list to define which fields to put the data in, and then you must supply the data itself in a value list. To define the value list, use the VALUES clause. For example, the following statement will insert the values "1", "Kelly", and "Jill" into the CustomerID, Last Name, and First Name fields, respectively INSERT INTO tblCustomers (CustomerID, [Last Name], [First Name]) VALUES (1, 'Kelly', 'Jill') You can omit the field list, but only if you supply all the values that record can contain. INSERT INTO tblCustomers VALUES (1, Kelly, 'Jill', '555-1040', '[email protected]') To add many records to a table at one time, use the INSERT INTO statement along with a SELECT statement. When you are inserting records from another table, each value being inserted must be compatible with the type of field that will be receiving the data. The following INSERT INTO statement inserts all the values in the CustomerID, Last Name, and First Name fields from the tblOldCustomers table into the corresponding fields in the tblCustomers table. INSERT INTO tblCustomers (CustomerID, [Last Name], [First Name]) SELECT CustomerID, [Last Name], [First Name] FROM tblOldCustomers If the tables are defined exactly alike, you can leave out the field lists. INSERT INTO tblCustomers SELECT * FROM tblOldCustomers Updating Records in a Table To modify the data that is currently in a table, you use the UPDATE statement, which is commonly referred to as an update query. The UPDATE statement can modify one or more records and generally takes this form: UPDATE table name SET field name = some value To update all the records in a table, specify the table name, and then use the SET clause to specify the field or fields to be changed. UPDATE tblCustomers SET Phone = 'None' In most cases, you will want to qualify the UPDATE statement with a WHERE clause to limit the number of records changed. UPDATE tblCustomers SET Email = 'None' WHERE [Last Name] = 'Smith' Deleting Records from a Table To delete the data that is currently in a table, you use the DELETE statement, which is commonly referred to as a delete query. This is also known as truncating a table. The DELETE statement can remove one or more records from a table and generally takes this form: DELETE FROM table list The DELETE statement does not remove the table structure—only the data that is currently being held by the table structure. To remove all the records from a table, use the DELETE statement and specify which table or tables from which you want to delete all the records. DELETE FROM tblInvoices In most cases, you will want to qualify the DELETE statement with a WHERE clause to limit the number of records to be removed. DELETE FROM tblInvoices WHERE InvoiceID = 3 If you want to remove data only from certain fields in a table, use the UPDATE statement and set those fields equal to NULL, but only if they are nullable fields. UPDATE tblCustomers SET Email = Null
Views: 906 Learn Everything
Introduction to seo in Hindi
SEO is a technique which helps search engines find and rank your site higher than the millions of other sites in response to a search query. SEO thus helps you get traffic from search engines. SEO is a marketing discipline focused on growing visibility in organic (non-paid) search engine results. SEO encompasses both the technical and creative elements required to improve rankings, drive traffic, and increase awareness in search engines. Search engine optimization is a methodology of strategies, techniques and tactics used to increase the amount of visitors to a website by obtaining a high-ranking placement in the search results page of a search engine (SERP) -- including Google, Bing, Yahoo and other search engines. SEO is short for Search Engine Optimization, and there is nothing really mystical about it. You might have heard a lot about SEO and how it works, but basically what it is is a measurable, repeatable process that is used to send signals to search engines that your pages are worth showing in Google's index. On-page SEO is the practice of optimizing individual web pages in order to rank higher and earn more relevant traffic in search engines. On-page refers to both the content and HTML source code of a page that can be optimized, as opposed to off-page SEO which refers to links and other external signals.
Views: 1054 Learn Everything
joins in sql server in hindi
An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is: SQL INNER JOIN (simple join). An SQL INNER JOIN returns all rows from multiple tables where the join condition is met. Different SQL JOINs Before we continue with examples, we will list the types of the different SQL JOINs you can use: INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the right table RIGHT JOIN: Return all rows from the right table, and the matched rows from the left table FULL JOIN: Return all rows when there is a match in ONE of the tables The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. SQL Join Types: There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table. FULL JOIN: returns rows when there is a match in one of the tables. SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement. CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables. What is a left outer join This means that if the ON clause matches 0 (zero) records in B (for a given record in A), the join will still return a row in the result (for that record)—but with NULL in each column from B. A left outer join returns all the values from an inner join plus all values in the left table that do not match to the right ... What is an outer join An outer join returns a set of records (or rows) that include what an inner join would return but also includes other rows for which no corresponding match is found in the other table. There are three types of outer joins: Left Outer Join (or Left Join) Right Outer Join (or Right Join) Full Outer Join (or Full Join) What is a natural join A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined. Common columns are columns that have the same name in both tables. A NATURAL JOIN can be an INNER join, a LEFT OUTER join, or a RIGHT OUTER join. What is an inner join Inner join. A join is combining the rows from two tables. An inner join attempts to match up the two tables based on the criteria you specify in the query, and only returns the rows that match. If a row from the first table in the join matches two rows in the second table, then two rows will be returned in the results.
Views: 1375 Learn Everything
Sql In Hindi #Part 2 - Create Tables in Sql Server in hindi
In this chapter i will teach you how to create table in Sql by Commands and GUI Commands used in video create table table_Name drop table_Name Creating a basic table involves naming the table and defining its columns and each column's data type. The SQL CREATE TABLE statement is used to create a new table. Syntax: Basic syntax of CREATE TABLE statement is as follows: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) ); CREATE TABLE is the keyword telling the database system what you want to do. In this case, you want to create a new table. The unique name or identifier for the table follows the CREATE TABLE statement. Then in brackets comes the list defining each column in the table and what sort of data type it is. The syntax becomes clearer with an example below. A copy of an existing table can be created using a combination of the CREATE TABLE statement and the SELECT statement.
Views: 709 Learn Everything
Part 10 Date Function in Sql in Hindi
SQL Server Date Functions The following table lists the most important built-in date functions in SQL Server: Function Description GETDATE() Returns the current date and time DATEPART() Returns a single part of a date/time DATEADD() Adds or subtracts a specified time interval from a date DATEDIFF() Returns the time between two dates CONVERT() Displays date/time data in different formats SQL Date Data Types SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE - format YYYY-MM-DD DATETIME - format: YYYY-MM-DD HH:MI:SS SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS TIMESTAMP - format: a unique number Note: The date types are chosen for a column when you create a new table in your database!
Views: 1194 Learn Everything
How seo works
Search engines have two major functions: crawling and building an index, and providing search users with a ranked list of the websites they've determined are the most relevant. Search engines use automated software (known as robots or spiders) to follow links on Websites, harvesting information as they go. When someone submits a query to a search engine, the engine returns a list of sites, ranking them on their relevance to the keywords used in the search. SEO is short for Search Engine Optimization, and there is nothing really mystical about it. You might have heard a lot about SEO and how it works, but basically what it is is a measurable, repeatable process that is used to send signals to search engines that your pages are worth showing in Google's index. Search engine optimization is a methodology of strategies, techniques and tactics used to increase the amount of visitors to a website by obtaining a high-ranking placement in the search results page of a search engine (SERP) -- including Google, Bing, Yahoo and other search engines.
Views: 641 Learn Everything
domain and title and meta description in seo
Meta Keywords Attribute - A series of keywords you deem relevant to the page in question. Title Tag - This is the text you'll see at the top of your browser. Search engines view this text as the "title" of your page. Meta Description Attribute - A brief description of the page. The meta title is the HTML code that specifies the title of a certain web page. It appears at the top left corner of your browser when you visit a web page. In coding, the meta title is embedded at the header of a web page, above the meta description and meta keywords tags. Title tags are often used on search engine results pages (SERPs) to display preview snippets for a given page, and are important both for SEO and social sharing. The title element of a web page is meant to be an accurate and concise description of a page's content.
Views: 386 Learn Everything
Paragraph Formating in Word in Hindi
Paragraph Formating in Word in Hindi
Views: 223 Learn Everything
Part 11 String Function in Sql in Hindi
SQL string functions are used primarily for string manipulation. What is substring function in SQL SQL Substring Function. The Substring function in SQL is used to return a portion of string. This function is called differently in different databases: MySQL: SUBSTR( ), SUBSTRING( ) What is a string in a database In computer science a string is any finite sequence of characters (i.e., letters, numerals, symbols and punctuation marks). An important characteristic of each string is its length, which is the number of characters in it. The length can be any natural number (i.e., zero or any positive integer) What is the meaning of varchar in SQL A varchar or Variable Character Field is a set of character data of indeterminate length. The term varchar refers to a data type of a field (or column) in a database management system which can hold letters and numbers.
Views: 1335 Learn Everything
Part 16  Unique Key in sql Server in Hindi
What is the unique key in SQL? A UNIQUE index creates a constraint such that all values in the index must be distinct. ... A PRIMARY KEY is a unique index where all key columns must be defined as NOT NULL . If they are not explicitly declared as NOT NULL , MsSQLdeclares them so implicitly (and silently). A table can have only one PRIMARY KEY What is the difference between a primary key and a unique key? 1. Behavior: Primary Key is used to identify a row (record) in a table, whereasUnique-key is to prevent duplicate values in a column (with the exception of a null entry). 2. Indexing: By default SQL-engine creates Clustered Index on primary-keyif not exists and Non-Clustered Index on Unique-key. What is the meaning of unique key? SQL UNIQUE Constraint. The UNIQUE constraint ensures that all values in a column are different. Both the UNIQUE and PRIMARY KEY constraints provide a guarantee for uniqueness for a column or set of columns. A PRIMARY KEY constraint automatically has a UNIQUE constraint.
Views: 418 Learn Everything
Introduction to Ms Word in Hindi
In this chapter we will learn about introduction of ms office. how to start ms word . what is office button and what is menu bar and tool bar. tabs in tool bar clipboard, fonts, paragraph, styles editing etc. office button is some what like old file menu . second is quick access . in quick access we can add things whic we use frequently. Then comes menu bar which contacts all the tab like clipboard and paragraph styles etc. we will each tab in details .in the middle of the screen is the window where we will write the document . in the bottom we have view option like print layout , full screen reading, web layout, outline, draft. and then we have zooming option after view
Views: 258 Learn Everything
Part 6 Order by and Distinct Clause in Sq Server in Hindi
The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some database sorts query results in ascending order by default. The SQL SELECT DISTINCT Statement. In a table, a column may contain many duplicate values; and sometimes you only want to list the different (distinct) values. The DISTINCT keyword can be used to return only distinct (different) values. SQL SELECT DISTINCT Syntax SELECT DISTINCT column_name,column_name FROM table_name; Syntax: The basic syntax of ORDER BY clause is as follows: SELECT column-list FROM table_name [WHERE condition] [ORDER BY column1, column2, .. columnN] [ASC | DESC]; You can use more than one column in the ORDER BY clause. Make sure whatever column you are using to sort, that column should be in column-list.
Views: 381 Learn Everything
Button Control in .Net in Hindi in c#
Windows Forms controls are reusable components that encapsulate user interface functionality and are used in client side Windows applications. A button is a control, which is an interactive component that enables users to communicate with an application. The Click event is raised when the Button control is clicked. This event is commonly used when no command name is associated with the Button control. Raising an event invokes the event handler through a delegate. Buttons enable users to interact with your program. For example, many dialog boxes have an OK button and a Cancel button. Users can click the OK button to submit the information entered in the dialog box. Alternatively, they can click Cancel to close the dialog box without submitting any data. You can set properties of a button to change its appearance. For example, you can set the Text property to display specific text on a button, or set the ForeColor property to change the color of the text. For more information, see How to: Create a Non-Rectangular Button. Controls have events that are raised whenever a user performs a specific action on the control. You can create event handlers that determine how the program should respond to the event. All controls have a default event handler, and for a button, it is the Click event. The code that you write in the Click event handler of the button runs whenever the user clicks the button.
Views: 1486 Learn Everything
Part 7 Aggregate Function in Sql in hindi
MIN returns the smallest value in a given column MAX returns the largest value in a given column SUM returns the sum of the numeric values in a given column AVG returns the average value of a given column COUNT returns the total number of values in a given column COUNT(*) returns the number of rows in a table Aggregate functions are used to compute against a "returned column of numeric data" from your SELECT statement. They basically summarize the results of a particular column of selected data. We are covering these here since they are required by the next topic, "GROUP BY". Although they are required for the "GROUP BY" clause, these functions can be used without the "GROUP BY" clause. SQL aggregate functions return a single value, calculated from values in a column. In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set, a bag or a list. Common aggregate functions include: Average() Count() The aggregate value is a mathematical term used to refer to the collective sum of a number of smaller sums. The term is typically used when an individual or group needs to analyze data from multiple data sources. Data aggregation is any process in which information is gathered and expressed in a summary form, for purposes such as statistical analysis. A common aggregation purpose is to get more information about particular groups based on specific variables such as age, profession, or income.
Views: 764 Learn Everything
Part 20 Variable Declaration in Sql in Hindi
Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement. Cursor variables can be declared with this statement and used with other cursor-related statements. After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration. Variables are often used in a batch or procedure as counters for WHILE, LOOP, or for an IF...ELSE block. Variables can be used only in expressions, not in place of object names or keywords. To construct dynamic SQL statements, use EXECUTE.
Views: 776 Learn Everything
Body Content , H1 Tag, Image Alt tag in Seo
HTML Header tags, as their name suggests, are used to differentiate the headings and sub-headings of a page from the rest of the content. These tags are also known to webmasters as heading tags or simply header tags. The most important heading tag is the h1 tag and least important is the h6 tag. In HTML coding the header tags from h1 to h6 form a hierarchy. This means that if you skip any of the tag numbers (ie. jump from 1 to 3) the heading structure will be broken, and this is not ideal for on-page SEO. The h1 tag is the most important tag. Every page must have an h1 tag. Note: The term "ALT tag" is a common shorthand term used to refer to the ALT attribute within in the IMG tag. Any time you use an image, be sure to include an ALT tag or ALT text within the IMG tag. Doing so will provide a clear text alternative of the image for screen reader users. The required alt attribute specifies an alternate text for an image, if the image cannot be displayed. The alt attribute provides alternative information for an image if a user for some reason cannot view it (because of slow connection, an error in the src attribute, or if the user uses a screen reader). t helps search engines understand what an image is about. Alternate text is also very helpful in case images on a page cannot be found. Image title is another attribute that can be added to the image tag in HTML. It is used to provide a title for your image.
Views: 451 Learn Everything
textbox in hindi
Views: 160 Learn Everything
Learn style tab features of ms word in hindi
In this video we will learn how to use style tab and its features and how to create new style according your requirement.
Views: 256 Learn Everything
How crawlers and robots works in seo
A Web crawler is an Internet bot which systematically browses the World Wide Web, typically for the purpose of Web indexing (web spidering). Web search engines and some other sites use Web crawling or spidering software to update their web content or indices of others sites' web content. Web crawlers can copy all the pages they visit for later processing by a search engine which indexes the downloaded pages so the users can search much more efficiently. Crawlers consume resources on the systems they visit and often visit sites without tacit approval. Issues of schedule, load, and "politeness" come into play when large collections of pages are accessed. Mechanisms exist for public sites not wishing to be crawled to make this known to the crawling agent. For instance, including a robots.txt file can request bots to index only parts of a website, or nothing at all. As the number of pages on the internet is extremely large, even the largest crawlers fall short of making a complete index. For that reason search engines were bad at giving relevant search results in the early years of the World Wide Web, before the year 2000. This is improved greatly by modern search engines, nowadays very good results are given instantly. Crawlers can validate hyperlinks and HTML code. They can also be used for web scraping (see also data-driven programming). Web site owners use the /robots.txt file to give instructions about their site to web robots; this is called The Robots Exclusion Protocol. It works likes this: a robot wants to vists a Web site URL, say http://www.example.com/welcome.html. Before it does so, it firsts checks for http://www.example.com/robots.txt, and finds: User-agent: * Disallow: / The "User-agent: *" means this section applies to all robots. The "Disallow: /" tells the robot that it should not visit any pages on the site. There are two important considerations when using /robots.txt: robots can ignore your /robots.txt. Especially malware robots that scan the web for security vulnerabilities, and email address harvesters used by spammers will pay no attention. the /robots.txt file is a publicly available file. Anyone can see what sections of your server you don't want robots to use.
Views: 577 Learn Everything
Sql In Hindi #Part 1 - Create Database in Sql Server
To access Sql Server we have to login to server. As we need to login username and password to access mail and other thigs. SQL Server allows four types of logins − • A login based on Windows credentials. • A login specific to SQL Server. • A login mapped to a certificate. • A login mapped to asymmetric key. In this tutorial we will learn login based on windows and login specific to sql server With Windows credential you can log in to sql by windows username and password Or if you want to login by system administrator or your username you can create a login specific to sql servererver. Database is a collection of table, view, stored procedure, function, trigger, etc. In MS SQL two types of databases are available. • System databases : Automatic created by sql • User Databases : User Database created by us. • We can create database by two method Using Query : Create database databasename Or by Management Studio (refer video how to crate database by gui) create database db_test Use db_test
Views: 526 Learn Everything
Part 14 Primary Key in Sql in Hindi
What is the primary key in a database? A primary key is a field in a table which uniquely identifies each row/record in a database table. Primary keys must contain unique values. A primary key column cannot have NULL values. A table can have only one primary key, which may consist of single or multiple fields. Can a composite key be a primary key? A primary key is a table column that can be used to uniquely identify every row of the table. ... In this example, only FirstName is a single-column candidate key, because it is the only column that is unique and not null. A composite primary keyis a primary key consisting of more than one column.
Views: 280 Learn Everything
Sitemap xml file for seo
A site map (or sitemap) is a list of pages of a web site accessible to crawlers or users. It can be either a document in any form used as a planning tool for Web design, or a Web page that lists the pages on a Web site, typically organized in hierarchical fashion. Google Sitemaps is an experiment in Web crawling by using Sitemaps to inform and direct Google search crawlers. Webmasters can place a Sitemap-formatted file on their Web server which enables Google crawlers to find out what pages are present and which have recently changed, and to crawl your site accordingly. XML Sitemaps are important for SEO because they make it easier for Google to find your site's pages—this is important because Google ranks web PAGES not just websites. There is no downside of having an XML Sitemap and having one can improve your SEO, so we highly recommend them. To submit your sitemap: Select your site on your Google Search Console home page. Click Crawl. Click Sitemaps. Click ADD/TEST SITEMAP. Type sitemap.xml. Click Submit Sitemap.
Views: 187 Learn Everything
How to Hide Mobile No, Email Id from Others
In this video i will try to explain how to hide you mobile no, email id and date of brith from others and your friends
Views: 376 Learn Everything
Site Analytics for Seo
Web analytics is the measurement, collection, analysis and reporting of web data for purposes of understanding and optimizing web usage. Web analytics is not just a tool for measuring web traffic but can be used as a tool for business and market research, and to assess and improve the effectiveness of a website. To log into your Google Analytics account, go to http://www.google.com/analytics/ and click on the Access Analytics button to sign in. If you are using your own Google Analytics account, then log in using your own username and password.
Views: 191 Learn Everything
robots.txt file for seo
The robots exclusion standard, also known as the robots exclusion protocol or simply robots.txt, is a standard used by websites to communicate with web crawlers and other web robots. The standard specifies how to inform the web robot about which areas of the website should not be processed or scanned. Web Robots (also known as Web Wanderers, Crawlers, or Spiders), are programs that traverse the Web automatically. Search engines such as Google use them to index the web content, spammers use them to scan for email addresses, and they have many other uses. The content of a robots.txt file consists of so-called "records". both "/support-desk/index.html" and "/support/index.html" as well as all other files in the "support" directory would not be indexed by search engines. If you leave the Disallow line blank, you're telling the search engine that all files may be indexed.
Views: 209 Learn Everything
Part 8 Group By Function in Sql in Hindi
SQL - Group By. The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. The GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause. syntax: The basic syntax of GROUP BY clause is given below. The GROUP BY clause must follow the conditions in the WHERE clause and must precede the ORDER BY clause if one is used. SELECT column1, column2 FROM table_name WHERE [ conditions ] GROUP BY column1, column2 ORDER BY column1, column2 Can I use HAVING without GROUP BY clause : The HAVING clause specifies conditions that determines the groups included in the query. If the SQL SELECT statement does not contain aggregate functions, you can use a SQL SELECT statement that contains a HAVING clause without a GROUP BY clause. The HAVING clause without a GROUP BY clause acts like the WHERE clause. What is true about having clause The SQL HAVING Clause is used in combination with the GROUP BY Clause to restrict the groups of returned rows to only those whose the condition is TRUE. What does having do in SQL A HAVING clause in SQL specifies that an SQL SELECT statement should only return rows where aggregate values meet the specified conditions. It was added to the SQL language because the WHERE keyword could not be used with aggregate functions.
Views: 404 Learn Everything
Part 4 Select Statment in Sql Server in Hindi
The SELECT statement is used to select data from a database.The SQL SELECT statement is used to retrieve records from one or more tables in your SQL database. You can retrive data by SQL SELECT statement is used to fetch the data from a database table which returns data in the form of result table. These result tables are called result-sets. select column1, columnd2 from anytable Here, column1, column2...are the fields of a table whose values you want to fetch. If you want to fetch all the fields available in the field, then you can use the following syntax: select * from anytable
Views: 360 Learn Everything
Sql Part 17 Check Costraint
What is check constraint : A check constraint is a type of integrity constraint in SQL which specifies a requirement that must be met by each row in a database table. The constraint must be a predicate. It can refer to a single column, or multiple columns of the table. What are table constraints : Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. ... NOT NULL Constraint: Ensures that a column cannot have NULL value. DEFAULT Constraint: Provides a default value for a column when none is specified.
Views: 297 Learn Everything
google Website tool for seo
Google Webmaster Tools (GWT) is the primary mechanism for Google to communicate with webmasters. Google Webmaster Tools helps you to identify issues with your site and can even let you know if it has been infected with malware (not something you ever want to see, but if you haven’t spotted it yourself, or had one of your users tweet at you to let you know, it’s invaluable). And the best part? It’s absolutely free. If you don’t have a GWT account, then you need to go get one now.
Views: 245 Learn Everything
install wordpress on server in hindi
The five steps to install WordPress… Download the latest version of WordPress from WordPress.org. Upload those files to your web server, using FTP. Create a MySQL database and user for WordPress. Configure WordPress to connect to the newly-created database. Complete the installation and setup your new website! How can I install Wordpress on my website nstalling WordPress Manually via FTP Your first step is to manually download the WordPress installation files. ... Go to the databases section of your web hosting control panel and select the MySQL database wizard. ... Step 3 (optional) How do I install Wordpress on Godaddy To Install WordPress on Your Hosting Account**Log in to your GoDaddy account.**Click Web Hosting.**Next to the hosting account you want to use, click Manage.**In the Popular Apps section, click WordPress.**Click Install Now.**Complete the on-screen fields, and then click OK:
Views: 166 Learn Everything
wordpess dashboard
In this video we will discuss about the wordpress dashboard and the features of wordpress dashboard
Views: 19 Learn Everything
checkbox list
Views: 61 Learn Everything