[vc_row][vc_column][vc_single_image image=”1675″ img_size=”Large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Database Concepts<\/strong><\/p>\n

\n
• Databases<\/li>\n
• Databases Management System (DBMS)<\/li>\n
• Characteristics of a Database<\/li>\n
• Users of a Database<\/li>\n
• Types of Database Management Systems<\/li>\n
• Relational Database<\/li>\n
• Hierarchal Database<\/li>\n
• Network Database Model<\/li>\n
• Object-oriented Models<\/li>\n<\/ul>\n

  Using MySQL Client<\/strong><\/p>\n

  \n
  • Introduction<\/li>\n
  • Using MySQL Client<\/li>\n
  • Installation of MySQL<\/li>\n
  • Installing MySQL on Linux\/Unix<\/li>\n
  • Installing MySQL on Windows<\/li>\n
  • MySQL Client Programs<\/li>\n
  • Types<\/li>\n<\/ul>\n

    Date, Time and Other Functions<\/strong><\/p>\n

    \n
    • Date and Time Functions<\/li>\n
    • String Functions<\/li>\n
    • Control Flow Functions<\/li>\n<\/ul>\n

      Managing Data<\/strong><\/p>\n

      \n
      • Ways to Manage Data<\/li>\n
      • Exporting Data to a Simple CSV File<\/li>\n
      • Exporting Data to a Custom File Format<\/li>\n
      • Import Data from a Simple CSV File<\/li>\n
      • Import Data from Custom File Formats<\/li>\n<\/ul>\n

        Limit, Aggregate and Union Functions<\/strong><\/p>\n

        \n
        • Limit Functions<\/li>\n
        • Aggregate Function<\/li>\n
        • Types of Aggregate Functions<\/li>\n
        • Union Function<\/li>\n<\/ul>\n

          Indexes and Views<\/strong><\/p>\n

          \n
          • Indexes<\/li>\n
          • Views<\/li>\n<\/ul>\n

            Module 7: Basic Select Function<\/strong><\/p>\n

            \n
            • SELECT Command<\/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=”1675″ img_size=”Large”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Database Concepts Databases Databases Management System (DBMS) Characteristics of a Database Users of a Database Types of Database Management Systems Relational Database Hierarchal Database Network Database Model Object-oriented Models Using MySQL Client Introduction Using MySQL Client Installation of MySQL Installing MySQL on Linux\/Unix Installing MySQL on Windows MySQL Client Programs Types Date, Time […]<\/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-1318","page","type-page","status-publish","hentry","no-post-thumbnail"],"_links":{"self":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1318","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=1318"}],"version-history":[{"count":2,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1318\/revisions"}],"predecessor-version":[{"id":1676,"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/pages\/1318\/revisions\/1676"}],"wp:attachment":[{"href":"https:\/\/itgizz.com\/wp-json\/wp\/v2\/media?parent=1318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}