Do you know any good resources to learn SQL as fast as possible?
>>53551961
is he burping?
bump
>>53552014
No, he is being gay as fuck. By the way, who's him?
>>53551961
why need mysql?
everything i need to store for a long time in php i write in textfiles,
dbs are a meme
>>53552036
Newfag, pls leave.
>>53552061
>>53552036
here's your (You).
https://www.codecademy.com/learn/learn-sql
???
>>53552036
By "gay" do you mean happy or a faggot?
bump
read the official docs
>>>/g/sqt/
>>53551961
SQL is incredibly easy.
>>53552143
True, SQL is basically for retards
>>53551961
Work with databases for a while
>>53552091
No. Did it as an SQL dev. You will not know Sql from that
>>53551961
Who is this semen demon?
w3schools.com
>>53552590
agreed, its the top of the ice berg.
[source] 7 years neck deep in data
>>53552625
Isn't he that famous 4channer, what was his name, Eggman maybe?
>>53552625
He's hiroshima nagasaki. He fought in the korean war.
http://sqlzoo.net/
>>53552625
>>53552695
>>53552709
newfags don't know about Christopher Poole. Fucking tards
>>53552673
do you enjoy it? what's the pay like? What does a typical day consist of for you?
>>53552794
literally kill yourself
>>53552794
Literally who?
>>53552821
How does someone figuratively kill self?
>>53552794
haha, you've been tricked
>>53552854
Social suicide, brah
>learning SQL
>not learning database modeling and SQL on the side
>>53552794
>Christopher Poole
Who?
>>53552077
Newfag, pls leave
>>53552857
kek, it is in fact YOU who has been tricked
open the facepalm image >>53552794
in mspaint and use the fill tool on the the black border. It was all a lie
Just use ORM
>>53552794
He was the guy who made these kind of images.
>>53552901
Well, looks like I've been bamboozled
>>53552945
wow, the effort behind this.
>this thread
>>53552945
you could just always post an image like this and get away with saying anything
Literally what the fuck is there to learn?
The S in SQL stands for SIMPLE, if you can't get it down in a week or so, don't bother
now PL/SQL, on the other hand...
>>53554534
You are literally retarded
>>53554534
This. MySQL is literally easier than learning python.
Use mongodb instead, SQL is deprecated.
>>53555278
Persistence? What's that?
SQL is not easy if you've written more than a select * from table where id=1 query in your life. Multiple joins, subselects, inline views, aggregations complicate things and let's not talk about analytical functions and for example model clause.
Of course, if you're not some BI analytics guy or work with databases extensively, you don't need much more than the above mentioned statement plus group by and order by.
>>53554534
>>53555255
Then you should get though this tests easily, right?
Basic SQL:
https://www.wiziq.com/online-tests/784-test-your-basic-sql-skills
Advanced:
https://www.wiziq.com/online-tests/38319-sql-server-dba-test-1
>>53551961
You can learn it absolutely everywhere anon
Just fucking type "SQL" on google
The basics are easy as shit.
>>53552061
Does your webpages took seconds to decrypt your text files instead of having to just connect and send query.
My school insists on having mySQL classes. I insisted on having 6 more hours a week free.
This education is a fucking meme, we could at least learn real programming. Who the fuck even manually manipulates databases.
>>53556577
>Who the fuck even manually manipulates databases.
Anyone serious.
>He thinks his fancy ORM doesn't impact performances
>>53556577
Because knowing how to use query languages, especially in the case of SQL, helps in understanding more behind the database schema design. If the class has anything theoretical like the algorithms the database uses, then that too.
Install MySQL in a linux VM and fuck around with it.
Murach's MySQL 2nd Edition
You're going to want to the project files too. They're on the murach website.
>>53556742
>>53556712
It's just a how2mySQL class. We don't learn about development, or security, or algorithms, or anything even remotely useful.
>>53556927
Well if you know SQL it should not take much time for you at all to do any of the work.
If you need several hours then it might be good practice.
>>53556712
ORMs are very good when performance doesn't matter
eg. when your API/service doesn't directly output something to your user
>>53555807
that fucking webpage sucks, lots of wrong answers