Design And Manage Your Database In Mssql Server

About:

I'm passionate about databases. I am a professional database designer having experience in the following RDBMS

1. MS SQL Server
2. MS SQL LocalDB
3. SQLLite
4. MS Access

I can help you with a different kind of database tasks:

1. Entity Relationship Diagram (ERD)
2. Identifying business rules/requirements
3. Logical Database Design (Transformation of ERD To Relational Diagram)
4. Normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
5. Making Logical Model and Physical Model
6. Database Creation
7. Table Creation
8. Write Simple and Complex Queries
9. Apply Constraints on Table
10. Create Joins and CRUD Functions
11. Database Objects Creation (Index, View, Sequence, etc)
12. Bugs Fixing
13. Query optimization
14. Denormalization.
15. Design Data warehouse
16. Star Schema and Snowflake
17. ETL Process
18. SSIS Packages
19. SSDT
20. ASP.NET MVC Web App with MS SQL Server
21. Desktop App with MS SQL Server

Reviews

: : : : :