The INSERT statement in SQL allows you to add data to a table. Let’s take a look at it and see some examples in this article.
Today we’ll be learning to connect to Postgre SQL like Amazon Redshift to R. So the package available in R is RPostgreSQL.
When I was learning about SQL JOINS I found this cheat sheet and couldn’t anything find better than this. So I want to share with all of you guys.
I don’t think I have to explain about the SQL JOINS now.
Image is taken from- Image Source
Today we’ll be learning about one of the most important statement in SQL that is ‘Update’ statement. As the name says Update statement is used to update the records in the existing table.
Below the table called new_table in database.
Today we’ll be learning some SQL tips and tricks that could save a lot of time.I’ll be using MYSQL workbench 6.3 for the tutorial. As you know SQL is not case sensitive so query can be written in either of the case.
Below is the table in the database named “new_table”
Today we’ll be learning about SQL functions. We have functions in SQL similar to Excel.
The following Table ‘cricket’ we have.
Today we’ll be learning about the SELECT statement in SQL.
Query the entire table
Using the ‘Select *‘ statement in the query will return the entire table (all the columns and all the rows). Read more
In this tutorial we’ll be starting with SQL and learning basics. I’ll be using MYSQL workbench 6.3 for the tutorial.
SQL is NOT case sensitive: select is the same as SELECT. We can write our queries in either upper case or lower case or in both of them.