Free course · Programming
SQL Fundamentals
The language every database speaks. Named by 8 of the 100 employers we researched — banks, software houses and BPOs alike — and the single most transferable technical skill on that list.
6lessons
13quiz questions
6exercises
1graded lab
Watch the course walkthrough
اردو
That was a one-minute preview. The full course video is for signed-in learners. Sign in to watch it here — or create a free BvLogic ID; it takes a minute, and this course is added to it.
What you'll be able to do
- Understand tables, rows and columns, and why one query language shows up in eight different job descriptions.
- Read and write queries that choose columns, filter rows with WHERE, and sort with ORDER BY.
- Turn thousands of rows into the one-line summaries that offices actually run on.
- Combine tables with JOIN, and understand why the database was split into tables in the first place.
- Change data safely: add rows, edit rows, remove rows, and never run an unbounded UPDATE again.
- Install a practice environment, know how each role uses SQL day to day, and leave with a 30-day practice plan.
When you want the whole trade
Data Analytics
Data Analytics
This free course is the introduction. The programme is taught by a trainer, marked by the academy, and carries the syllabus in full — the part an employer asks about.
See the full syllabus and feeCourse content
- 1 What a database is, and why SQL has not died in 50 years Understand tables, rows and columns, and why one query language shows up in eight different job descriptions.
- 2 SELECT: asking your first questions Read and write queries that choose columns, filter rows with WHERE, and sort with ORDER BY. Sign in to open
- 3 COUNT, SUM and GROUP BY: from rows to answers Turn thousands of rows into the one-line summaries that offices actually run on. Sign in to open
- 4 JOIN: the question that spans two tables Combine tables with JOIN, and understand why the database was split into tables in the first place. Sign in to open
- 5 INSERT, UPDATE, DELETE — and the WHERE clause that saves your job Change data safely: add rows, edit rows, remove rows, and never run an unbounded UPDATE again. Sign in to open
- 6 SQL in real jobs — and your practice setup Install a practice environment, know how each role uses SQL day to day, and leave with a 30-day practice plan. Sign in to open
Course lab
Graded lab The academy database, built and queried Open the lab →Related free courses
- Advanced SQL · Urdu video
- APIs · Urdu video
- Automation · Urdu video
- C# and .NET Basics · Urdu video
- Git and GitHub Basics · Urdu video
- JavaScript Basics · Urdu video