Not sure which skill to learn? Take a Career Quiz & find out!

BitDegree’s Choice

+100 XP + Certificate

Interactive SQL Tutorial: Learn SQL Commands and Practice SQL Online

Name: Interactive SQL Tutorial: Learn SQL Commands and Practice SQL Online
Price: 9.99 USD

Interactive SQL tutorial: learn what is SQL & SQL data types

4.4 (ratings 110) | students enrolled 20,167

BitDegree Foundation VSI ©

English

$9.99 $16.65

Limited time offer. Exclusive sales price!

Start Learning Now

SecurePayment

3 other students just bought this course!

watching now

283 Students

Beginner

Certificate Available

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

Data Is Key

Data should be the driving factor of any business. You need to collect data and efficiently search through it to make any strategy, operation or marketing decision. There are loads of companies that use large databases. Hence, understanding how to interact with databases is a very employable skill to have if you are looking to start your career as a data scientist or analyst.

The SQL Tutorial You Need

This SQL tutorial is the perfect tool for any beginner looking to learn SQL. What is SQL? In short, it is a programming language that is used for database interaction and manipulation. By starting this SQL tutorial you will be able to learn how to collect data and store it in a database. Moreover, what features you will need to consider if you plan to implement efficient data collection. This course mixes practice, theory and visual representation to provide you with the best educational experience possible. Practice SQL online without any danger of losing your data.

Manage Data With Ease

Learn SQL commands by executing the most useful queries and table aggregation statements by practicing real-time. By the end of this SQL tutorial, you will have a clear understanding of how databases work and how different SQL queries interact with your data. This SQL tutorial goes over all of the most popular SQL commands to teach you every tool you will need for your next project using SQL. What are you waiting for? Enroll and learn SQL!

Show More Show Less

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

BitDegree Foundation VSI ©

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.