MS Database SQL server, Data Modelling and Live Projects

Sql Server Database Learning

Topics Covered

1.Introduction to SQL Server Overview Understanding Client Server Architecture Introducing the Tools Selecting an Edition Creating Sample Databases 2.DESIGNING RELATIONAL DATABASES Understanding Normalization Discovering Patterns Avoiding Over Complexity Managing Optional Data Creating Physical Keys Using the Database Diag Tool Di Final Comments 3. WORKING WITH SINGLE TABLE QUERIES Understanding Query Flow Filtering Data with the Where ClauseColumns, Expressions & Scalar Functions. Using Case ExpressionsWorking with Nulls & Coalesce. Selecting Environment Functions Working with Dates & Times Parsing Strings Converting Data and Sorting Data Topping Off the Query with Predicates MODIFYING DATA Insert, Update and Delete Data Using the Output Clause Final Comments & Credits 5.STORED PROCEDURES Introducing Stored Procedures Passing Parameters Returning Parameters Working with a Cursor Handling Errors Explaining the Raise Error Controlling Transactions 6.TRIGGERS 1.Introducing After Triggers Using "Instead of" Trigger Disabling Triggers Using the Update ( ) Function Selecting Transaction Data Nesting & Recursion Enforcing Complex RI Auditing Data Changes 7.INDEX Introducing Indexes Creating Indexes TRANSACTIONS, LOCKING & BLOCKING Introducing ACID Transactional Faults Stepping through a Transaction Exploring Locks Working with Locks & Viewing Using Snapshot Isolation 9. INTRODUCTION TO OPTIMIZATION THEORY Deconstructing the Database System Walk thro.. Optimization Theory Optimization Theory Continued Final Comments & Credits 10.Reliability and availability Database backup & Restore Log shipping Database snapshots Mirrored databases 11. Applications Service Broker HTTP endpoints

Who should attend

Professionals desire to work on Databases

Pre-requisites

Nothing

What you need to bring

Nothing"

Key Takeaways

Course Material. 100% Practical Training and projects. Placement assistance provided for good candidates. You can work on more than one project. You will work on our freelance projects Opportunity to work on our products.