Study Log – OCP – MySQL

  1. Objectives:
    1. exam
    2. my own MySQL system with KM
    3. comparisons with Graph DB and MongoDB NoSQL
  2. Contents
  3. References
    1. MySQL documentation Library: https://dev.mysql.com/doc/
    2. Stramer’s log for MySQL 5.6. https://stramer.org/2013/11/07/mysql-5-6-database-administrator-exam-study-guide/
Advertisements
Study Log – OCP – MySQL

Programming – Python & R

  1. Objectives
    1. Modify scikit-learn for Machine learning
    2. Building and using own web crawler
    3. Linux system administration
  2. Usage
    1. Heavily used by Google
    2. No.2 Used in data science, after R
  3. Contents
    1. Python Basics (https://www.dataquest.io/m/1/python-basics)
      1. Characteristics of Python for Data
        1. handling large datasets
        2. working with common mathematical functions
        3. creating powerful data visualizations
      2. Basic features of programming in Python
        1. Displaying – print():
          1. Numbers: print(4), print(4+5)
    2. Edx.org (Introduction to Python: Absolute Beginner)
      1. Basics
      2. Functions
      3. Conditionals
      4. Nesting & Loops
      5. Final Evaluation
  4. References:
    1. Google’s Python Class. https://developers.google.com/edu/python/
    2. Introduction to Python. https://www.udacity.com/course/introduction-to-python–ud1110
    3. Programming Foundations with Python. https://www.udacity.com/course/programming-foundations-with-python–ud036
    4. Introduction to Python: Absolute Beginner. https://www.edx.org/course/introduction-to-python-absolute-beginner-0
    5. Learn Python for Data Science. https://www.datacamp.com/courses/intro-to-python-for-data-science?utm_medium=fb%2Can%2Cig%2Cms-all&utm_source=fb_paid&utm_campaign=smartly_ppa&utm_id=5a348450c7e28c19ab425b3b
    6. Top 15 Python Libraries for Data Science in 2017. https://www.kdnuggets.com/2017/06/top-15-python-libraries-data-science.html
    7. 7 Steps to Mastering Data Preparation with Python. https://www.kdnuggets.com/2017/06/7-steps-mastering-data-preparation-python.html
    8. Introduction of Web crawling in Python: http://www-rohan.sdsu.edu/~gawron/python_for_ss/course_core/book_draft/web/web_intro.html
    9. MongoDB and python:
      1. https://realpython.com/blog/python/introduction-to-mongodb-and-python/
      2. http://api.mongodb.com/python/current/tutorial.html
    10. Top 7 Tips for the Model in Android Architectures. https://futurice.com/blog/top-7-tips-for-the-model-in-android-architectures
    11. DataQuest – Pythons Basics. https://www.dataquest.io/m/1/python-basics
      1. login with tabt
Programming – Python & R

Network administration

  1. Objectives:
    1. Availability
    2. Confidential
  2. Techniques
  3. Best practices
  4. Tools
    1. Total Network monitor: https://www.softinventive.com/total-network-monitor/
      1. Self comments: Good in ping test and signals, but bugs in setting email alert and detecting error;
    2. Advanced host monitorhttps://www.ks-soft.net/hostmon.eng/
    3. https://www.paessler.com/ping-monitoring
    4. 13 free network monitoring tools for IT Pro: https://community.spiceworks.com/topic/1923309-13-free-network-monitoring-tools-for-it-pros?utm_medium=house&utm_source=spiceworks&utm_campaign=native
Network administration

Learning Git for version control

  1. Objectives
    1. Apply Git in CY or future work
    2. Getting to know the foundation git commands
  2. Contents (Learn Git in 30 Minutes, http://tutorialzine.com/2016/06/learn-git-in-30-minutes/)
    1. The basics
      1. Install Git
        1. Git for Windows
        2. GUI client for absolute beginner, such as GitHub Desktop and Sourcetree;
      2. Configure Git
        1. Open terminal and run (make a stamp for changes tracing):
          1. $ git config –global user.name “My Name”
            $ git config –global user.email myEmail@example.com
      3. Creating a new repository – git init
        1. git init –  create a hidden .git directory where the repository history and configuration will be stored;
      4. Checking the status – git status
      5. Staging – git add
      6. Commiting – git commit
    2. Remote repositories
    3. Branches
    4. Advanced
  1. References
    1. http://learngitbranching.js.org/
    2. https://try.github.io/levels/1/challenges/1
    3. https://www.codecademy.com/courses/learn-git/lessons/git-workflow/exercises/hello-git?action=lesson_resume#
    4. https://www.git-tower.com/learn/
    5. https://www.atlassian.com/git
    6. https://www.codeschool.com/courses/git-real
    7. https://www.visualstudio.com/learn-git/?rr=https%3A%2F%2Fwww.google.com.hk%2F
    8. Systematic 課程內容: http://www.systematic.com.hk/git.htm?id=14
Learning Git for version control

Study Log – API

  1. Objectives
    1. Create own first API for CY and MJ
    2. Learn, share and tech API programming
    3. Concern API quality and security
  2. Javascript
  3. Python
  4. Facebook
  5. Wechart
  6. Google map
  7. Linux
  8. References
    1. Introduction to APIs. https://zapier.com/learn/apis/chapter-1-introduction-to-apis/
    2. API tutorials for beginners. https://cloudrail.com/api-tutorial-for-beginners/
    3. Practical API Design: Confessions of a Java Framework Architect
    4. https://wiki.python.org/moin/BeginnersGuide
    5. Codecademy, https://www.codecademy.com/blog/52
    6. What is a API? https://www.quora.com/What-is-an-API-4
    7. AIP University. https://www.programmableweb.com/api-university/what-are-apis-and-how-do-they-work
Study Log – API