|
|
|
|
|
�� |
|
|
�� |
|
���ͳ�Ȩ������ ��ȹ, ���, ����� ����� ����Ʈ���� �� ��� ��õ� ������� ��� �����ϴ� ���� ������Ͷ��մϴ�. ����������� ��� html tag���� ����� ��Ʈ��ũ����, �����ͺ��̽� ������� msql��� ����Ͽ� ������ ������ͷ� ����� Ȯ���� �� �ֽ�ϴ�. ���� ���ͳ��� �� ���ȭ�� ��ο� ��ȭ��ȭ�� �ΰ��ϰ� ��ó�ϰ� �̸� ������ �ȭ��Ű�� ���� ��������� �ǹ��Դϴ�. �� ��������ص� ����� �о��̾���� ���ͳ� �������� ������� ���Ͽ� �����, ��ü��� ������ ��������� ��䰡 �����ϰ� �ֽ�ϴ�. ���� ���� �������� ������ ������Ͱ� ����� ����� ����Դϴ�. ���� �߿��� ��� ȥ�ڼ� �غ��ϱ�� ���� ���� ����Դϴ�. �缾�Ϳ����� �ܱ ��������� �缺�ϴ� ��� ��ǥ�� �ϰ� �ֽ�ϴ�
|
���
|
����
|
��
|
��
|
��
|
���ͳ�
����˻�
��
HTML
���ʰ��
|
1��
|
OT/��ǻ�Ϳ� ���ͳ�
���ͳݰ���, Network������
|
���ͳݼ�����, ���ȯ�漳�
WWW����, �˻��� ����
|
E-mail Client
Usenet����
|
2��
|
FTP����
Archie����, IRC����
|
Telnet����
Dmpro�� �̿��� �������
|
����˻� ����
����˻� �DZ����(Web Search)
|
3��
|
HTML����
�⺻HTML�����ۼ�
|
Text Formatting
List Tag ���
|
Image���� �� ���
Table Tag
|
4��
|
Hyper Text, Anchors
|
��ĸ����, Frame Tag
|
Homepage���, uploading
|
���
|
����
|
��
|
ȭ
|
��
|
��
|
��
|
Network
Essentlal ���
(Client/Server1)
|
1��
|
OT
|
Network
����
|
Win95 Network
|
Network
H/W
|
NT Intranet
|
2��
|
NT�Ұ�
|
NT Setup1
|
NT Setup2
|
NT System
����
|
NET��ɾ�
|
3��
|
Server
��1
|
Server
��2
|
NT Server H/W
|
REgestry
& Recovery
|
OSI 7LAYER, TCP/IP
|
4��
|
NT Domain
|
DNS ����1
|
DNS ����2
|
Windows
2000
|
Windows2000
|
NT Server
Backoffice �ǹ�
(Client/Server2)
|
1��
|
Backoffice
����
|
Backoffic
Setup - o/p
|
IIS4 ��ġ ��
�̷�
|
Web Server
|
Loading��
�����
|
2��
|
Index Server
|
Frontpage
Extension
|
FTP Server
|
����
���
|
NNTP Server
|
3��
|
NT Security1
|
NT Security2
|
Transaction Server
|
Message Queue Server
|
3rdpary E-mail Server
|
4��
|
Exchange Server0
|
Exchange Server1
|
Exchange Server2
|
Exchange Server3
|
Exchange Server4
|
Web
Programing
�ǹ�
(Clien/Server3)
|
1��
|
Vbasic6.0 �Ұ�
|
����
����
|
MDI ��
�ۼ���
���콺,
�������
|
DB�����
���
Access
|
Logon Crystal
Reports, DB Form
|
2��
|
Vbasic Script
|
CGI
|
ASP����
|
ASP�� IIS4.0
|
Global.asa
����
|
3��
|
Web Interface
����
|
Form ������ ó��
|
���ϼ���1
|
���ϼ���2
|
���ϼ���3
|
4��
|
uploading
�Խ���
����1
|
uploading
�Խ���
����2
|
uploading
�Խ���
����3
|
Web Update1
|
Web Update2
|
Web
D/B ����ǹ�
(Client/Server4)
|
1��
|
Web DB
����
|
MSSQL
��ġ
|
Enterprise
�� �̿���
��
|
Client tool�
�̿��� ��
|
�ڷ�����
|
2��
|
ODBC ���
|
IIS�� ����
|
ASP�� ����1
|
ASP�� ����2
|
ASP�� ����3
|
3��
|
EC(����
��ŷ�)
����
|
Shopping Mall ���� ����
|
Merchand Server
|
ȸ��� TOOL ����
|
Site ��
|
4��
|
Web Design ���� Portfolio����� ������ Web Server ����ǹ�
|
��
|
�� ��
|
�� ��
|
��
|
O.T
WIN 9X�� NT�� �����, NET Work�� Domain�� �����
|
|
��
|
Windows NT ��ġ
��� ��, ����� ��
|
|
��
|
���ñ�, �۷ι��, ����ID, �������, Ȩ ���, �������
|
|
��
|
����� �������, ���(FAT), ���(NTES), �����
|
|
��
|
��Ƽ��, NT��ġ�ɼ�, NT���
|
|
��
|
NT����, ����� �ý��� �å �����
|
|
��
|
��ũ ��, �����ͺ���, ARC���
|
|
��
|
����� ���, ���� �å ���, ����ȭ Ʈ����Ʈ
|
|
��
|
��Ʈ��ũ �����, �μ���
|
|
��
|
�ý��� �ڿ� �����, �������
|
|
��
|
DHCP, WINS ����
|
|
��
|
DNS ����, Browser ����
|
|
��
|
Directory Service, RAS Service, Netware
|
|
��
|
���丮 ���, Data Backup
|
|
��
|
����Ʈ��, ��� ��ũ��
|
|
CS 2 �ܰ� : SQL Server7.0 �����ͺ��̽���/������ ���
|
��
|
�� ��
|
�� ��
|
��
|
��������̼� �� NT ��ġ, Sp4, IE4 ��ġ
|
A
|
��
|
DB ���ʰ���, MSSQL�� Ư¡ �� ��ġ
|
A
|
��
|
Enterprise Manager ����, ���� DB�� ���� ���
|
A
|
��
|
Query Analyzer�� �̿��� DB�����, DB�����
|
I
|
��
|
Table �����, �ڷ��Է��ϱ�, Select�� ����
|
I
|
��
|
Null�� ���, order by union, ��Į���Լ� ����
|
I
|
��
|
DML(insert, update, delete)����ϱ�
|
I
|
��
|
Constraints (Primary, Default, Unique, Check)
|
I
|
��
|
Foreign'key, default, rule ����ϱ�
|
I
|
��
|
No Check, Identity, Index ����
|
I
|
��
|
Index�� ����ȭ
|
I
|
��
|
Join����� ���� ���̺�� ���ϱ�
|
I
|
��
|
Group by����� ���� ���̺�� ���ϱ�
|
I
|
��
|
Transaction�� Lock
|
I
|
��
|
View�� Stored Procedure
|
I
|
��
|
Trigger
|
I
|
��
|
DTS, Linked Server, � �Խ� �� ��ü �ؽ�Ʈ ����
|
A
|
��
|
����� ��� �� ���, ��(role)
|
A
|
��
|
DataBase�� Buckup�� Recovery
|
A
|
��
|
Replication(���)
|
A
|
��� :
1. �ֱ��� : ���ȣ ��. 1999.SQL ������ ���̵�. (��)�������ǻ�
2. ��� : MICROSOFT. 1999.SQL Server 7.0 database Implementation Training Kit. Compeople(��)
3. ��� : MICROSOFT. 1999.SQL Server 7.0 database Administration Training Kit. Compeople(��)
���� :
1. A - Administrator(70-028. Administratering SQL Server 7.0)
2. I - Implementation(70-029. Designing and Implementing Database with Microsoft SQL Server 7.0) |
CS 3 �ܰ� : Web Programming |
��
|
�� ��
|
���
|
��
|
Visual Basic 6.0�� ����ȯ��
Object�� Interface
Visual Basic�� ȭ�� �������
Form Design ���, Control�� ������ ��õ� �Ӽ��� Method
elick event, load event |
|
��
|
�߰��� �Ӽ��� Method
getfocus event
����(�����, ����, ���, ��⺯��)�� ���
TEST 1
��(if.....then....endif) |
|
��
|
��(select case....end select)
�迭� �̿��� ��ü �۾���
frame, checkbox, optionbutton control�� ������ ��õ� �Ӽ��� Method
TEST 2 |
|
��
|
�߰��� �Ӽ��� Method
change event, keypress event |
|
��
|
msgbox �Լ�
Project 1 : ��ȣȮ�� ��α�
shell�Լ�
�߰��� �Ӽ��� Method
������(���, ��, �, ����)
��(for....next) |
|
��
|
InputBox �Լ�
TEST 3
listbox control ������ ��õ� �Ӽ��� Method
�߰��� �Ӽ��� Method |
|
��
|
TEST 4
Combbox control ������ ��õ� �Ӽ��� Method
Project 2 : ������� ��α� |
|
��
|
Scrollbar, Line control ������ ��õ� �Ӽ��� Method
Line Method, QBColor
MouseDown, MouseUp event
TEST 5 |
|
��
|
Shape control ������ ��õ� �Ӽ��� Method
TEST 6
Left, Mid, Right �Լ�
�߰��� �Ӽ��� Method
��(FOR...EACH��) |
|
��
|
Time control ������ ��õ� �Ӽ��� Method
�߰��� �Ӽ��� Method
TEST 7
Drivelistbox, dirlistbox, filelistbox ������ ��õ� �Ӽ��� Method |
|
��
|
�߰��� �Ӽ��� Method
Project3 - ������ �����ִ� ��α� |
|
��
|
Image, Picturebox control ������ ��õ� �Ӽ��� Method
�߰��� �Ӽ��� Method
TEST 8 |
|
��
|
������� ����
�߰��� �Ӽ��� Method
TEST 9
Microsoft Windows Common Controls 6.0 - Toolbar, Imagelist ��Ʈ�� ����� |
|
��
|
�߰��� �Ӽ��� Method
����ó��(��������, ��������,��������)
Open�� Print��
Project4 - �����α��� ���� ����� (1�ܰ�) |
|
��
|
Microsoft Common Dialog 6.0 ��
Project4 - �����α��� ���� ����� (2�ܰ�) |
|
��
|
Microsoft Common Dialog 6.0 ��
Microsoft Rich Textbox control 6.0
TEST 10 |
|
��
|
MDI FORM��� �۾�
��õ� �Ӽ��� Method
Project 5 |
|
��
|
Data Access Control �۾� |
|
��
|
Data Access Objects �۾� |
|
��
|
DAO�� SQL �۾� |
|
CS 4 �ܰ� : Web Server �� Programming |
��
|
�� ��
|
��
|
����� ȯ�� ���� (NT/SQL/Develop Tool Setup)
|
��
|
DNS Server�� ��� Domain Name ���
|
��
|
Inside Internet Information Server 4.0
|
��
|
WWW Server & WebLogging
|
��
|
FTP/NNTP/SMTP Server
|
��
|
WMT(Windows Media Technlogy)Service:VOD
|
��
|
EWMAC�� �̿��� E-Mail Service
|
��
|
Visual Interdev�� �̿��� ASP Coding
|
��
|
Client Script & Server Script
|
��
|
ASP �� �⺻ 5 ��ü
|
��
|
Guestbook ���踦 ���� Webapplication�� ���
|
��
|
ADO Connection� �̿��� DB Search
|
��
|
Sqi ��� �̿��� DB Search
|
��
|
Paging Components�� �̿��� ������ ����
|
��
|
CDO Components�� �̿��� Mailing List
|
��
|
Global asa ������ ���ؿ� �̸� �̿��� Counter
|
��
|
Cookie�� �̿��� ����� ����� ��
|
��
|
IIS 4.0 Resource Kit �̿��
|
|
Visual Basic� �̿��� Components ���
|
|
�ǹ� ����Ʈ�� ���� ����
|
���ü ȫ����, ��ȹ��, ������� ���ü, ���ͳ� ���� �����, � ȣ���þ�ü ���̹���,
���̹���, ���̹� ���θ�, ���ͳ� TV, ��� ��ó���, SOHO â��, ������� Ȱ�� ��
|
��
|
|
|
|
|
|
Copyright �� Modern Academy Co., Ltd. All right reserved.
����� ��α� ��ö�� 7-12 ���Ϻ�� 6�� Tel : 02-6743-0775
mail to
|
|
|
|