Self-Paced Online

The SQL Programming Essentials

The SQL Programming Essentials: a self-paced PACI course with 53 lessons in 9 sections and a quiz after each section.

AI & Data Science
English language
Beginner

What you’ll learn

Section. 1 Introduction and installation
Section. 2 The Basic of SQL Programming
Section. 3 SQL Operations and Data
Section. 4 Ordering and limitations
Section. 5 Powerful Functions and Aggregation
Section. 6 Playing with DB tables and constraints

About this course

The SQL Programming Essentials is a self-paced recorded course from the Punjab Artificial Intelligence and Cybersecurity Initiative (PACI). It has 53 lessons in 9 sections (49 video lessons, 1 quizzes, 3 reading / resource lessons). What the course covers: - Section. 1 Introduction and installation - Section. 2 The Basic of SQL Programming - Section. 3 SQL Operations and Data - Section. 4 Ordering and limitations - Section. 5 Powerful Functions and Aggregation - Section. 6 Playing with DB tables and constraints - Section. 7 Working with and combining multiple tables - Section. 8 Temporary names and conditions - Section. 9 Exercise Apply the SQL Concepts

Course content

9 modules · 53 lessons

01Section. 1 Introduction and installation4 lessons

1. Introduction to course
2. SQL quick intro
3. Installing the working environment DB Manager
Quiz

02Section. 2 The Basic of SQL Programming18 lessons

4. SQL syntax theory
5. SELECT Statement theory
6. SELECT Statement hands-on
7. SELECT DISTINCT Theory
8. SELECT DISTINCT hands-on
9. WHERE Statement theory
10. WHERE Statement hands-on
11. Count rows theory
12. Count rows hands-on
13. Insert data theory
14. Insert data hands-on
15. NULL OP Theory
16. NULL and Not OP hands-on
17. Updating data records theory
18. Updating data records hands-on
19. Deleting data theory
20. Deleting data hands-on
Exercise files

03Section. 3 SQL Operations and Data9 lessons

21. Operators IN - NOT IN theory
22. Operators - IN and Not IN
23. SQL Logical Operators theory
24. Operators- Logical op hands-on
25. Operators - Arithmetic op hands-on
26. Operators - Comparisons hands-on
27. Operators- SQL BETWEEN and NOT hands-on
28. SQL Data Types
Exercise files

04Section. 4 Ordering and limitations3 lessons

29. Ordering theory
30. Ordering and sorting hands-on
31. LIMIT with condition hands-on

05Section. 5 Powerful Functions and Aggregation4 lessons

32. Smallest and Largest Values hands-on
33. Counting records with different ways hands-on
34. Average of numeric columns hands-on
35. Total sum for numerics hands-on

06Section. 6 Playing with DB tables and constraints8 lessons

36. Create DB and Tables hands-on
37. Deleting newOrders hands-on
38. ALTER ADD OR DELETE fields hands-on
39. Renaming tables hands-on
40. Constraints theory
41. Constraints hands-on
42. Joining tables hands-on
43. Combining result-sets hands-on

07Section. 7 Working with and combining multiple tables2 lessons

44. Joining tables hands-on
45. Combining result-sets hands-on

08Section. 8 Temporary names and conditions2 lessons

46. Power of Aliases hands-on
47. Set conditions hands-on

09Section. 9 Exercise Apply the SQL Concepts3 lessons

48. About the exercise
49. Exercise solution
Exercise files

Your instructor

PACI

Punjab Artificial Intelligence and Cybersecurity Initiative

No reviews yet20 courses on NSDP

PACI (Punjab Artificial Intelligence and Cybersecurity Initiative) publishes recorded courses in artificial intelligence, cybersecurity, web development and data skills.

View full profile

24-hour refund policy

Start learning with confidence.

1
Pay and start
Pay the course fee and open your first lessons on the NSDP Portal.
2
Ask within 24 hours
Not satisfied? Ask for a refund within 24 hours of payment.
3
Get your fee back
Our team confirms your request and refunds the course fee.

The same policy applies to self-paced courses (within 24 hours of payment) and to live Zoom and on-campus classes (within 24 hours of the first class). To ask, contact the NSDP helpline 0304 111 0869, WhatsApp 03484350668 or email support.department@nsdp.pk with your CNIC and PSID / challan number, or type “refund” in the NSDP Rehnuma chat. Requests after 24 hours aren’t eligible. See the cancellation & refund policy.

Student reviews

No reviews yet. Students can share their experience once they have completed at least half of the course.

Record your course on NSDPInstructors wantedCreate a self-paced course once, reach learners across Pakistan and abroad, and earn on every enrolment.Become an instructor

Students also explore

Self-Paced OnlineAdmissions open

AI & Data Science · English · Beginner

Pandas Bootcamp for Data Analysis

Pandas Bootcamp for Data Analysis: a self-paced PACI course with 140 lessons in 16 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

AI & Data Science · English · Beginner

Master Power BI Desktop for data analysis

Master Power BI Desktop for data analysis: a self-paced PACI course with 75 lessons in 8 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

Machine Learning · English · Beginner

Machine Learning Classification Bootcamp

Machine Learning Classification Bootcamp: a self-paced PACI course with 88 lessons in 11 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month

Self-Paced OnlineAdmissions open

Machine Learning · English · Beginner

Machine Learning Regression Masterclass

Machine Learning Regression Masterclass: a self-paced PACI course with 81 lessons in 11 sections and a quiz after each section.

New

6 months course

PPACIPKR 1,000 / month