Is SQL algorithmic language? | Sololearn: Learn to code for FREE!

+42

Is SQL algorithmic language?

5/17/2018 1:05:24 PM

John Motta

37 Answers

New Answer

+44

https://stackoverflow.com/questions/4164587/what-algorithms-does-sql-use?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining?view=sql-analysis-services-2017 An algorithm in data mining (or machine learning) is a set of heuristics and calculations that creates a model from data. ... The algorithms provided in SQL Server Data Mining are the most popular, well-researched methods of deriving patterns from data.

+27

SQL Arithmetic Operators Arithmetic Operators Arithmetic operators can perform arithmetical operations o n numeric operands involved. Arithmetic operators are addition(+), subtraction(-), multiplication(*) and division(/). The + and - operators can also be used in date arithmetic. CHECK HERE:: 1.)https://www.w3resource.com/sql/arithmetic-operators/sql-arithmetic-operators.php 2.)https://www.w3schools.com/sql/sql_operators.asp 3.)https://www.geeksforgeeks.org/sql-arithmetic-operators/ 4.)https://docs.microsoft.com/en-us/sql/t-sql/language-elements/arithmetic-operators-transact-sql?view=sql-server-2017 5.)https://www.1keydata.com/sql/sql.html Check these websites very well explanation here......!!!!! πŸ˜‹πŸ˜‹πŸ˜ŽπŸ˜Ž

+18

It is a Structured Query Language by which we can interact with the database. It is not Arithmetic but It is used to do several operations like Insert Delete Drop Update select nd many more. It has made the life of human easy in interacting the hardware at ease and effectively. It is a important language that everyone should learn...No database No life.

+15

As the name suggests sql(sequel) is an structured query language that means all we have databases and interaction with databases. Sql is also a self-declarative language. Apart from that... Sql has three divisions: Dml(data manipulation language) Ddl(data definition language) Dql(data query language) As for algorithm... In my view every language is an algorithmic language... As to program in any language we need to set algorithm. I hope u might find it useful!

+11

partially .. but we can't say it algorithm it's a structure based language you will need to be good in searching pattern ... like regex .. it has built in features . . but for frontend you will need regex to refine the data

+8

very well answered Deepak Mittal... I would like to appreciate your explanation.

+8

what is php😐?

+8

s sql is an algorithimic language but there is a lots of queries and as a alg there is a such type of procedure in writing the queries and languages and certain constraints can be applied for that.

+7

is sql object oriented

+7

If the question is can you implement some sort of algorithms to do something like inserting a new record or retriving or processing a transaction, then yes, SQL is indeed an algorithmic language .Aside from that you can be sure that there are some algorithms behind the scene when you try to match string like "_[^a,b,c,d]$" but thats still not publicly known how exactly ..

+7

also when you use or define functions or procedures in sql server you are just writing a piece of code, in this case , to translate a some sort of algorithm to a code.

+7

[note: personally-developing theory ahead] SQL is a fourth-generation declarative language. In 4GLs you specify WHAT conditions must be met to have a solution, but not HOW to solve or analyze the problem (I think hints are ok). Then, some engine goes off and decides how to satisfy your conditions. -- how does it get there? You're going to analyze its query plan, which is for most people a don't-care item. In a third-generation language (like c++) you specify HOW to solve the problem and you know exactly how it gets there because you wrote it. This sort of pre-analysis / plan control is common in imperative programming. Compare: Artificial Intelligence (like how a neural net gives answers): 4GL Python: Advanced 3GL. It works better as a declarative language with 3GLs it can order around (which ones? Think: SQL execution plan). Gradle (Android build system) is declarative. You say what must be in the final build, but it figures out HOW...and it improves without help. As for SQL... to understand what it's doing will require some algorithmic thinking, but I don't think of using the language to write algorithms. Instead I think of SQL as: "I'm too busy to come up with an algorithm, you figure it out." [Disclaimer: I mean SQL, under normal "go fetch" use]

+6

sql is a backend application and its query language

+5

It may and may not be an algorithmic language. In some instances, it may not be... it depends on what you want to use it for.

+4

So, you need to know - what is the algorithms. It will answer you.

+4

Structured Query Language !

+3

It is based on commands

+3

which is best programming language to start with C,html ,r or java and how can we learn to code.please step by step guidance needed.Beginner

+3

Welldone

+3

SQL is structure query language. algorithm is a set of instructions made Programmer on the basis of various program model like uml and so on. with the help of the algorithm we can create control flow of the program and functionality of a program as we want.