서브쿼리 한방에 정리해 줌

안녕하세요, SQL전문가 정미나입니다.

이번 영상은 서브쿼리 1탄입니다.

1탄. 중첩 서브쿼리 - where 절, having 절
중첩 서브쿼리는 다시 단일행 서브쿼리와 다중행 서브쿼리로 나뉘는데요, 영상 보시고 실습을 통해 상세히 알아가는 시간 되셨으면 좋겠습니다.

2탄, 3탄은 아래와 같이 준비할 예정이니 기대해 주세용~

2탄. 인라인 뷰 - from 절
3탄. 스칼라 서브쿼리 - select 절


그럼 오늘도 즐거운 하루 되세요! 뿅~♡


#데이터베이스 #전문가 #SQL

Database Project for MS SQL Server

This project uses the Westlake Database project. It adds the tables needed to patient visits / symptoms, adds stored procedures, triggers and indexes, and asks the student to create views using query skills learned previously.

The importance of database security to prevent SQL injection attacks is also demonstrated, and mitigated through the use of stored procedures. In addition, indexes are discussed and demonstrated.

SQL Tutorial - Full Database Course for Beginners

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.

Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.

You can get PopSQL to follow along here: http://popsql.com/freecodecamp

Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables \u0026 Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update \u0026 Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas

Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw

Follow Mike on Twitter: http://twitter.com/mike_dane

The Giraffe Academy website: http://www.giraffeacademy.com/

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp

...