Category: ব্লগ । Blog

ব্লগ । Blog

Database Design in Pictures

Database Design in Pictures https://www.youtube.com/watch?v=LpCFCkCxVSk&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D Watch on Youtube

Learn Some Data Flow Diagram (DFD)

Learn Some Data Flow Diagram (DFD) https://www.youtube.com/watch?v=FROyc00v9Sw&pp=ygUac2FsZWFybmluZ3NjaG9vbCBzaXRlc3RyZWU%3D

SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar

SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar https://youtu.be/uje72uNAT6I?list=PLUA7SYgJYDFoharKbJxz2Hxw6xQITXvBn

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 …

Continue reading

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 …

Continue reading

Some Topics to Know and Understand to prepare for a DBMS related Job Interview

Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https://www.geeksforgeeks.org/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency. non key attributes must have …

Continue reading

Putin Slams Russian mercenary revolt as ‘treason’: Weekend Reads

Best of Bloomberg Opinion This Week Water Risks Are Coming to Bite Investors: Lara Williams The World Ignores Africa at Its Peril: Brooke Sample Italy’s Not the Economic Basket Case You Thought: Lionel Laurent US and India Need to Deal With Their Trust Issues: Mihir Sharma China Wants to Buy Off Europe. The Price Is …

Continue reading

The TechCrunch Exchange – Keeping tabs on dry powder and university spinouts

Newest Jobs from Crunchboard Data Architect at AAOS (Rosemont, IL, USA) Infrastructure Engineer at AAOS (Rosemont, IL, USA) Senior Data Engineer at UpClear (New York, NY, USA) Cloud Infrastructure and Security Lead at UpClear (New York, NY, USA) IT Specialist (INFOSEC/APPSW at Bonneville Power Administration (Portland, OR, USA)

IBM nears $5 billion deal for software provider Apptio, Wall Street Journal reports

Tweet Share IBM nears $5 billion deal for software provider Apptio, Wall Street Journal reports YouTube is testing an online-games offering, Wall Street Journal reports Amazon raises investment in India to $26 billion by 2030 EU, Meta agree to July stress test on EU online content rules Japan’s JSR says it is considering being bought …

Continue reading

Week in Review – OceanGate fires a whistleblower, hackers threaten to leak Reddit data, and Marvel embraces AI art

OceanGate fired a whistleblower: Hackers threaten to leak Reddit data: Reddit protests continue: Google Pixel Tablet review: Microsoft gets serious about quantum: WhatsApp gets automatic silencing: Marvel’s AI art controversy: Board members quit Byju’s: Europe’s and Israel’s unicorns: Coinbase, the next super app: AI infiltrates crowdsourced work: Read more stories on TechCrunch.com Newest Jobs from …

Continue reading