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
    <ul> <li style="list-style-type: none;"> <ul> <li>Vertical Join- Appending</li> <li>Horizontal Join- Merging <ul> <li>Inner Join</li> <li>Outer Join <ul> <li>Full outer join <ul> <li>Un-matched join</li> </ul> </li> <li>Left outer join <ul> <li>Left null join</li> </ul> </li> <li>Right outer join <ul> <li>Right null join</li> </ul> </li> <li>Keys and Relationships</li> </ul> </li> </ul> </li> </ul> </li> </ul>
    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
    <ul> <li>Character</li> <li>Numeric</li> <li>Datetime</li> </ul>
    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