Learn to implement Joins, Tuning, Sub queries and Views in a given table.
Details
In this Meetup we shall discuss the following MS SQL server features on a given Table:
a) Operators and their implementation on queries with filegrowth & autogrowth.
b) Query Tuning and optimisation options.
c) Self Joins, , Merge Joins and Cross Joins with aliases.
d) Subqueries and Joins
e) Define, Operations, Issues, Cascading and Orphan Views.
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
Learn to implement Joins, Tuning, Sub queries and Views in a given table.