mysql프로그램

페이지 정보

profile_image
작성자호빵맨 조회 27회 작성일 2021-06-09 19:58:52 댓글 0

본문

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: https://www.facebook.com/suanlab
김민호 : MySQL 라디오 듣는 중 ㅋㅋㅋㅋ
Hayoung Lee : 20210315 1:11:11 2nd
고등학생 : 자세부터 쌉고인물의 스멜이 느껴져서 믿음직스러움 ㅋㅋㅋㅋ
그냥TV : 좋은 영상 감사합니다 ㅎㅎ
정성윤 : 정말 좋은 강의 감사하빈다!!

[2020개정판]이것이 MySQL이다(8.0)05장-01교시 MySQL Workbench 사용법 - 관리툴

※ 이 동영상은 『이것이 MySQL이다』 책 내용을 토대로 제작되었습니다.
▶ 도서 자세히 보기 : https://www.hanbit.co.kr/store/books/look.php?p_code=B2064300579
※ 이 동영상은 『이것이 MySQL이다』 책 내용을 토대로 제작되었습니다.
▶ 도서 자세히 보기 :https://www.hanbit.co.kr/store/books/look.php?p_code=B2064300579 도서 해당내용
chapter05. MySQL 유틸리티 사용법(p137~p151)
- MySQL Workbench의 버전과 실행
- [MySQL Connections] 창
- MySQL Workbench의 화면 구성
JIHO SONG : 20.12.19 3일차 시작 지점
kay Min : 영상 감사합니다.
mysql local host를 이용하여 개발이 끝나고
웹서버 개인 도메인에서 실행을 하려면
db host 를 어떻게 바꿔야 하나요?
($db_host ="localhost:3306"; ---> $db_host ="http://www.advina.co.kr"; )
이 방법이 아닌가요?
Sangsik Kwak : 안녕하세요?
"이것이 Mysql"이다 를 동영상과 책으로 공부하고 있습니다. Mysql 8.0을 컴퓨터에 인스톨 할 때 심중하게 했으나, 동영상 설명시 제데로 되지 않아 고민하고 있습니다.
Workbench ADMINISTRATION SERVER STATUS를 동영상 화면과 대조해보니 내컴퓨터 화면과 강사님 동영상 화면이 다른 점이 있어 강사님 화면과 같이 수정 가능한지 문의 합니다.
1. Connection name : Local instance MySQL(강사님) - new connection(본인 컴퓨터)
2. Host : DTSOLUTION(강사님) - SSKWAK(본인 컴퓨터, 제 이름약자)
3. temp Directory : c:\user\public\Documents\ESTsoft\creatorTemp(강사님) - c:\windows\servic~1\NETWOR~1\Local\Temp(본인)
4. Eerror Log : (green) on .\DTSSOLUTION.err (강사님) - (green) on .\SSKWAK.err(본인)
5. Slow Query Log : (green) on DTSSOLUTION-slow Log(강사님) - (green) on SSKWAK-slow Log(본인)
이상과 같이 다른점이 있어 강사님의 고견을 듣고 싶습니다. 제 메일은 sskwak217@hotmail.com 입니다.

MySQL Tutorial for Beginners [Full Course]

MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database.
Want to master MySQL? Get the full MySQL course: http://bit.ly/2uAoPM3
Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF

⭐️Want to learn more from me? Check out these links:

Courses: https://codewithmosh.com
Twitter: https://twitter.com/moshhamedani
Facebook: https://www.facebook.com/programmingwithmosh/
Blog: https://programmingwithmosh.com

Get my FREE SQL cheat sheet:
http://bit.ly/2JCO73l

Scripts to create the databases in this course:
http://bit.ly/2LNdvCd

TABLE OF CONTENT

0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases

If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time.

SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.

There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems.
nikoloz gabidzashvili : mosh you are treasure of world
❤❤❤
Fereshteh Mehrnia : Thank you so much for this helpful video.
Aradog321 : 1:51:30
MOURYA : cheatsheet is 404...gone , hey Mosh can you hear ...:)
Federico Coronati : Amazing course, everything is very well explained and took time to give exercises. Thank you a lot!

... 

#mysql프로그램

댓글목록

등록된 댓글이 없습니다.

전체 4,477건 11 페이지
게시물 검색
Copyright © www.aidsmove.net. All rights reserved.  Contact : help@oxmail.xyz