SQL Server Base and Advanced Programming - Dvanalytics
dvanalytics whatsapp contact
dvanalytics whatsapp

SQL Server Base and Advanced Programming

0 STUDENTS ENROLLED

    Microsoft SQL Server is a relational database management system.
    Primary objective is to store data and retrieve data by other software. SQL uses queries to manipulate , design complex data models designing using fact and dimension table concept for start schema and
    snowflakes

    Course Curriculum

    Session - 1
    Introduction SQL server and installation procedure 00:00:00
    Creating database and database objects 00:00:00
    Dropping and using database 00:00:00
    SQL command over DDL,DML,DCL and DQL 00:00:00
    SQL create table and data types in designing table along with constraints. 00:00:00
    Data importing and exporting using wizard 00:00:00
    Dropping/Deleting and Truncating table 00:00:00
    Session - 2
    Select Queries , SQL clauses, SQL summary query 00:00:00
    Advanced SQL queries using case and when, pivot and unpivot, update with case and when sub queries 00:00:00
    Session - 3
    SQL Joins and Relationship 00:00:00
      • Vertical Join- Appending
      • Horizontal Join- Merging
        • Inner Join
        • Outer Join
          • Full outer join
            • Un-matched join
          • Left outer join
            • Left null join
          • Right outer join
            • Right null join
          • Keys and Relationships
    SQL data model designing using fact and dimension table concept for start schema and snowflakes 00:00:00
    SQL sub-queries 00:00:00
    Sub-queries vs partition by vs with clause 00:00:00
    Projects with industry real time data analysis experience 00:00:00
    Session - 4
    SQL Functions 00:00:00
    • Character
    • Numeric
    • Datetime
    Session - 5
    SQL Views 00:00:00
    SQL Store Procedure 00:00:00
    SQL Live projects with designing data model from complex data 00:00:00