About Microsoft SQL Developer Course

1. SQL Server Management Studio 2. Transact-SQL 3. SQL Server Configuration Manager 4. DBMS Concept 5. RDBMS Concepts 6. ER Diagram Concepts 7. Cardinality 8. Ordinality 9. SDLC for Database design and Development 10. Normalization and Denormalization

1. Managing schemas 2. Referencing schemas versus using the default schema 3. Hiding schemas with synonyms 4. Building tables

1. Constructing tables with CREATE TABLE 2. Different data types and what is the internal difference 3. Importance of selecting proper data types 4. Data types and performance 5. Converting data using CAST and CONVERT 6. User Defined Data Types

1. Not Null 2. Primary Key 3. Foreign key 4. Unique key 5. Default 6. Candidate Key 7. Alternate Key 8. Natural Key 9. Surrogate Key

1. Inner joins 2. Cross joins 3. Left, right and full outer joins 4. Equijoins 5. The performance implications of joins 6. Adding filter conditions to outer joins 7. Writing self joins 8. Join algorithms(hash join), loop join and merge join 9. Joining a table to itself 10. Chaining self joins 11. Solving time-interval problems

1. Taking advantage of scalar functions 2. Converting data types 3. Handling dates 4. Manipulating strings 5. Choosing the right function for the job 6. Set operators – UNION , UNION ALL ,INTERSECT ,EXCEPT

1. Sorting Data 2. Filtering Data with Predicates 3. Filtering with the TOP and OFFSET-FETCH Options 4. Working with Unknown Values

1. COUNT 2. SUM 3. AVG 4. Equijoins 5. MIN 6. MAX 7. Managing NULLs 8. Suppressing duplicates 9. GROUP BY and GROUPING SETS 10. Applying conditions with HAVING 11. Calculating moving averages 12. Computing running totals 13. Nesting grouped aggregates 14. Joins and grouping 15. Introducing subtotals with CUBE and ROLLUP

1. Creating and utilizing local variables 2. Passing input and output parameters 3. Interrogating global variables

1. RANK and DENSE_RANK 2. Ordering data with ranking functions 3. ROW_NUMBER with ordered sets 4. The OVER clause

1. Simple subqueries 2. Sub-queries in conditions and column expressions 3. Creating multi level sub-queries 4. Avoiding problems when subqueries return NULLs 5. Handling multi row subquery results 6. Correlated subqueries 7. Accessing values from the outer query 8. EXISTS vs. INoIdentifying duplicates 9. Avoiding accidental correlation

1. Create local temporary tables 2. Create global temporary tables 3. Table value parameter 4. Table variables Common table expression (CTE) 5. Derived Tables

1. Importance of pivoting 2. How to pivot data

1. Modifying data 2. Inserting, updating and deleting data 3. Derived table in FROM clause 4. Derived table in JOIN clause

1. Storing queries on the server 2. Concealing complexity with views 3. Indexed views 4. Partitioned views 5. Taking advantage of schema binding 6. View encryption

1. ACID properties 2. Ensuring data consistency with transactions and distributed transactions 3. Isolation levels 4. Begin Transaction 5. Commit Transaction 6. Save point 7. Phantom rows 8. Non repeatable reads 9. Dirty Reads 10. Dealing with open transactions when an exception occurs

1. Implementing conditions with IF...ELSE 2. Looping with WHILE and GOTO 3. Creating code blocks with BEGIN...END 4. Debugging with PRINT 5. Returning data using RETURN 6. Debugging T-SQL in Management Studio

1. Communicating problems to the client with RAISERROR 2. Intercepting errors with TRY...CATCH 3. Dealing with open transactions when an exception occurs

1. Batch and stored procedure processing 2. Minimizing network traffic using batches and procedures 3. Stored procedure compilation and execution 4. Using scalar functions 5. Table valued parameters 6. Querying Multiple Tables

1. Clustered Index 2. Non Clustered Index 3. Unique Index 4. Filtered Index 5. Partitioned Index 6. Covered Index 7. Defining indexed views 8. Analyzing and repairing fragmentation

1. Scalar Function 2. In-Line table valued function 3. Multi-statement table-valued function 4. Creating user-defined functions 5. Calculating values with scalar functions 6. Processing multiple rows returned from a table-valued function 7. Taking advantage of schema binding 8. Function encryption

1. INSTEAD OF vs. AFTER triggers 2. Detecting row changes using the inserted and deleted tables 3. Tracking metadata changes with DDL triggers 4. Auditing user access using a LOGON trigger 5. Tracking data changes with the OUTPUT clause 6. Track column changes using UPDATE function 7. Processing rows on the server with a cursor

1. Creating logins 2. Contrasting Windows and SQL Server authentication 3. Authorizing logins 4. Making logins members of server roles 5. Enforcing password policy

1. Master 2. MSDB 3. Model 4. TempDB 5. Importance of TempDB with respect to performance

1. Restore a full backup 2. Restore a differential backup 3. Restore a log backup 4. Restore with NO RECOVERY 5. Restore with RECOVERY 6. Restore with RESTART 7. Point in time restore 8. MARK restore 9. Recovering user databases 10. Testing recovery scenarios 11. Scripting objects and moving data with Transact-SQL 12. Detaching and attaching databases

1. What /why / how about linked server 2. To create a linked server to another instance of SQL Server 3. To create a linked server with Non-SQL Command Providers 4. Test the linked server 5. Writing a query that joins tables from a linked server

1. Import wizard 2. Export wizard 3. Copy database wizard

1. The SQL Server Agent 2. Configuring the agent 3. Setting up Database Mail 4. Multistep jobs 5. Defining jobs to handle routine tasks 6. Creating alerts and operators 7. Associating alerts with jobs

1. XML and XML Schemas 2. Storing XML Data and Schemas in SQL Server 3. Implementing the XML Data Type 4. Using the T-SQL FOR XML Statement 5. Getting Started with xQuery 6. Shredding XML

1. Introduction to Temporal Data 2. End to End Case study Including Build Database from Scratch 3. Total 6 Assignments 4. More than 10 quizzes 5. Debugging Techniques 6. Introduction to Profiler 7. Top 50 queries to be used in Industry 8. Top 50 interview questions for preparation as SQL Server Developer 9. Review and consolidate your SQL skills with tons of exercises!