watching now
282 students

Course Details

Skill level

Beginner

Certificate

Available

RESERVE - Only minutes left for your FREE certificate!

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
  • 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
  • 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
  • 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

Reviews 134
Students 134,343
Massive audience
Courses 14

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 highest quality educational material