FREE SHIPING FOR OVER $100 - MOSTLY SHIP VIA USPS GROUND ADVANTAGE %D days %H:%M:%S
조용학
저자:조용학 ㈜씨에스리TL-LAB랩장,정보관리기술사,정보시스템수석감리원 게임개발자로스페셜포스,드래곤히어로즈등다수의유명게임을개발했다.PC온라인,모바일,VR등다양한플랫폼뿐만아니라클라이언트에서서버에이르기까지거의모든분야에서의개발경험을가지고있다.사람들에게보다유용한소프트웨어를개발하고싶다는마음에분야를넓혀현재는데이터베이스및빅데이터관련솔루션개발을하고있다.최근에개발한솔루션으로노코드빅데이터분석솔루션(빅재미)과데이터베이스전환및모델링솔루션이있다.솔루션개발외에정보관리기술사로서공공빅데이터청년인턴십1~3기강사,멘토로참여했고현재에도다양한빅데이터분석및인공지능개발자과정의강의를맡아지식전달에도힘쓰고있다.
[1과목]데이터모델링의이해__Chapter1데이터모델링의이해____1.1데이터모델의이해______1.1.1모델링의개념______1.1.2모델링의특징______1.1.3모델링의세가지관점______1.1.4모델링의세가지단계______1.1.5ANSI-SPARC에서정의한3단계스키마구조______1.1.6ERD____1.2엔터티______1.2.1엔터티의개념______1.2.2엔터티의특징______1.2.3엔터티의분류____1.3속성______1.3.1속성의개념______1.3.2속성값______1.3.3엔터티,인스턴스,속성값______1.3.4속성의분류______1.3.5도메인____1.4관계______1.4.1관계의개념______1.4.2표기법____1.5식별자______1.5.1식별자의개념______1.5.2주식별자______1.5.3식별자의분류______1.5.4식별자관계,비식별자관계____출제예상문제__Chapter2데이터모델과SQL____2.1정규화______2.1.1제1정규형______2.1.2제2정규형______2.1.3제3정규형____2.2관계와조인의이해______2.2.1반정규화가필요한상황______2.2.2테이블반정규화______2.2.3칼럼반정규화______2.2.4관계반정규화____2.3모델이표현하는트랜잭션의이해______2.3.1트랜잭션의개념____2.4Null속성의이해______2.4.1Null의개념____2.5본질식별자vs인조식별자____출제예상문제[2과목]SQL기본및활용__Chapter3SQL기본____3.1관계형데이터베이스개요______3.1.1데이터베이스______3.1.2관계형데이터베이스______3.1.3TABLE______3.1.4SQL____3.2SELECT문______3.2.1SELECT______3.2.2산술연산자______3.2.3합성연산자____3.3함수______3.3.1문자함수______3.3.2숫자함수______3.3.3날짜함수______3.3.4변환함수______3.3.5NULL관련함수______3.3.6CASE____3.4WHERE절______3.4.1비교연산자______3.4.2부정비교연산자______3.4.3SQL연산자______3.4.4부정SQL연산자______3.4.5논리연산자____3.5GROUPBY,HAVING절______3.5.1GROUPBY______3.5.2집계함수______3.5.3HAVING____3.6ORDERBY절______3.6.1ORDERBY____3.7조인______3.7.1조인의개념______3.7.2EQUIJOIN______3.7.3NonEQUIJOIN______3.7.43개이상TABLEJOIN______3.7.5OUTERJOIN____3.8표준조인______3.8.1INNERJOIN______3.8.2OUTERJOIN______3.8.3NATURALJOIN______3.8.4CROSSJOIN____복합쿼리예제-1____복합쿼리예제-2____출제예상문제__Chapter4SQL활용4.1서브쿼리______4.1.1스칼라서브쿼리______4.1.2인라인뷰______4.1.3중첩서브쿼리____4.2집합연산자______4.2.1UNIONALL/UNION______4.2.2INTERSECT______4.2.3MINUS/EXCEPT____4.3그룹함수______4.3.1ROLLUP______4.3.2CUBE______4.3.3GROUPTINGSET______4.3.4GROUPING____4.4윈도우함수______4.4.1순위함수______4.4.2집계함수______4.4.3행순서함수______4.4.4비율함수____4.5TopN쿼리______4.5.1ROWNUM함수______4.5.2윈도우함수의순위함수____4.6계층형질의와셀프조인______4.6.1계층형질의______4.6.2셀프조인____4.7PIVOT절과UNPIVOT절______4.7.1PIVOT절______4.7.2UNPIVOT절____4.8정규표현식____복합쿼리예제-3____복합쿼리예제-4____출제예상문제__Chapter5관리구문____5.1DML______5.1.1INSERT______5.1.2UPDATE______5.1.3DELETE______5.1.4MERGE____5.2TCL______5.2.1트랜잭션의특징______5.2.2COMMIT______5.2.3ROLLBACK______5.2.4SAVEPOINT____5.3DDL______5.3.1CREATE______5.3.2ALTER____5.4DCL______5.4.1USER관련명령어______5.4.2권한관련명령어______5.4.3ROLE관련명령어____출제예상문제__Appendix____(복원)기출문제1회____(복원)기출문제2회____(복원)기출문제3회____(복원)기출문제4회____(복원)기출문제정답및해설____Oracle실습환경설치가이드
어떤독자를위한책인가?-.SQLD자격시험을준비중인수험생,취업준비생-.SQLD개발자,애플리케이션개발자#SQLD14일합격#SQLD모든것#SQLD개발자쿼리문제풀기를포기하고기출문제를외워서시험합격,NO!시험이끝나도까먹지않는진짜SQL실력보장,YES!--------------------------------------------------------------------------------------*SQLD모의고사를풀어볼수있는온라인CBT무료제공__https://cbt.ilifo.kr*QR코드로바로확인할수있는동영상강의__꼭필요한핵심개념부터SQL구문,문제풀이까지*Q/A,커뮤니케이션,피드백제공__Q/A및정오표,SQLD14일스터디운영,기출문제복원/도서리뷰/합격후기이벤트__아이리포카페cafe.naver.com/ilifobooks*합격을위한학습전략,14일학습플랜__시간이부족한수험생을위해빠르고,효율적으로학습할수있는플랜안내*SQLD합격생여섯명이도서기획부터검토·문제풀이까지참여__“제가만약이책으로공부했더라면이해하지못한기출문제를무작정외우지는않았을겁니다”__“확실하게알지못하고풀었던SQL구문이이책을보니이해가됩니다.다시시험친다면100점맞을것같아요!”
