This course is on Microsoft SQL training. There will be lot of practice excercises with solutions explained in detail. We will cover Major SQL Concepts.

Sr No	Content
1	Database, Create table,identity in SQL, top clause, drop table, Insert, and Update command Different data types, Delete Truncate
2	decimal(10,2), SQL Joins, Group By, Aggregate functions,Having Clause default keyword and check constraint
3	Primary Key, Unique Key, Difference between a) Where and having clause b) Primary key and unique key, c) Union and Union all
04-01-00	cross join example, what is DDL and DML, What is COALESCE in SQL Server? How to check null value, Floor and sign functions, case when,Dynamic Queries, Debugging Queries
05-01-00	exporting data to excel, and loading data from excel, Schema
6	Stored Procedures, Advantages of stored procedures, excution plan , network traffic, code reusability, SQL Injection Input and output parameters.
7	Inline Functions, Functions, Views
8	Pivot, Acid property, Normalization
9	Commit and rollback, Triggers, Magic Tables in SQL server
10	Difference b/w clustered n non clustered index. , DBCC command, Heap BCP, Collation
11	Indexes, Rank, row_number, Transactions, Explain indexes and filter Index, Convert varchar to date. MINUS, INTERSECT, Partition
12	What is CTE, Temporary Tables, Cursors, Merge

Reviews (50)