Mastering in Database Design and Development (MS SQL SERVER)


After learning the basics of the SQL database, software developers will be able to store and access structured data in a relational database. They will be able to work within a relational database, and create queries and reports using Microsoft Reporting Services Reporting Manager and SQL Server reporting services. 

SQL Master class


Why should you learn SQL database for software developments, because in the world of Web and mobile applications, SQL databases play a vital role where in almost all the big and famous companies use it. And here we are discussing about Microsoft SQL Server, its semantic rules and basic clauses, its advanced queries and functions; this database programming language knowledge is extremely necessary for quick analysis of data and retrieving data from any database.

After learning the basics of the SQL database, software developers will be able to store and access structured data in a relational database. They will be able to work within a relational database, and create queries and reports using Microsoft Reporting Services Reporting Manager and SQL Server reporting services. 


Why Choose Us?


CERTIFIED SERVICE PROVIDER

Softopark IT LTD is a certified IT service provider in Bangladesh that provides all kinds of tech services and products all over the world. As a limited company softopark is a brand in Its sector.

100% QUALITY ASSURANCE

Softopark has a fame for not doing compromise with quality. Our dedicated team is ensuring to provide you effective and quality services all over the world.

Dedicated Team

We work with leading technology partners to help our clients get connected to the right business program, thereby accelerating their growth. Our team consists of experts in software development, application development, sales, marketing, and operations.

Effective Technology

Innovation doesn’t only happen in the corporate world. At Softopark, we help startups and SMEs to transform their digital experiences into success through modern, effective technology.


Get The Most Out of this Course


3 Real life Projects

Mentor support

Quizzes / assignment

Lifetime Access

Self Learning

3 Real Projects

Exclusive Resources

Certificate after complition

From Mobile tab or pc

From Any place

48 hours Refund policy
django-course-by-kawser-chowdhury
Video Duration:
11 hours

Language:
Bengali

Difficulty:
Basic to Advanced

Currently Enrolled:
456 students

Django Version:
2.3 or letters 3

Instructor Name:
Kawser Chowdhury

Course Module


Introduction and Getting Yourself Ready
  • 1.1 Why SQL?
  • 1A Introduction to DBMS and SQL
  • ISQL Quiz 1

Getting Yourself Ready
  • 2.1 Database We will Use
  • 2.2 Data Types and RDMS We will Use
  • 2.3 Setting up IBM DB2 and DB2 Interface
  • 2.4-Setting Up MySQL
  • 2.5 MySQL Workbench
  • Download Data and Script Files
  • 2.6 Running Wamp Server & Changing Password
  • 2.7 Creating Database and Importing Database in Wamp Server
  • SQL Quiz 2

Relational Database and SQL Join
  • 5.1 Relational Database and ERD
  • 5.2 Join Types
  • 5.3 Join Example – Part 1
  • 5.4 Join Example – Part 2
  • SQL Quiz 5

Aggregations of SQL
  • 6.1 Sum
  • SQL Quiz 6A
  • 6.2 Min and Max
  • SQL Quiz 6B
  • 6.3 Average
  • 6.4 Count
  • 6.5 Group By – Part 1
  • 6.6 Group By – Part 2
  • SQL Quiz 6D
  • 6.7 Having
  • SQL Quiz 6E
  • 6.8 Date and Time – Part 1
  • 6.9 Date and Time – Part 2
  • 6.10 Date and Time – Part 3
  • SQL Quiz 6F

Subquery and Temporary Table
  • 7.1 SubQuery
  • SQL Quiz 7A
  • 7.2 Temporary Table
  • SQL Quiz 7B

Data Cleaning in SQL
  • 8.1 Data Cleaning intro
  • 8.2 Left-Right-Upper-Lower
  • 8.3 Length
  • 8.4 Position, Strpos and Substring
  • 8.5 Concat
  • 8.6 Coalesce

SQL Advanced: Union and Join
  • 9.1 Union
  • 9.2 Self Join
  • SQL Quiz 9

SQL Advanced: Window
  • 10.1 Window Function
  • SQL Quiz 10A
  • 10.2 Row number and Rank
  • SQL Quiz 10Br
  • 10.3 Window Function Mania
  • 10.4 Lag and Lead
  • SQL Quiz 10C

Frequently Answerd Question



No new version is really useless. Rather the new version takes time to be implemented. Documentation is available for all versions in Web Development. When you start work, you can decide which version to use. That will be shown in the course. And Syntax doesn't really have much of a difference with the previous version.


Total three projects: Blog, Social Media and E-commerce. How to Deploy in Server is also shown in the course.


No, only Backend has been worked on here. And the template used for Front-End. Note that Django is basically a Backend Web Development Framework.


You can do free-lancing by learning Django. However, there is nothing about free-lancing in our course. Free-lancing is up to you.


Lifetime! Once you buy a course, it will never expire, it will always be on your dashboard.



All videos of the course can be viewed from any smartphone, tablet or PC. However, since it is a course in programming and web development, you must use a laptop / PC to practice.


Completing all the tasks of the course will automatically bring the certificate to your dashboard, instantly. You can download and print it in PDF format. However, if you wish, we can print the certificate and deliver it to you by courier for a fixed service charge.


এইচটিএমএল, সিএসএস, কিংবা জাভাস্ক্রিপ্ট ছাড়াও পাইথন শিখতে পারবেন । এইচটিএমএল, সিএসএস, কিংবা জাভাস্ক্রিপ্ট জানা থাকলে খুব ভালো। তাহলে আপনি তারাতারি ওয়েব ডেভেলপমেন্ট এর কাজ করতে পারবেন অথবা অন্যান্য সাইটে যোগদান করতে পারবেন, তাই এইচটিএমএল, সিএসএস, কিংবা জাভাস্ক্রিপ্ট জানা থাকলে ভালো। না থাকলেও কোন সমস্যা নেই।

Get Connect






Become a Django Developer with Projects to Showcase

By the end of the course, you should be able to develop the back-end of three fully functional websites and put them on your portfolio. ????


Course Instructor


Kawser Chowdhury
Kawser Chowdhury
Developer at Softopark

Cras sit amet nibh libero, in gravida nulla. Nulla vel vestibulum in vulputate at, tempus viverra turpis. Fusce condimentum nunc ac nisi vulputate fringilla. Donec lacinia congue felis in faucibus.