#SQL(DAY5) How does a person can interact with the database by using SQL?

 How does a person can interact with the database by using SQL?

As, we know if two people want to convey their feelings they use their native language for communicating and if we think a little bit how can a human interact with machine or databse? this can be solved by using commands.

Yes, as discussed above there are few commands that can help us to interact with database.

The SQL commands help in creating and managing the database. There are different types of commands:

We use above sql commands to communicate with the database and in the later stories let us discuss about each every command types seperately.

#SQL(DAY4)Do you know the process of SQL?

 Do you know the process of SQL?

When we are executing the command of SQL on any Relational database management system, then the system automatically finds the best routine to carry out our request, and the SQL engine determines how to interpret that particular command.

Structured Query Language contains the following four components in its process:

1) Query Dispatcher

The function of the dispatcher is to route the query request to either CQE or SQE, depending on the attributes of the query. All queries are processed by the dispatcher. It cannot be bypassed.

2) Optimization Engines

The SQL Server Query Optimizer is a cost-based optimizer. Each possible execution plan has an associated cost in terms of the amount of computing resources used. The Query Optimizer must analyze the possible plans and choose the one with the lowest estimated cost.

3) Classic Query Engine

Classic query engine handles all non-SQL queries but SQL query engine won’t handle logical files. CREATE Creates a new table, a view of a table, or other object in database ALTER Modifies an existing database object, such as a table. DROP Deletes an entire table, a view of a table or other object in the database.

4) SQL Query Engine

At a high level, a query engine is a piece of software that sits on top of a database or server and executes queries against data in that database or server to provide answers for users or applications. More specifically, a SQL query engine interprets SQL commands and language to access data in relational systems.

The architecture of SQL is shown in the following diagram:

#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