Yes, students at national law universities generally get access to the major legal research databases through the university's library, and this is one of the real benefits of being at an NLU.
A student comparing NLUs with state and private universities explains that NLU students use resources such as SCC Online, Manupatra, Taxmann, EBC, Westlaw Asia and Jus Mundi, whereas equally hardworking friends in other universities often never get to use them because the institution does not provide them. That difference shows up at internships, where students from universities without access have to learn these tools on the job.
Access normally comes through the campus network or university login, so you may not be able to use it from outside without the library's remote-access setup. Terms and the exact databases change with the university's subscription, so check with the library for the current list.
My advice: when you join, attend the orientation sessions and the SCC Online and MS Word or Excel workshops that seniors recommend. Learning to use these databases for research and drafting in your first year pays off in moot courts, research papers and internships.
Yes, NLU Delhi gives free access to SCC through the SCC Online IP, which is accessible only on the university campus.
In addition to its useful search function and case notes, SCC Online is regarded as the most reliable source for SC judgements. Aside from cases, SCC Online coverage consists of articles from Practical Lawyers and SCC, reports from the Law Commission of India, articles from SCC, and selective judgements from the Indian State High Courts.
If you want to access SCC through LAN Mode, you need to contact the IT Section of NLU Delhi.