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
    Instagram
    Youtube
    Geek Haus
    TutorFlow
    Made by Geek Haus

    Geek Haus LLC | USA | contact@codefriends.net

    Learn. Practice. Win.