Search Results for: RDBM

Data Analysis: What to Learn

Francisco Olvera

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 […]

Database Administration Fundamentals (WS17SQL1007) – Day 1

Francisco Olvera

We have started a new SQL course. As I explained last night, each relational database management systems (RDBMS) vendor has some proprietary syntax and tools. Therefore some code has to be converted when moving code from SQL Server to Oracle, PostgreSQL or SQLite. Some third-parties have released facilities like SQLines. If you have any questions on other systems, do not hesitate to […]