Rating 2.75 out of 5 (2 ratings in Udemy)

• You will learn how to: install and query on SQL Server
• Importance of E-R modeling and Normalization
• Retrieve, delete, insert and update Data(SELECT INTO, AND, OR , NOT, ORDER BY)
• Clear understanding on different types of keys
• Modifying existing table structure
• AGGREGATE FUNCTIONS (MIN,MAX,SUM,AVG,COUNT)
• Data Conversion(CAST,CONVERT)
• Query using JOINS,UNIONS,DISTINCT,Logical operators
• SQL sub queries (IN, EXISTS, ANY)
• SQL Constraints(NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, INDEX)
• Create VIEW, INDEXES, Triggers, Stored Procedures,cursors, temporary tables, variables, table variables
• Transactions and User-defined Functions
• Interview Questions