It’s Festive Season! Enjoy 30% Off

Use code FESTIVE30 at checkout
watching now
271 Students

What Will You 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 315
Students 173,732
Massive audience
Courses 16

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!