Emelt fakt C++

Logikai utasítások

 if (i%5!=0)   cout << i << endl;

 if (i%5==0)   coutinue;

 ==
>
<
<=
>=
!=

and    &&
or        ||



 switch (muv) {
    case '+': cout << a+b << endl; break;
    case '-': cout << a-b << endl; break;
    case '*': cout << a*b << endl; break;
    case '/': cout << a/b << endl; break;
    default: cout << "Ilyen muvelet nincsen" << endl;
    }


Random number

#include <time.h>

  /* initialize random seed: */
  srand ( time(NULL) );

  /* generate secret number: */
  iSecret = rand() % 10 + 1; 

http://www.doc.ic.ac.uk/~wjk/C++Intro/CourseStructure.html#S1 

10A SQL

Source: http://www.w3schools.com/sql/default.asp

Database Management Sotwares: MySQL, SQL Server, Access, Oracle, Sybase, DB2

Standard Query Language

Quiz: http://www.w3schools.com/sql/sql_quiz.asp

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database

• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

SQL SELECT Syntax

 SELECT column_name(s) FROM table_name

 SELECT DISTINCT column_name(s) FROM table_name

 SELECT column_name(s) FROM table_name WHERE column_name operator value

=	Equal
<>	Not equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	To specify multiple possible values for a column

SELECT * FROM Persons WHERE LastName='Svendson' AND (FirstName='Tove' OR FirstName='Ola')

SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC

DELETE FROM Persons WHERE LastName='Tjessem' AND FirstName='Jakob'

UPDATE Persons SET Address='Nissestien 67', City='Sandnes' WHERE LastName='Tjessem' AND FirstName='Jakob'

INSERT INTO Persons (P_Id, LastName, FirstName) VALUES (5, 'Tjessem', 'Jakob')

9A presenation programs

Presentation Words

blank

slide

bulleted point

animation

theme

brass

clay

iron

belly

at least

chart

bar chart

table

transparent

to insert

hyperlink

previous -

to consist of

to bring front

to send back

handout

title

Good or bad presentations

feature – sajátosság, jellemvonás

too much text (2-3 – sentences enough, no sentences just keywords)

no pictures

too small, bad quality

not readable

speaks quietly

no gesture

ctrl+c ctrl+V

no eye contact (audience)

bad background

bad order of slides (need a good structure)

bad fonts

table is hard to understand (chart is better)

http://www.youtube.com/watch?v=gNG0etmnwuk

 

9A drawing programs

MS Paint Words

pixel

canvas

free form select tool

rectangular  select tool

eraser

fill

color picker

magnify tool

pencil

brush

air brush

text tool

line (straight)

curve

rectangle

polygon

ellipse

rounded rectangle

opaque, transparent

skew, rotate, flip, stretch

palette

http://www.teachers.ash.org.au/geparker/how_to_use_microsoft_paint.htm