??? ??? : ???????? ?? ???? SQL ? ??????? ????
- ?????? ?? ?????? ???? - DBMS - ????? ?????? ??????? - ????? SQL - ???????? ????? SQL - ??????? ?????????? ? ?????????? - ?????? ?? ??? ????? - ???? ??? SQL
??? ??? : ????? ?? Database
- ????? ????? ?? Database - ??? ER - ?????? ??? ?????????? - Logical Model - ???? - ???? ????? - ????? Datatype ?? ?? SQL Server - ????? ???? - ???? ??? ????? - ???? ??? ????? - ???? ??? ????? - ?????? ??????
??? ??? : ???? ??? ?? SQL Server Management Studio
- ?????? ????? ?? SQL Server 2008 - ???? ?? SQL Server Management Studio - ??????? ???????? ?????? - ???? ??? ?? SQL
??? ????? : ??? ?????? (Physical Model)
- ????? ????????? ???? - ????? ????? - ?????????? ?????? ?????? ?? ??????? ?? Constraint?? - ????? ????? ???? ??????? ?? T-SQL - ????? ????? Database? ???????? - Database Diagrams (?????????? ???? ????????) - ????? Alter - ????? ?? ?? ???? ???????? ????? ???????
??? ???? : ??????? DML
- ????? Cancel - Insert ???? ????? Identity - ????? ???? ???? ?? ????? ???????? - ????? ????? ? ???? (Getdate and Dateadd) - ????? Update - ????? Delete
??? ??? : ??????? ??????
- ???? ????? ????? ?? T-SQL - ??????? ?????? Begin ... End ? If - ????? ?????? While - ???? ??????? ?????? - ?????? ?? ????? Cast? ? ?Convert?- ????? ??? ?? ???????????? ? ??? ?????? ?? ????
??? ???? : ????? Select
- ????? ??????? ? ??? ??? Select - ????? Top ? Distinct - ??? ?????? (Alias Name) - ????????? ??????? ?? ????? Order By - ???????? ??? ?? ????? Select ?? ??????? ?? Where - ????? Like - ??? ???? ???? ????? Like - ???? ??????? ????? ???????
??? ???? : ????? ????? Select
- ??? ?? ?????? - ????? Outer Join - ????? Query??? ????? ??????? - ????? Group By?- ??? ???? ?????? Aggregate?? - ????? Having - ????? ????????? ?? Query ????? ??????? - ????? ???? ??????? Select ?? ????? - Pivot? ?? ????? ????? Cross Table - ????? ?????? ?? SQL Server 2008 - ?????? ?? Sub Query?- ???? ??????? ?? Sub Query??? - ????? Exists - ????? Union
??? ??? : View (???)
- ?????? ?? View - View ??? ??? - ????? View??? ?? ??? ??????? - ????? Case
|
