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 (WS16SQL1006) – Day 6

We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures. Download the class notes for day 6. Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL for SQL Server. If anyone if […]