DEV Community: Prashant Gyawali The latest articles on DEV Community by Prashant Gyawali (@prashantcod). https://dev.to/prashantcod https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2792682%2F3e198f3a-e316-4946-af62-65c568c6ca2f.jpg DEV Community: Prashant Gyawali https://dev.to/prashantcod en DAY 02: PYTHON PROGRAMMING (2/20/2025) Prashant Gyawali Thu, 20 Feb 2025 17:16:06 +0000 https://dev.to/prashantcod/day-02-python-programming-2202025-3n48 https://dev.to/prashantcod/day-02-python-programming-2202025-3n48 <p>—&gt; Interactive mode in Python </p> <p>—&gt;Integer(int)</p> <p>—&gt; Float </p> <p>—&gt;ROUND THE FLOATING POINT VALUE </p> <p>—&gt;Function (def) </p> <p>—&gt;Using <code>main()</code> to sort the functions as you like </p> <p>—&gt;Scope </p> <p>—&gt;Return</p> python 100daysofcode github programming DAY 01: PYTHON PROGRAMMING Prashant Gyawali Wed, 19 Feb 2025 17:04:20 +0000 https://dev.to/prashantcod/day-01-pyhton-programming-1eli https://dev.to/prashantcod/day-01-pyhton-programming-1eli <h1> DAY 01: PYTHON INTRODUCTION (2/19/2025) </h1> <p>-VARIABLES</p> <p>-FUNCTIONS (Arguments , Bugs , User Input)</p> <p>-Use of print() and modification of it. </p> <p>-<strong>Strip and capitalize function in python</strong></p> python coding 100daysofcode programming DAY 02: More SELECT keywords and WHERE Clause In SQL Prashant Gyawali Thu, 30 Jan 2025 16:29:55 +0000 https://dev.to/prashantcod/day-02-more-select-keywords-and-where-clause-in-sql-308i https://dev.to/prashantcod/day-02-more-select-keywords-and-where-clause-in-sql-308i <ul> <li>NULL (use by IS NULL or IS NOT NULL) </li> <li>LIKE operators( % or _ )(not case sensitive) -Relational Operators(&lt; &gt; &lt;= &gt;= ) </li> <li>BETWEEN AND keyword </li> <li>ORDER BY ( ASC OR DESC -Aggregate Functions(COUNT, AVG,SUM,MAX, MIN ) --&gt;** </li> </ul> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>Relational Databases in SQL </code></pre> </div> <p>** <br> -One to One relationships<br> -One to Many relationships<br> -Many to Many relationships</p> <ul> <li>ER Diagram (Crow's foot notation) -KEYS ( PRIMARY KEY AND FOREIGN KEY)</li> </ul> sql Day-01: Introduction to SQL - database -DataBase Management System(DBMS) -SQL(Structured Query Language) -SELECT keyword -LIMIT keyword -WHERE keyword -NOT keyword -LOGICAL OPERATORS(AND OR () ) Prashant Gyawali Thu, 30 Jan 2025 16:27:23 +0000 https://dev.to/prashantcod/day-01-introduction-to-sql-database-database-management-systemdbms-sqlstructured-query-4l70 https://dev.to/prashantcod/day-01-introduction-to-sql-database-database-management-systemdbms-sqlstructured-query-4l70 sql database