MySQL 데이터베이스 한번에 끝내기 SQL Full Tutorial Course using MySQL Database

MySQL을 이용해서 SQL을 배워보자 강의 페이지: http://suanlab.com/youtube.html#MySQL 00:00:35 MySQL 소개 00:01:53 MySQL 설치 00:03:51 SQL 기본 00:05:06 SHOW DATABASES 00:06:06 USE 00:07:03 SHOW TABLE, SHOW TABLE STATUS 00:07:45 DESCRIBE (DESC) 00:09:14 SELECT 00:10:59 WHERE 00:15:07 BETWEEN 00:15:51 IN 00:17:21 LIKE 00:19:01 Sub Query 00:20:27 ANY(SOME) 00:22:02 ALL 00:22:56 ORDER BY 00:26:16 DISTINCT 00:27:02 LIMIT 00:28:19 GROUP BY 00:31:04 HAVING 00:32:31 ROLLUP 00:33:56 JOIN 00:35:34 MySQL 내장함수 00:35:50 LENGTH() 00:36:07 CONCAT() 00:36:39 LOCATE() 00:37:20 LEFT(), RIGHT() 00:38:14 LOWER(), UPPER() 00:38:46 REPLACE() 00:39:21 TRIM() 00:40:40 FORMAT() 00:41:21 FLOOR(), CEIL(), ROUND() 00:41:54 SQRT(), POW(), EXP(), LOG() 00:42:25 SIN(), COS(), TAN() 00:42:45 ABS(), RAND() 00:44:00 NOW(), CURDATE(), CURTIME() 00:44:29 DATE(), MONTH(), DAY(), HOUR(), MINUTE(), SECOND() 00:45:18 MONTHNAME(), DAYNAME() 00:45:43 DAYOFWEEK(), DAYOFMONTH, DAYOFYEAR() 00:46:27 DATE_FORMAT() 00:47:05 SQL 고급 00:47:10 CREATE TABLE AS SELECT 00:48:15 CREATE DATABASE 00:49:02 CREATE TABLE (MySQL Workbench) 00:50:37 CREATE TABLE 00:52:12 ALTER TABLE (ADD, MODIFY, DROP) 00:53:58 인덱스 Index 00:55:17 CREATE INDEX 00:55:43 SHOW INDEX 00:56:42 CREATE UNIQUE INDEX 00:57:15 FULLTEXT INDEX 00:58:06 INDEX 삭제 (ALTER) 00:58:27 DROP INDEX 00:58:55 VIEW 01:00:05 CREATE VIEW 01:00:45 ALTER VIEW 01:01:05 DROP VIEW 01:04:34 INSERT 01:05:25 INSERT( MySQL Workbench) 01:06:11 INSERT INTO SELECT 01:06:58 UPDATE 01:07:52 DELETE 01:08:43 TRUNCATE 01:09:16 DROP TABLE 01:09:35 DROP DATABASE 사용되는 소프트웨어 버전 MySQL 8.0, MySQL Workbench SuanLab 이수안컴퓨터연구소 Web Site: http://suanlab.com Facebook:   / suanlab   채널 후원하기: https://buymeacoffee.com/suanlabn