Monthly Subscription Starting at AED 99 + VAT

SQL Tutorial
  • Level Foundation
  • Duration 19 hours
  • Course by W3Schools
  • Offered by

About

One of the most in-demand developer skills in todays market! Knowing how to use SQL will give you the ability to work with large amounts of data stored in databases. By knowing SQL, you get the ability to extract meaningful insights, analyze data and make data-driven decisions. The course is self-paced with text based modules, practical interactive examples and exercises to check your understanding as you progress. W3schools is the world's largest web developer learning site. Start learning with our proven tutorials used by millions of learners!

Modules

Introduction to SQL

    • 1 Plugin
Show info about module content

SQL Syntax

    • 1 Plugin
Show info about module content

SQL SELECT

    • 1 Plugin
Show info about module content

SQL SELECT DISTINCT Statement

    • 2 Plugin
Show info about module content

SQL WHERE Clause

    • 1 Plugin
Show info about module content

SQL AND, OR and NOT Operators

    • 1 Plugin
Show info about module content

SQL Where - Exercises

    • 1 Plugin
Show info about module content

SQL ORDER BY Keyword

    • 1 Plugin
Show info about module content

SQL Order By - Exercises

    • 1 Plugin
Show info about module content

SQL INSERT INTO Statement

    • 2 Plugin
Show info about module content

SQL NULL Values

    • 2 Plugin
Show info about module content

SQL UPDATE Statement

    • 2 Plugin
Show info about module content

SQL DELETE Statement

    • 2 Plugin
Show info about module content

SQL TOP, LIMIT or ROWNUM Clause

    • 1 Plugin
Show info about module content

SQL MIN() and MAX() Functions

    • 1 Plugin
Show info about module content

SQL COUNT(), AVG() and SUM() Functions

    • 1 Plugin
Show info about module content

SQL Functions - Exercises

    • 1 Plugin
Show info about module content

SQL LIKE Operator

    • 2 Plugin
Show info about module content

SQL Wildcards

    • 2 Plugin
Show info about module content

SQL IN Operator

    • 2 Plugin
Show info about module content

SQL BETWEEN Operator

    • 2 Plugin
Show info about module content

SQL Aliases

    • 2 Plugin
Show info about module content

SQL Joins

    • 1 Plugin
Show info about module content

SQL INNER JOIN Keyword

    • 1 Plugin
Show info about module content

SQL LEFT JOIN Keyword

    • 1 Plugin
Show info about module content

SQL RIGHT JOIN Keyword

    • 1 Plugin
Show info about module content

SQL FULL OUTER JOIN Keyword

    • 1 Plugin
Show info about module content

SQL Self JOIN

    • 1 Plugin
Show info about module content

5. SQL Joins - Exercises

    • 1 Plugin
Show info about module content

SQL UNION Operator

    • 1 Plugin
Show info about module content

SQL GROUP BY Statement

    • 2 Plugin
Show info about module content

SQL HAVING Clause

    • 1 Plugin
Show info about module content

SQL EXISTS Operator

    • 1 Plugin
Show info about module content

SQL ANY and ALL Operators

    • 1 Plugin
Show info about module content

SQL SELECT INTO Statement

    • 1 Plugin
Show info about module content

SQL INSERT INTO SELECT Statement

    • 1 Plugin
Show info about module content

SQL CASE Statement

    • 1 Plugin
Show info about module content

SQL NULL Functions

    • 1 Plugin
Show info about module content

SQL Stored Procedures for SQL Server

    • 1 Plugin
Show info about module content

SQL Comments

    • 1 Plugin
Show info about module content

SQL Operators

    • 1 Plugin
Show info about module content

SQL Create DB

    • 1 Plugin
Show info about module content

SQL Drop DATABASE

    • 1 Plugin
Show info about module content

SQL Backup DB

    • 1 Plugin
Show info about module content

SQL Create Table

    • 1 Plugin
Show info about module content

SQL Drop Table

    • 1 Plugin
Show info about module content

SQL Alter Table

    • 1 Plugin
Show info about module content

SQL Constraints

    • 1 Plugin
Show info about module content

SQL Not Null Constraint

    • 1 Plugin
Show info about module content

SQL Unique Constraint

    • 1 Plugin
Show info about module content

SQL Primary Key Constraint

    • 1 Plugin
Show info about module content

SQL Foreign Key Constraint

    • 1 Plugin
Show info about module content

SQL Check Constraint

    • 1 Plugin
Show info about module content

SQL Default Constraint

    • 1 Plugin
Show info about module content

SQL Create Index Statement

    • 1 Plugin
Show info about module content

SQL Auto Increment Field

    • 1 Plugin
Show info about module content

SQL Working With Dates

    • 1 Plugin
Show info about module content

SQL Views

    • 1 Plugin
Show info about module content

SQL Injection

    • 1 Plugin
Show info about module content

SQL Hosting

    • 1 Plugin
Show info about module content

SQL Data Types for MySQL, SQL Server, and MS Access

    • 1 Plugin
Show info about module content

SQL Database - Exercises

    • 1 Plugin
Show info about module content

Final Assessment Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Assessment Quiz - SQL Tutorial

Auto Summary

Master SQL, one of the most sought-after skills in IT and Computer Science, with this comprehensive tutorial. Offered by Coursera and created by W3schools, this foundational course features self-paced text modules, practical examples, and exercises. Perfect for beginners aiming to analyze data and make data-driven decisions. Available with Starter and Professional subscription options. Dive into the world of databases and enhance your data handling capabilities!

W3Schools
Instructor

W3Schools