I am a CTO with over 5 years of experience in start-up and over 10 years in working at managing position for big companies. I am also a full-stacks developer with over 12 years in system design, product development and technology product deployment. User experience and system security are the things I care about most.
Learn College Precalculus with Python
Precalculus is an important mathematical course that lays the groundwork for calculus and other higher-level math subjects. We just released a college precalculus course on the freeCodeCamp.org YouTube channel. This course is unique in that you will …
Why am I not getting Quincy Larson’s email anymore?
If you’re not getting Quincy Larson’s email each week, and you want to get them again, do the following: Fill out this form. It takes less than a minute. Search your spam folder for “Quincy Larson” and if you find any of my emails in there, mark th…
Which languages should you learn for data science?
Data science is an exciting field to work in, combining advanced statistical and quantitative skills with real-world programming ability. There are many potential programming languages that the aspiring data scientist might consider specializing in. While there is no correct answer, there are several things to take into consideration. Your success
Spreadsheets getting you down? Converting row data to JSON trees is a breeze.
Like many of you, I often have to take the result of SQL queries [http://www.sqlcourse.com/intro.html] and convert the rowsets to JSON data objects [http://www.json.org/]. Sometimes I have to do the same with CSV files from spreadsheets. The transformation process can be a hassle, though anyone can do it. Yet, it
SQLAlchemy makes ETL magically easy
One of the key aspects of any data science workflow is the sourcing, cleaning, and storing of raw data in a form that can be used upstream. This process is commonly referred to as “Extract-Transform-Load,” or ETL for short. It is important to design efficient, robust, and reliable ETL processes,
Exploring a powerful SQL pattern: ARRAY_AGG, STRUCT and UNNEST
by Lak Lakshmanan Exploring a powerful SQL pattern: ARRAY_AGG, STRUCT and UNNEST It can be extremely cost-effective (both in terms of storage and in terms of query time) to use nested fields rather than flatten out all your data. Nested, repeated fields are very powerful, but the SQL required to
How to write modular, readable SQL using named result sets and functions
by Lak Lakshmanan How to write modular, readable SQL using named result sets and functions My professional journey in computers has involved C++, then Java, and now Python. SQL remains, at best, a foreign language. For my own sanity, therefore, I’ve brought some of my programming best practices to SQL.
How to get started with PostgreSQL
by Akul Tomar How to get started with PostgreSQL PostgreSQL is an open source Relational Database Management System (RDBMS). In this article, I’ll provide an introduction to getting started with PostgreSQL. Here is what we’ll cover: * Installation [https://medium.com/p/9d3bc1dd1b11#d220] * Administration [https://medium.com/p/9d3bc1dd1b11#d003] * Basic Database Operations Installation