<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: priyanka prasad</title>
    <description>The latest articles on DEV Community by priyanka prasad (@priyankaprasad).</description>
    <link>https://dev.to/priyankaprasad</link>
    <image>
      <url>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%2F390400%2Fbe4403d9-077f-47cb-9cfa-677ef540857f.jpeg</url>
      <title>DEV Community: priyanka prasad</title>
      <link>https://dev.to/priyankaprasad</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/priyankaprasad"/>
    <language>en</language>
    <item>
      <title>Launch Your APPS for Free!!!</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Tue, 09 Apr 2024 10:24:43 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/launch-your-apps-for-free-2a05</link>
      <guid>https://dev.to/priyankaprasad/launch-your-apps-for-free-2a05</guid>
      <description>&lt;p&gt;Are you a developer with a passion for creating innovative solutions for India's booming e-commerce industry? If so, we invite you to join at &lt;strong&gt;Shiprocket Appstore Developer Program&lt;/strong&gt;! Our platform offers a unique opportunity for developers to showcase their apps to a targeted audience, collaborate with industry experts and fellow developers, and receive valuable feedback to refine and enhance their creations.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Why Join Us?&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Access to a Thriving Marketplace&lt;/strong&gt;: Shiprocket Appstore provides developers with access to a thriving marketplace specifically tailored for India's Direct-to-Consumer (D2C) ecosystem. With a vast network of merchants.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Showcase Your Apps&lt;/strong&gt;: As a member of our developer program, you'll have the opportunity to showcase your apps to Indian merchants actively seeking solutions to enhance their e-commerce operations. This exposure can significantly boost the visibility and adoption of your creations.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Receive Valuable Feedback&lt;/strong&gt;: We understand the importance of feedback in the development process. By joining our program, you'll receive constructive feedback from merchants and experts, helping you refine and enhance your apps for optimal performance and user experience.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Monetization Opportunity&lt;/strong&gt;: We offer developers the opportunity to monetize their apps through a revenue-sharing model. As your app gains traction and generates revenue, you'll benefit from our partnership.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Special Offer&lt;/strong&gt; : To kickstart your journey with us, we're offering a special promotion of no commission fee for the first three months! Take advantage of this opportunity to launch your apps with minimal financial barriers.&lt;/p&gt;

&lt;p&gt;Ready to Get Started?&lt;/p&gt;

&lt;p&gt;Join us today and become a part of the movement to revolutionize India's e-commerce landscape. Together, we can shape the future of D2C in India and empower merchants with innovative solutions tailored to their needs.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://bit.ly/3UadaN2"&gt;Click here&lt;/a&gt; to sign up for Shiprocket Appstore Developer Program.&lt;/p&gt;

&lt;p&gt;For more information, check out our &lt;a href="https://drive.google.com/file/d/1Lj2TgC7Eq0FKqEb83l73cEbriHd1Q1uK/view"&gt;FAQs&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;*&lt;em&gt;About Shiprocket *&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Shiprocket is a leading logistics and fulfillment platform empowering businesses to grow their e-commerce operations efficiently. With a comprehensive suite of services and a focus on innovation, Shiprocket is committed to driving the success of Indian merchants in the digital era.&lt;/p&gt;

&lt;p&gt;Join us and be a part of the journey at &lt;a href="http://www.shiprocket.in"&gt;www.shiprocket.in&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;Let's revolutionize D2C together!&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Alan Turing</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Fri, 02 Jul 2021 19:31:26 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/alan-turing-2onm</link>
      <guid>https://dev.to/priyankaprasad/alan-turing-2onm</guid>
      <description>&lt;p&gt;Early life and career&lt;br&gt;
The son of a civil servant, Turing was educated at a top private school. He entered the University of Cambridge to study mathematics in 1931. After graduating in 1934, he was elected to a fellowship at King’s College (his college since 1931) in recognition of his research in probability theory. In 1936 Turing’s seminal paper “On Computable Numbers, with an Application to the Entscheidungsproblem [Decision Problem]” was recommended for publication by the American mathematical logician Alonzo Church, who had himself just published a paper that reached the same conclusion as Turing’s, although by a different method. Turing’s method (but not so much Church’s) had profound significance for the emerging science of computing. Later that year Turing moved to Princeton University to study for a Ph.D. in mathematical logic under Church’s direction (completed in 1938).&lt;/p&gt;

&lt;p&gt;The Entscheidungsproblem&lt;br&gt;
What mathematicians called an “effective” method for solving a problem was simply one that could be carried by a human mathematical clerk working by rote. In Turing’s time, those rote-workers were in fact called “computers,” and human computers carried out some aspects of the work later done by electronic computers. The Entscheidungsproblem sought an effective method for solving the fundamental mathematical problem of determining exactly which mathematical statements are provable within a given formal mathematical system and which are not. A method for determining this is called a decision method. In 1936 Turing and Church independently showed that, in general, the Entscheidungsproblem problem has no resolution, proving that no consistent formal system of arithmetic has an effective decision method. In fact, Turing and Church showed that even some purely logical systems, considerably weaker than arithmetic, have no effective decision method. This result and others—notably mathematician-logician Kurt Gödel’s incompleteness results—dashed the hopes, held by some mathematicians, of discovering a formal system that would reduce the whole of mathematics to methods that (human) computers could carry out. It was in the course of his work on the Entscheidungsproblem that Turing invented the universal Turing machine, an abstract computing machine that encapsulates the fundamental logical principles of the digital computer.&lt;/p&gt;

&lt;p&gt;The Church-Turing thesis&lt;br&gt;
An important step in Turing’s argument about the Entscheidungsproblem was the claim, now called the Church-Turing thesis, that everything humanly computable can also be computed by the universal Turing machine. The claim is important because it marks out the limits of human computation. Church in his work used instead the thesis that all human-computable functions are identical to what he called lambda-definable functions (functions on the positive integers whose values can be calculated by a process of repeated substitution). Turing showed in 1936 that Church’s thesis was equivalent to his own, by proving that every lambda-definable function is computable by the universal Turing machine and vice versa. In a review of Turing’s work, Church acknowledged the superiority of Turing’s formulation of the thesis over his own (which made no reference to computing machinery), saying that the concept of computability by a Turing machine “has the advantage of making the identification with effectiveness…evident immediately.”&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Plans for the 2022 Hackathon Season.</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Wed, 30 Jun 2021 19:41:05 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/plans-for-the-2022-hackathon-season-gma</link>
      <guid>https://dev.to/priyankaprasad/plans-for-the-2022-hackathon-season-gma</guid>
      <description>&lt;p&gt;The plan is starting the day and waiting for the MLH to start and CheckIn.&lt;br&gt;
As The Trimmings doesn't match its always the night owl and sleeping in the morning.&lt;br&gt;
Then coming on the challenges always ready to look for the new challenges every day and allocating the timings when to complete which task.&lt;br&gt;
And it all ended with making walk up all the night and doing projects hanging out on server&lt;/p&gt;

</description>
    </item>
    <item>
      <title>All About Google Dorks</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Wed, 13 Jan 2021 17:54:03 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/all-about-google-dorks-4440</link>
      <guid>https://dev.to/priyankaprasad/all-about-google-dorks-4440</guid>
      <description>&lt;h1&gt;
  
  
  LocalHackDay
&lt;/h1&gt;

&lt;p&gt;In this blog, you will get to know about google Dorking and some pro tips which I used to become the author of my own google dork.&lt;br&gt;
What is Google Dorking?&lt;br&gt;
Did you ever get into the situation when you are searching for the term and the result just contradicts the output? So the solution is “Dorking” there are some advanced google searching keywords/queries to find information that is not easily available on the websites &amp;amp; which helps you to get better/exact results which you want.&lt;br&gt;
There is a hell lot of dorks available on GHDB (google hacking database) where you can find much sensitive information. But keep in mind Dorking is just an advanced search method you can’t hack or achieve anything big/great just by Dorking it just comes handy in the information gathering process(recon).&lt;br&gt;
What can Google can do for a hacker?&lt;br&gt;
— Search sensitive information like payroll, SIN, even the personal email box&lt;br&gt;
— Vulnerabilities scanner&lt;br&gt;
— Transparent proxy&lt;br&gt;
Popular dorks&lt;br&gt;
Image for post&lt;br&gt;
Basic Formula of Dork&lt;br&gt;
"inurl:."domain"/"dorks" "&lt;br&gt;
Here,&lt;br&gt;
“inurl” = input URL&lt;br&gt;
“domain” = your desired domain ex. .gov&lt;br&gt;
“dorks” = your dork of your choice&lt;br&gt;
How to publish your own dorks?&lt;br&gt;
when you got your desired google dork take for example — Dork:allintext:password filetype:log&lt;br&gt;
you just need to mail to the &lt;a href="mailto:dorks@offsec.com"&gt;dorks@offsec.com&lt;/a&gt;&lt;br&gt;
with the subject "allintext:password filetype:log" as it is the dork you have mined with author name and description&lt;br&gt;
you won't get any confirmation mail that your dork is published on google hacking database nut yes they publish it within a maximum of 1 day you need to check your name manually if it's published or not.&lt;br&gt;
Image for post&lt;br&gt;
Some measures to take!&lt;br&gt;
Protect Your Data&lt;br&gt;
— Keep patching your systems and applications&lt;br&gt;
— Keep your sensitive data off the Web apply authentication — (RSA, Clienless VPN) — Disable directory browsing&lt;br&gt;
— Consider removing your site from Google’s index: &lt;a href="http://www.google.com/remove.html"&gt;http://www.google.com/remove.html&lt;/a&gt;.&lt;br&gt;
— Use a robots.txt file to against Web crawlers: &lt;a href="http://www.robotstxt.org"&gt;http://www.robotstxt.org&lt;/a&gt;.&lt;br&gt;
Some Pro tips to publish your own!&lt;br&gt;
1 If you want to publish your own dork sometimes the similar search results also have a dork that is useful and isn't in the google hacking database.&lt;/p&gt;

</description>
    </item>
    <item>
      <title>How the internet works ?</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Sat, 06 Jun 2020 09:58:45 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/how-the-internet-works-2k9p</link>
      <guid>https://dev.to/priyankaprasad/how-the-internet-works-2k9p</guid>
      <description>&lt;p&gt;We all use the internet for a multitude of purposes and on a range of devices connected using different technologies. However, this complexity s hidden from us and does not seem to matter, because we can connect to the same services and have a similar experience no matter which device and connection we use.&lt;/p&gt;

&lt;p&gt;Connecting to the internet&lt;br&gt;
The networks you connect to at home, work, or out and about all connect to the internet using another network. This secondary network comes from an internet service provider, or ISP.&lt;/p&gt;

&lt;p&gt;ISPs connect with one another directly or through other networks. Large corporations and telecommunications providers also connect to these networks. The connections might use fibre-optic cables, satellite links, or radio transmissions, and this vast web forms the infrastructure of the internet.&lt;/p&gt;

&lt;p&gt;The internet gives you access to networks hosting thousands of servers. These ‘server farms’ provide services such as email, storage, media streaming, and more.&lt;/p&gt;

&lt;p&gt;Finding the IP address&lt;br&gt;
An app on your smartphone may connect to the internet using a dedicated server, with a fixed IP address. In this case, the app will have the destination IP address built into its software.&lt;/p&gt;

&lt;p&gt;If you’re using a web browser, you can enter the exact URL of the site you want, follow a link on a web page, or use a search engine to find a website.&lt;/p&gt;

&lt;p&gt;Once you have the URL you want, your browser tries to find the IP address belonging with that URL. This is where a domain name server, or DNS, comes in: the browser sends a query to its local DNS asking for the IP address of the URL in question. If the server knows the IP address, it replies with that address. If not, it sends the query on to a DNS server with a more global list of URLs. Eventually, your device will get back the IP address matching the URL.&lt;/p&gt;

&lt;p&gt;Routing the IP packets&lt;br&gt;
Once it has the IP address it needs, your device encapsulates your data in an IP packet with the destination address of the server. The IP packet travels over the network to the first router. But how does the router know where to send the packet next?&lt;/p&gt;

&lt;p&gt;Your home router only knows about the local networks it’s connected to: it only has one default connection to the internet and the ISP.&lt;/p&gt;

&lt;p&gt;More complex routers that your IP packet passes through will use the IP address to identify the network they need to reach. For example, all IP addresses starting 200.11 belong to a large telecom company. Inside the company, routers advertise the networks they know about to neighbouring routers. The neighbours advertise to other neighbouring routers, throughout the whole organisation. This way, the routers know which link to use to send an IP packet to reach any networks within that organisation.&lt;/p&gt;

&lt;p&gt;These large organisations then advertise their summary routes to each other. This dramatically reduces the number of individual networks that each router must learn.&lt;/p&gt;

&lt;p&gt;With this information, each router can quickly send IP packets via the best links on its journey around the globe. Routers can also choose between multiple paths based on speed or bandwidth.&lt;/p&gt;

&lt;p&gt;On the way, the changing links encapsulate the IP packet in a variety of different frames.&lt;/p&gt;

&lt;p&gt;Finally, the IP packet arrives at a router connected to the same LAN as the destination server, and the IP packet will be delivered to that device.&lt;/p&gt;

&lt;p&gt;Servers respond&lt;br&gt;
The server responds, sending data back to the source. This data usually consists of many thousands of bytes, split into a series of fragments. Each fragment is encapsulated in its own IP packet and sent back over the internet.&lt;/p&gt;

&lt;p&gt;This quantity of data could potentially congest the network and cause it to fail. So the returning packets may take different routes back through the network, and may arrive out of sequence.&lt;/p&gt;

&lt;p&gt;The destination device reassembles the packets, decapsulates the data, and passes it to the app or web browser that requested it.&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Cybersecurity</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Sat, 06 Jun 2020 09:08:03 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/cybersecurity-4300</link>
      <guid>https://dev.to/priyankaprasad/cybersecurity-4300</guid>
      <description>&lt;p&gt;Cybersecurity includes the following elements:&lt;br&gt;
Network security&lt;br&gt;
Application security&lt;br&gt;
Endpoint security&lt;br&gt;
Data security&lt;br&gt;
Identity management&lt;br&gt;
Database and infrastructure security&lt;br&gt;
Cloud security&lt;br&gt;
Mobile security&lt;br&gt;
Disaster recovery/business continuity planning&lt;br&gt;
End-user education&lt;/p&gt;

&lt;p&gt;further elements that come under the umbrella of cyber security:&lt;/p&gt;

&lt;p&gt;Trojans and backdoor attacks&lt;br&gt;
Denial of service&lt;br&gt;
Information security&lt;br&gt;
Cybercrime&lt;br&gt;
Intrusion detection&lt;br&gt;
Spyware, &lt;br&gt;
phishing&lt;br&gt;
Viruses,&lt;br&gt;
worms, &lt;br&gt;
man-in-the-middle attacks and passwords&lt;/p&gt;

</description>
      <category>security</category>
      <category>computerscience</category>
    </item>
    <item>
      <title>List of SQL Commands Glossary of commonly used SQL commands.</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Sun, 31 May 2020 17:26:06 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/list-of-sql-commands-glossary-of-commonly-used-sql-commands-4o2j</link>
      <guid>https://dev.to/priyankaprasad/list-of-sql-commands-glossary-of-commonly-used-sql-commands-4o2j</guid>
      <description>&lt;p&gt;Background&lt;br&gt;
SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and it helps maintain the integrity of databases, regardless of size.&lt;/p&gt;

&lt;p&gt;Here’s an appendix of commonly used commands.&lt;/p&gt;

&lt;p&gt;Commands&lt;br&gt;
ALTER TABLE&lt;br&gt;
ALTER TABLE table_name &lt;br&gt;
ADD column_name datatype;&lt;br&gt;
ALTER TABLE lets you add columns to a table in a database.&lt;/p&gt;

&lt;p&gt;AND&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_1 = value_1&lt;br&gt;
  AND column_2 = value_2;&lt;br&gt;
AND is an operator that combines two conditions. Both conditions must be true for the row to be included in the result set.&lt;/p&gt;

&lt;p&gt;AS&lt;br&gt;
SELECT column_name AS 'Alias'&lt;br&gt;
FROM table_name;&lt;br&gt;
AS is a keyword in SQL that allows you to rename a column or table using an alias.&lt;/p&gt;

&lt;p&gt;AVG()&lt;br&gt;
SELECT AVG(column_name)&lt;br&gt;
FROM table_name;&lt;br&gt;
AVG() is an aggregate function that returns the average value for a numeric column.&lt;/p&gt;

&lt;p&gt;BETWEEN&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_name BETWEEN value_1 AND value_2;&lt;br&gt;
The BETWEEN operator is used to filter the result set within a certain range. The values can be numbers, text or dates.&lt;/p&gt;

&lt;p&gt;CASE&lt;br&gt;
SELECT column_name,&lt;br&gt;
  CASE&lt;br&gt;
    WHEN condition THEN 'Result_1'&lt;br&gt;
    WHEN condition THEN 'Result_2'&lt;br&gt;
    ELSE 'Result_3'&lt;br&gt;
  END&lt;br&gt;
FROM table_name;&lt;br&gt;
CASE statements are used to create different outputs (usually in the SELECT statement). It is SQL’s way of handling if-then logic.&lt;/p&gt;

&lt;p&gt;COUNT()&lt;br&gt;
SELECT COUNT(column_name)&lt;br&gt;
FROM table_name;&lt;br&gt;
COUNT() is a function that takes the name of a column as an argument and counts the number of rows where the column is not NULL.&lt;/p&gt;

&lt;p&gt;CREATE TABLE&lt;br&gt;
CREATE TABLE table_name (&lt;br&gt;
  column_1 datatype, &lt;br&gt;
  column_2 datatype, &lt;br&gt;
  column_3 datatype&lt;br&gt;
);&lt;br&gt;
CREATE TABLE creates a new table in the database. It allows you to specify the name of the table and the name of each column in the table.&lt;/p&gt;

&lt;p&gt;DELETE&lt;br&gt;
DELETE FROM table_name&lt;br&gt;
WHERE some_column = some_value;&lt;br&gt;
DELETE statements are used to remove rows from a table.&lt;/p&gt;

&lt;p&gt;GROUP BY&lt;br&gt;
SELECT column_name, COUNT(*)&lt;br&gt;
FROM table_name&lt;br&gt;
GROUP BY column_name;&lt;br&gt;
GROUP BY is a clause in SQL that is only used with aggregate functions. It is used in collaboration with the SELECT statement to arrange identical data into groups.&lt;/p&gt;

&lt;p&gt;HAVING&lt;br&gt;
SELECT column_name, COUNT(&lt;em&gt;)&lt;br&gt;
FROM table_name&lt;br&gt;
GROUP BY column_name&lt;br&gt;
HAVING COUNT(&lt;/em&gt;) &amp;gt; value;&lt;br&gt;
HAVING was added to SQL because the WHERE keyword could not be used with aggregate functions.&lt;/p&gt;

&lt;p&gt;INNER JOIN&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_1&lt;br&gt;
JOIN table_2&lt;br&gt;
  ON table_1.column_name = table_2.column_name;&lt;br&gt;
An inner join will combine rows from different tables if the join condition is true.&lt;/p&gt;

&lt;p&gt;INSERT&lt;br&gt;
INSERT INTO table_name (column_1, column_2, column_3) &lt;br&gt;
VALUES (value_1, 'value_2', value_3);&lt;br&gt;
INSERT statements are used to add a new row to a table.&lt;/p&gt;

&lt;p&gt;IS NULL / IS NOT NULL&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_name IS NULL;&lt;br&gt;
IS NULL and IS NOT NULL are operators used with the WHERE clause to test for empty values.&lt;/p&gt;

&lt;p&gt;LIKE&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_name LIKE pattern;&lt;br&gt;
LIKE is a special operator used with the WHERE clause to search for a specific pattern in a column.&lt;/p&gt;

&lt;p&gt;LIMIT&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
LIMIT number;&lt;br&gt;
LIMIT is a clause that lets you specify the maximum number of rows the result set will have.&lt;/p&gt;

&lt;p&gt;MAX()&lt;br&gt;
SELECT MAX(column_name)&lt;br&gt;
FROM table_name;&lt;br&gt;
MAX() is a function that takes the name of a column as an argument and returns the largest value in that column.&lt;/p&gt;

&lt;p&gt;MIN()&lt;br&gt;
SELECT MIN(column_name)&lt;br&gt;
FROM table_name;&lt;br&gt;
MIN() is a function that takes the name of a column as an argument and returns the smallest value in that column.&lt;/p&gt;

&lt;p&gt;OR&lt;br&gt;
SELECT column_name&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_name = value_1&lt;br&gt;
   OR column_name = value_2;&lt;br&gt;
OR is an operator that filters the result set to only include rows where either condition is true.&lt;/p&gt;

&lt;p&gt;ORDER BY&lt;br&gt;
SELECT column_name&lt;br&gt;
FROM table_name&lt;br&gt;
ORDER BY column_name ASC | DESC;&lt;br&gt;
ORDER BY is a clause that indicates you want to sort the result set by a particular column either alphabetically or numerically.&lt;/p&gt;

&lt;p&gt;OUTER JOIN&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_1&lt;br&gt;
LEFT JOIN table_2&lt;br&gt;
  ON table_1.column_name = table_2.column_name;&lt;br&gt;
An outer join will combine rows from different tables even if the join condition is not met. Every row in the left table is returned in the result set, and if the join condition is not met, then NULL values are used to fill in the columns from the right table.&lt;/p&gt;

&lt;p&gt;ROUND()&lt;br&gt;
SELECT ROUND(column_name, integer)&lt;br&gt;
FROM table_name;&lt;br&gt;
ROUND() is a function that takes a column name and an integer as arguments. It rounds the values in the column to the number of decimal places specified by the integer.&lt;/p&gt;

&lt;p&gt;SELECT&lt;br&gt;
SELECT column_name &lt;br&gt;
FROM table_name;&lt;br&gt;
SELECT statements are used to fetch data from a database. Every query will begin with SELECT.&lt;/p&gt;

&lt;p&gt;SELECT DISTINCT&lt;br&gt;
SELECT DISTINCT column_name&lt;br&gt;
FROM table_name;&lt;br&gt;
SELECT DISTINCT specifies that the statement is going to be a query that returns unique values in the specified column(s).&lt;/p&gt;

&lt;p&gt;SUM&lt;br&gt;
SELECT SUM(column_name)&lt;br&gt;
FROM table_name;&lt;br&gt;
SUM() is a function that takes the name of a column as an argument and returns the sum of all the values in that column.&lt;/p&gt;

&lt;p&gt;UPDATE&lt;br&gt;
UPDATE table_name&lt;br&gt;
SET some_column = some_value&lt;br&gt;
WHERE some_column = some_value;&lt;br&gt;
UPDATE statements allow you to edit rows in a table.&lt;/p&gt;

&lt;p&gt;WHERE&lt;br&gt;
SELECT column_name(s)&lt;br&gt;
FROM table_name&lt;br&gt;
WHERE column_name operator value;&lt;br&gt;
WHERE is a clause that indicates you want to filter the result set to include only rows where the following condition is true.&lt;/p&gt;

&lt;p&gt;WITH&lt;br&gt;
WITH temporary_name AS (&lt;br&gt;
   SELECT *&lt;br&gt;
   FROM table_name)&lt;br&gt;
SELECT *&lt;br&gt;
FROM temporary_name&lt;br&gt;
WHERE column_name operator value;&lt;br&gt;
WITH clause lets you store the result of a query in a temporary table using an alias. You can also define multiple temporary tables using a comma and with one instance of the WITH keyword.&lt;/p&gt;

&lt;p&gt;The WITH clause is also known as common table expression (CTE) and subquery factoring.&lt;/p&gt;

</description>
      <category>sql</category>
      <category>summary</category>
    </item>
    <item>
      <title>Priyanka Prasad</title>
      <dc:creator>priyanka prasad</dc:creator>
      <pubDate>Wed, 20 May 2020 09:13:55 +0000</pubDate>
      <link>https://dev.to/priyankaprasad/first-post-4k34</link>
      <guid>https://dev.to/priyankaprasad/first-post-4k34</guid>
      <description>&lt;p&gt;Hello, world,&lt;br&gt;
I am Priyanka Prasad and I am a university student doing my undergraduate 1st-year BCA from Rajasthan university maharani college and I am really passionate about new technology and want to learn + explore all the new technology &lt;br&gt;
any I have made the project which will give all the beginners in python to learn python through interactive task by Codecademy link to my GitHub repo&lt;/p&gt;

&lt;p&gt;&lt;a href="https://github.com/P-riyanka-prasad/Python_codecademy_projects"&gt;https://github.com/P-riyanka-prasad/Python_codecademy_projects&lt;/a&gt; &lt;/p&gt;

</description>
    </item>
  </channel>
</rss>
