데이터베이스 과정

▷ SQL 기초

• Select, Distinct 문
• where 조건문의 사용
• 논리연산(AND, OR, NOT Operator)
• Sorting(Order by) Keyword
• Insert Into 문
• Min, Max, Count, Avg, Sum 함수
• Like Operator와 Wildcard
• In, Between, Aliases 구문
• 조인(Inner, Left, Right, Full, Self Join)
• Union, Group By, Having 절
• Select Into 문
• Insert Into Select 문
• Case 문

▷ SQL Databse

• 데이터베이스 관리(Create, Drop, Backup)
• 테이블 관리( Create, Drop, Alter)
• Constraints, Unique
• Primary Key 설정
• Foreign Key 설정
• Check, Default Constraint
• Create Index Statement
• Create View Statement
• SQL Data Type

▷ PostgreSQL PL/pgSQL

• PostgreSQL PL/pgSQL 개요
• Variables & constants
• Reporting messages and errors
• Control structures
• User-defined functions
• Exception handling
• Stored procedures
• Cursors
• Trigger functions

▷ MongoDB

• NoSQL MogoDB의 개요
• Create Database
• Create Collection
• Insert Document
• fine_one(), fine_all(), fine()
• Query Object 사용하기
• Sort the Result
• Delete Document
• Drop Collection
• Update the Collection
• Limit Method 사용하기