Skip to main content

Posts

SQL Batabase

SQL:- Structured Query Language Install Xampp.  Install My SQL Workbench. Create Database using below mentioned query:- create database Dpk Datatypes in MySQL:- String Numeric Date and time     Create Database:- create database dpk; execute above query in mysql workbence then create a table using below query:- create table Product( pid int,     pname varchar(50),     pcompany varchar(50),     price int ); show table by using below query:- SELECT * FROM dpk.product; how to insert Data in table:- insert into personal (id, name, birth_date, phone, gender) values(1, "Deepak Tewatia", "1997-08-02", "8398979594", "M") list of constraints in MySQL not null unique default check foreign key primary key to set conditions create table test_2(  id int not null unique, name varchar(50) not null,     age int not null check(age>=18),     phone varchar(12) not null uniq...

Web Development

  WEB DEVELOPMENT FOR FULL STACK DEVELOPMENT C# .net core  .net core API Learn above mentioned course using "freecodecamp" youtube channel UI UI Frame Angular React JS Blazor PHP CSS BOOTSTRAP "Yahoo Baba" youtube channel

Learn HTML Basic

Learn HTML Basic Anyone check the HTML and JavaScript cope of any website in browser using Inspect element button (ctrl+shift+i). Inspect element button can found on clicking right click of mouse in browser such as google chrome, Microsoft edge etc.

How to Host any stable website on github

First of all we need to make a stable website script using any language here i am using HTML.  then login into github  then create a repository as shown in below snapshot. then use below mention commands in git bash cmd. git init git status git add README.md git status git commit -m "first commit" git branch -M master git remote add origin https://github.com/DpkTewatia/Dpk_Tewatia.git git push -u origin master …or push an existing repository from the command line git remote add origin https://github.com/DpkTewatia/Dpk_Tewatia.git git branch -M master git push -u origin master Finally your static website hosted on GitHub and whole source code added on GitHub repository.

Learn Python (Python 3.9 (64 bit))

 Learn Python  Today (24.04.2021) I start learning Python (Python 3.9 _ 64-bit). so first of all we need to install python using official website i.e.  https://www.python.org/downloads/ and download Visual Studio code using their official website i.e. https://www.code.visualstudio.com/ Basic commands are given below which we need to know before making any project in python:- # comment out anything (ctrl+/) Ctrl+\ :- to make multi open tabs in VS CODE PWD:- Print work directory CD:- Change Directory LS:- MKDIR:- Make directory CLEAR:- Clear all previous commands TOUCH:- make any new file RM:- Remove any file RRM:- Remove any folder MV:- Rename ‘current name’ ‘new name’ MV:- Move and file from one folder to another ‘file name’ ‘new path’ RRM:- Folder remove CP:- Copy  . :- Single dot #current path to next folder .. :- Double dot # one step back Print ("Hello World") :-  Parenthesis Escape Sequence  \' :- Single Quote \" :-   Double Quote \\  :-...

IoT Virtual Conference

Fun and learning from data to AI on the edge #IoT #IoTConference #InternetOfThings #stratisplatform #Stratis #AI by @hboelman Thank you so much @CsharpCorner for this conference.🙏 @codewithsimon @Stratis_Faction @stratisplatform https://t.co/58AkDdXW8Q pic.twitter.com/kIJL9HjqVj — Dpk Tewatia (@DpkTewatia) April 23, 2021