Class Diagram, Object Diagram, Use Case Diagram, Sequence Diagram, Collaboration Diagram, Activity Diagram, Statechart Diagram, Component Diagram and Deployment diagram in Object Oriented Software Engineering.
Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL
Database Administrator, Popular Database Products and Security, How Does a Database Become Secure?, Personal Oracle7 and Security, Creating Roles, User Privileges, User Access to Views, Using Views for Security Purposes, Using Synonyms in Place of Views, Using Views to Solve Security Problems, Using the WITH GRANT OPTION Clause.
Transaction Control, The Banking Application, Beginning a Transaction, Finishing a Transaction, Canceling the Transaction, Using Transaction Savepoints
Using Views, A Simple View, Renaming Columns, SQL View Processing, Restrictions on Using SELECT, Modifying Data in a View, Problems with Modifying Data Using Views, Common Applications of Views, Views and Security, Using Views to Convert Units, Simplifying Complex Queries Using Views, The DROP VIEW Statement, Using Indexes, What Are Indexes?, Indexing Tips, Indexing on More than One Field, Using the UNIQUE Keyword with CREATE INDEX, Indexes and Joins, Using Clusters.
Creating and Maintaining Tables, Objectives, The CREATE DATABASE Statement, CREATE DATABASE Options, Database Design, Creating a Data Dictionary, Creating Key Fields, The CREATE TABLE Statement, The Table Name, The Field Name, The Field’s Data Type, The NULL Value, Table Storage and Sizing, Creating a Table from an Existing Table, The ALTER TABLE Statement, The DROP TABLE Statement, The DROP DATABASE Statement.
Introduction to Data Manipulation Statements, The INSERT Statement, The INSERT…VALUES Statement, Inserting NULL Values, Inserting Unique Values, The INSERT…SELECT Statement, The UPDATE Statement, The DELETE Statement, Importing and Exporting Data from Foreign Sources, Microsoft Access, Microsoft and Sybase SQL Server, Personal Oracle7
Algorithm to find the HCF of three numbers
Algorithm to merge two sorted array in a sorted order
Write an method to merge the two arrays in such a way that the elements in the resulting array are arranged in the ascending order. Programming language used C#
Algorithm to check if a string is a substring of the another string
Write an algorithm to accept two strings and check whether the second string exists within the first string. For example, if the first string is “concatenation” and the second string is “cat”, the algorithm should display “Substring found at position 4 in the string”. However, if the first string is “concatenation” and the second string is “tent”, the algorithm should display “Substring not found in the string”. It will check if the given string toCheck is a substring of str or not.