Seize the opportunity to gain new skills and reshape your career!

Choose a free learning path and get valuable insights from first-rate courses
watching now
100 Students
45 Lessons
Beginner

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

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

  • A PC or a Mac (no mobile support yet)
  • An Internet connection

About the Instructor

Reviews 741
Students 291,967
Massive audience
Courses 13

BitDegree Foundation is the team of in-house BitDegree course creators who offers the possibility to learn in a fun and engaging way. Their interactive courses are visually appealing, educational, and functional all at the same time.

Needless to say, more than one person has worked to make these courses available for you to learn from. BitDegree is combining the efforts of multiple experts to bring you the highest quality educational material.

On BitDegree, learning on these interactive courses, you can improve your programming skills. You can find a variety of courses from the basic ones to more advanced level trainings. You can learn such programming languages as Java, JavaScript, Python, HTML, CSS, and others. If you are an absolute beginner and want to find the easiest way to learn coding, these courses are the perfect option for you. So, choose the best course for yourself and deep dive into learning!