Skip to content

pandevim/Learn_SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

494 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Learn SQL

This is a repository for anyone who wants to learn SQL.
It's an effort by Yash and Aniruddha to understand and learn "SQL".
SQL, is an International Organization for Standardization (ISO)-governed standard language that is used for database programming.
You can use all the queries laid down in this tutorial in the SQL Tryit Editor by W3Schools.

alt text
We're using the Northwind sample database provided by https://www.w3schools.com/
You can also practice on Oracle's Offical website dedicated entirely to SQL from Live SQL
On some points of the tutorial Oracle or PL/SQL Clauses and Fucntions are used. So you can download Oracle Express Edition 11g which does not require any connection with SQL Server Client and is made for the use of developers and learners, from here or else there is an online interpreter provided by TutorialsPoint with online Oracle XE 11.2.0-1.0 all built in, which include some basic tables, you can use to practice on, from here. The Tables that I found were DEPT, EMP, DUAL, SYSTEM_PRIVILEGE_MAP, TABLE_PRIVILEGE_MAP, STMT_AUDIT_OPTION_MAP, AUDIT_ACTIONS.
After the Introduction of DataBase it is adviced to use either Live SQL or Oracle.

The below picture is one of the table of database, the "Customer" table. There are many more tables available.
alt text

alt text

No copyright infringement intended and will be rectified to all parties satisfaction.

About

This repository will help you to learn SQL!

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors