2.19 > intro to SQL

AIMS > 1st TASK [web hosting, CMS with DBMS (WordPress)]  > 2nd TASK [SQL intro]

First week results

•  First task > Web Hosting? > WordPress 5 min. install?
• Autonomous work >  Initial survey? > WordPress features demo? > description of results
  [themes?, plugins?, posts?, pages?, menus?, widgets?, editors?, tools?, config.?, etc. ]

For today [2.19] > 9-11; 11-13

1. Continuation of the first task [feb-mar]
2. First DBMS actuality theme [feb-mar] > theme selection > about WordPress, e.g.,
   • WP technologies analysis, WP theme adapting, WP alternatives, WP SWOT analysis, CMS analysis, WP plugins, WP analytics, WP mobile, .. etc.
   • process: sources finding, analysis (argumented, with samples) , presentation and publication of results.
   • presentation: title, author, actuality, problem, arg. analysis, findings, sources (>1).
3. Introduction to SQL (simple queries; lecture & practice)

Lecture [2.19] > Introduction to SQL > slides

1. Simple SQL queries [analysis & demo]
2. Tools, sources
   • w3schools 
   • phpMyAdmin [on your server][tutorial]
   • Db. Sol. [pdf, ppt], Db. Sys. [pdf]

Practice [2.19] > 1st task continuation; simple SQL demo

1. 1st task continuation [WP]
2. SQL
   • practice actual SQL queries > w3schools
     • SQL > intro > syntax
     • SELECT > DISTINCT > WHERE > AND > OR > ORDER > LIKE > UPDATE > .. etc.
     • do SQL quiz > send result to the lecturer (regimantas.pranaitis@ff.vu.lt)
   • practice SQL queries with your phpMyadmin [use your Hosting > DBMS >MySQL]
     • create simple table > fill it with data
     • demo different actual SQL queries
     • publish main different results in your webpage (wordpress)