Database Query using SQL | MySQL Functions | Unit-2 | Informatics Practices  Class 12 |  Term-2 Exam
Channel: DEEPTI SHARMA: Let's Learn Programming
Date: 2022-03-09

Hello Children, this is one shot video. This video covers entire chapter of database query using SQL (IP Class -12 Unit-2). It covers- Math functions , Text functions , Date functions  and Aggregate functions .
Dear Students, below are given links of some useful playlists related to your CBSE Syllabus.(Computer Science , Informatics Practices , Information Technology(402)).
Class XI
SQL  Tutorial (Class XI & XII) Computer Science & Informatics Practices-
https://www.youtube.com/watch?v=onZ_XPSXkgo&list=PLtxBCYcxUluznVsIPOJjseZdNiwjruWdq

Boolean logic  class 11 (Computer Science)-
https://www.youtube.com/watch?v=J5H3wZ24Bk0&list=PLtxBCYcxUluyY1Yf7bIE0DLd-xRgGp2Sp

Basics of Python Programming-
https://www.youtube.com/watch?v=3uupt8APkUE&list=PLtxBCYcxUluyRKCir0S_Se00K5jKOFTKq

Python libraries Installation-
https://www.youtube.com/watch?v=dHOLYXrhwfI&list=PLtxBCYcxUluzrJnYwNrWBWu8LOc6IxK4p

Conditional and Looping Constructs Class 11 (CS & IP)-
https://www.youtube.com/watch?v=d3GLKXtE9KI&list=PLtxBCYcxUluwA78vJTkWe5VKZz6K9yHme

Data Handling using NumPy-
https://www.youtube.com/watch?v=4ZOhEgSxv6A&list=PLtxBCYcxUluwojTMm_T8YYTfNt9LU-QOf

List Manipulation (Lists in python)-
https://www.youtube.com/watch?v=c0pM8SbJz2k&list=PLtxBCYcxUluy1imnuQH9rSOpyZSSV0riF

Dictionary in Python-
https://www.youtube.com/watch?v=2lDZ_QnFr4M&list=PLtxBCYcxUluyNHy2I2j3YiSNhbtFyiTfs

Strings in Python(String Manipulation)
https://www.youtube.com/watch?v=CbnP8E_TioE&list=PLtxBCYcxUluzzEiLh1yQC_SUzI2cKArvl

Tuples in Python
https://www.youtube.com/watch?v=QBTZK2hI8Us&list=PLtxBCYcxUluwAHZqeOX4PuPysoR02HGLq

Database Concepts (IP Class-11)
https://www.youtube.com/watch?v=fHBwez8V9do&list=PLtxBCYcxUluwQqoDJHPlx4oBoc6Qad7UO



Class XII
SQL  Tutorial (Class XI & XII) Computer Science & Informatics Practices-
https://www.youtube.com/watch?v=onZ_XPSXkgo&list=PLtxBCYcxUluznVsIPOJjseZdNiwjruWdq

python mysql connectivity class 12 (Computer Science)-
https://www.youtube.com/watch?v=zq81zUouve8&list=PLtxBCYcxUluxthqC-Sd9Cm08bxK_cMBAL


Data Handling using Pandas class 12 (IP)-
https://www.youtube.com/watch?v=YuKZid96Lcg&list=PLtxBCYcxUluwMvRuw7AiZU6pIYjJ-mrtU


Importing/Exporting Data between CSV files and DataFrame class 12-
https://www.youtube.com/watch?v=-rJ5L43si_I&list=PLtxBCYcxUluy4koOh3jLcFn0Vpm4-z338


Data Visualization class 12 (IP)-
https://www.youtube.com/watch?v=T54Dehq6G0o&list=PLtxBCYcxUluymaJILBISRT5FDQSSWpQRt


IP Sample paper important questions(Class 12)-
https://www.youtube.com/watch?v=76bBTXZLV6k&list=PLtxBCYcxUluzGK6X-Xmhv_TzqzE4ur-63


Most Expected Questions of Informatics Practices (Class 12)-

https://www.youtube.com/watch?v=FSoenDNEXvI&list=PLtxBCYcxUluw_-3Fm8qNGhg84dgcOsc38

Class X
Information Technology (402) Tutorial-
https://www.youtube.com/watch?v=vypN8z6ERyc&list=PLtxBCYcxUluyvKTIefyckuP9z8IFzw7jC