Array ( [category_name] => database [error] => [m] => [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [static] => [pagename] => [page_id] => 0 [second] => [minute] => [hour] => [day] => 0 [monthnum] => 0 [year] => 0 [w] => 0 [tag] => [cat] => 668 [tag_id] => [author] => [author_name] => [feed] => [tb] => [paged] => 1 [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [embed] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [post_name__in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [post_parent__in] => Array ( ) [post_parent__not_in] => Array ( ) [author__in] => Array ( ) [author__not_in] => Array ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [post_type] => [posts_per_page] => 10 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [order] => DESC [orderby] => date )
Database

Learn How to Work with R Data Structures

To use the R language effectively a good understanding of data types, data structures and how they are operated is important. These objects are the basis of all operations performed in R. For example, a common source of headache is object conversions which can be eliminated with a good understanding of R objects. It is

Database

Learn how to manage data in a Nosql database using HBase

NoSQL databases are designed for scalability where unstructured data is spread across multiple nodes. When data volumes increase you just need to add another node to accommodate the growth. The lack of structure in NoSQL databases relaxes stringent requirements of consistency enforced in relational databases to improve speed and agility. Hbase, MongoDB and Cassandra are

Database

Learn working of String function in SQL

Few days ago we learnt about how to use Date Function in SQL, In today’s post we will learn working of String Function in SQL. SQL string function is used for string manipulation. Following are the commonly used inbuilt String function in SQL server. 1. Lower() 2. Upper() 3. LTrim() 4. RTrim() 5. Replace() 6.

Database

Learn working of Date function in SQL

In programming, situation usually comes to manage data with dates. Sql inbuilt function provides help to manipulate the data to avoid date errors in different scenario. Following are the commonly used inbuilt Date function in sql server. 1. GetDate() 2. Convert() 3. IsDate() 4. DatePart() 5. DateADD() 6. DateDiff(). 7. DateName() 8. Day() 9. Month()

Database

Learn While loop in SQL

The looping statement repeatedly executes command in its block until the specified condition become true or it terminates by break keyword. SQL extensively use While loop statement to iterate the PL/SQL statement because this is the only looping statement support by SQL. IN this article we are going to learn to how to use of

Database

Learn Basics and Use of SQL – Into Statement

In this tutorial we are going to learn about SQL – Into Statement. Usages : It is used to Copy Table Data. It is used to insert bulk record at once from existing table. It inserts entire result set into a table at once. Operation on INTO Select Into. Insert Into Select. 1) Select Into

Database

SQL –Merge Statement

As name initiated, merge statement is used to synchronize the two tables so that the target table is modified with source table. Merge statement basically combines the data from different table together on the basis of join fields in both table. SQL Merge statement do insert and update/delete in target table basis on the row

Database

What is a SQL Pivot Operator

In this section, I will explain about ‘What is a SQL Pivot Operator’ and how to apply it. The word ‘Pivot’ means to rotate and that is exactly what we do with the SQL Pivot Operator. We rotate rows in to columns. Example: In the following example, there is a table on the left side

Database

What is SQL Store Procedure

In this section I have covered following thing about store procedure. Things like: • What is store procedure • What are the usages of store procedure • Creating simple store procedure • Execution of store procedure • Creating procedure with parameter • Alter a procedure • Deletion of store procedure Let’s discuss each point in

Database

SQL Transaction Control Language (TCL)

This article explains in brief about Transaction control language which provides accessibility to control the changes in database, for example TCL controls the execution of DML operation (insert/update/delete) in database.It also illustrates to how to control the DML operation using Transaction control statement. In order to understand the concept of SQL Transaction Control Language (TCL)