watching now
283 Students

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

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

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.

About the Instructor

Reviews 301
Students 165,914
Massive audience
Courses 16

This course was created by the in-house BitDegree course creators. This means that more than one person has worked to make this course available for you to learn from. This allows the courses to be fun, visually appealing, educational and functional all at the same time. BitDegree is combining the efforts of multiple experts to bring you the highest quality educational material.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo