Database Management [MS SQL, Oracle OCA, mySQL ...]
Structured Query Language (MS SQL / my SQL)
- ü Introduction
- ü ER Diagrams
- ü SQL Syntax
- ü Connecting to and Disconnecting from the Server
- ü Creating SQL Statements in MS SQL
- ü Common SQL Statements- SELECT, INSERT, UPDATE, DELETE, CREATE …
- ü Advanced SQL Statements- JOIN, UNION, IN …
- ü Creating functions, triggers, views …
- ü User privileges and security
- ü Query optimization
Oracle based on OCA Syllabus
- ü Introduction to Oracle SQL
- ü Relational and Object Relational Database Management System
- ü ER model
- ü Communicating with a RDBMS Using SQL
- ü SQL Statements syntax
- ü Writing SQL Statements using SELECT, INSERT, DELETE, UPDATE, REVOKE, GRANT …
- ü Using Arithmetic Operators and Precedence
- ü Logical and Other Conditions
- ü SQLfunctions, conversion
- ü Working with multiple tables
- ü Aggregating Data Using Group Functions
- ü Producing Readable Output with iSQL*Plus
- ü Create and Invoke Index, Table, View, Function, Procedure, Triggers …
- ü Oracle Program with PL/SQL
- ü Declaring and Handling Variables and Data types
- ü Use of DBMS_OUTPUT.PUT_LINE
- ü Working with SQL Implicit and Explicit Cursor
- ü Conditional Statements IF THEN ELSE CASE WHEN
- ü Loop Statements BASIC FOR WHILE
- ü Handling Exceptions
- ü Privileges of the user management
Operation Systems [Windows, Linux]
Microsoft Windows
LINUX
S
For more guidance!!!
Online Individual / Group classes in English / Sinhala / Tamil. Sample Projects/Assignments Exam Papers, Tutorials, Notes and Answers will we provided.
CALL +94 777 33 7279 | EMAIL ITCLASSSL@GMAIL.COM
YouTube https://www.youtube.com/channel/UCJojbxGV0sfU1QPWhRxx4-A
LinkedIn https://www.linkedin.com/in/ict-bit-tuition-class-software-development-colombo/
WordPress https://computerclassinsrilanka.wordpress.com
quora https://www.quora.com/profile/BIT-UCSC-UoM-Final-Year-Student-Project-Guide
Newsletter https://sites.google.com/view/the-leaning-tree/newsletter
Wix https://itclasssl.wixsite.com/icttraining
Web https://itclass-bit-ucsc-uom-php-final-project.business.site/
mystrikingly https://bit-ucsc-uom-final-year-project-ideas-help-guide-php-class.mystrikingly.com/
https://elakiri.com/threads/bit-ucsc-uom-php-mysql-project-guidance-and-individual-classes-in-colombo.1627048/
LinkedIn https://www.linkedin.com/in/ict-bit-tuition-class-software-development-colombo/
WordPress https://computerclassinsrilanka.wordpress.com
quora https://www.quora.com/profile/BIT-UCSC-UoM-Final-Year-Student-Project-Guide
Newsletter https://sites.google.com/view/the-leaning-tree/newsletter
Wix https://itclasssl.wixsite.com/icttraining
Web https://itclass-bit-ucsc-uom-php-final-project.business.site/
mystrikingly https://bit-ucsc-uom-final-year-project-ideas-help-guide-php-class.mystrikingly.com/
https://elakiri.com/threads/bit-ucsc-uom-php-mysql-project-guidance-and-individual-classes-in-colombo.1627048/
No comments:
Post a Comment