How to Perform DDL,DML,DQL,Constraints,Operators and Cascading in MS SQL SERVER

So, far we learnt on basic installations, database creations and table creation in MS Sql Server. Next, Week our work will be on:

1. How to Perform DDL Operations i.e Create, Alter and Drop.

2. How to Perform DML Operations i.e Update, Delete and Insert.

3. How to Perform DQL Operations i.e Select.

4. How to use Keys, i.e Unique Key, Primary Key and Foreign Key.

5. Constraints and Logical Operators.

6. Joins, Cross Joins, Inner Joins and Outer Joins.

7. Overview on Cascading.

This is a DIY(Do it yourself) session so please bring your laptop with you and install MS SQL server 2014/2016 with SSMS (SQL server Management Studio) before the event.

Please, follow these links to Install SQL server 2014/2016 as well as SQL Server Management Studio 2014/2016 as below:

https://figshare.com/s/e5844dd90be7adc3a720

In case you have a problem finding us or you will be late, please call us on 9163 4228