DBMS and Reporting Skill, MDS Program 1, MDS Program 2, MDS Program 3
SQL Server Base and Advanced Programming
0( 0 REVIEWS )
0 STUDENTS
Instructors
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 |