🚀 Medial Secures Investment on Shark Tank India - Fueling the Future of Professional Social Networking. 🔥

News

Messages

Try our Valuation Calculator →

Back

Sanskar

Keen Learner and Exp... • 6m

Day 26 of learning python as a beginner. Topic: CRUD operations in python postgreSQL. I had tried to explore SQL database handling in python and someone suggested me that I should also try performing CRUD (Create, Read, Update and Delete) operations in it. Although I have performed CRUD using the code however it was my first time doing the same by using a SQL database. While programming I was getting ideas of using try except (error handling), using match case (for selection of operation) however I decided to stick to CRUD only for now. I created four functions to perform each operations and used with keyword which someone has suggested me. Some of the SQL keywords I used are as follows: 1. INT PRIMARY KEY: this means that the type of value will be an integer and the primary key means that it is necessary for it to be entered. 2. VARCHAR: you can call it like a string as it can take data with strings, integers, special characters etc. 3. CHAR: this is a one word character which I used to enter the value of gender. And here's my code and its result in both console and database.

Recommendations from Medial

Sanskar

Keen Learner and Exp... • 6m

Day 25 of learning python as a beginner. Topic: database handling. I used to write simple programs which just showed some text in the console when I started learning python. I didn't used to store that data somewhere because I didn't know how to.

Mantra Pandya

Learning is real wea... • 18d

Hello everyone day17/100 Completed SQL DDL commands today. Implemented Primary Key, Foreign Key, NOT NULL, UNIQUE, DEFAULT, AUTO INCREMENT, and CHECK constraints. Practiced their implementations using DDL queries. #SQL #DDL #Database #DailyLearning #

2 Replies

Sidharth Singh

Backend Developer • 3m

can anyone refer me somewhere; my primary skills (which I almost use daily) are :- Python, Git/GitHub, AWS (RDS, EC2, ECS, S3, Lambda), Jenkins, SQL, and Docker. Really appreciate it!

2 Replies

Mantra Pandya

Learning is real wea... • 20d

Hello everyone Day 16/100 Daily Learning Update Studied SQL DDL commands today. Covered constraints, transactions, and normalization. Learned Primary Key, Foreign Key, NOT NULL, UNIQUE, DEFAULT, AUTO INCREMENT, and CHECK. #SQL #DDL #Database #DailyLe

Ravindra Gudala

Hey I am on Medial • 13d

I am eager to prove myself with Python, full-stack development[React + Django], and SQL and "operations", If someone working on real time project loop me in to show what can i contribute. I have wasted a lot of time, now i want a chance to prove myse

Hitendrasinh Chauhan

Software Engineer | ... • 6m

🚀 Open to Full Stack (.NET + Angular) Developer Role 🎯 I have 1 year of experience as a Full Stack Developer, working alongside my studies. I've built responsive web applications and robust backend systems. 🛠️ Tech Stack: ASP.NET (C#) | Angular

Vikram Kumar Raju

Validation Engineer • 1y

I have lost my job in last month due to office politics, I am a seasoned python developer with skills in flask, html, css, SQL and bootstrap. Can anyone refer me. I had an experience of 7 months. Thanks in advance.

Sanskar

Keen Learner and Exp... • 6m

Day 12 of learning python as a beginner. Topic: object oriented programming (OOP). Yesterday I shared a journal taking app and many people suggested that it would be great if I used classes. Initially I was not aware of what classes actually are an

Comet

#freelancer • 1y

What is SQL? "Guys, ever wondered how data analysts 'talk' to databases? It’s with SQL! Think of SQL as the language of data. Just like English or Hindi helps us communicate, SQL lets us interact with databases. Here’s the cool part: SQL is super

3 Replies

Sajal Kumar

CTO | Full stack dev... • 1y

Hey everyone, Can someone suggest me a good and cheapest cloud media database which can be used with mongodb and express where front-end is developed using react native