IIO30220 Database management (Tietokannan hallinta) - schedule 2015
Teaching in D327 on Tuesdays at 8.15 - 11.30
Week	Date	Hrs	Themes/teemat	Assignments		Suomeksi
36	1.9.	2	Introduction	Optima, assignment (quiz) 1
		0,5	Learning report	Set your own goals		Työmäärien ja aikaisempien toteutusten esittely
		0,5	Research report topics	Choose a topic for your research report
		1	Azure Websites on OpenSource	Optional webinar starting at 11
37	8.9.	4	DBA roles, DBMS structure	Optima, assignment (quiz) 2
38	15.9.	0	Reverse engineering	Read and learn from previous reports
39	22.9.	2	MySQL administration	Examine a PaaS solution such as OpenShift and install PHP, MySQL and PhpMyAdmin
		1	NoSQL - no problems?	MongoDB excercises
		1	NoSQL databases, MongoDB
40	29.9.	1	PostgreSQL and other open source databases	Examine PostgreSQL web site
		1	MariaDB and history of MySQL	Examine MariaDB web site
		2	MySQL administration	Reverse engineering etc.		Muut Open Source -tietokannat
41	6.10.	4	SQL Server, part I  (Esa Salmikangas)	Get familiar with SQL Server
42	13.10.	0	No lectures (distance learning week)	Examine NoSQL Databases
43	20.10.	4	SQL Server, part II (Esa Salmikangas)
44	27.10.	2	Physical design	Write a database management plan (DBMP)		Fyysinen suunnittelu
			Transaction management, part 1	Optima, assignment (quiz) 3
		2	Creating a prototype	Create a prototype for your database
45	3.11.	4	Database Security	Security plan for your own database (=> DBMP)
46	10.11.	1	Transaction management, part 2	Install lab environment, do the exercises & quiz 4		Tapahtumien hallinta
		3	Index Design and Database Performance	Generate data to MySQL database
47	17.11.	0	No lectures; write your research report
48	24.11.	2	Big data management (Hadoob etc.)
		2	Answers to exercises; tips for exam	Remember: all assignments due this day!
49	1.12.	4	Examination (first theoretical part, then applied part)
50	8.12.	4	Presentations, summary and evaluation	Return all documents to Optima
51	15.12.	4	Re-exam in D327 at 8.15
	Total	52
	plus	13,5	Virtual learning, e.g.	SQL Server Learning Center Resources
	Last update: 2.11.2015			See also Database design course
	© Jouni Huotari