Sale!

Microsoft SQL Server (Professional)

৳ 27,500 ৳ 15,000

Category:

Description

Introduction: This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures, Functions and triggers in SQL Server.  The course gives idea about writing Queries & Subqueries, working with Joins, etc. along with database management skills like backup, restore, etc.

Objectives:

  • Learn Database models.
  • Overview of SQL Server Management Studio and Transact-SQL language.
  • Master writing simple and complex queries that retrieve data from the database.
  • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.).
  • Insert, update, and delete data, Retrieve data from tables.
  • Joins, Sub-queries, Working with Data Types, Procedure and Functions.
  • Understand the different Views.
  • Working with Triggers.
  • Design a database, Maintain databases, tables, and sequences with SQL statements.
  • Create and manage views.
  • Ensure the integrity of multiple, related database updates by using transactions.
  • Retrieve data using cursor.
  • Manage binary data using BLOBs.

Course Contents:

Duration – 80 hours

Daily / Weekly Classes

4 Case Studies & 1 Live Project

Professional Courses are only for the working professionals / experienced candidates

Download Content

Reviews

There are no reviews yet.

Be the first to review “Microsoft SQL Server (Professional)”

Your email address will not be published. Required fields are marked *

About Us

Poralekha.com.bd, is an Bangladeshi massive open online course provider (pre recorded video live & live streaming) aimed at professional adults and students. It was founded in Jan 2020. As of Jan 2020, the platform has more than 1000+ students and 25 instructors teaching courses in over 2 different languages. From September 2020 Poralekha.com.bd has associated with Ardent Computech Pvt. Ltd, largest online IT course provider for Academic & Industry sector.

top
Copyright© 2020 all rights reserved by Poralekha.com.bd. Designed & Developed by Radical Creation.
X