http://www.dbtalks.com/Watch articles from C# Corner© 1999 - 2011 Mindcracker LLC. All Rights ReservedIf we want to specify any condition before grouping record we can use where clause before Group By & if we want to specify any condition after grouping records we can use Having Clause. For example-We want to get count of student on the basis of course except 'c' course and only those subject where count is greater than one. http://www.dbtalks.com/UploadFile/a01fa5/use-of-having-clause-in-mysql/5/15/2012 1:16:17 AMMegha GoyalData Type are used to define the type of data we are using in table records in ,MySql.Here there are various kinds of data type which are allowed in MySql.http://www.dbtalks.com/UploadFile/a01fa5/various-datatypes-in-mysql/5/14/2012 1:39:12 AMMegha GoyalIn this article we are going to understand the concept of Aggregate Function in SQL Server.http://www.dbtalks.com/UploadFile/c37c73/concepts-of-aggregate-functions-in-sql-server/5/12/2012 6:46:55 AMAjay RajIn this article we are going to Inner Join, Outer Join, Cross Join, Self Join In SQL Server. http://www.dbtalks.com/UploadFile/c37c73/concepts-of-inner-join-outer-join-cross-join-self-join-in/5/12/2012 5:47:19 AMAjay RajComposite key is used to uniquely identified the two columns. In case if there is no such column that can be uniquely identified we can use composite key to uniquely identified the column values.http://www.dbtalks.com/UploadFile/a01fa5/concept-of-composite-key-in-mysql/5/11/2012 6:10:31 AMMegha GoyalHere we will see how to make a column value unique using primary key concept which means every column value will be uniquely identifiedhttp://www.dbtalks.com/UploadFile/a01fa5/to-make-the-column-value-unique-in-mysql/5/9/2012 11:29:35 PMMegha GoyalIn this article we are going to store procedure with Dynamic Query In SQL Server.http://www.dbtalks.com/UploadFile/c37c73/concepts-of-search-in-stored-procedure-with-dynamic-query-i/5/9/2012 5:44:55 PMAjay RajHere we will see how to copy an existing MySql table to a new table with same architecture. Here are some steps:http://www.dbtalks.com/UploadFile/a01fa5/creation-of-new-table-with-the-same-architecture-and-with-sa/5/9/2012 12:08:59 AMMegha GoyalIn This article we are going to understand the concept of  create function in sql server.http://www.dbtalks.com/UploadFile/c37c73/concept-of-create- function-in-sql-server/5/8/2012 7:13:02 PMAjay RajIn This article we are going to understand the concept of insert store procedure in sql server.http://www.dbtalks.com/UploadFile/c37c73/concept-of-insert-store-procedure-in-sql-server/5/8/2012 2:27:56 PMAjay RajWe know that a Null value can't be equal to a value so here we will see how to fetch the record where value is Null.http://www.dbtalks.com/UploadFile/a01fa5/working-with-null-values/5/8/2012 6:35:23 AMMegha GoyalIn This article we are going to understand Store Procedure.http://www.dbtalks.com/UploadFile/c37c73/concept-of-store-procedure-in-sql-server3/5/7/2012 5:17:04 PMAjay RajIn This article we are going to understand SQL Server. In this article you will find what is Store Procedure in SQL Server and how to implement the concept of Store Procedure in SQL Server. http://www.dbtalks.com/UploadFile/c37c73/concept-of-store-procedure-in-sql-server/5/7/2012 4:22:18 PMAjay RajWildcards are used to select the records on the basis of particular character set without ever knowing the full string name.It is used with LIKE and RLIKE operators in MySql.http://www.dbtalks.com/UploadFile/a01fa5/use-of-wildcards-in-mysql/5/7/2012 1:36:32 AMMegha GoyalIt is used to keep the record whether in increasing order or decreasing order. By default records are set in ascending order but to set them in decreasing order we need to use desc keyword with order by clause.http://www.dbtalks.com/UploadFile/a01fa5/use-of-order-by-clause-in-mysql/5/4/2012 3:49:15 AMMegha GoyalDistinct keyword is used to retrieve the unique records out of duplicate records.http://www.dbtalks.com/UploadFile/a01fa5/use-of-distinct-keyword-in-mysql/5/3/2012 12:19:34 AMMegha Goyal If we want to get the output of aggregate function on the basis of group we can use group by clause.http://www.dbtalks.com/UploadFile/a01fa5/use-of-group-by-clause-in-mysql/5/2/2012 10:52:40 PMMegha GoyalIn this article you will find how to DELETE or ALTER any Function in SQL Server. http://www.dbtalks.com/UploadFile/d1a5a5/how-to-delete-or-alter-any-function-in-sql-server/4/30/2012 3:52:44 PMVipendra VermaIn this article you will find what is Multi-statement table Valued Function in SQL Server and how to implement the concept of Multi-statement table Valued Function in SQL Server.http://www.dbtalks.com/UploadFile/d1a5a5/concept-of-multi-statement-table-value-function-in-sql-serve/4/29/2012 2:28:54 AMVipendra VermaIn this article we will study about the new feature of SQL Server 2012 i.e. Contained Database.http://www.dbtalks.com/UploadFile/a7e1c8/contained-database-in-sql-server-2012/4/26/2012 6:03:07 AMAkash AhlawatIn this article we are going to understand the concept of Inline Table Valued Function in SQL Server. In this article you will find what is Inline Table Valued Function in SQL Server and how to implement the concept of Inline Table Valued Function in SQL Server.http://www.dbtalks.com/UploadFile/d1a5a5/concept-of-inline-table-valued-function-in-sql-server/4/25/2012 3:41:51 PMVipendra VermaIn this article we are going to understand the concept of Scalar Valued User Define Function in SQL Server. In this article you will find what is Scalar Valued User Define Function in SQL Server and how to implement the concept of Scalar Valued User Define Function in SQL Server.http://www.dbtalks.com/UploadFile/d1a5a5/introduction-of-scalar-valued-user-define-function-in-sql-se/4/24/2012 4:21:11 PMVipendra VermaIn this article we will see how to add keys to the table in MySql.http://www.dbtalks.com/UploadFile/a7e1c8/adding-keys-to-the-table-in-mysql/4/24/2012 2:45:29 AMAkash AhlawatIn this article we are going to understand the concept of user define function in SQL Server. In this article you will find what is user define function in SQL Server and how to implement the concept of user define function in SQL Server.http://www.dbtalks.com/UploadFile/d1a5a5/an-introduction-of-user-define-functions/4/23/2012 1:38:29 PMVipendra Vermahttp://www.dbtalks.com/UploadFile/d1a5a5/testing-video/4/20/2012 3:29:38 AMVipendra VermaMaster Data is simple data about various players of organization like suppliers, partners, products, customers, materials, accounts and other entities that is commonly stored and replicated across the systems.http://www.dbtalks.com/UploadFile/d1a5a5/master-data/4/20/2012 2:14:23 AMVipendra VermaIn this article we are going to understand the concept Cursor in SQL Server. In this article you will find what is Cursor in SQL Server and how to implement the concept of Cursor in SQL Server.http://www.dbtalks.com/uploadfile/d1a5a5/concept-of-cursor-in-sql-server/4/8/2012 6:31:37 AMVipendra VermaIn this article we will see the steps required for the installation of effective integrated enterprise data warehouse.http://www.dbtalks.com/uploadfile/dd43c8/integrated-enterprise-data-warehouse/4/4/2012 7:42:13 AMAlviro DanIn this article we are going to understand the concept of view in Database. In this article you will find how to implement the concept of view.http://www.dbtalks.com/uploadfile/d1a5a5/concept-of-views-in-database/3/31/2012 8:45:05 AMVipendra VermaIn this article I will let you know about the new features of SQL Server 2012.http://www.dbtalks.com/uploadfile/26adbe/new-features-of-sql-server-2012/3/29/2012 5:18:47 AMRitesh SinghIn this article we will see how to add a language to MS Word.http://www.dbtalks.com/uploadfile/a7e1c8/adding-a-language-to-ms-word/3/27/2012 5:16:56 AMAkash AhlawatIn this article we will see how to set up AutoCorrect properties in MS Word.http://www.dbtalks.com/UploadFile/a7e1c8/automatic-text-correction-in-ms-word/3/23/2012 5:16:41 AMAkash AhlawatIn this article we will see how to set up the privacy of the Word document.http://www.dbtalks.com/uploadfile/a7e1c8/setting-the-privacy-priorities-in-the-ms-word/3/22/2012 4:52:22 AMAkash AhlawatIn this article we will see how to encrypt and decrypt the word document with password.http://www.dbtalks.com/uploadfile/a7e1c8/encryption-and-decryption-of-word-document/3/21/2012 2:14:45 AMAkash AhlawatLet's see some common questions and their answers related to PL/SQL.http://www.dbtalks.com/uploadfile/a7e1c8/plsql-faqs/3/20/2012 5:36:12 AMAkash AhlawatIn this article we are going to understand the concept of Elimination of Duplicate rows in SQL Server. In this article you will find how to Eliminate Duplicate rows in SQL Server. http://www.dbtalks.com/uploadfile/d1a5a5/elimination-of-duplicate-rows-in-sql-server/3/14/2012 4:08:18 PMVipendra VermaIn this article we will see some commonly related questions with Ingres and their answers.http://www.dbtalks.com/uploadfile/a7e1c8/ingres-faqs-part-2/3/14/2012 5:41:51 AMAkash AhlawatIn this article you will find what is Arithmetic Operations and how to implement the concept of Arithmetic Operations in SQL Server. http://www.dbtalks.com/uploadfile/d1a5a5/concept-of-arithmetic-operations-in-sql-server/3/13/2012 2:14:08 PMVipendra VermaIn this article we will see some commonly related questions with Ingres and their answers.http://www.dbtalks.com/uploadfile/a7e1c8/ingres-faqs-part-1/3/13/2012 2:51:34 AMAkash AhlawatIn this article we are going to understand the concept of triggers in SQL Server. In this article you will find what is triggers and how to implement the concept of Triggers.http://www.dbtalks.com/uploadfile/d1a5a5/concept-of-triggers-in-sql-server/3/12/2012 3:54:07 PMVipendra VermaIn this article we will learn about some important tools provided by Ingres database.http://www.dbtalks.com/uploadfile/a7e1c8/ingres-tools/3/12/2012 5:43:32 AMAkash AhlawatHere I am explaining about the concept of Grouping in SQL Server.http://www.dbtalks.com/uploadfile/d1a5a5/grouping-in-sql-server/3/6/2012 1:35:45 PMVipendra VermaIn this article we will see that how can we fetch the limited piece of data from our document.http://www.dbtalks.com/uploadfile/a7e1c8/how-to-return-a-collection-of-the-sibling-elements-in-linq/3/6/2012 5:38:07 AMAkash AhlawatIn this article we will understand the basics of the PLINQ.http://www.dbtalks.com/uploadfile/a7e1c8/plinq-high-performance-query/3/6/2012 4:03:54 AMAkash AhlawatHere i am explaining about Locking Techniques for Concurrency Control in Database.http://www.dbtalks.com/uploadfile/d1a5a5/locking-techniques-for-concurrency-control-in-database/3/5/2012 3:23:41 PMVipendra VermaIn this article we will see the basics about the Ingres database.http://www.dbtalks.com/uploadfile/a7e1c8/introduction-to-ingres/3/5/2012 2:26:40 AMAkash AhlawatHere I am explaining about Join Operator and it's type in SQL .http://www.dbtalks.com/uploadfile/d1a5a5/join-operator-in-sql/3/3/2012 2:42:22 PMVipendra VermaIn this article we will discuss the functioning of generation operator RANGE.http://www.dbtalks.com/uploadfile/a7e1c8/generation-operator-range/3/2/2012 3:41:10 PMAkash AhlawatIn this article, I have explained some more properties of SQLiteConnectionStringBuilder Class Members.http://www.dbtalks.com/uploadfile/ca5be5/some-more-properties-of-sqliteconnectionstringbuilder-class/3/2/2012 4:26:00 AMMonika AroraIn this article we will learn some concurrency related issues with LINQ to XML.http://www.dbtalks.com/uploadfile/a7e1c8/concurrency-in-linq-to-sql/3/1/2012 3:33:35 PMAkash AhlawatIn this article I have discussed the public properties and some of the public methods of SQLiteDataReader Class members.http://www.dbtalks.com/uploadfile/ca5be5/public-properties-and-public-methods-of-sqlitedatareader-cla/3/1/2012 5:15:01 AMMonika AroraIn this article I have explained some of the properties of SQLiteConnectionStringBuilder Class Members.http://www.dbtalks.com/uploadfile/ca5be5/some-properties-of-sqliteconnectionstringbuilder-class-membe/2/29/2012 5:42:24 AMMonika AroraIn this article we will see the concept of immediate query execution in LINQ.http://www.dbtalks.com/uploadfile/a7e1c8/immediate-query-execution-in-linq/2/28/2012 2:43:20 PMAkash AhlawatIn this article I have explained the Public properties and Public methods of SQLiteBlob class members.http://www.dbtalks.com/uploadfile/ca5be5/public-properties-and-public-methods-of-sqliteblob-class-mem/2/27/2012 6:58:45 AMMonika AroraIn this article I have discussed the Public properties and Public methods of DbConnectionStringBuilderClass members.http://www.dbtalks.com/uploadfile/ca5be5/public-properties-and-public-methods-of-dbconnectionstringbu/2/23/2012 6:51:12 AMMonika AroraIn this article we will see the concept of deferred query execution in LINQ.http://www.dbtalks.com/uploadfile/a7e1c8/deferred-query-execution-in-linq/2/22/2012 1:33:56 PMAkash AhlawatIn this article we will perform calculation in one of the projection operator i.e. Select operator.http://www.dbtalks.com/uploadfile/a7e1c8/projection-operators-performing-calculation-in-the-select-s/2/20/2012 1:54:16 AMAkash AhlawatIn this article we will see how to use Lambda Expression to declare a Delegate.http://www.dbtalks.com/uploadfile/a7e1c8/using-lambda-expression-to-declare-a-delegate/2/19/2012 2:41:31 AMAkash AhlawatIn this article we will use Lambda expression to declare an expression tree. http://www.dbtalks.com/uploadfile/a7e1c8/declaring-an-expression-tree-using-lambda-expression/2/18/2012 4:57:31 AMAkash AhlawatSome of the properties and methods of DbLoader class members are BufferSize, Item and CreateObjRef, Dispose respectively.http://www.dbtalks.com/uploadfile/ca5be5/properties-and-methods-of-dbloader-class-members/2/16/2012 6:23:19 AMMonika AroraIn this article we will see how to Access the XML Document from an XElement Object via the Document Property. http://www.dbtalks.com/uploadfile/a7e1c8/using-xelement-object-via-the-document-property-for-accessin/2/15/2012 3:29:11 PMAkash AhlawatYou can use AddWhereCondition with where clause, if you want to include some more condition with it.http://www.dbtalks.com/uploadfile/ca5be5/addwherecondition-method-in-sqlite/2/14/2012 7:06:12 AMMonika AroraIn this article we will see how to obtain restricted element without reaching in LINQ to XML.http://www.dbtalks.com/uploadfile/a7e1c8/obtaining-restricted-elements-without-reaching-in-linq-to-xm/2/13/2012 1:02:04 PMAkash AhlawatThere are various properties of SQLiteSelectStatement class members which are All,Tables,Where etc. In the same way there are methods also for the same which are ToString, Clear, TryParse etc.http://www.dbtalks.com/uploadfile/ca5be5/properties-and-methods-of-sqliteselect-statement-class-membe/2/13/2012 7:03:23 AMMonika AroraIn this article we will see how to obtain element without reaching in LINQ to XML.http://www.dbtalks.com/uploadfile/a7e1c8/obtaining-elements-without-reaching-in-linq-to-xml/2/11/2012 1:57:33 AMAkash AhlawatIn this article we will see that how IsBefore method is used to determine whether the given node appears before a specified node or not.http://www.dbtalks.com/uploadfile/a7e1c8/how-to-determine-whether-the-given-node-appears-before-a-spe/2/6/2012 2:19:06 AMAkash AhlawatCreating a new XML document using the classes such as XDocument, XElement and XAttribute.http://www.dbtalks.com/uploadfile/a7e1c8/using-xdeclaration-xelement-xattribute-to-create-an-xml-do/2/2/2012 2:14:21 PMAkash AhlawatIn this article we will create Xml document declaration and will set its properties.http://www.dbtalks.com/uploadfile/a7e1c8/creating-a-declaration-and-setting-its-properties-of-xml-doc/2/1/2012 5:11:13 PMAkash AhlawatYou can update records in a table through Command Editor in SQLite through the use of DataTable object.http://www.dbtalks.com/uploadfile/ca5be5/updation-of-records-in-a-table-through-command-editor-in-sql/2/1/2012 5:49:20 AMMonika AroraIn this article we will see how to use XPath to query document using example.http://www.dbtalks.com/uploadfile/a7e1c8/linq-to-xml-xpath-for-querying-the-document/1/30/2012 4:15:29 PMAkash AhlawatIn this article we will see the functionality of SequenceEqual operator in LINQ.http://www.dbtalks.com/uploadfile/a7e1c8/sequenceequal-operator-in-linq/1/29/2012 1:58:29 AMAkash AhlawatIn this article we will see the role and functionality of extension methods.http://www.dbtalks.com/uploadfile/a7e1c8/linq-extension-methods/1/28/2012 5:07:59 AMAkash AhlawatIn this article we will see how to write a node to the XmlWriter in LINQ.http://www.dbtalks.com/uploadfile/a7e1c8/using-xmlwriter-for-writing-a-node-in-linq/1/25/2012 3:49:42 PMAkash AhlawatYou can use LinqConnect tool with SQLite to create model of your database.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-model-using-linqconnect-tool-with-sqlite-databas/1/25/2012 4:25:59 AMMonika AroraYou can use named parameters in SQLite if you want to update a record into table. In named Parameters, ':' or '@' sign is used.http://www.dbtalks.com/uploadfile/ca5be5/named-parameters-in-sqlite/1/24/2012 4:49:58 AMMonika AroraIn this article we will see how to add the processing instruction to the document.http://www.dbtalks.com/uploadfile/a7e1c8/how-to-add-processing-instruction-to-the-document-using-linq/1/23/2012 4:08:26 PMAkash AhlawatIn this article we will learn that what is XProcessingInstruction and how to create it.http://www.dbtalks.com/uploadfile/a7e1c8/creating-the-xprocessinginstruction-in-linq/1/22/2012 4:53:45 AMAkash AhlawatIn this article we will see in depth of the XStreamingElement Class.http://www.dbtalks.com/uploadfile/a7e1c8/xstreamingelement-class-in-linq-to-xml/1/21/2012 4:10:48 AMAkash AhlawatYou can use parameters in SQLite if you want to insert a record into table. In Unnamed Parameters, question sign is used.http://www.dbtalks.com/uploadfile/ca5be5/unnamed-parameters-in-sqlite/1/20/2012 6:52:44 AMMonika AroraUntyped DataSet can also be used for creation of Data Tables and for establishing relations between tables in SQLite.http://www.dbtalks.com/uploadfile/ca5be5/untyped-dataset-in-sqlite/1/19/2012 6:35:00 AMMonika AroraIn this article we will see the importance of MDM in today's world.http://www.dbtalks.com/uploadfile/a7e1c8/master-data-management-need-and-necessity/1/18/2012 4:24:50 PMAkash AhlawatDataset can be created through Dataset Wizard also and relations between fields in tables can also be established.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-dataset-through-dataset-wizard-in-sqlite/1/18/2012 6:41:06 AMMonika AroraData in SQLite database can be accessed through DataReader by using its ExecuteReader method in connected model.http://www.dbtalks.com/uploadfile/ca5be5/access-of-data-using-the-connected-model-in-sqlite-through-d/1/13/2012 4:45:48 AMMonika AroraIn this article we will see how to traverse up and down in XML Document.http://www.dbtalks.com/uploadfile/a7e1c8/traversing-the-xml-document/1/12/2012 4:21:51 PMAkash AhlawatIn this article we will use the OfType operator on the Xml data.http://www.dbtalks.com/uploadfile/a7e1c8/using-the-oftype-operator-in-quering-the-xml-data/1/11/2012 4:22:30 PMAkash AhlawatYou can create a table and can insert values into it through SQLiteScript object if you work in SQLite through dotConnect for SQLite.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-table-and-insertion-of-values-in-dotconnect-for/1/11/2012 6:26:06 AMMonika AroraSQLite connection can be created at runtime using the SQLiteConnectionStringBuilder class in Visual Studio.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-sqlite-connection-at-runtime-and-querying-the-da/1/10/2012 6:23:39 AMMonika AroraIn this article we will see the use and functionality of ReplaceAll method.http://www.dbtalks.com/uploadfile/a7e1c8/linq-to-xml-replaceall-method/1/9/2012 3:14:05 PMAkash AhlawatYou can create SQLite connection through Dotconnect for SQLite tool also in Visual Studio. http://www.dbtalks.com/uploadfile/ca5be5/creation-of-sqlite-connection-at-design-time-through-dot-con/1/9/2012 3:22:02 AMMonika AroraIn this article we will see the use of RemoveAll method in LINQ to XML.http://www.dbtalks.com/uploadfile/a7e1c8/linq-to-xml-removeall-method/1/7/2012 4:00:14 AMAkash AhlawatDotconnect for SQLite is build on ADO.Net technology to develop database applications that are based on SQLite.http://www.dbtalks.com/uploadfile/ca5be5/introduction-to-dotconnect-for-sqlite/1/5/2012 6:22:08 AMMonika AroraIn this article we will learn how to delete nodes from the XML document.http://www.dbtalks.com/uploadfile/a7e1c8/deleting-the-specific-node-or-sequence-of-node-from-xml-docu/1/4/2012 3:58:47 PMAkash AhlawatIn this article I will show you how to add, update and delete the child element using the SetElementValue method.http://www.dbtalks.com/uploadfile/a7e1c8/how-to-add-update-and-delete-child-element-in-xml-document/1/3/2012 4:24:03 PMAkash AhlawatTriggers can be created in SQLite through the SQLite Administrator tool also using Create Trigger option in it.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-triggers-in-sqlite-through-sqlite-administrator/12/30/2011 1:28:39 AMMonika AroraViews can be created in SQLite through the SQLite Administrator tool also using Create View option in it.http://www.dbtalks.com/uploadfile/ca5be5/creation-of-views-in-sqlite-through-sqlite-administrator-too/12/29/2011 3:58:35 AMMonika AroraIndex can be created and SQL query can be executed in SQLite through SQLite Administrator tool also.http://www.dbtalks.com/uploadfile/ca5be5/index-creation-and-execution-of-sql-query-in-sqlite-adminis/12/28/2011 11:43:37 PMMonika AroraIn this article I will use InDocumentOrder method to display the XML document in document order.http://www.dbtalks.com/uploadfile/a7e1c8/displaying-the-xml-document-in-exact-document-order-using-li/12/27/2011 1:59:18 PMAkash AhlawatDatabase and tables in SQLite can also be made through SQLite Administrator tool.http://www.dbtalks.com/uploadfile/ca5be5/creating-database-in-sqlite-using-sqlite-administrator-tool/12/27/2011 5:08:41 AMMonika AroraSQlite can be used in Visual Studio 2010 through the use of ADO.Net provider which helps in loading SQLite database in Visual Studio.http://www.dbtalks.com/uploadfile/ca5be5/using-sqlite-in-visual-studio-2010/12/23/2011 2:04:45 AMMonika AroraIn this article we will see the use of DescendantNodesAndSelf method.http://www.dbtalks.com/uploadfile/a7e1c8/linq-to-xml-descendantnodesandself-method/12/20/2011 11:47:17 PMAkash Ahlawat