Introduction to SQL & Algorithms with Python 

 

Day 1

  • Understand database language: SQL
  • Familiar with commonly used SQL statements, clauses, functions and keywords: SELECT DISTINCT, WHERE, GROUP BY, ORDER BY, INNER JOIN, LEFT JOIN, MIN, MAX, COUNT, SUM, AVG
  • SQL in Python environment
  • Python overview and Python community introduction
  • Working with numbers in Python
  • Using Loops to automate repeat code
  • Creating functions with Python

Day 2

  • Introduction to basic algorithms with Python:
    • Sorting
    • Searching
    • Cryptography
  • Optimization with Newton’s Method in Python
  • AI Concepts: problem solving as searching
  • 10 popular algorithms used in data science for big data

 

Target Participants: 

IT professionals, data analysts or data science passionate learners with solid programming background and would like to have a refresh view on emerging programming languages in big data domain. Students with science background or good at mathematics are encouraged for this introductory course. 

Remarks:

  • The course will be conducted in Cantonese with course materials in English
  • A certificate will be presented to the students with 100% attendance rate
  • The students are required to bring along with their own notebooks for the classwork sessions

Enquiry: email to education@radicasys.com or call +852 3188 7416

Supporting Organizer: Data Studio @ Hong Kong Science Park

Trainer

Brain Tsang is Data Analytics Consultant at Radica. He is an active data scientist on Kaggle, a global crowdsourcing platform for predictive modeling and joined the big data analytics competition since 2010 with high ranking record. He has over 5 years of professional training experience on course content design and development for subjects in Information, Communications and Technology.