Maintaining data integrity is crucial for ensuring the accuracy and reliability of data stored in a database. It helps to prevent data inconsistencies, errors, and other issues that can lead to incorrect results, data corruption, and other problems. Therefore, it's important to define and enforce data integrity rules in SQL databases to ensure that data remains consistent and reliable over time.

💥4 NEW OPPORTUNITIES ‼️

1. *Juspay's Hiring Challenge is here*

*Package* - 21-30 LPA and 40K/month Stipend to Interns

*Eligibility* - Freshers and Working Professionals

*Apply Here* - https://unstop.com/o/bJKCuZN?ref=4OpLp8GF



2. *Accenture Hiring Challenge For Women in Engineering*

*Package* - 4.5 LPA

*Role* - Associate Software Engineer

*Eligibility* - Women Engineer's from Batch of 2022 and 2023

*Apply Here* - https://unstop.com/o/YQjws24?ref=QgGVjVUb



3. Scaler is looking for Problem Setter Intern (2024 and 2025 grads eligible)

Requirements: codechef 5star or codeforces 1700+ above rating

Apply: https://docs.google.com/forms/d/e/1FAIpQLSeu932MGjfM76CCcY3LsARvo0hDoATcCzQF5qV6oBwVp6_CXg/viewform





4. Physics Wallah is hiring for QA Intern(SDET) role

Batch eligible: 2022 and 2023 grads.

If interested, send your resume at jitendra.shukla@pw.live

Note: Previous QA experience will be a plus.



Apply now ♂️

Checkout for Accenture opening all girls

The deadline is 3pm today

One of the leading banks in India is looking to *hire 500+ girls* who are in last year of their graduation (only UG) across streams in their Women Graduate Leadership Program at an *CTC of INR 7 LPA.*

They will be opening it to around *300+ colleges* basis some criteria as it is the first time they are looking at doing such an exercise. And we'd like to propose all colleges in our network to them so that they can select. Please note final decision will be with them.

*Please fill the below form* if you'd like your college to be considered for this hiring opportunity. We already have details of some of you but still fill it again, if possible. *It won't take you more than 1 minute.*

Deadline: Today 3 PM (Sorry about the short deadline)

Link: https://forms.gle/VUYw4gWbG86kxmFy7


Apply now ♂️

***PROMOTED POST***

Summer Internship 2023
16th May to 21st Jul 2023 (10 weeks)
❗️Sign up closes on 31st March 2023

What you can expect:
✅    Internship Allowance ($1200)
✅    Fully sponsored 4D3N Overseas Business Trip
✅    Fully sponsored MAS Financial Certifications during internship

During this internship you will:     
•  Explore the different career tracks in the financial services industry 
•  Learn from Top Practioners on wealth & risk management for different markets    
•  Acquire Financial Analysis & Portfolio construction skills
•  Gain hands-on entrepreneurship experience    
•  1-1 mentorship opportunity with award winning industry practitioners
•  Post-Internship conversion opportunity for Management Associate position while studying
    
Email your resume to chatwithus@theaagencypeople.com
    
Shortlisted candidates will be contacted

☎️ DM  for any enquiries

Email on above email address

COCKTAIL | Premium Coworking | Managed Office
https://maps.app.goo.gl/hZt5G58SpgHBcyC38


Work location

Email on vijay.gururaja@6degree.co

Shopee: Data Analytics Intern (Summer)

✍🏼 Description:
- Identify opportunities and collaborate with both internal and external teams to achieve overall business objectives and growth attainment
- Utilise SQL to efficiently extract data for end-users
- Assist full-cycle projects on data acquisition, data cleaning, data analysis and data visualisation

🎓 Qualifications:
- Bachelor's degree or higher in Analytics, Mathematics, Statistics, Engineering, Computer Science or other related field
- Proficient in Microsoft Excel, SQL and Python

Full-time interns are preferred (3-6 months)

📚 Level: Intermediate
Given the relative competitiveness of Shopee, try to apply if you have prior experience in data roles for higher chance. Good showcase of projects, and a overall good portfolio will give you a better shot. Technical test should be manageable, so work more on interview


👉🏼Application Link

💼 💰https://careers.shopee.sg/job-detail/J00076432/1?channel=10001

Description

As a JAVAHYDTEAM admin user when I receive a user's request to delete their data permanently from the system, I should have a functionality to delete the user's data using the admin dashboard screen.

This functionality should be available only to the Admin user role.

Admin dashboard screen design should be as below:

The screen design should be as given below:

The Email address should be put on the screen and the user's account will be populated.

1. Columns

a. Checkbox

Priority

b. User_id

c. Email

d. First name

Severity

Risk

e. Last name

f. ciam_sync_strategy

2. Delete button

a. A confirmation popup must be there before deleting the data. (implement the popup layout already used in Admin Dashboard for

reference refund screen refund completed popup)

b. The message which is shown in the confirmation popup is given below:

Are you sure you want to permanently delete the selected user?

Once confirmed the data can not be recovered. Click Okay to confirm or Cancel to go back.

1. A new database table should be created to log the delete user's data activities.

a. Admin user ID

b. deleted email

c. deleted_date

Complete this requirement