- Applied statistics (not software, but good old math) including general understanding of machine learning (artificial intelligence).
- R and/or Python with libraries like NumPy and/or pandas.
- Structured Query Language (SQL) with a broad understanding of extensions (vendor-specific syntax) depending on the relational database management system (RDBMS) that the company (your employer) has like Oracle, MySQL, PostgreSQL and/or SQL Server.
- Data visualization applications like Tableau, SSRS and/or Crystal Reports.
- Data normalization (how to clean dirty data using SQL).
SQL
Why Programmers Need to Learn SQL if You Want a Job in Data? (Analytics Insight)
The quote below is neither an endorsement nor an advert.
SQL is a language that enables storing, retrieving, and manipulating data in databases… SQL has a lot of career options in the business domain as well as in the data science sector. When data is of interest in the gap analysis, SQL can be used to find gaps in data such as dates or number sequences. A thorough gap analysis is a critical piece of any business analysis; therefore, a good understanding of SQL can be an essential tool for Business Analysts.
https://www.analyticsinsight.net/why-programmers-need-to-learn-sql-if-you-want-a-job-in-data/
The article is loosely written, but the potential student can get the idea what SQL is for and how to use it.
SQL is the only language to access relational databases like PostgreSQL, Oracle, MySQL and its fork MariaDB, SQL Server and others. The only difference between vendors is the subset of language (different statements and/or syntax not included in the latest version, SQL:2016 or ISO/IEC 9075-1:2016) that each vendor adds to the language, referred to as extensions — PL/pgSQL, PL/SQL, MySQL, T-SQL and others.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 10
Thank you for taking class SF21JOB#2.
Download the class notes for day 10.
Database Administration Fundamentals (SF21SQL1001) – Day 10
Thank you for taking class SF21SQL1001. See you in the intermediate class.
Download the class notes for day 10.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 9
We have finished all new material for this course.
Download the class notes for day 9.
Database Administration Fundamentals (SF21SQL1001) – Day 9
We have finished covering all the material for this course.
Download the class notes for day 9.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 8
We have finished all new material for this course.
Download the class notes for day 8.
Database Administration Fundamentals (SF21SQL1001) – Day 8
We are two sessions away to finish the course and we have covered all the material for this course.
Download the class notes for day 8.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 7
We are almost done with this course. We have covered how to SELECT data from tables throughout several sessions. We have also just started to CREATE and DROP objects.
Download the class notes for day 7.
CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB#2) — Day 6
We are almost ready to start working with database objects. In the meantime, we reviewed all the material so far.
Download the class notes for day 6.