• DBA

    MS SQL server remote DBA training course topics Chennai India

    Microsoft SQL server training course topics:   Overview of IT environment with daily DBA activity and health check A brief of history (RDBMS & DBMS) SQL server internal architecture SQL server overview (Editions) SQL Installation overview (System DBs) Review of new features Transact -SQL overview Normalization TABLES AND CONSTRAINTS Standard data types Tables and columns in SQL server Objects, Tables and columns in T-SQL Modifying tables and columns Database diagram architecture Constrains TRANSACT SQL QUIERES Querying SQL server tables SQL and transact SQL Using the select statement Transact SQL built-in function Summary queries Sub queries MERGING DATA WITH JOINS&UNIONS Working with inner joins Using left outer joins Multiplying data with…