/CT29_learnSQL

Primary LanguageTSQL

================================================================================

CT29 -- Learn Programming in SQL

================================================================================

This Web page is about creating, editing, deleting databases and tables
and more SQL programming**.
version:12/011/2019

By Josh Hortt

SOURCES

https://www.geeksforgeeks.org/sql-tutorial/ https://www.w3schools.com/sql/ https://www.tutorialspoint.com/sql/

IN CLASS SOURCES
https://www.w3schools.com/sql/sql_syntax.asp https://www.w3schools.com/sql/sql_drop_db.asp https://www.w3schools.com/sql/sql_create_table.asp https://www.w3schools.com/sql/sql_drop_table.asp https://www.w3schools.com/sql/sql_select.asp https://www.w3schools.com/sql/sql_where.asp https://www.w3schools.com/sql/sql_insert.asp https://www.w3schools.com/sql/sql_null_values.asp https://www.w3schools.com/sql/sql_update.asp https://www.w3schools.com/sql/sql_delete.asp

================================================================================

First Steps before creating DATABASE

  1. Download xampp (Web-server)
  2. Create shortcut
  3. Double click Xammp
  4. Start apache (wait for green light, allow access)
  5. Start sql (wait for green light, allow access)
  6. Open browser - to access the BD typing "localhost" or "127.0.0.1" no brackets
  7. Wait while xampp dashboard opens
  8. Go to right panel and click on "phpAdmin"
  9. Explore the Envirenment, then go to upper menu bar where SQL is. Click on it
  10. You re in the Console. Type code inside console and do "Go"

Commands Used

Some of The Most Important SQL Commands

SELECT - extracts data from a database

UPDATE - updates data in a database

DELETE - deletes data from a database

INSERT INTO - inserts new data into a database

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index

IMPORTANT: one of the fields always needs a dedicated PRIMARY KEY

Technologies Used

SQL - Scripting Query Language

Licence

MIT License. Copyright (c) 2019 Josh Hortt