watching now
200 Students

Description

What Will You Learn?

  • What SQL fundamentals are and how to use them
  • How to write SQL queries and commands
  • How SQL data types, tables, and other core concepts work

Requirements

  • A PC or a Mac (no mobile support yet)
  • An Internet connection
  • NFT Certificate
  • 45 Lessons
  • Beginner
  • English
  • 4.6 Rating
  • +100 XP

Share Course on Social media

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

About the Instructor

BitDegree Insider is the team of in-house BitDegree course creators who offers the possibility to learn in a fun and engaging way about Web3. Our portfolio consists of video-based courses delivered by Instructor August, who explains difficult Web3 technologies concepts in a casual manner (with a bit of humor!) and uses everything from simple allegories, to appealing animations, to simple Knowledge checks and practical challenges to help you understand various Web3 concepts and put that knowledge into practice.

Needless to say, we are combining the efforts of multiple Web3 experts to bring you the highest quality educational material. Our goal is to be your trusted, credible, and crypto-educated fellow guiding you through the jungle of Web3. You will find a variety of courses from the basic ones to more advanced level, to concrete project courses or reviews.

Whether you are an absolute beginner or on the way of getting industry-ready, BitDegree Insider will be the easiest and most fun way to learn about Web3. Choose the best ones and deep dive into learning!

See All Instructor Courses

Course reviews