/DB_SQL_practice

sql practice

SQL Practice

leetcode

https://leetcode.com/study-plan/sql/?progress=xkrbglo7

SQL I language : mysql

solved list (incomplete)

topic problem
SELECT 595, 1757, 584, 183*, 1873
UPDATE 627
DELETE 196
String manipulation 1667, 1484*, 1527
UNION 1965
LEFT JOIN 175
NOT EXIST 1581*
CASE WHEN 1393
IFNULL 1407
DATEDIFF 197*
YEAR() 1158

hackerrank

basic select

sqlcourse

done list

  • beginner
    • select
    • create table
    • insert into
    • update set
    • delete
    • drop table
  • advanced
    • distinct
    • aggregate functions
    • group by
    • having
    • order by
    • and, or
    • join