DIGIT-ARC read-only archive · snapshot: July 23, 2026

SQL for cbse class 12

12 posts · originally from https://geek.digit.in/community/threads/sql-for-cbse-class-12.186596/

G
G.Ashwinkumar Original post #1
Aug 25, 2014 at 10:14 PM
Hi guys i'm studying in cbse class 12, i would like to know which software( preferably freeware) i should be using to practice sql for my cbse class 12? I was redirected to Oracle SQL Developer after googling for a few hours i downloaded the software. It asks for some username and password for some connection! Well i don't think i have one. Is it paid or something like that? While in our lab they use oracle sql + 2001 edition. Can someone please guide me with detailed explanations and be quick!
RCuber
RCuber #2
Aug 25, 2014 at 10:55 PM
its usually the connect for your sql account, did you provide a password during setup? I am unaware of Oracle Installation , I know only about MS SQL .
tkin
tkin #3
Aug 26, 2014 at 12:23 AM
Hi guys i'm studying in cbse class 12, i would like to know which software( preferably freeware) i should be using to practice sql for my cbse class 12? I was redirected to Oracle SQL Developer after googling for a few hours i downloaded the software. It asks for some username and password for some connection! Well i don't think i have one. Is it paid or something like that? While in our lab they use oracle sql + 2001 edition. Can someone please guide me with detailed explanations and be quick!
Get MySql, google for the guide to set it up, takes 10 mins.
Shah
Shah #4
Aug 26, 2014 at 6:57 AM
Just download and install WAMP, You'll have MySQL and phpMyAdmin installed (along with Apache, PHP) in your PC.

Use phpMyAdmin to try out SQL Commands.
nisargshah95
Aug 26, 2014 at 7:54 PM
[MENTION=129731]Shah[/MENTION] I beleive WAMP server might overwhelm the OP.
I agree with [MENTION=52329]tkin[/MENTION]. I also used MySQL in 12th class and it worked just fine.
harshilsharma63
Aug 27, 2014 at 12:58 PM
Download MySQL community edition. Setup an anonymous account and you are good to go. DO NOT USE WANT/XAAMP as you'll learn much less with them.

Download page: MySQL :: MySQL Community Downloads

- - - Updated - - -

Download MySQL community edition. Setup an anonymous account and you are good to go. DO NOT USE WANT/XAAMP as you'll learn much less with them.

Download page: *dev.mysql.com/downloads/
tanmaymohan
Aug 28, 2014 at 3:25 PM
^ The above works fine :)
anirbandd
Aug 28, 2014 at 8:24 PM
MS SQL Server is also very good. you can try it out along with MySQL.

SQL server is most widely used. its used almost everywhere and the UI is very easy and good. particularly MS's Intellisense is very good and helps a lot. it also has seamless integration with Visual Studio..
tkin
tkin #9
Aug 28, 2014 at 10:27 PM
MS SQL Server is also very good. you can try it out along with MySQL.

SQL server is most widely used. its used almost everywhere and the UI is very easy and good. particularly MS's Intellisense is very good and helps a lot. it also has seamless integration with Visual Studio..
Is it free?
G
Aug 28, 2014 at 11:20 PM
Well guys thanks for your replies! Well i thought i was simple enough i just want a software to try create table <tablename> (fn1 dt1,...) yes such simple ones( atleast this is what i have in my portions) so i don't think integration with visual studio and all wouldn't matter to me at all. Well i followed the thread and headed to the mysql community download section and there was given a lot of versions to select from so i downloaded mysql community server 5.6.20 64 bit zip archive and couldn't figure out on a way to install it. So i again downloaded mysql workbench and installed it. But have no idea on how to create a simple coding and test it? Just how when i try to use it it shows some connection ... and then when i try to connect it shows connection not established some error.... Guys i want to be clear i have a 64 bit pc and no knowledge whatsoever on sql, sql is just a very small part in our cbse board view so please give me detailed steps on what to download and how to install so that i can understand the basic working of create, select , alter, update, drop,insert.. queries, some constraints and a few more basic things..( no the entire programming language is not there for us). Please help me. I noticed that in our school they use sql ++ version 8i when i checked on google i came to know it was very outdated but still it was very simple and lpain straightforward so if someone can help me get that version or something very similar it would be really good. PLease help me this monday i have exams PLease be quick and detailed!
anirbandd
anirbandd #11
Aug 29, 2014 at 2:22 AM
Is it free?

express edition is AFAIK.

- - - Updated - - -

Well guys thanks for your replies! Well i thought i was simple enough i just want a software to try create table <tablename> (fn1 dt1,...) yes such simple ones( atleast this is what i have in my portions) so i don't think integration with visual studio and all wouldn't matter to me at all. Well i followed the thread and headed to the mysql community download section and there was given a lot of versions to select from so i downloaded mysql community server 5.6.20 64 bit zip archive and couldn't figure out on a way to install it. So i again downloaded mysql workbench and installed it. But have no idea on how to create a simple coding and test it? Just how when i try to use it it shows some connection ... and then when i try to connect it shows connection not established some error.... Guys i want to be clear i have a 64 bit pc and no knowledge whatsoever on sql, sql is just a very small part in our cbse board view so please give me detailed steps on what to download and how to install so that i can understand the basic working of create, select , alter, update, drop,insert.. queries, some constraints and a few more basic things..( no the entire programming language is not there for us). Please help me. I noticed that in our school they use sql ++ version 8i when i checked on google i came to know it was very outdated but still it was very simple and lpain straightforward so if someone can help me get that version or something very similar it would be really good. PLease help me this monday i have exams PLease be quick and detailed!

sql installation and deployment is a bit complex for beginners.

can you do it in your school lab? else, if you want it on your home pc, google for installation guides of mysql.
dashing.sujay
Sep 1, 2014 at 12:55 AM
@OP - Oracle has got some default usernames to login in order to work. The default root login is "system" and the password is set during installation.

If you do not remember the password for system, you can use "scott" as Id and "tiger" as password.