Course Details
Skill Level
Beginner
Certificate
Available
What You Will Learn?
- The basics of coding in SQL
- How to write commands and queries
- Data types, tables and the rest of the core concepts of SQL
Description
Requirements
- No pre-knowledge is required - enthusiasm is all you need!
- A PC or Mac is required. Mobile not supported yet;
- No special software is required in advance of the course.
Curriculum
Section 1: Manipulation
- Lecture 1: Introduction
- Lecture 2: Relational Databases
- Lecture 3: Statements & creating tables
- Lecture 4: Insert
- Lecture 5: Select
- Lecture 6: Alter
- Lecture 7: Update
- Lecture 8: Delete
- Lecture 9: Constraints
- Lecture 10: Summary
Section 2: Queries
- Lecture 1: Intro
- Lecture 2: Select
- Lecture 3: Aliases
- Lecture 4: Distinct
- Lecture 5: Where
- Lecture 6: Like I
- Lecture 7: Like II
- Lecture 8: Is Null
- Lecture 9: Between
- Lecture 10: And
- Lecture 11: Or
- Lecture 12: Order By
- Lecture 13: Limit
- Lecture 14: Case
- Lecture 15: Summary
Section 3: Aggregate functions
- Lecture 1: Intro
- Lecture 2: Count
- Lecture 3: Sum
- Lecture 4: Min and Max
- Lecture 5: Average
- Lecture 6: Round
- Lecture 7: Group By (Part 1)
- Lecture 8: Group By (Part 2)
- Lecture 9: Having
- Lecture 10: Summary
Section 4: Multiple tables
- Lecture 1: Intro
- Lecture 2: Combining Tables Manually
- Lecture 3: Combining Tables
- Lecture 4: Inner Join
- Lecture 5: Left Join
- Lecture 6: Primary Key vs Foreign Key
- Lecture 7: Cross Join
- Lecture 8: Union
- Lecture 9: With
- Lecture 10: Summary
