SQL for Data Science - Level II
Go to main | Course Page
Section 1: Testing the Setup
- Import necessary libraries and create sample data
- Download Resources
- SQL Null values
Section 2: Self-Assessment Test
- Instructions
- Questions
- Solutions
Section 3: Operators Part - 1
- Logical Operators SQL And, Or, Not
- SQL mini and max
- SQL, count, avg, Sum and group by Index
- SQL Like and Wildcards
- SQL IN and Between
- Course Review
- SQL Exists
- SQL Aliases
- SQL Case statements
- SQL Operators
Section 4: Self-Assessment Test
- Exercise Set 2
- Hard Questions
Section 5: String Operations
- Concentration
- Substring
- How to separate First name and Last name?
- Length or Len
- Lower and Upper
- Trimming Text
- Replace Occurrence
Section 6: Self-Assessment Test
- Exercise Set 3