The SQL Programming Essentials | NSDP Learning Portal

Home Courses Bundles Live Sessions About Contact

National Skills Development Program

Website menu

Home Courses Bundles Live Sessions About Contact

National Skills Development Program

National Skills Development Program — Empowering Pakistan's Freelancers with Digital Skills.

Navigation

Courses Bundles Live Sessions Contact

Contact

Contact details can be added from theme settings.

Powered learning website

Courses

/ data-science

/ beginner

The SQL Programming Essentials

Name: The SQL Programming Essentials
Price: 6000 PKR
Availability: InStock

New

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

Created by PACI

Learners

PKR 1,000 / month

Course length: 6 months

24-hour refund: not for you? Ask for your course fee back within 24 hours of payment.

Enroll nowBrowse catalog

English

Access after enrollment

Language

English

Course type

recorded

Level

beginner

Course promise

What you will 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

Explore

Course content

9 sections · 53 lessons

Section. 1 Introduction and installation4 lessons

1. Introduction to course

video

2. SQL quick intro

video

Details

Course description

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

Instructor

Meet your guide

PACI

Punjab Artificial Intelligence and Cybersecurity Initiative

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

More courses by PACI

WordPress Website Development

web-development • beginner

83 lessons

PKR 1,000 / month · 6-month course

SOC Analyst Training

cybersecurity • beginner

90 lessons

PKR 1,000 / month · 6-month course

Python Programming for All Levels

it-software • beginner

137 lessons

PKR 1,000 / month · 6-month course

Course snapshot

Categorydata-science

Levelbeginner

LanguageEnglish

CertificateNot configured

Reviews

Section. 6 Playing with DB tables and constraints

3. Installing the working environment DB Manager

video

Quiz

quiz

Section. 2 The Basic of SQL Programming18 lessons

4. SQL syntax theory

video

5. SELECT Statement theory

video

6. SELECT Statement hands-on

video

7. SELECT DISTINCT Theory

video

8. SELECT DISTINCT hands-on

video

9. WHERE Statement theory

video

10. WHERE Statement hands-on

video

11. Count rows theory

video

12. Count rows hands-on

video

13. Insert data theory

video

14. Insert data hands-on

video

15. NULL OP Theory

video

16. NULL and Not OP hands-on

video

17. Updating data records theory

video

18. Updating data records hands-on

video

19. Deleting data theory

video

20. Deleting data hands-on

video

Exercise files

text

Section. 3 SQL Operations and Data9 lessons

21. Operators IN - NOT IN theory

video

22. Operators - IN and Not IN

video

23. SQL Logical Operators theory

video

24. Operators- Logical op hands-on

video

25. Operators - Arithmetic op hands-on

video

26. Operators - Comparisons hands-on

video

27. Operators- SQL BETWEEN and NOT hands-on

video

28. SQL Data Types

video

Exercise files

text

Section. 4 Ordering and limitations3 lessons

29. Ordering theory

video

30. Ordering and sorting hands-on

video

31. LIMIT with condition hands-on

video

Section. 5 Powerful Functions and Aggregation4 lessons

32. Smallest and Largest Values hands-on

video

33. Counting records with different ways hands-on

video

34. Average of numeric columns hands-on

video

35. Total sum for numerics hands-on

video

Section. 6 Playing with DB tables and constraints8 lessons

36. Create DB and Tables hands-on

video

37. Deleting newOrders hands-on

video

38. ALTER ADD OR DELETE fields hands-on

video

39. Renaming tables hands-on

video

40. Constraints theory

video

41. Constraints hands-on

video

42. Joining tables hands-on

video

43. Combining result-sets hands-on

video

Section. 7 Working with and combining multiple tables2 lessons

44. Joining tables hands-on

video

45. Combining result-sets hands-on

video

Section. 8 Temporary names and conditions2 lessons

46. Power of Aliases hands-on

video

47. Set conditions hands-on

video

Section. 9 Exercise Apply the SQL Concepts3 lessons

48. About the exercise

video

49. Exercise solution

video

Exercise files

text

Practical Malware Analysis for Beginners

cybersecurity • beginner

44 lessons

PKR 1,000 / month · 6-month course

Penetration Testing Web Hacking

cybersecurity • beginner

54 lessons

PKR 1,000 / month · 6-month course

Pandas Bootcamp for Data Analysis

data-science • beginner

140 lessons

PKR 1,000 / month · 6-month course

Not yet

Ready when you are

Enroll to unlock lessons, track progress, and continue learning from your student dashboard.

The SQL Programming Essentials

What you will learn

Related topics

Course content

Course description

Meet your guide

PACI

More courses by PACI

WordPress Website Development

SOC Analyst Training

Python Programming for All Levels

Practical Malware Analysis for Beginners

Penetration Testing Web Hacking

Pandas Bootcamp for Data Analysis

Invite someone to this course

Ready when you are