SQL - Structured Query language is used to communicate with DataBase , it is the standard language for relational database management sys...
![[100% Off] SQL Server in C# : Create Database Apps with C# and SQL Udemy Coupon](https://i.udemycdn.com/course/480x270/991562_fdce.jpg)
SQL - Structured Query language is used to communicate with DataBase , it is the standard language for relational database management systems.
As part of this course you will learn below topics
- What is Data & Its types
- Various Database Types - DBMS & RDBMS
- DDL commands : CREATE,ALTER,DROP AND TRUNCATE
- DML commands : SELECT,INSERT,UPDAT,DELETE
- Creating database - Manually & With Code
- Creating Tables - Adding data and deleting data
- Variables - Temporary Variables & Table Variables
- Constraints - Primary key , foreign key , null etc
- Joins - Inner , Left ,Right, Full
- Functions - Scalar Functions, Table Valued functions , Aggregate Functions, String Functions , Date Time Functions
- Views - Create , Alter , Drop
- Indexes - Clustered Indexes , Nonclustered Indexes ,
- Store procedures
- Triggers - DDL , DML & Logon
- Result Sets - Combining Result Sets Union|Union All|Intersect|Except
Udemy Coupon Code : https://www.udemy.com/sql-with-c-c-adonet-with-sql-server-database/?couponCode=SQLSERVERCOURSE