Pratiksha – Medium

Pratiksha

Pratiksha

SQL Multitable Queries Made Easy: A Beginner’s Guide with Tips and Tricks

This article teaches you how to write multitable queries in SQL, that combine data from two or more tables into a single table.

Jun 18, 2023

join multiple tables using queries.

Jun 18, 2023

Pratiksha

How to Perform ETL Process Using Excel

Learn how to use Power Query in Excel to perform ETL operations on data sources and create a dimensional model for analysis.

May 31, 2023

ETL process example using excel

May 31, 2023

Pratiksha

Data Visualization for E-commerce: A Guide to Creating Stunning Visuals and Boosting Your Sales

Learn how to use data visualization to grow your e-commerce business and what tools to use. Plus, see some inspiring examples. #dataviz

May 25, 2023

data visualization for ecommerce

May 25, 2023

Pratiksha

Search Conditions in SEO: What They Are and How to Use Them

Learn what search conditions are and how to use them for SEO. #SEO #searchconditions #webpages

May 23, 2023

SEO optimisation for better ranking and gaining organic traffic

May 23, 2023

Pratiksha

How to Master Search Conditions in SQL and Manipulate Data Like a Pro

SQL (Structured Query Language) is a language for manipulating data in relational databases. SQL allows you to perform various operations…

May 22, 2023

Sql conditions for data searching

May 22, 2023

Pratiksha

How to Learn Data Science: A Step-by-Step Guide

How to Learn Data Science in: A Guide for Beginners #datascience #python #machinelearning #deeplearning #tools

May 18, 2023

Learn data science in 5 steps: Python, statistics, machine learning, deep learning, and tools.

May 18, 2023

Pratiksha

Data Extract, Transform and Load: What, Why and How

Data ETL: extract, transform, load data for analysis. Ensure quality and consistency. Choose mode based on volume and frequency.

May 17, 2023

Data ETL is a process of extracting, transforming, and loading data from various sources into a destination where it can be used for analysis.

May 17, 2023

Pratiksha

SQL: A Handy Guide to Creating, Updating, Altering, and Backing Up Your Database

Learn SQL basics: create, update, alter, backup databases with examples and tips. A handy guide for data lovers.

May 16, 2023

Learn SQL basics: create, update, alter, backup databases with examples and tips. A handy guide for data lovers.

May 16, 2023

Pratiksha

Usage of primary and foreign keys in SQL

Learn about primary & foreign keys in SQL, their importance in ensuring data integrity & consistency, their differences & usage examples.

May 16, 2023

May 16, 2023

Pratiksha

Understanding SQL JOIN Queries: Examples and Explanations

SQL JOINs combine data from multiple tables. Types include INNER, LEFT, RIGHT, FULL JOIN. Each has unique behavior for different results.

May 14, 2023

sql table join using left, right and full

May 14, 2023

Pratiksha

Pratiksha

Hey! I’m a business strategist who loves data. I share my learnings on Medium and love reading anything. Got book suggestions? I’m all ears!

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams