FASE 5: TALLER VIRTUAL EN LINEA SOBRE LENGUAJE SQL
PRESENTADO POR: SERGIO IVAN RODRIGUEZ COD: 1.122.135.835
GRUPO: 301330_31
PRESENTADO A: IBO LUIS CERRA DIRECTOR DEL CURSO
UNIVERSIDAD UNIVERS IDAD NACIONAL N ACIONAL ABIERTA Y A DISTANCIA UNAD PROGRAA: INGENIER!A DE SISTEAS NOVIEBRE DEL 201" VILLAVICENCIO
INTRODUCCION E# $%&$ &'()(*+ &'()(*+ %$ ,,$-( ( ()+ ,( /$#&//( /$#&//(/# /# $ ,+% '/#/(,$% '/#/(,$% +4$#&+% +4$#&+% $, P'+$%+ $ D/%$+ $ B(%$% $ D(&+% R$,(/+#(,$%6 $ $%&$ 4++ /$#&//(#+ ,(% '/#/(,$% 7$''(4/$#&(% &$#+,/(% 9 4$&++,/(% /#-+,'((% $# $, P'+$%+ $ D/%$+ $ B(%$% $ D(&+% R$,(/+#(,$%; L$+ %$ A,/( ,+% +#+/4/$#&+% ('( +#&$<&(,/=(' # '+$%+ $ ,( +'(#/=(/# >$ &$#( '+),$4(% +# (&+%. E, ,$# ,$#( (*$ *$ $ +#% +#%, ,&( &( $%&' $%&' & &'( '(+ + ?SQL ?SQL@@ $% # ,$# ,$#( (*$ *$ $ )(%$ )(%$ $ (&+ (&+%% #+'4(,/=(+; &/,/=(+ +' $, 4+&+' $ )(%$ $ (&+% $ /'+%+& J$&. SQL $# $, (, '(/(% (, $#&+'#+ $ +'(,$; $# $, (4)/$#&$ $< &'()(*('$4+% 9 $*$&('$4+%
#( '(# (#&/( $ %$#&$#/(% ('( (%/ +$' -$' %% '$%,&(+% 9 (#(,/=(',+%.
A&/-/( 1: C(( #+ $ ,+% 4/$4)'+% $, G'+ $ T'()(*+ C+,()+'(&/-+ $)$ (%/%&/' + '$-/%(' ,( '()(/# $ ,(% $) +#$'$#/( 5 9+ L( '()(/# $ ,+% T(,,$'$% $ ,( F(%$ 5: T(,,$' V/'&(, $# L#$( %+)'$ L$#(*$ SQL ?+$,+ F%/+@ $# +#$ %$ 4$%&'(; $#&'$ +&'+% &$4(%: 1. T(,,$' I#%&(,(/# $ +)*$&+% $ )(%$% $ (&+% $# $, E%>$4( (%/#(+ ( (( $%&/(#&$ $# $, IDE O'(,$ A$<. P('( &$#$' ($%+ ( ,(% &(),(% 9 (&+% >$ %$ &/,/=('# '(#&$ ,( F(%$ 5 L$#(*$ SQL; $)$ $*$&(' # ('7/-+ $ S'/& DDL; $# ,( $#&( $ O'(,$ ?A$<@ %4/#/%&'((.
2. T(,,$'$% $ SQL: E, $%&/(#&$ $)$ 7($' ,/ $# (( #+ $ ,+% %//$#&$% -#,+% 9 %$/' ,(% /#%&'/+#$%. E%&(% )%/(4$#&$ /#/(# >$ $*$&$ $# $, (4)/$#&$ APE; $# ,( %$/# SQL COANDS ,( %$#&$#/( SQL 9 +)%$'-$ 9 (#(,/$ $, '$%,&(+. E,
$%&/(#&$ $)$ &'(&(' $ 7($' (( #( $ ,+% &(,,$'$% ('( >$ %$ -(9( (4/,/('/=(#+ +# ,(% S$#&$#/(% $, L$#(*$ SQL. E, '$%,&(+ $ $%&( (&/-/( +#%/%&$ $# >$ $, $%&/(#&$ $#&'$( # /#+'4$ $ % $<$'/$#/( +# $, %+ $ ,(% S$#&$#/(% $, L$#(*$ SQL B%/+ >$ %$ '$%$#&( $# ,+% &(,,$'$%6 +/(#+ 9 $(#+ $, '$%,&(+ $ (( #( $ ,(% %$#&$#/(% %((% $# ,+% &(,,$'$% ?A>$,,(% >$ '$%$#&(# '$%,&(+%@. SQL +' B$/##$'% ?P('& 1@ : T7$ SELECT L/%& /,(' HH
SQL +' B$/##$'% ?P('& 2@ : T7$ FRO C,(%$
P/$,/#$ T(),$ F#&/+#%
E<'$%%/+#%
SQL +' B$/##$'% ?P('& 3@ : T7$ ERE C,(%$
BETEEN (# NOT BETEEN C+#/&/+#%
LIKE (# NOT LIKE C+#/&/+#%
SQL +' B$/##$'% ?P('& @ : S$& O$'(&+'%
UNION
INTERSECT
SQL +' B$/##$'% ?P('& 8@ : T7$ INSERT S&(&$4$#&
SQL +' B$/##$'% ?P('& M@ : T7$ UPDATE S&(&$4$#&
CONCLUSIONES P+$4+% +)%$'-(' +4+ $# (( -#,+ $#+#&'(4+% /$'$#&$% %$#&$#/(%6 ,(% (,$% #+% ()'$# # (4/#+ #$-+ $# ,(% )(%$% $ (&+% (/,/&(#+ ( % -$= $# $, 4(#$*+ $ /7(%. (9 47(% #/+#$%; +#//+#$% 9 +$'(+'$% +# ,+% >$ &'()(*(4+% '(#&$ $, &'()(*+ +# SQL; $'+ &++% %+# (//+#$% ( $%&( )(%$. L$+ $ C+4'$#$' $ 4(#$'( ($(( ,+% +#$&+% )%/+% ,(% $4% +%(% $#(*('# $# $, &/$4+ (% &$#/$#+ #( 4$*+' +4'$#%/# $, &$4(. T(4)/# $)$ &$#$' $# $#&( >$ ,+ >$ %$ $%'/)$ #+ $% %/$4'$ ,+ >$ O'(,$ $*$&(. E# (,#+% (%+%; $, +&/4/=(+' &'(#%+'4(' % $,('(/#. P+' $*$4,+; #( +#//# IN >$ &/,/=( #( ,/%&( %$ $$ $<(#/' ( # '+ $ +#//+#$% $ /(,( -/#,((% +# +#//+#$% OR. A 4$/( >$ %$ $%(''+,,(; &$#' >$ $4$=(' ( +#%/$'(' $%&+ (, $,$/' ,(% +#//+#$% $ /,&'+ >$ %$ &/,/=('#6 $# 47(% %$#&$#/(% &(4++ %$ $*$&( #(( #/ %$ 4$%&'( (,# (&+ %+,+ (''+*(#+ $''+'. Vinculo drive: https://drive.google.com/drive/folders/11VMzs0tznxskWCxuU0t0!"z#$ #%im&#'usp(sh)ring
