Learn SQL

Funda i-SQL uhlelo lokusebenza lokufunda imiyalo eyisisekelo yolimi lombuzo. Phequlula izihloko ze-SQL ngesampula yombuzo. Uhlelo lokusebenza lunikeza okokufundisa kwe-SQL kwabaqalayo ekuthuthukiseni imininingwane.


Izici ezintsha ezingeziwe:
> Imibuzo Yezingxoxo
> Imibuzo Eyinkimbinkimbi yokuzijwayeza
> Imibuzo ye-SQL


Izihloko ezifakwe kuhlelo lokusebenza yilezi:
> Imigomo Eyisisekelo ye-SQL
- Imigomo Eyisisekelo
- Ithebula & Ikholomu Ukuqamba Imithetho

> Amathuluzi e-SQL
- Iseva ye-Microsoft SQL,
- MySQL
- I-Oracle
- I-Postgre SQL
- I-SQLite
- I-MongoDB

> Izingxenye ze-SQL
- Ulimi Lwencazelo Yedatha (DDL)
- Ulimi Lokukhohlisa Kwedatha (DML)
- Ulimi Lombuzo Wedatha (DQL)
- Ulimi lokulawula idatha (DCL)
- Ulimi Lokulawula Ukuthengiselana (TCL)

> Izinhlobo Zedatha
- Izinhlobo zedatha ye-SQL
- Ukuqhathanisa phakathi kwe-TinyInt, i-SmallInt, i-Int, i-BigInt
- Ukuqhathanisa phakathi kukaChar, NChar, Varchar, NVarchar
- Ububi bohlobo lwedatha yombhalo

> Izihloko Eziyisisekelo
- I-SQL YAKHA Isizindalwazi
- I-SQL DROP Database
- SQL YAKHA Ithebula
- I-SQL YAKHA Ithebula Kuthebula Elikhona
- SQL FAKA UKUKHETHA
- SQL KHETHA
- SQL LAPHO Isigaba somthetho
- SQL KHETHA OKUHLUKILE
- Isigaba somthetho se-SQL TOP
- I-SQL UPDATE
- SQL DELETE
- I-SQL TRUNCATE
- I-SQL DELETE vs TRUNCATE
- I-SQL ALTER
- Imithetho yesitatimende ALTER
- I-SQL RENAME (Ithebula)
- I-SQL RENAME (Ikholomu)
- I-SQL DROP
- DROP vs TRUNCATE

> Izihloko Ezithuthukile
- SQL KANYE, NOMA, CHA
- I-SQL Ihlanganiswe KANYE, NOMA, CHA
- SQL PHAKATHI
- I-SQL I-ORDER BY
- SQL IN
- I-SQL AYINGENA
- SQL LIKE
- I-SQL NULL
- Icala le-SQL NINI
- SQL IKHONA Operator
- I-SQL YONKE & NOMA IMUPHI Opharetha
- IMIYALELO YE-SQL
- I-SQL AGGREGATE Imisebenzi
- SQL GROUP BY
- UKUBA ne-SQL
- SQL LAPHO vs HAVING
- SQL NUMERIC Imisebenzi
- SQL STRING Imisebenzi
- SQL USUKU Imisebenzi
- Imisebenzi ye-SQL Advanced
- I-SQL SET Operators
- SQL AUTO INCREMENT
- I-SQL IDENTITY INSERT ON/OFF
- I-SQL ALIAS
- I-SQL IJOYINA
- I-SQL CARTESIAN JOIN
- I-SQL INNER JOIN
- I-SQL LEFT JOIN
- SQL OKUFANELE JOIN
- I-SQL FULL JOIN
- I-SQL SELF JOIN
- I-SQL JOIN vs UNION
- I-SQL UNIQUE KEY
- SQL PRIMARY KEY
- UKHIYE WAMAZWE WE-SQL
- Ukhiye Oyinhloko vs Ukhiye Oyingqayizivele vs Ukhiye Wangaphandle
- I-SQL CHECK Constraint
- I-SQL DEFAULT Constraint
- SQL SUBUMBUZO
- IMIBUZO EHLOSISWE YE-SQL
- SQL SUBQUERY vs CORRELATED
- I-SQL COMMIT/ROLLBACK
- I-SQL GRANT/REVOKE

Izici ezibalulekile zohlelo lokusebenza yilezi:
> Izihloko ezingu-50+ Zolimi Lombuzo Ohleliwe (SQL)
> 50+ umbuzo oyisampula wokudluliselwa kwakho
> Funda ulimi lwe-SQL mahhala
> Kulula ukusebenzisa i-User Interface
> Ungabelana ngohlelo lokusebenza nabangani bakho namalungu omndeni.
------------------------------------------------- ------------------------------------------------- ------------------------------------------
Lolu hlelo lokusebenza lwakhiwe kwa-ASWDC ngu-Arik Kantesaria (190540107099), umfundi we-6th-semester CE. I-ASWDC iyi-Apps, Software, kanye neSikhungo Sokuthuthukiswa Kwewebhusayithi @ Darshan University, i-Rajkot ephethwe abafundi nabasebenzi boMnyango Wesayensi Yekhompyutha Nobunjiniyela.

Sishayele: + 91-97277-47317

Sibhalele: [email protected]
Vakashela: http://www.aswdc.in http://www.darshan.ac.in

Silandele ku-Facebook: https://www.facebook.com/DarshanUniversity
Usilandela ku-Twitter: https://twitter.com/darshanuniv
Uyasilandela ku-Instagram: https://www.instagram.com/darshanuniversity/