#SQL(DAY3)History of SQL

                         #SQL(DAY3)

 History of SQL

Today let us know the history of SQL, how the sql was developed, who developed it and when it was developed all these we will be learning in this blog.

History of SQL

“A Relational Model of Data for Large Shared Data Banks” was a paper which was published by the great computer scientist “E.F. Codd” in 1970.

E.F.Codd

The IBM researchers Raymond Boyce and Donald Chamberlin originally developed the SEQUEL (Structured English Query Language) after learning from the paper given by E.F. Codd.

They both developed the SQL at the San Jose Research laboratory of IBM Corporation in 1970.

At the end of the 1970s, relational software Inc. developed their own first SQL using the concepts of E.F. Codd, Raymond Boyce, and Donald Chamberlin.

This SQL was totally based on RDBMS. Relational Software Inc., which is now known as Oracle Corporation, introduced the Oracle V2 in June 1979, which is the first implementation of SQL language. This Oracle V2 version operates on VAX computers.

#SQL(DAY2)Why SQL?

                                                 #SQL(DAY2)

Why SQL?

Nowadays, SQL is widely used in data science and analytics. Following are the reasons which explain why it is widely used:

• The basic use of SQL for data professionals and SQL users is to insert, update, and delete the data from the relational database.

• SQL allows the data professionals and users to retrieve the data from the relational database management systems.
• It also helps them to describe the structured data.
• It allows SQL users to create, drop, and manipulate the database and its tables.

• It also helps in creating the view, stored procedure, and functions in the relational database.

• It allows you to define the data and modify that stored data in the relational database.

• It also allows SQL users to set the permissions or constraints on table columns, views, and stored procedures.

#SQL(DAY1)What is SQL?

#SQL(DAY1)

Structured Query Language(sQL) for beginners

From today, let us start our new subject i.e SQL. In this blog we will just learn about What is SQL. It is just going to be short and sweet blog.

SQL Tutorial

SQL (Structured Query Language) is used to perform operations on the records stored in the database, such as updating records, inserting records, deleting records, creating and modifying database tables, views, etc.

SQL is not a database system, but it is a query language.

Suppose you want to perform the queries of SQL language on the stored data in the database. You are required to install any database management system in your systems like MySQL, SQL Server.

What is SQL?

SQL is a short-form of the structured query language, and it is pronounced as S-Q-L or sometimes as See-Quell.

This database language is mainly designed for maintaining the data in relational database management systems. It is a special tool used by data professionals for handling structured data (data which is stored in the form of tables). It is also designed for stream processing in RDSMS.

You can easily create and manipulate the database, access and modify the table rows and columns, etc. This query language became the standard of ANSI in the year of 1986 and ISO in the year of 1987.

If you want to get a job in the field of data science, then it is the most important query language to learn. Big enterprises like Facebook, Instagram, and LinkedIn, use SQL for storing the data in the back-end.

#PYTHON(DAY50)Conclusion

                                     #PYTHON(DAY50)

Conclusion of python(Tips for becoming good programmer)

Tip 1: Code Everyday

Consistency is very important when you are learning a new language. We recommend making a commitment to code every day. It may be hard to believe, but muscle memory plays a large part in programming. Committing to coding everyday will really help develop that muscle memory. Though it may seem daunting at first, consider starting small with 25 minutes everyday and working your way up from there.

Tip 2: Write It Out

As you progress on your journey as a new programmer, you may wonder if you should be taking notes. Yes, you should! In fact, research suggests that taking notes by hand is most beneficial for long-term retention. This will be especially beneficial for those working towards the goal of becoming a full-time developer, as many interviews will involve writing code on a whiteboard.

Once you start working on small projects and programs, writing by hand can also help you plan your code before you move to the computer. You can save a lot of time if you write out which functions and classes you will need, as well as how they will interact.

Tip 3: Go Interactive!

Whether you are learning about basic Python data structures (strings, lists, dictionaries, etc.) for the first time, or you are debugging an application, the interactive Python shell will be one of your best learning tools. We use it a lot on this site too!

Tip 4: Teach

It is said that the best way to learn something is to teach it. This is true when you are learning Python. There are many ways to do this: whiteboarding with other Python lovers, writing blog posts explaining newly learned concepts, recording videos in which you explain something you learned, or simply talking to yourself at your computer. Each of these strategies will solidify your understanding as well as expose any gaps in your understanding.

So, by constant learning we can achive our goals and can become a good python programmer.

#PYTHON(DAY49)Example Programs

                                    #PYTHON(DAY49)

Example Programs

1) Python Program to Find Sum of n Natural Numbers

print("Enter the Value of n: ")
n = int(input())

sum = 0
i = 1
while i<=n:
  sum = sum+i
  i = i+1

print("\nSum =", sum)

And the output is:

Enter the value of n:
10

sum = 55

2) Python Program to Add Digits of a Number

print("Enter a Number")
num = int(input())
sum = 0
while num>0:
    rem = num%10
    sum = sum+rem
    num = int(num/10)
print("\nSum of Digits of Given Number: ", sum)

And the output is:

Enter a Number:
123

Sum of Digits of Given Number: 6

3) Sum of First and Last digit of a Number

print("Enter a Number: ")
num = int(input())

count = 0
while num!=0:
    if count==0:
        last = num%10
        count = count+1
    rem = num%10
    num = int(num/10)

sum = rem + last
print("\nSum of first and last digit =", sum)

And the output is:

Enter a Number:
1203

Sum of first and last digit = 4

#PYTHON(DAY48)Example Programs

                                     #PYTHON(DAY48)

Example Programs

1) Python Program to Randomly Select an Element From the List

import random

my_list = [1, 'a', 32, 'c', 'd', 31]
print(random.choice(my_list))

And the output is:

31

2) Python Program to Print Output Without a Newline

# print each statement on a new line
print("Python")
print("is easy to learn.")

# new line
print()

# print both the statements on a single line
print("Python", end=" ")
print("is easy to learn.")

And the output is:

Python
is easy to learn.

Python is easy to learn.

3) Python Program to Get a Substring of a String

my_string = "I love python."

# prints "love"
print(my_string[2:6])

# prints "love python."
print(my_string[2:])

# prints "I love python"
print(my_string[:-1])

And the output is:

love
love python.
I love python

#PYTHON(DAY47)Example Programs

                                         #PYTHON(DAY47)

Example programs

1) Python Program to Capitalize the First Character of a String

my_string = "programiz is Lit"

print(my_string[0].upper() + my_string[1:])

And the output is:

Programiz is Lit

2) Python Program to Count the Number of Occurrence of a Character in String

count = 0

my_string = "Programiz"
my_char = "r"

for i in my_string:
    if i == my_char:
        count += 1

print(count)

And the output is:

2

3) Python Program to Trim Whitespace From a String

my_string = " Python "

print(my_string.strip())

And the output is:

Python