CodeFriends
Courses
Demo
Projects
Pricing
More
Materials
Beginner
3 Chapters  ·  31 Lessons

Introduction to SQL

This chapter provides an overview of SQL, covering basic concepts and foundational knowledge necessary for understanding SQL queries and database interactions.

My Courses

Chapter 1
Master the basics of SQL and databases.
‌
Lessons
‌
  • What is SQL?
    ‌
  • Databases and Tables
    ‌
  • Introduction to SELECT
    ‌
  • Filtering with WHERE
    ‌
  • Multiple-choice quiz
    ‌
  • Comparison Operators
    ‌
  • Logical Operators
    ‌
  • ORDER BY and LIMIT
    ‌
  • DISTINCT and Aliases
    ‌
  • Fill-in-the-blank quiz
    ‌
  • Chapter 2
    Learn how to insert, update, and delete data in a database.
    ‌
    Lessons
    ‌
  • INSERT INTO
    ‌
  • UPDATE
    ‌
  • DELETE
    ‌
  • Data Types
    ‌
  • NULL and NOT NULL
    ‌
  • Multiple-choice quiz
    ‌
  • Primary Keys
    ‌
  • Unique and Default Constraints
    ‌
  • Altering Tables
    ‌
  • Column Naming & Conventions
    ‌
  • Fill-in-the-blank quiz
    ‌
  • Chapter 3
    Count, sum, and average data in a database.
    ‌
    Lessons
    ‌
  • Aggregation Intro
    ‌
  • COUNT and SUM
    ‌
  • AVG, MAX, MIN
    ‌
  • GROUP BY
    ‌
  • HAVING Clause
    ‌
  • Multiple-choice quiz
    ‌
  • WHERE vs HAVING
    ‌
  • Nested Aggregates and DISTINCT
    ‌
  • Result Formatting and Aliases
    ‌
  • Fill-in-the-blank quiz
    ‌
  • CodeFriends
    About Us
    Demo
    Blog
    Services
    Courses
    Projects
    Resources
    Feed
    Info
    Membership
    For Institutions
    Customer Center
    Privacy Policy
    Welcome
    Geek Haus
    TutorFlow
    Made by Geek Haus

    Geek Haus LLC | USA | contact@codefriends.net

    Learn. Practice. Win.