OliveiraRyan/60DaysOfDataScience

60 Days Of Data Science

Current day: 7

Days missed: 3

0. Understand Data Science Interviews
   • Interview process
   • Sample Questions
1. Reviewing CSC343 - Part 1
   • Integrity Constraints
   • Keys (superkey, candidate, primary, foreign)
   • Entity Relationship (ER) Diagrams
2. Reviewing CSC343 - Part 2
   • Data Definition Language (DDL)
   • Data Manipulation Language (DML)
3. Reviewing CSC343 - Part 3
   • Aggregation
   • Joins
   • Triggers
4. Reviewing conditional probability:
   • Stats Review Sheet
   • Statsquest vid
5. Reviewing CSC343 - Part 4
   • Relational Algebra (RA)
   • Views and Indexes
6. Reviewing Bayes Theorem
   • Stats Review Sheet
   • Statsquest Bayes' THeorem

Goals:

• 1 sql practice question a day

Topics I want to touch on:

• Review CSC343
  • Reviewing CSC343 - Part 5
    • Relational DB Design Theory
    • Transactions and Concurrency Control
• Brush up on SQL
• Product-sense
• Quantitative statistical/probability concepts review
  • Bayes Theorem
  • Confidence Interval
  • Hypothesis Testing
  • P-Value
  • Basic Distributions (i.e. Bernoulli, Binomial, Normal)
  • Naive Bayes
• Review NN and ML
  • Redo/revive past projects
• Data cleaning
• Web scraping
• Big data