Data Science Man

Introduction - SQL Programming for Data Analysis and Development Part 1

What is SQL, What is RDBMS and DataTable

How to Install MySQL with Xampp and What is Schema in SQL

Creating MySQL Database and Table using Phpmyadmin GUI

Creating MySQL Database and Tables using SQL Queries - Part 5

Insert Records with SQL and Alter Table Statements

SQL Select star and Select 1 Column or Multiple Columns Statement

How to Import MySQL Database Northwind from a SQL File - Part 8

What is a Collation and a Character Set in MySQl - Part 9

DELETE Command in MySQL - Delete Records and Drop Table - Part 11

Comments in SQL - How to comment lines in sql queries Part 12

ALIAS Use of AS keyword to Rename Columns in SQL Table - Part 15

Inserting and updating records in Postgresql table with SQL queries - Part 3

How to Analyze Live MySQL Database with Python Pandas -

Python Set - unordered, mutable, and unindexed collection of unique elements.

PostgreSQL Introduction, Installation and Creating your first Database, Table with UI - Part 1

Importing an External Database in PostgreSQL from SQL Code

Create Database Command in MySQL with Phpmyadmin

JSON Module in Python - JSON for Data Analytics

Sorting in SQL with Order By Ascending and Descending Part 14

Change Measure with Change in Parameter in Tableau - Dynamic Measures in Tableau

Sample Google Analytics Report in Power BI - Quick Overview

List in Python - Introduction -

List Methods in Python for Data Analysis