Aug 06

In English: Course Introduction: Effective Teaching Skills

https://youtu.be/hbDtB79v5Zs

Aug 05

Step 2 Review Report a DSL Automate Initial and Exploratory Analysis for Data analytics projects

Aug 05

Step 1 A DSL to Automate Initial and Exploratory Analysis for data analytics project

Aug 01

PHP Topics to Learn

Identifiers https://docstore.mik.ua/orelly/webprog/php/ch02_01.htm#:~:text=An%20identifier%20is%20simply%20a,ASCII%200x7F%20and%20ASCII%200xFF. PHP Data Types https://www.odinschool.com/learning-hub/php/datatypes Type Hinting https://www.honeybadger.io/blog/php-type-hinting/#:~:text=Type%2Dhinting%20means%20explicitly%20stating,to%20write%20more%20robust%20code. PDO and MySQL https://www.w3schools.com/php/php_mysql_connect.asp PHP OOP https://www.w3schools.com/php/php_oop_what_is.asp abstract classes https://www.w3schools.com/php/php_oop_classes_abstract.asp Abstract vs Interface https://www.w3schools.com/php/php_oop_interfaces.asp#:~:text=PHP%20%2D%20Interfaces%20vs.%20Abstract%20Classes&text=Interfaces%20cannot%20have%20properties%2C%20while,abstract%20keyword%20is%20not%20necessary , methods, interfaces, and inheritance Pillars of OOP The Four pillars of OOPs, abstraction, encapsulation, inheritance, and polymorphism, are integral to understanding and using OOP https://datatrained.com/post/four-pillars-of-oops/#:~:text=The%20Four%20pillars%20of%20OOPs%2C%20abstraction%2C%20encapsulation%2C%20inheritance%2C,to%20understanding%20and%20using%20OOP. Four Pillars with Examples: https://www.geeksforgeeks.org/four-main-object-oriented-programming-concepts-of-java/ Magic Method https://www.php.net/manual/en/language.oop5.magic.php https://www.geeksforgeeks.org/what-are-magic-methods-and-how-to-use-them-in-php/ Overloading and Magic Methods https://www.geeksforgeeks.org/overloading-in-php/

Jul 30

In English, Laravel Concepts

https://youtu.be/0zFsFGclpLM

Jul 23

In English, Backbone.Js By Example

https://youtu.be/8uGh7IMLhH0

Jul 16

in English (start at around 54 seconds) introduction to isotope : Magical web layouts with ISOTOPE

https://youtu.be/ctMouCNhZ9E

Jul 09

In Bengali, PHPStorm Debug Configuration for PHP and Laravel applications

https://youtu.be/FxCPKPchsLk

Jul 02

In Bengali, Overview of a Laravel Project

https://youtu.be/pZVS8tnAIkM

Jun 25

MS SQL Server Dynamic SQl, T-SQL

MS SQL Server
Dynamic SQl, T-SQL

  • Mostly:

  • Dynamic SQL

  • Stored Procedure

  • Trigger

  • Cursor

  • Function

  • Sayed Ahmed

What are the Most Important
Most Used

  • Design ERD

  • Convert ERD to database

  • Normalization

  • Indexing

  • SQL

  • Stored Procedure

  • Dynamic SQL

  • These will come, not too frequent

  • Function, User Defined Data Types, Temporary Table

  • Trigger, Cursor

  • SSRS, SSIS, SSAS

  • ML in SQL Server (in advanced level)

  • May not be important initially

Today

  • More on

  • Dynamic SQL

  • Stored Procedure

  • Cursor

Basics of Stored Procedure

From Northwind Database

Dynamic SQL

  • DECLARE    @table NVARCHAR(128), @sql NVARCHAR(MAX);

  • SET @table = N’Products’

  • SET @sql = N’SELECT * FROM ‘ + @table;

  • EXEC sp_executesql @sql;

Convert the previous to a stored procedure

Using dynamic SQL to query from any table    of Northwind Database

Write a stored Procedure for it
table name as the parameter

Create or ALTER      Procedure    [dbo].[usp_query] ( @table NVARCHAR(128))
AS
BEGIN