Sql

thenightrider

Does any one know of an online database that i could practice queries on or even better one that i can make a database on and try some queries on. I have an exam on it on Monday and have no way do try it out at home.

Thanks

cython

thenightrider wrote: »

Does any one know of an online database that i could practice queries on or even better one that i can make a database on and try some queries on. I have an exam on it on Monday and have no way do try it out at home.

Thanks

You could download something like lampp and use the MySQL component, and phpmyadmin if you want access other than the prompt?

L8rdude

Would this help?

http://www.w3schools.com/sql/sql_tryit.asp

There seems to be a few listed here - http://webapps.stackexchange.com/questions/1114/is-there-any-site-where-i-can-practice-basic-sql-queries

L8rdude

Or if you are downloading

https://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

There's also 2005/2008 version available

thenightrider

Thanks guys ill give them a try that w3schools one seems handy should get me started

ChRoMe

WAMP will get you started nicely http://www.wampserver.com/en/

cj maxx

Sorry to ressurect such an old thread but it's the only sql one I've seen here.
Is sql a good choice for a starter language and any more recent tutorials / online courses ?
Thanks . Cjmc

L8rdude

It depends what you want to do.

An SQL database is for storing information like an employee or sales record. SQL then lets you query the database to read those records.

Do you want to build a website, a phone app or a desktop application? A lot of these would use an sql database to store information in the background.

cj maxx

L8rdude wrote: »

It depends what you want to do.

An SQL database is for storing information like an employee or sales record. SQL then lets you query the database to read those records.

Do you want to build a website, a phone app or a desktop application? A lot of these would use an sql database to store information in the background.

I really just want to do a programming course that would be useful In the job market , not really as a programmer per se , but as a component of any future
education I take on ,if that makes sense !
Maybe something with statisics. Lower level entry.
As everything is now kept on databases I thought being able to read / compile data bases would be an asset.

cj maxx

thanks

PrzemoF

SQL is database query language, so it's an general purpose programming language. I mean you cannot do the typical "Hello World!" [1]. If you have zero experience try Scratch [2] and when you learn the basic concepts try python [3]

SQL is handy to have anyway, but the real power comes for combining different technologies and languages (i.e. make a python program to manipulate data that is pulled/pushed to a database using SQL)

[1] https://en.wikipedia.org/wiki/%22Hello,_World!%22_program
[2] https://en.wikipedia.org/wiki/Scratch_(programming_language)
[3] https://en.wikipedia.org/wiki/Python_(programming_language)

28064212

PrzemoF wrote: »

I mean you cannot do the typical "Hello World!" [1]

Pfft:

SELECT 'Hello World!'

:pac:

PrzemoF

I knew it was going to happen! I'm waiting for someone to make nokia snake game in SQL to prove me that it is a general purpose language :eek:

BrokenArrows

SQL would generally be considered a skill required by developers in order to make their products useful.

eg. A developer might code their product in C# but need to read and write customer information to a database. One method of reading and writing to the database would be using via SQL.

However SQL by itself isnt very useful unless you want to simply analyse/view the contents of a database and you need to retrieve specific data.

If you are looking to get something useful out of SQL then you should learn a programming language at the same time and combine the two.

Tom Dunne

cjmc wrote: »

I thought being able to read / compile data bases would be an asset.

:eek::pac:

I think you need to be clear in your own head what you are trying to achieve.

General programming languages like C# and Java are for creating software programs. PHP and the like are typically used for developing websites.

Languages like SQL are for manipulating data and can be called (used) by languages such as those I have mentioned above (and many more besides).

In my opinion, learn programming fundamentals first, in a language you are comfortable with, and then progress onto SQL.

cj maxx

Tom Dunne wrote: »

:eek::pac:

I think you need to be clear in your own head what you are trying to achieve.

General programming languages like C# and Java are for creating software programs. PHP and the like are typically used for developing websites.

Languages like SQL are for manipulating data and can be called (used) by languages such as those I have mentioned above (and many more besides).

In my opinion, learn programming fundamentals first, in a language you are comfortable with, and then progress onto SQL.

Thanks , I started a online course in R but should I go for C+ maybe

Tom Dunne

Stay away from R for now, it is a pretty niche language.

C++ is quite a broad, general purpose language. Personally, I wouldn't recommend it unless you doing low-level stuff (you will know if you are doing it).

In my opinion, if you want to learn a language that will force good programming practices on you, learn Java.

PrzemoF

Stay away from C++ (l'll get a pitchfork in my back for that..). Learn C to understand how it really works and then go to C++ if you need it. To be honest, go for anything but no C++ as the first language.

cj maxx

PrzemoF wrote: »

Stay away from C++ (l'll get a pitchfork in my back for that..). Learn C to understand how it really works and then go to C++ if you need it. To be honest, go for anything but no C++ as the first language.

Looking at online sources to learn from , , Python seems most popular and lots or online tutorials.
good choice ?

gctest50

PrzemoF wrote: »

I knew it was going to happen! I'm waiting for someone to make nokia snake game in SQL to prove me that it is a general purpose language :eek:

snake ?

The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database

http://schemaverse.marcneuwirth.com/

Talisman

cjmc wrote: »

Looking at online sources to learn from , , Python seems most popular and lots or online tutorials.
good choice ?

Python is probably the best language to start with.

Learn Python The Hard Way is a great free resource to learn from.

Talisman

gctest50 wrote: »

snake ?

The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database

http://schemaverse.marcneuwirth.com/

Postgres is a kick ass database system.

Evil Phil

I would say learn Java or Python. Loads of online stuff for them as well. The Java Tutorials from Oracle are a good start for Java. Somebody mentioned Learn Python the Hard Way earlier, that's a great start too.

Or you could be brave, do https://tour.golang.org/basics/1, and report back

PrzemoF

I don't think anyone wrote it directly: most of the programming languages use similar concepts, so one you know how conditionals or loops work in one language, you'll be able to quickly apply it to another, so it doesn't really matter if you learn how "if" works in python, C++ or in java. This is a simplification, but for someone learning his first high level language it's very true.

ishotjr2

I would always recommend C as the first programming language because I think it teaches discipline rather than higher level languages which give an impression that they will handle the complexities.

I am not sure about the future of Java and I only say that because I just went through a process of replacing all Java code because of new JDK/JRE licensing terms (please do not start shouting about OpenJDK).Python, is popular, Node I would put on an equal foot to Python.

To master C++ is a big commitment and being a bad/mediocre C++ programmer would be a difficult career choice. That is, you have to do the time!

Bit of fun:
Have a look at Rust https://www.rust-lang.org/en-US/