<strike id="jrjdx"><ins id="jrjdx"></ins></strike>

<address id="jrjdx"></address>

    <listing id="jrjdx"><listing id="jrjdx"><meter id="jrjdx"></meter></listing></listing>
    <address id="jrjdx"></address><form id="jrjdx"><th id="jrjdx"><th id="jrjdx"></th></th></form>
    <address id="jrjdx"><address id="jrjdx"><listing id="jrjdx"></listing></address></address>
    <noframes id="jrjdx">

    <noframes id="jrjdx">
    <form id="jrjdx"></form><form id="jrjdx"></form>

      <noframes id="jrjdx"><address id="jrjdx"><listing id="jrjdx"></listing></address>
      <noframes id="jrjdx">

      課程目錄:SQL Fundamentals培訓
      4401 人關注
      (78637/99817)
      課程大綱:

               SQL Fundamentals培訓

       

       

      RDBMS (Relational DataBase Management System)
      Relational Operators
      SQL as Declarative Language
      SQL Syntax
      SQL Sublanguages DQL, DML, DDL, DCL
      DQL (Data Query Language) in Detail
      SELECT clause
      Column aliases
      Table aliases
      Date types and Date functions
      Group function
      Table joins
      JOIN clause
      UNION operator
      Nested queries
      Correlated subqueries
      DML (Data Manipulation Language) Overview
      Inserting rows (INSERT)
      Inserting rows using subquery
      Updating rows (UPDATE)
      Deleting rows (DELETE)
      DDL (Data Definition Language) Overview
      Creating, altering and dropping objects (CREATE, ALTER, DROP)
      Creating tables using subquery (CREATE TABLE .... AS SELECT...)
      CONSTRAINTS Overview
      NULL i NOT NULL
      CONSTRAINT clause
      ENUM type
      SET type
      PRIMARY KEY
      UNIQUE
      FOREIGN KEY
      DEFAULT clause
      Transactions Overview
      COMMIT
      ROLLBACK
      SAVEPOINT
      Implicit and explicit rollbacks and commits
      SQL Dialects Overview
      MySQL
      Microsoft Access and SQL Server
      Oracle and PostgreSQL

      日韩不卡高清