Sale!

Microsoft SQL Server (Beginner)

৳ 15,000 ৳ 7,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 – 60 hours

Daily / Weekly Classes

2 Case Studies & 1 Live Project

Begineer Courses are only for students. You can avail this by producing valid proof of studentship

Download Content

Reviews

There are no reviews yet.

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

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