Loading...

SQL Fundamentals: Query, Maintain, and Define Databases from Scratch is a self-paced intermediate-level technology online course on GreyAcademy, taught by Karan Mehta. It has 6 modules and 24 chapters, and it takes about 12 hours to complete. Enrol once and learn at your own pace. You get a completion certificate when you finish all the lessons.
Topics covered: What's a Relational Database? Tables, Columns, and Rows, Your First SELECT: Fetch All Columns and Rows, Pick and Choose: Selecting Specific Columns, Filter Rows with WHERE and Sort with ORDER BY, Pattern Matching with LIKE: Find Names Containing 'esh', Range and Set Filters: BETWEEN, IN, and IS NULL, Combining Conditions: AND, OR, and NOT, Operator Precedence and Negation – Avoid Common Mistakes, Arithmetic Expressions and Column Aliases: Calculate Discounts, String Expressions: Concatenate Names and Formats, Aggregate Functions: COUNT, SUM, AVG, MAX, MIN, Grouping with GROUP BY and Filtering Groups with HAVING and more.
Not sure where to start? Compare this with other online courses or follow a career roadmap.
Start with the simplest SQL commands. You'll learn what a relational database is, how to select all or specific columns and rows, sort results, and remove duplicates. By the end, you'll be able to explore any table like a pro.

SQL Fundamentals: Query, Maintain, and Define Databases from Scratch is a intermediate-level technology course covering What's a Relational Database? Tables, Columns, and Rows, Your First SELECT: Fetch All Columns and Rows, Pick and Choose: Selecting Specific Columns, taught through short self-paced lessons on GreyAcademy.
SQL Fundamentals: Query, Maintain, and Define Databases from Scratch is a paid course on GreyAcademy. Enrol once and get lifetime access to all lessons.
Yes. Once you complete all lessons (and pass any required assessments) in SQL Fundamentals: Query, Maintain, and Define Databases from Scratch, you can download a verified GreyAcademy certificate with a unique verification code.
Yes, SQL Fundamentals: Query, Maintain, and Define Databases from Scratch is fully self-paced. You can pause, rewind, and revisit any lesson as many times as you need, on any device.
SQL Fundamentals: Query, Maintain, and Define Databases from Scratch is a intermediate-level course. Check the course level above to see if it matches your current experience.
SQL Fundamentals: Query, Maintain, and Define Databases from Scratch takes approximately 12 hours to complete, spread across 24 lessons at your own pace.
Go beyond basic WHERE. Master operators like LIKE, BETWEEN, IN, IS NULL, and combine conditions with AND/OR. Understand precedence and negation. You'll write precise queries that get exactly the data you need.
Transform data on the fly using arithmetic, string operations, and column aliases. Then learn aggregate functions (COUNT, SUM, AVG, MAX, MIN) and grouping with GROUP BY. You'll answer business questions like 'What is the average order value per city?'
Real databases have many related tables. Learn to combine them using JOINs (INNER, LEFT, RIGHT, FULL), table aliases, and UNION. By the end, you'll be able to answer questions like 'Which customers placed orders in the last month?' by joining Customers and Orders.
Learn to embed one query inside another (subqueries) for powerful filtering. Then switch to data maintenance: INSERT, UPDATE, DELETE with transactions for safety. You'll handle real-world scenarios like updating a customer's address or deleting old records.
Move from user to designer. Learn to create tables with proper data types, enforce rules with constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL), speed up queries with indexes, and simplify complex queries with views. You'll design a small database from scratch.
Admin User
All prices include a 18% platform fee