Object-Oriented Web Applications

course aims in English
  Support theoretical background and practical skills for creating web applications with complex structure. 
  
brief description of course content in English

   Main concepts in object-oriented programming. Class, object, access levels. Class and instance fields and methods. Using classes for structurating server-side web applications. Design class and object structure in applications. User interface creation with objects and HTML page templates. Moving data between objects and database. Using subclasses for versatile behaviour of objects. Data saving using subclasses. Testing objects with unit-tests. Graphical tests with Watir. Object-Oriented Javascript. Object prototyping. Objects in web browser. Designing web page with indepentent components. Synchronous and asynchronous data communication between client and web server. XML and JSON. Analyze of existing web applications. With independent work are needed to finalize examples started in class.
independent work in English
  Finishing programming examples by subjects studied at school.

learing outcomes in English
  Course participant knows possibilities to structure his web application. He can analyze good and bad possibilities and approximate amount of work with different structures.
  
  He can develop three-tier web applications, where are separated user interface, business logic and data storing.
  
ways of assessment in English
  Explanation of 5 independent works, control work and seminar. For finishing course, all things must be done. With exception solving hardest item in control work allows not to do one independent work.
responsible lecturer
  Jaagup Kippar
study literature
  PHP Classes and Objects.  http://www.php.net/manual/en/language.oop5.php
  Andris Reinman. JavaScript edasijõudnutele. http://tahvel.info/javascript:advanced
replacement literature
  Finishing course with replacement literature is possible only with special plan scheduled with teacher.
  
  
Database Lab  
  
course aims in English
  Support theoretical background and practical skills for creating and using middle-size databases. 
brief description of course content in English
  Main concepts with relational databases: database, table, field, data type, row. SQL commands for creating and changing data table. Commands for insert, update and delete data. Different queries, sorting, searching. Aggregate functions and grouping data. Joining tables with queries. One to many and many to many data structures and queries with them. SQL commands handling workflow data. Subqueries replacing value, list and table. Joining subqueries for getting complicate results. Indexing, accelating queries. Automatically running triggers. Business logic with saved procedures. SQL standard and company-based additions. Planning and realizing database schema. Creating and optimizing queries with test data. Automated tools for creating database user interface. Database commands in different programming languages. 
independent work in English
  Creating own solutions based on examples started at classes.
learing outcomes in English
  Student can practitally design and develop real middle-sized databases for applications (~20 joined data tables). He can plan them, analyze structure and manipulate data with SQL. He can create different queries which are needed for applications using that database.
ways of assessment in English
   Explanation of 5 independent works, control work and seminar. For finishing course, all things must be done. With exception solving hardest item in control work allows not to do one independent work. 
responsible lecturer
   Jaagup Kippar
study literature
   Kippar, Jaagup, Savisaar, Erki. Andmebaasipõhiste veebirakenduste arendamine Microsoft Visual Studio ja SQL Server’i baasil. SQL ja andmed. Tallinn, 2010.
   http://minitorn.tlu.ee/~jaagup/kool/java/loeng/dotnet/sql.docx

   Eessaar, Erki. Andmebaaside projekteerimine. Tallinna Tehnikaülikool 2008.

replacement literature
  Finishing course with replacement literature is possible only with special plan scheduled with teacher.