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.

5/5
  • 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.

None

  • Duration – 60 hours
  •  
  • Daily / Weekly Classes
  •  
  • 2 Case Studies & 1 Live Project
  •  
  • Industrial Courses are only for students. You can avail this by producing valid proof of
  • studentship
  •  
  • Download Content

15,000 TK 7,000 TK

  • Duration – 80 hours  
  •  
  • Daily / Weekly Classes
  •  
  • 4 Case Studies & 1 Live Project
  •  
  • Professional Courses are only for the working professionals / experienced candidates
  •  
  • Download Content

27,500 TK 15,000 TK

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