× Course
Exams
Services
Student Certificates
Leaders Board
Feedback
Dedicated
Login
Courses Exams Services Student Certificates Leaders Board Feedback Dedicated Login

SQL Basics

Course Image

This course provides an introduction to SQL (Structured Query Language), the standard language for relational database management and data manipulation. Designed for beginners, it covers the basics of SQL including selecting data, inserting, updating, and deleting records, as well as creating and modifying tables. Students will learn how to use SQL to efficiently query and manipulate data, gaining the skills necessary to manage databases and perform data analysis. By the end of this course, participants will have a solid understanding of SQL fundamentals, ready to explore more complex database concepts.

Introduction to SQL

SQL Lesson 1: SELECT queries 101

SQL Lesson 2: Queries with constraints (Pt. 1)

SQL Lesson 3: Queries with constraints (Pt. 2)

SQL Lesson 4: Filtering and sorting Query results

SQL-Lesson-5 Review: Simple SELECT Queries

SQL Lesson 6: Multi-table queries with JOINs

SQL Lesson 7: OUTER JOINs

SQL Lesson 8: A short note on NULLs

SQL Lesson 9: Queries with expressions

SQL Lesson 10: Queries with aggregates (Pt. 1)

SQL Lesson 11: Queries with aggregates (Pt. 2)

SQL Lesson 12: Order of execution of a Query

SQL Lesson 13: Inserting rows

SQL Lesson 14: Updating rows

SQL Lesson 15: Deleting rows

SQL Lesson 16: Creating tables

SQL Lesson 17: Altering tables

SQL Lesson 18: Dropping tables