Data Analysis: What to Learn

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

Get Started with a List of Reference Sites: Where to Get Help When Needed or What to Read When Bored

Get yourself a list of websites and other resources to read and for reference. The following are some recommendations. https://arstechnica.com/ https://apachefriends.org/ https://cloudsavvyit.com/ https://cnet.com/ https://dev.to/ https://freecodecamp.org/ https://mariadb.org/ https://mongodb.com/ https://mongodb.com/blog https://mysql.com/ https://news.ycombinator.com/ https://oracle.com/ https://phpmyadmin.net/ https://postgresql.org/ https://slashdot.org/ https://sqlite.org/ https://techonthenet.com/ https://techonthenet.com/sql_server/ https://techrepublic.com/ https://wired.com/

Database Administration Fundamentals (WS17SQL1007) – Day 1

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