(SQL Tutorials for Citizen Data Scientist) SQL Join Fundamentals All the queries you’ve seen so far have been concentrated on a single table. But in real life situation you often need to query two or more tables at time and bring a combined result set. This is technically referred to as a join, since it …

(SQL Tutorials for Citizen Data Scientist) SQL DROP Statement In this tutorial you will learn how to delete database and table using SQL. Removing a Table from Database You can use the DROP TABLE statement to easily delete the database tables that you no longer need. The DROP TABLE statement permanently erase all data from the table, as well as the …

(SQL Tutorials for Citizen Data Scientist) SQL TRUNCATE TABLE Statement In this tutorial you will learn how to quickly delete all rows from a table using SQL. Removing Table Data The TRUNCATE TABLE statement removes all the rows from a table more quickly than a DELETE. Logically, TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause. The TRUNCATE TABLE statement removes all the rows from …

(SQL Tutorials for Citizen Data Scientist) SQL DELETE Statement In this tutorial you will learn how to delete records from a database table using SQL. Deleting Data from Tables Just as you insert records into a table with the INSERT statement, you can delete records from a table as well with the DELETE statement. Syntax The DELETE statement is used to remove one …

(SQL Tutorials for Citizen Data Scientist) SQL UPDATE Statement In this tutorial you will learn how to update records in a database table using SQL. Updating Table Data In the previous chapters we’ve learnt how to insert data as well as how to select data from a database table based on various conditions. In this tutorial we’ll learn to perform one …

(SQL Tutorials for Citizen Data Scientist) SQL DISTINCT Clause In this tutorial you will learn how to remove duplicate values from a result set. Retrieving Distinct Values When fetching data from a database table, the result set may contain duplicate rows or values. If you want to remove these duplicate values you can specify the keyword DISTINCT directly after …

(SQL Tutorials for Citizen Data Scientist) SQL TOP / MySQL LIMIT Clause In this tutorial you will learn how to retrieve fixed number of records from the table. Limiting Result Sets In some situations, you may not be interested in all of the rows returned by a query, for example, if you just want to retrieve the top 10 …

(SQL Tutorials for Citizen Data Scientist) SQL IN & BETWEEN Operators In this tutorial you will learn how to use IN and BETWEEN operators with WHERE clause. Working with Range and Membership Conditions In the previous chapter we’ve learned how to combine multiple conditions using the AND and OR operators. However, sometimes this is not sufficient and very productive, for example, if you have to check the values that …