2.26-3.04 > SQL queries

DBMS lectures&practices [2.26-3.4]

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

Results [2.12-26-3.4] > what had happened?

  • Initial surveys > Selin, Konstantina, Besim, Arlan, Oman, Dima[3.4] > thanks, waiting the rest ones [Georgios? etc.].
  • Web hosting & wordpress install > Selin, Konstantina, Besim, Arlan, Georgios, Osman, Christina [Dima? Marie? Renad?].
    • WP features analysis & demo? description? > Besim[adapted+, description?], Arlan[theme~, description?] /feb-mar/
      [e.g., wp themes, plugins, posts, pages, menus, widgets, editors, tools, config., etc.]
    • 3.4 Georgios [restoran&cafe; adapted; description?[vision, wp possibilities demo, etc.]] > presentation? when?
    • 3.4 Osman [one of 10 top themes demo] > description? > presentation? when?
    • 3.4 Christina > makeup ..
  • SQL intro > some simple SQL queries demo & publishing? > Besim [SQL, phpMyAdmin] /mar/
  • 1st actualities selected
    • 3.4 > Besim > “wordpress modern features!“? -> why actual? where’s problem? conclusions? sources? -> when presentation? 3.4?
    • 3.4 Osman > may be 1st actuality about > analysis of top wp themes?

Today’s practice  [2.26] > Structure Query Language [SQL]

  • SQL is a key step in understanding DBMS
  • SQL sources & tools
    • Lecture slides about SQL > here
      • in slides you will find about SQL [condensed]
        • SQL syntax [condensed]
        • Main types of  SQL queries examples [with short descriptions]
    • W3schools SQL tutorial & emulator > here < try it
      • Tutorial is provided with correct and practically useful information about SQL
      • Emulator includes certain business database with related tables
    • phpMyAdmin > the client application to manage online DBMS [MySQL] > here
      • phpMyAdmin tutorial > here
    • Literature > Db. Sol. [pdf, ppt], ~Db. Sys. [pdf]
    • etc.
  • Analyze SQL sources [above]
    • Try selected types of SQL queries and publish actual results [e.g., 10 typical SQL queries]
      • Queries demo [with w3schools.emulator & phpMyAdmin.MySQL]
        • SELECT queries
          • Simple queries > try with w3schools
            • Then realise them with your phpMyAdmin
              • for SQL demos > create a Table and fill it with data first
            • if result is actual for you > publish in your webpage
              • problem > solution > demo [phpMyAdmin report]
          • Usage of DISTINCT ..
          • Usage of WHERE ..
          • Usage of AND / OR ..
          • Usage of ORDER BY ..
          • Usage of LIKE, wildcards ..
          • ..
          • Usage of Aliases ..
          • Usage of Queries with
            • Calculated fields ..
            • Aggregate functions ..
          • ..
          • Queries with some related tables
        • UPDATE ..
        • DELETE ..
        • INPUT ..
        • CREATE TABLE ..
      • Your SQL query examples?
    • w3schools SQL quiz > here
    • Problems? Questions?
  • For the next week [3.4 ..]
    • *First actuality theme selection [~about wordpress]
    • Intro to DBMS > slides1, slides2 [Db. Sol. > pdf,]
      • There you will find about > slides1
        • Common uses of DB systems
        • Meaning of the terms
        • Components of the DBMS environment
        • Typical functions of DBMS
        • Adv./disadv. of DBMSs
      • And about other DBMS peculiarities > slides2
        • Terms of relational data model
        • Tables & data
        • Properties of DB relations
        • Candidate, primary, foreign keys
        • Entity & referential integrity
    • 1st colloquium > quiz > ~end of march > http://vma.esec.vu.lt

——————————————————————————————————————–

  • *First actuality > DBMS actual theme selection > ~about WordPress
    • e.g., about: 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).