Skip to content

TheQuickBlog

Learn Quick, Lead Quicker

  • How To
  • Django
    • Django Rest Framework
    • Django Session
  • Python
    • Jupyter Notebook
    • Machine Learning
    • Openpyxl
  • Data Science
    • Orange
    • Jupyter Notebook
  • Laravel
    • Installation
    • CRUD
  • Linux
  • SQL
  • Blockchain
  • Git
    • GitHub Pages
    • Jekyll Framework
    • GitHub Gist
    • GitHub Resume
    • GitHub Contribution
  • OS
  • Data Structure
  • AI

Tag: SQL

sending an email through gmail using python

Pagination for retrieving large table records in SQL.

April 10, 2024 thequickblog SQL

To implement pagination in SQL, you need to retrieve a subset of records from the database based on the current page being requested and the number of records to display per page. This involves specifying the starting and ending rows for the desired page and then selecting only those rows from the database.

Continue reading

List of essential tools and libraries that were widely used in the Software industry:

September 30, 2023 thequickblog Python

Python: Python remains the primary programming language for data science due to its extensive libraries and ecosystem.

Jupyter Notebook: Jupyter notebooks are interactive and popular for data exploration, visualization, and sharing results.

Continue reading
sending an email through gmail using python

How to use INNER JOIN in SQL?

August 23, 2023 thequickblog How To, MySQL, Snowflake, SQL

In SQL, an INNER JOIN is utilized to merge rows from two or more tables based on a shared column. It only delivers the data from the intersection of the tables or the rows for which the stated condition is true. Here’s the basic syntax for using INNER JOIN in SQL:

Continue reading
sending an email through gmail using python

How to Rename Column Name in SQL?

August 13, 2023 thequickblog How To, MySQL, Snowflake, SQL

Using the ALTER TABLE statement and the RENAME COLUMN clause, you can rename a column in SQL. Depending on the database management system (DBMS) you are using, the precise syntax for renaming a column may differ slightly.

Continue reading
Snowflake

Select all columns except a few specific column in snowflake [New Feature]. 

January 26, 2023 thequickblog Data Science, How To, MySQL, Snowflake, SQL

We all know that SELECT * FROM table_name gives us all the columns from table but sometimes we need to select all the columns except a few columns. One of the easiest ways is to manually specify columns and exclude unwanted columns, like:

SELECT column_1,column_2, column_3,…column_n FROM table_name;

Continue reading
SQL cheat sheet

SQL Cheat Sheet [Basic DDL and DML commands]

November 22, 2022 thequickblog MySQL, Snowflake, SQL

DATA DEFINITION LANGUAGES (DDL) COMMANDS A Data Definition Language (DDL) statement is used to define

Continue reading

Categories

  • AI
  • Blockchain
  • Data Science
  • Data Structure
  • Excel
  • Git
  • How To
  • Laravel
  • Linux
    • Terminal
    • Ubuntu
  • Machine Learning
    • Orange3 Data Mining Tool
  • MySQL
  • OS
  • PHP
  • Python
    • Django
    • Django Rest Framework
    • Jupyter Notebook
    • Openpyxl
    • Pandas
    • pip
  • Snowflake
  • SQL
  • Uncategorized

Recent Posts

  • Application of Binary Cross Entropy.
  • Code for Binary Cross Entropy quick implementation.
  • Pagination for retrieving large table records in SQL.
  • Complete Overview of Tree Data Structure.
  • Complete overview of Cryptocurrency.

Archives

  • April 2024 (9)
  • October 2023 (1)
  • September 2023 (4)
  • August 2023 (9)
  • July 2023 (2)
  • May 2023 (1)
  • January 2023 (3)
  • November 2022 (1)
  • July 2022 (1)
  • June 2022 (1)
  • January 2022 (4)
  • September 2021 (1)
  • July 2021 (1)
  • June 2021 (1)
  • May 2021 (1)
  • April 2021 (3)
  • March 2021 (2)
  • January 2021 (1)
  • November 2020 (4)
  • August 2020 (4)
  • July 2020 (5)
  • June 2020 (7)
  • May 2020 (33)
  • April 2020 (1)
  • March 2020 (3)
  • February 2020 (1)
  • January 2020 (2)
  • December 2019 (1)
  • November 2019 (2)
  • October 2019 (1)
  • September 2019 (1)
  • August 2019 (1)
  • July 2019 (8)
  • June 2019 (1)
  • May 2019 (1)
  • April 2019 (1)
  • March 2019 (1)
  • February 2019 (2)
  • January 2019 (2)
  • December 2018 (1)

Tags

Algorithm (3) automation (8) Bitcoin (6) blockchain (8) blockchain technology (5) blog (3) computer science (4) cryptocurrency (4) cryptography (8) data (6) Database (4) datascience (4) Django (11) Django Tutorial (12) DSA (4) Excel (5) Git (6) Github (9) Google (4) How To (48) Jupyter (3) Jupyter Notebook (4) Laravel (12) Laravel5 (6) Laravel5.7 (9) Laravel Migration (3) Linux (12) Linux Terminal (6) MySQL (13) openpyxl (6) Php (8) php5.7 (3) PHP7 (9) pip (7) Python (30) Python3 (32) python module (9) python pacakge (3) Query (4) quickblog (5) SQL (6) terminal (5) Ubuntu (5) virtualcoin (3) windows (4)
WordPress Theme: Tortuga by ThemeZee.