SQL Server Creating/Altering Table, Import Export wizard, Constraint Primary and Foreign key

In this session you've Learnt :
MODULE 2: CREATING TABLES, DATABASES AND IMPORTING AND EXPORTING DATA
• Introduction of Language Statements (DDL, DML, DCL, TCL)
• Creating table and DDL commands
• Introduction of Import and Export Wizard
MODULE 3: SQL CONSTRAINTS AND DATA TYPES
• SQL Data Types
• SQL Constraints
Download Materials: https://drive.google.com/drive/folders/1I5oDYYJQYWIaBBNfbqJWQ8nFXFtHIJCN?usp=sharing
If you want to join my live class then Tell us
========================================================
All Contents of course is here:
MODULE 1: INTRODUCTION TO RDBMS AND MICROSOFT SQL SERVER
• Introduction to RDBMS concepts
• Normalization Technique
• SQL Server Architecture
• Introduction to Microsoft SQL Server
• Introduction to SQL Server Management Studio
• Installation of SQL server Management Studio
MODULE 2: CREATING TABLES, DATABASES AND IMPORTING AND EXPORTING DATA
• Introduction of Language Statements (DDL, DML, DCL, TCL)
• Creating table and DDL commands
• Introduction of Import and Export Wizard
MODULE 3: SQL CONSTRAINTS AND DATA TYPES
• SQL Data Types
• SQL Constraints
• SQL Indexing
MODULE 4: SELECT STATEMENT AND WORKING WITH SORTING AND FILTERING DATA
• Select Statement
• SQL Distinct keyword
• SQL Where Clause
• SQL wild card concept
• SQL Group by and Having clause
• SQL CASE statements
MODULE 5: WORKING WITH MULTIPLE TABLES USING JOIN CONCEPT
• Introduction of Join
• Inner Join
• Outer Join
• Left Join
• Right Join
• Self Join
• Cross Join
• Concept of Nested Join with Where Clause
MODULE 6: USING DML TO MODIFY DATA
• SQL Update Statement
• SQL Insert Statement
• SQL Delete Statement
• SQL Transaction control Language
MODULE 7: USING BUILT IN FUNCTIONS
• SQL Number Functions
• SQL Date Functions
• SQL Text Functions
• SQL Special Functions
MODULE 8: USING SUBQUERIES CONCEPTS AND TABLE EXPRESSIONS
• SQL Scalar Subqueries
• SQL Multivalued Sub Queries
• SQL Table Values Sub Queries
• SQL Common Table Expression
MODULE 9: USING SET OPERATORS AND WINDOWS RANKING, AND AGGREGATE FUNCTIONS
• SQL UNION, UNION ALL, INTERSECT AND EXCEPT
• SQL CROSS APPLY operator
• SQL RANK function
• SQL DENSE_RANK function
• SQL ROW_NUMBER function
• SQL Over Clause
MODULE 10: PROGRAMMING WITH T-SQL AND STORED PROCEDURE
• SQL If condition
• SQL While Loop
• Creating Stored Procedure
• Modifying Stored Procedure
MODULE 11: WORKING WITH USER DEFINED FUNCTIONS
• Creating User Defined Function
• Modifying User Defined Function
• SQL Pivot and Unpivot Concept
MODULE 12: APPLYING ERROR HANDLING CONCEPT IN T SQL PROGRAMMING
• Implementing T-SQL Error Handling
• Redirecting Errors with Try/Catch
• Using THROW to pass an error message back to a client
• Applying Error Handling in Stored Procedure
• Applying Error Handling in Stored Procedure
MODULE 13: CONCEPT OF CURSOR AND INDEX
• Introduction of Cursor
• Creating cursor
• Modifying cursor
• Detailed description about Index
MODULE 14: PERFORMANCE TUNING
• Query optimization
• Performance Tuning