MYSQL구입

페이지 정보

profile_image
작성자코난 조회 5회 작성일 2021-10-23 09:44:31 댓글 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
쉽게 알려주는남자 : 말도 나근나근 한데 핵심만 쪽쪽 뽑아내시면서, 컨텐츠는 왜 또 괴물이시고,
강의준비는 또 왜이리 체계적이신가요?
진짜 너무 좋네요 ㅎㅎㅎㅎ
Askforme : 17:00 라이크 19:00 서브쿼리 23:00 오더바이 59:00 뷰 47:00 테이블 만들기 55:20 인덱스
주연우 : 너무 좋은 강의에요 선생님!
고명범 : 아..... 내 등록금!!
이 강의가 대학보다 더 잘 가르치잖아!!
ᄋᄋ : 고맙습니다! 우연히 SQL에 관심이 생겼는데 정말 재밌고 정리를 잘 해주셔서 이해가 잘 됐어요~

MySQL Tutorial - 16강 조인(join)

1. 처음 시작하는 MySQL DataBase 할인 쿠폰
https://www.udemy.com/softcampus-mysql/?couponCode=SOFTMYSQL

2. 처음시작하는 구글 공식 개발 언어 : 코틀린(Kotlin) 할인 쿠폰
https://www.udemy.com/softcampus-kotlin/?couponCode=SOFTKOTLIN

유데미에서 서비스 되는 소프트캠퍼스 강의 아래 경로를 통해 수강신청하시면
무조건 $9.99에 결재 됩니다.

3. Mobile App UI UX GUI Design Tutorials(모바일 앱 UX UI GUI디자인 실무) 할인쿠폰
https://www.udemy.com/mobpp-uxui-design-working-level-uxui/?couponCode=SOFTUXUI

4. 코틀린 기반 안드로이드 기본(Kotlin for Android: Beginner) 과정 할인 쿠폰
https://www.udemy.com/sofrtcampus_adroid/?couponCode=SOFT_KAD

5. 유니티 클릭커 게임 과정 할인 쿠폰
https://www.udemy.com/unity3d-clicker/?couponCode=SOFTCLICKER

6. 개발자 및 디자이너를 위한 HTML \u0026 HTML5 Tutorials 할인 쿠폰
https://www.udemy.com/softcampus-html5/?couponCode=SOFTHTML

7. node.js server Tutorials 할인 쿠폰
https://www.udemy.com/nodejs-server-tutorials/?couponCode=SOFTNODE

8. 처음시작하는 JQuery programming 할인 쿠폰
https://www.udemy.com/softcampus-jquery/?couponCode=SOFTJQ

9. 처음시작하는 JavaScript Tutorials 할인 쿠폰
https://www.udemy.com/softcampus-javascript/?couponCode=SOFTJAVAST

10. 개발자 및 디자이너를 위한 CSS \u0026 CSS3 Tutorials 할인 쿠폰
https://www.udemy.com/css-css3-tutorials/?couponCode=SOFTCSS

11. 처음시작하는 파이썬(Python) 할인 쿠폰
https://www.udemy.com/python-soft/?couponCode=SOFTPYTHON

12. unity 3D(유니티 3D) defense game(디펜스 게임) 할인 쿠폰
https://www.udemy.com/softcampus-unitydefense/?couponCode=SOFTDUNITY

강사 : 윤재성(소프트캠퍼스 선임연구원)
자바스크립트 샘플 강의를 무료로 제공합니다.
강의 제공 및 저작권 : 아이폰 안드로이드 스마트폰 디자인 교육센터 (주)소프트캠퍼스 http://www.softcampus.co.kr
기타 강의 의뢰 및 문의 : softcampus.co.kr@gmail.com
저작권 : 소프트캠퍼스 원격평생교육원
제작: 2017년 8월
조승호 : 잘 봤습니다~~ 감사합니다
몽삼 : 잘 봤습니다 감사합니다
Shota Nishikata : 이해너무잘됬어요 고맙습니다.
리풀 : 예제가 너무 복잡한 예를 들어 오히려 이해하기 복잡해요.
テテ : 이것도 이해 안되면 걍 하지마삼

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.
bruto6666 : The tutorial is great, I have seen the other java and python tutorials and your teaching methodology is really GREAT. You are an excellent teacher and I will definitely follow the most advanced SQL and Python that you have on your website. Thank you very much for taking the time to teach more people.
Nawal Mirza : THIS IS AN AMAZING TUTORIAL FOR NON-PROGRAMMERS!

May God bless you with success and good health. Thank you so so much :)
Hamaam cabdala Axmed : The feeling when you finish all of this in just 4 days is unbelievable. Thank you mosh for stepping out your comfort zone and giving us free valuable lectures that'd may be cost us a lot of money if we were to take from other courses online.
Mazhar khan : lied in my cv and got a full-time job as a data analyst so learning this for the first time
Hayley : Absolutely amazing course - thank you!!! Just leaving a comment for the algorithm ;)

... 

#MYSQL구입

댓글목록

등록된 댓글이 없습니다.

전체 5,674건 1 페이지
게시물 검색
Copyright © www.nswc.or.kr. All rights reserved.  Contact : help@oxmail.xyz