SQL
Images are sometimes not shown due to bandwidth/network limitations. Refreshing the page usually helps.
You are currently reading a thread in /g/ - Technology
You are currently reading a thread in /g/ - Technology
Where could I get information, resources on writing more complicated SQL scripts? All I can find is stuff for begginers, but doesn't point out where I could get more complicated stuff.
>>55052651
> more complicated SQL scripts
Could you specify that?
Are you looknig for SQL Server or plain SQL?
SQL-Functions? Excecution plans? Stored procedures? There's a lot of stuff, but you won't many of that. It all depends on the purpose..
But basically a lot is "trial and error". There are of course good blogs (i.e. "sql in the wild"), and you can also try to google SQL interview questions, for example:
>http://java67.blogspot.com/2013/04/10-frequently-asked-sql-query-interview-questions-answers-database.html
You should really try to wrap your head arround the questions.
But more important: Write queries.
Make your own DB or use an exmaple DB (there are a lot of them out there) and really try to get the informations you want.
>> 55053613
Thank you for the input . Basically I have the Internship in the Company in Which I have been Assigned to Oracle Database Maintanance . The main idea is to input information in the Specific Specific places with the Specific Conditions with script use . Everything I have Learned hasn't been about Real Life Scripts with SQL , and now I was just interested to get some books or articles That focus on the Functions , procedures, subqueries in the subqueries and so on. And again , thanks for answer !
>>55052651
No, no no, you don't want that! It's 2016. You should be using NoSQL, or even better a simple key-value data store like BigTable or leveldb.
Traditional relational databases simply don't scale, ask any modern company: Google, Facebook, Twitter all exclusively use modern datastores.
There is more information available at http://mongodb-is-web-scale.com/
But if you _absolutely_ *MUST* use a relational database, you should use a full ORM solution (that's Object Relational Mapping) like ActiveRecord so you can do migrations, stubs, mocks, rollbacks, and more quickly, and easily!
>>55053698
am I being memed
Look up the TPCH
>>55053707
Yes, you are. Sure, NoSQL databases are nice, but SQL is here to stay for a long time and most companies still will be using it.
>>55052651
OP is the guy who learns the definition of addition and multiplication but can't transfer those skill to evaluate a formula involving both
>>55053698
They should just rename NoSQL to NoData because that's what you'll get
>>55053747
sick burn, bro
https://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/0596523068/186-0990720-5545948?ie=UTF8&camp=217145&creative=399369&creativeASIN=0596523068&linkCode=as2&redirect=true&ref_=as_li_ss_tl&tag=ucmbread-20
you need to read this if you dont shit on streets desu senpaifam
>>55053707
Yes.
MongoDB and NoSQL solutions scale because they're simpler. Use them when you only need a really fast cache and it's not a big deal if your database becomes inconsistent. For instance if you're running a search engine and then you don't really care about the exact number of search results you get or their exact order, rather you care more about it being fast as shit and in the general ballpark.
Use a proper relational database when you're worried about data integrity more than speed for instance if you're storing user account information for a bank or something.
It is also not unreasonable to use a combination of relational database and NoSQL solutions to handle different parts of a project.
Here is an article that talks about how the Diaspora people fucked up by using MongoDB without understanding the repercussions.
http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/
>>55053693
I see.
Well, if it's an internship they won't assume you are the ultimate DBA, will they?
Anyway, if you want to prepare you could look into functions:
>http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm
..or subqueries:
>https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm#i2066912
But don't overdo it.
You will probably need only a bunch of functions and you can google them whenever you need a specific one.
Or do they expect you to call stored C/C++ procedures? No, they won't.
Maybe you will get into pl/sql, but I doubt it.
>http://plsql-tutorial.com/
>>55053698
You want differnt possibilities.
Each DB System has pros and cons, but SQL is used a lot in industry and it's wont go anywhere.
Also, NoSQL is kinda the next staep after SQL. You should really have a deep undersatnding of SQL, relational databases, referential integrity and normalisation before messing around with NoSQL..
>>55053707
Yes. MongoDB isn't even ACID compliant and unlike any other memes like CouchDB doesn't even try to, basically what >>55053747 said.
Can't take "datebases" like that serious.
Even when storing JSON documents, your best bet usually is to use an SQL database which has this functionality as a bonus.
