Choosing among SQL Server, PostgreSQL, MySQL, and SQLite — While I was learning SQL, I was unsure of which database management system to use. I was advised to first learn the fundamentals, as they are mostly the same for relational database management systems. Out of 388 votes in a LinkedIn poll on which RDBMS to use, 64% of participants…

Reference Guide — SQL Basics Select Select Distinct Select Top Where Order By Like And, Or, Not Operators In Between Exists Is Null Wildcards Case Comments Tables Create Table Alter Table Drop Table Data Types Insert Into Update Delete Select Into Insert Into Select Transactions Constraints Primary Key Unique Not Null Auto Increment Default Check Foreign Key …

I first became a Python Developer I enrolled college as a physics major I started college at the age of 17 at Stevens Institute of Technology in Hoboken, NJ. I graduated high school in three years and had not gotten a chance to take Calc 1 or any AP courses…

Python lists are data structures used to store and change items. If you’re just learning Python or want to learn some neat tricks when using lists, this post is for you! The documentation on python lists can be found here. 1. Element-wise addition of two lists

Today I tackled plotting both probability density functions and kernel density estimations in Python. In order to first understand probability density functions or PDF’s, we need to first look at the docs for scipy.stats.norm. scipy.stats.norm A normal continuous random variable. The location (loc) keyword specifies the mean. …