SQL for Data Science - Level II

Go to main | Course Page

Section 1: Testing the Setup

  1. Import necessary libraries and create sample data
  2. Download Resources
  3. SQL Null values

Section 2: Self-Assessment Test

  1. Instructions
  2. Questions
  3. Solutions

Section 3: Operators Part - 1

  1. Logical Operators SQL And, Or, Not
  2. SQL mini and max
  3. SQL, count, avg, Sum and group by Index
  4. SQL Like and Wildcards
  5. SQL IN and Between
  6. Course Review
  7. SQL Exists
  8. SQL Aliases
  9. SQL Case statements
  10. SQL Operators

Section 4: Self-Assessment Test

  1. Exercise Set 2
  2. Hard Questions

Section 5: String Operations

  1. Concentration
  2. Substring
  3. How to separate First name and Last name?
  4. Length or Len
  5. Lower and Upper
  6. Trimming Text
  7. Replace Occurrence

Section 6: Self-Assessment Test

  1. Exercise Set 3
Report abuse