Weeks | Topics |
1 |
The necessity of using the development of filing systems and databases. Access, MySQL, Microsoft SQL and Oracle databases properties.
|
2 |
The installation of Microsoft SQL Server and Microsoft SQL Server, and Client Management Introduction. Microsoft SQL Database, table creation.
|
3 |
QweryBuilder Express and install SQL editor. Create editors, Select, Insert, Update, such as SQL ments to the application.
|
4 |
Microsoft's SQL table access information, you are done with different methods of transferring and using Microsoft Excel.
|
5 |
Mysql Database Server and Management installation, MySQL database management. MySQL Workbench 5.2 and SQL commands to add user methods.
|
6 |
The input methods and MySQL Database creation, table creation process. Table with SQL commands and SQL developer, entry, deletion, modification operations. TABLE mysql excel with different methods of access to the transmission and use of information, you are done.
|
7 |
Oracle database installation, database and Developer. Oracle management parameters. What are the Oracle sqlplus input methods.
|
8 |
exam
|
9 |
Sqlplus and Sql Developer Oracle user creation, Table entry, delete, and modify operations.
|
10 |
In Microsoft Excel, transfer and use of information, you are making table'a access to Oracle. Oracle Database system and user files listed in a different connection method and system. Table creation, vision and sql sentences registration process variables. Select, Update, Delete operations between used, in, order by, group by, group by having software and applications.
|
11 |
Distinct, union, intersect, minus, Table comparison, the features and the use of transactions. Used for Table, Delete, Create, Update, Select, Insert the use of SQL statements. Create a different date, reading input methods.
|
12 |
Trunc, Round, nvl, length, substr, INITCAP ments, such as the use of sql function
Synonym, view, What is Cluster. Properties and Applications. What is the Index. What are the effects on performance. Creating and Deleting index of different methods. Single sign-on to make double entries in a table.
|
13 |
Sql files automatically, and Rollback methods of operation, why use the commit process. login.sql property and the use of the file. grand, revoke, What are the methods and implementation of the public.
|
14 |
Oracle Database files transferred with the outside sqlloader and export, import operations.
|