Difference between Microsoft SQL Server and Oracle on the basis of language, transaction control, organization of database objects, platform dependency, locking and concurrency control, performance & tuning and other.
We’re so thankful for your interest in sharing your knowledge among others and are excited to tell you how much support we are getting through many other sources. By seeing the enthusiasm in people about knowsh.com, we are proud to say that people are very much excited to get a platform to share their knowledge among others who are actually in requirement of it.
We have tried initiating a noble way to share what we know and to request others to share what they know. It is a mutual way to let everyone learn and let everyone teach. Each and every knowsher is responsible to take care of other knowshers and provide the help what they required.
We’d love for you to become a member of the Knowledge Sharing team and become a knowsher: stay in touch and interact with us through our Facebook, spread the word about what we do and to know what your role as an individual knowsher is. If you’d like to learn more about how you can support us or if you have any query, please send us a message. We are so grateful to have you as a knowsher and we will seek for your support in near future.
We hope you will enjoy being an active knowsher and you will help other knowshers as well. To understand the details of how, when and what, please check FAQ.
Architecture DDBMS, Dimensions of implementation, Issues with DDBMS, Fragmentation, Allocation, Replication, Optimization – Query Plan, Transparencies in a DDBMS, Date 12 Rules, Distributed Transaction Management.
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.
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