[vc_row][vc_column][vc_single_image image=”1671″ img_size=”large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]DBMS CONCEPTS<\/strong><\/p>\n

\n
• What is Database<\/li>\n
• What is Database Management System<\/li>\n
• Different Types of Database Models<\/li>\n
• Normalization<\/li>\n
• RDBMS<\/li>\n
• ORDBMS<\/li>\n
• Difference Between DBMS, RDBMS & ORDBMS<\/li>\n<\/ul>\n

  INTRODUCING ORACLE<\/strong><\/p>\n

  \n
  • Different versions of Oracle<\/li>\n
  • Features of Oracle<\/li>\n<\/ul>\n

    SQL<\/strong><\/p>\n

    \n
    • What is SQL<\/li>\n
    • Role of SQL in RDBMS<\/li>\n
    • Data Types of Oracle<\/li>\n
    • Naming rules in Oracle<\/li>\n
    • What is SQL*PLUS<\/li>\n
    • What is Metadata<\/li>\n
    • What is Schema<\/li>\n
    • Data Dictionary Tables<\/li>\n<\/ul>\n

      SQL COMMANDS<\/strong><\/p>\n

      \n
      • Data Definition Language (DDL)<\/li>\n
      • Data Retrieval Language (DRL)<\/li>\n
      • Data Manipulation Language (DML)<\/li>\n
      • Transaction Control Language (TCL)<\/li>\n
      • Database Security and Privileges (DCL)<\/li>\n
      • Introduction to SQL Database Object:<\/li>\n
      • Oracle Pre Defined Data types<\/li>\n
      • DDL Commands<\/li>\n
      • Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop<\/li>\n
      • DML-Insert, update, delete, merge<\/li>\n
      • DCL-Grant, Revoke<\/li>\n
      • TCL-Commit, Rollback, Savepoint<\/li>\n<\/ul>\n

        Writing Basic SQL SELECT Statements<\/strong><\/p>\n

        \n
        • Objectives<\/li>\n
        • Capabilities of SQL SELECT Statements<\/li>\n
        • Basic SELECT Statement<\/li>\n
        • Selecting All Columns<\/li>\n
        • Selecting Specific Columns<\/li>\n
        • Writing SQL Statements<\/li>\n
        • Column Heading Defaults<\/li>\n
        • Arithmetic Expressions<\/li>\n
        • Using Arithmetic Operators<\/li>\n
        • Operator Precedence<\/li>\n
        • Using Parentheses<\/li>\n
        • Defining a Null Value<\/li>\n
        • Null Values in Arithmetic Expressions<\/li>\n
        • Defining a Column Alias<\/li>\n
        • Using Column Aliases<\/li>\n
        • Concatenation Operator<\/li>\n
        • Using the Concatenation Operator<\/li>\n
        • Literal Character Strings<\/li>\n
        • Using Literal Character Strings<\/li>\n
        • Duplicate Rows<\/li>\n
        • Eliminating Duplicate Rows<\/li>\n
        • Displaying Table Structure<\/li>\n
        • Limiting Rows Using a Selection<\/li>\n
        • Limiting the Rows Selected<\/li>\n
        • Using the WHERE Clause<\/li>\n
        • Character Strings and Dates<\/li>\n
        • Comparison Conditions<\/li>\n
        • Using Comparison Conditions<\/li>\n
        • Other Comparison Conditions<\/li>\n
        • Using the BETWEEN Condition<\/li>\n
        • Using the IN Condition<\/li>\n
        • Using the LIKE Condition<\/li>\n
        • Using the NULL Conditions<\/li>\n
        • Logical Conditions<\/li>\n
        • Using the AND Operator<\/li>\n
        • Using the OR Operator<\/li>\n
        • Using the NOT Operator<\/li>\n
        • Rules of Precedence<\/li>\n
        • ORDER BY Clause<\/li>\n
        • Sorting in Descending Order<\/li>\n
        • Sorting by Column Alias<\/li>\n
        • Sorting by Multiple Columns<\/li>\n
        • Set Operators (UNION, UNION ALL, INTERSECT, MINUS)<\/li>\n<\/ul>\n

          Constraints<\/strong><\/p>\n

          \n
          • What are Constraints?<\/li>\n
          • Constraint Guidelines<\/li>\n
          • Defining Constraints<\/li>\n
          • The NOT NULL Constraint<\/li>\n
          • The UNIQUE Constraint<\/li>\n
          • The PRIMARY KEY Constraint<\/li>\n
          • The FOREIGN KEY Constraint<\/li>\n
          • FOREIGN KEY Constraint Keywords<\/li>\n
          • The CHECK Constraint<\/li>\n
          • Adding a Constraint Syntax<\/li>\n
          • Adding a Constraint<\/li>\n
          • Dropping a Constraint<\/li>\n
          • Disabling Constraints<\/li>\n
          • Enabling Constraints<\/li>\n
          • Cascading Constraints<\/li>\n
          • Viewing Constraints<\/li>\n
          • Viewing the Columns Associated with Constraints<\/li>\n<\/ul>\n

            Functions<\/strong><\/p>\n

            \n
            • SQL Functions<\/li>\n
            • Two Types of SQL Functions<\/li>\n
            • Single-Row Functions<\/li>\n
            • Single-Row Functions<\/li>\n
            • Character Functions<\/li>\n
            • Character Functions<\/li>\n
            • Case Manipulation Functions<\/li>\n
            • Using Case Manipulation Functions<\/li>\n
            • Character-Manipulation Functions<\/li>\n
            • Using the Character-Manipulation Functions<\/li>\n
            • Number Functions<\/li>\n
            • Using the ROUND Function<\/li>\n
            • Using the TRUNC Function<\/li>\n
            • Using the MOD Function<\/li>\n
            • Working with Dates<\/li>\n
            • Arithmetic with Dates<\/li>\n
            • Using Arithmetic Operators with Dates<\/li>\n
            • Date Functions<\/li>\n
            • Using Date Functions<\/li>\n
            • Conversion Functions<\/li>\n
            • Implicit Data Type Conversion<\/li>\n
            • Explicit Data Type Conversion<\/li>\n
            • Using the TO_CHAR Function with Dates<\/li>\n
            • Elements of the Date Format Model<\/li>\n
            • Using the TO_CHAR Function with Dates<\/li>\n
            • Using the TO_CHAR Function with Numbers<\/li>\n
            • Using the TO_NUMBER and TO_DATE Functions<\/li>\n
            • General Functions<\/li>\n
            • NVL Function<\/li>\n
            • Using the NVL Function<\/li>\n
            • Using the NVL2 Function<\/li>\n
            • Using the NULLIF Function<\/li>\n
            • Using the COALESCE Function<\/li>\n
            • Conditional Expressions<\/li>\n
            • The CASE Expression<\/li>\n
            • Using the CASE Expression<\/li>\n
            • The DECODE Function<\/li>\n
            • Using the DECODE Function<\/li>\n
            • Aggregate functions<\/li>\n<\/ul>\n

              Joins<\/strong><\/p>\n

              \n
              • Obtaining Data from Multiple Tables<\/li>\n
              • Cartesian Products<\/li>\n
              • Generating a Cartesian Product<\/li>\n
              • Types of Joins<\/li>\n
              • Joining Tables Using Oracle Syntax<\/li>\n
              • What is an Equijoin?<\/li>\n
              • Additional Search Conditions Using the AND Operator<\/li>\n
              • Qualifying Ambiguous Column Names<\/li>\n
              • Using Table Aliases<\/li>\n
              • Joining More than Two Tables<\/li>\n
              • Non-Equijoins<\/li>\n
              • Retrieving Records with Non-Equijoins<\/li>\n
              • Outer Joins<\/li>\n
              • Outer Joins Syntax<\/li>\n
              • Using Outer Joins<\/li>\n
              • Self Joins<\/li>\n
              • Joining a Table to Itself<\/li>\n
              • Practice 4, Part One: Overview<\/li>\n
              • Joining Tables Using SQL: 1999 Syntax<\/li>\n
              • Creating Cross Joins<\/li>\n
              • Creating Natural Joins<\/li>\n
              • Retrieving Records with Natural Joins<\/li>\n
              • Creating Joins with the USING Clause<\/li>\n
              • Retrieving Records with the USING Clause<\/li>\n
              • Creating Joins with the ON Clause<\/li>\n
              • Retrieving Records with the ON Clause<\/li>\n
              • Creating Three-Way Joins with the ON Clause<\/li>\n
              • INNER Versus OUTER Joins<\/li>\n
              • LEFT OUTER JOIN<\/li>\n
              • RIGHT OUTER JOIN<\/li>\n
              • FULL OUTER JOIN<\/li>\n<\/ul>\n

                Subqueries<\/strong><\/p>\n

                \n
                • Using a Subquery to Solve a Problem<\/li>\n
                • Subquery Syntax<\/li>\n
                • Using a Subquery<\/li>\n
                • Guidelines for Using Subqueries<\/li>\n
                • Types of Subqueries<\/li>\n
                • Single-Row Subqueries<\/li>\n
                • Executing Single-Row Subqueries<\/li>\n
                • Using Group Functions in a Subquery<\/li>\n
                • The HAVING Clause with Subqueries<\/li>\n
                • What is Wrong with this Statement?<\/li>\n
                • Will this Statement Return Rows?<\/li>\n
                • Multiple-Row Subqueries<\/li>\n
                • Using the ANY Operator in Multiple-Row Subqueries<\/li>\n
                • Using the ALL Operator in Multiple-Row Subqueries<\/li>\n
                • Null Values in a Subquery<\/li>\n<\/ul>\n

                  Database Objects<\/strong><\/p>\n

                  \n
                  • Views<\/li>\n
                  • Why use Views?<\/li>\n
                  • Simple Views and Complex Views<\/li>\n
                  • Creating a View<\/li>\n
                  • Retrieving Data from a View 1<\/li>\n
                  • Querying a View<\/li>\n
                  • Modifying a View<\/li>\n
                  • Creating a Complex View<\/li>\n
                  • Rules for Performing DML Operations on a View<\/li>\n
                  • Using the WITH CHECK OPTION Clause<\/li>\n
                  • Denying DML Operations<\/li>\n
                  • Removing a View<\/li>\n
                  • Inline Views<\/li>\n
                  • Sequence<\/li>\n
                  • The CREATE SEQUENCE Statement Syntax<\/li>\n
                  • Creating a Sequence<\/li>\n
                  • Confirming Sequences<\/li>\n
                  • NEXTVAL and CURRVAL Pseudo columns<\/li>\n
                  • Using a Sequence<\/li>\n
                  • Modifying a Sequence<\/li>\n
                  • Guidelines for Modifying a Sequence<\/li>\n
                  • Removing a Sequence<\/li>\n<\/ul>\n

                    Index<\/strong><\/p>\n

                    \n
                    • How Are Indexes Created?<\/li>\n
                    • Creating an Index<\/li>\n
                    • When to Create an Index<\/li>\n
                    • When Not to Create an Index<\/li>\n
                    • Confirming Indexes<\/li>\n
                    • Function-Based Indexes<\/li>\n
                    • Removing an Index<\/li>\n<\/ul>\n

                      <\/h4>\n

                      [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

                      [vc_row][vc_column][vc_single_image image=”1671″ img_size=”large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]DBMS CONCEPTS What is Database What is Database Management System Different Types of Database Models Normalization RDBMS ORDBMS Difference Between DBMS, RDBMS & ORDBMS INTRODUCING ORACLE Different versions of Oracle Features of Oracle SQL What is SQL Role of SQL in RDBMS Data Types of Oracle Naming rules in Oracle What is SQL*PLUS […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1299","page","type-page","status-publish","hentry","no-post-thumbnail"],"_links":{"self":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/comments?post=1299"}],"version-history":[{"count":2,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1299\/revisions"}],"predecessor-version":[{"id":1673,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1299\/revisions\/1673"}],"wp:attachment":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/media?parent=1299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}