Database Management

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

How to start a software project ? Pre conditions to follow. 

Sample Project Proposal: Absence Request and Vacation Schedule Management
Example Project Proposal: Online Examination and Evaluation System

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/