+44-20-3695-1294 (ID:288445)
Not a customer yet? Sign up now!

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

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


MySQL을 이용해서 SQL을 배워보자 강의 페이지: 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: Facebook:
source

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Visit Us On FacebookVisit Us On Youtube