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.
- 6 lessons
- about 15 minutes (estimate)
- Free
- Free BvLogic Certificate of Completion
- Video in اردو
- Exercises in اردو
- 13 quiz questions
- 6 exercises
- 1 graded lab
Earn your free BvLogic Certificate of Completion.
A digital credential issued by BvLogic Academy to recognize successful completion of this introductory learning activity.
Not a government qualification or regulatory certification.
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.
Skills covered
- Data Handling
- MySQL
- SQL
Course 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 · optional practice The academy database, built and queried Open the lab →Data Analytics
Data Analytics
This free course is the introduction to the full Data Analytics programme. 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 feeRelated free courses
- Advanced SQLUrdu video
- APIsUrdu video
- AutomationUrdu video
- Bash and the Command LineUrdu video
- C ProgrammingUrdu video
- C# and .NET BasicsUrdu video
Programming courses in Pakistan · All free courses · Government free courses open now