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/
Advertisements
Study Log – OCP – MySQL

Programming – Python

  1. Objectives
    1. Modify scikit-learn for Machine learning
    2. Building and using own web crawler
    3. Linux system administration
  2. Contents
  3. References:
    1. Introduction of Web crawling in Python: http://www-rohan.sdsu.edu/~gawron/python_for_ss/course_core/book_draft/web/web_intro.html
    2. MongoDB and python:
      1. https://realpython.com/blog/python/introduction-to-mongodb-and-python/
      2. http://api.mongodb.com/python/current/tutorial.html
Programming – Python

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
Study Log – API