Microsoft SQL Server database administration training course in Dhaka-Bangladesh can help you to enhance your skills and expertise in building SQL Server strong databases, writing advanced SQL queries, and understanding business needs and requirements for databases administration and security.

Rosetta provides best level SQL Server online and classroom training for database professionals at all stages of their careers. We offer courses for beginners as well as for experienced IT professionals who need to master skills requited for database queries, database developments, or implement a business intelligence technologies for an enterprise level business organization.

Part 1: Querying Data with Transact-SQL.

  • Introduction to Microsoft SQL Server 2022
  • Introduction to T-SQL Querying.
  • Writing Select Queries.
  • Querying Multiple Tables.
  • Sorting and Filtering Data.
  • Working with SQL Server 2022 Data Types.
  • Using DML to Modify Data.
  • Using Built-In Functions.
  • Grouping and Aggregating Data.
  • Using Subqueries.
  • Using Table Expressions.
  • Using Set Operators.
  • Using Windows Ranking, Offset, and Aggregate Functions.
  • Pivoting and Grouping Sets.
  • Executing Stored Procedures.
  • Programming with T-SQL.
  • Implementing Error Handling.
  • Implementing Transactions.

Part 2: Developing SQL Database.

  • Introduction to Database Development.
  • Designing & Implementing Tables.
  • Advanced Table Designs.
  • Ensuring Data Integrity through Constraints.
  • Introduction to Indexes.
  • Designing Optimized Index Strategies.
  • Designing and Implementing Views.
  • Designing and Implementing Stored Procedures.
  • Designing and Implementing User-Defined Functions
  • Responding to Data Manipulation via Triggers.
  • Using In-Memory Tables.
  • Implementing Managed Code In SQL Server.
  • Storing and Querying XML Data in SQL Server.
  • Storing and Querying Spatial Data in SQL Server.
  • Storing and Querying Blobs and Text Documents in SQL Server
  • SQL Server Concurrency
  • Performance and Monitoring.

Part 3: Administering A SQL Database Infrastructure.

  • Configure Data Access and Auditing
  • Manage Backup Plan and Restore of Database
  • Manage and Monitor SQL Server Instances
  • Manage High Availability and Disaster Recovery
  • Log Shipping
  • Replication
  • Mirroring
  • Database Security: Login and User
  • User Based Objects & Data Access.
  • Manage Databases and Instances
  • Database Profiling: Database Tracing.
  • Manage Storage: File & File Group Management

Vendor Exam available on Microsoft SQL Data Platform: 

SQL Server database administration training course in Dhaka-Bangladesh.

Certification Name: Microsoft Certified: Azure Database Administrator Associate

Exam required: 1

Exam Code & Name: Exam DP-300: Administering Microsoft Azure SQL Solutions

Fundamental Certification: Microsoft Certified: Azure Data Fundamentals

Exam required: 1

Exam Code & Name: Exam DP-900: Microsoft Azure Data Fundamentals

Earlier versions of Microsoft SQL Server Training (Retired Certifications: MCSA, MCSE)

 

Microsoft SQL Server 2016 Hands-On Training ensuring the professional approach and implementing the Microsoft’s Official Curriculum.

Microsoft Certified Solution Associate (MCSA) Database Development in SQL Server 2016

  • 70-760: Querying Data with Transact-SQL
  • 70-761: Developing SQL Databases

Microsoft Certified Solution Associate (MCSA) Database Administration in SQL Server 2016

  • 70-764: Administering a SQL Database Infrastructure
  • 70-765: Provisioning SQL Databases

Microsoft Certified Solution Associate (MCSA): SQL 2016 Business Intelligence Development.

  • 70-767: Implementing a SQL Data Warehouse
  • 70-768: Developing SQL Data Models

Microsoft Certified Solution Associate (MCSA) Database Administration in SQL Server 2012/14

  • 70-461: Querying Microsoft SQL Server
  • 70-462: Administering Microsoft SQL Server Databases
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server