people sharing knowledge
 


home | offered | wanted | your account | about us | help


login

username

password

go

register








< back to search results
<< browse all categories

 book















Introduction to database modelling and programming

courses


 with Ivan Pavlov






short description:
This course will introduce the basic concepts of database development using PostgreSQL as an example.
 
long description:
This course will introduce the basic concepts of database development using PostgreSQL as an example. Focus will be more on real-life applications than on theory.

The course will offer introductory-level coverage of the following topics:

1. Introduction to DBMS (2h)
* Entities
* Queries
* Transactions
* Software

2. Database Design (3h)
* ER Diagrams
* Normal Forms
* Real-life example

3. Introduction to SQL (5h)
* Data types
* DDL
* Primary keys
* Example - creating your first PostgreSQL database

4. Quering the database (10h)
* Data manipulation - INSERT, UPDATE and DELETE statements
* Accessing data - SELECT statements
* JOIN clauses
* Example - Creating your first database applition

5. Advanced topics in SQL (5h)
* Foreign keys
* Views
* Indexes
* Schemas

6. Basic PL/pgSQL (5h)
* Basic Statements
* Control structures
* Triggers
 
level of difficulty:
intermediate
 
minimum class size:
1
 
availability:
n.a.
 
fee comments:
n.a.
 
 session structure




title:


type:

description:


duration:


Introduction to DBMS

live session

n.a.


2h 0m



Database Design 1

live session

n.a.


2h 0m



Database Design 2

live session

real-lefi examples


2h 0m



Introduction to SQL 1

live session

n.a.


3h 0m



Creating a real database

podium discussion

n.a.


2h 0m



Optional Test

take a test

n.a.


1h 0m



Quering the database 1

live session

Data manipulation - INSERT, UPDATE and DELETE statements


2h 0m



Quering the database 2

live session

Accessing data - SELECT statements


3h 0m



Creating your first database applition

podium discussion

n.a.


4h 0m



Optional Test

take a test

n.a.


1h 0m



Advanced topics in SQL 1

live session

n.a.


2h 0m



Advanced topics in SQL 2

live session

n.a.


3h 0m



Basic PL/pgSQL 1

live session

n.a.


2h 0m



Basic PL/pgSQL 2

review materials

n.a.


2h 0m



Final test

take a test

n.a.


1h 0m




total duration: 32h 0m over 15 session(s)
comments: n.a.
 

discussion forums: 1
 










languages: English
duration: 32h 0m over 15 session(s)
fee: 120US$  (1200lp)
payment: on satisfaction
delivery method: live online and self-paced

Quick Help




Bulgaria


Ivan Pavlov



description of :

 
Teacher's qualifications:
I have limited teaching experience - I've taught math in highschool and programming in college for one year each. I have 7 years of programming experience.
 
's preferred teaching style:

 



jobs | about us | contact us | terms of usage | privacy policy

Copyright ę 2012 Limu.com ltd. All rights reserved.