- 31
- 7 825
Sejal Shah
Приєднався 21 чер 2023
CREATE TABLE in SQL #Constraints in SQL #NEP #DML commands | By Sejal Shah
BRANCH_MASTER(B_NO,B_NAME,LOCATION)
CUSTOMER_MASTER(C_NO,C_NAME,GENDER,DOB,CITY,CONTACT_NO)
ACCOUNT_MASTER(ACC_NO,ACC_TYPE,B_NO,C_NO,OPEN_DATE,CURR_ BALANCE)
Insert minimum 5 Records in each table
1) CURR_BALANCE should not be less than 1000.
2) Display details of male customers only.
3) Display the details of account opened in 2020.
4) List all records where current balance not less than 15000.
5) List all branch names where branch number is 101 or 103. @SejalShah1511
CUSTOMER_MASTER(C_NO,C_NAME,GENDER,DOB,CITY,CONTACT_NO)
ACCOUNT_MASTER(ACC_NO,ACC_TYPE,B_NO,C_NO,OPEN_DATE,CURR_ BALANCE)
Insert minimum 5 Records in each table
1) CURR_BALANCE should not be less than 1000.
2) Display details of male customers only.
3) Display the details of account opened in 2020.
4) List all records where current balance not less than 15000.
5) List all branch names where branch number is 101 or 103. @SejalShah1511
Переглядів: 18
Відео
CREATE TABLE in SQL | By Sejal Shah
Переглядів 372 години тому
CUST(CID,CNAME,CCITY,DOB) PROD(PID,PNAME,PCOST,PPROFIT) SALE_DETAIL(CID,PID,SALE,SALE_DATE) 1) City must be Ahmedabad, Surat and Baroda 2) Display the Name of customers who are born in 1995. 3) Display the name of product starts with “F”. 4) Display details of product having maximum sales. 5) Update all PPROFIT of product to 3000 where PCOST is greater than 200. @SejalShah1511
#DoublyLinkedList Operations in #DataStructures | By Sejal Shah
Переглядів 1619 годин тому
A doubly linked list operations in data structures using C @SejalShah1511
#SinglyLinkedList Operations in #DataStructure | By Sejal Shah
Переглядів 1819 годин тому
A menu driven program of Singly linked list in data structures using C. Operations: Create, Display, Insert ( At beginning, at end, before the number, after the number), Delete (At beginning, at end, before the number, after the number) @SejalShah1511
U1P5 #NEP-2020 #CheckboxListControl in ASP.NET | By Sejal Shah
Переглядів 10614 днів тому
U1P5-Create a web page having checkboxlist control shows different products. Web page should have a button and a label. On the click event of the button shows the message “Thank You for placing the order of following items” and then list of all products selected by the user from the checkboxlist server control. Each selected product should be displayed in the new line. @SejalShah1511
U1P4-#NEP-2020 #RadioButtonListControl in ASP.NET | By Sejal Shah
Переглядів 10814 днів тому
U1P4- Create a RadioButtonList that displays the names of some colors in two columns. Add a button to the web form which when clicked changes the background color of the form to the color selected from the list. Also show the use of external CSS file. @SejalShah1511
Unit-1_Pro-3 NEP-2020 | DLL file using ASP.NET with C# | By Sejal Shah
Переглядів 7714 днів тому
U1P3-Design a class file with two methods as sum and subtraction which takes two arguments. Design a web page to take two integer numbers from the user. When user clicks on sum or subtraction button, display the result of two entered values in the label control placed on the web page. (Use of App_code & Bin directory). @SejalShah1511
Insertion sort in Data Structure using C | By Sejal Shah | NEP-2020
Переглядів 1521 день тому
#NEP-2020 This program demonstrates use of insertion sort. For example, card game. we arrange card in ascending order while receiving a new card. @SejalShah1511
Selection Sort in Data Structure using C |NEP-2020 | By Sejal Shah
Переглядів 1121 день тому
#NEP-2020 Selection sort finds the smallest element from the list. For example, arrange files and folders in ascending order(minimum file size will be displayed first) @SejalShah1511
#BubbleSort in #DataStructure using C #NEP-2020 | By Sejal Shah
Переглядів 2721 день тому
A program to implement bubble sort in C. #NEP-2020 @SejalShah1511
#BinarySearch in Data Structure Using C #NEP-2020 | By Sejal Shah
Переглядів 2728 днів тому
A C program to implement binary search in array. #NEP-2020 @SejalShah1511
#LinearSearch#SequentialSearch in #C #datastructures | By Sejal Shah
Переглядів 5828 днів тому
A linear search program in data structures using C @SejalShah1511
#PanelControl#Coderenderblock#LinkButton in ASP.Net using C# | By Sejal Shah @SejalShah1511
Переглядів 189Місяць тому
Unit-1_Pro-2_Take two linkbuttons showing ‘New Member’ and ‘Existing Member’. When user clicks on the ‘New Member’ link button panel1 becomes visible, having user name, password, confirm password and email, city as inputs. When user clicks on ‘Existing Member’ link button then only panel2 becomes visible having user name and password as inputs. Set proper property of the textbox to mask the pas...
#LITERALControl in ASP.NET using C#InternalCSS#External CSS| By Sejal Shah @SejalShah1511
Переглядів 223Місяць тому
Unit-1_Pro-1_Create a form which takes user name in TextBox control. On the click event of the button, name of the user and current date & time will be displayed on the title bar of the web page. (Using Literal control). Also show the use of CSS property to change the text color of a button control using internal and external CSS. @SejalShah1511
#hscrollbar#changecolor using C# | @SejalShah1511
Переглядів 81Рік тому
This windows appliaction chnages back color generated by hscrollbar
Windows Application using #hscrollbar that chanages color #chnagecolor using C# | By @SejalShah1511
Переглядів 89Рік тому
Windows Application using #hscrollbar that chanages color #chnagecolor using C# | By @SejalShah1511
#calculator#Arithmetic using C# | By @SejalShah1511
Переглядів 101Рік тому
#calculator#Arithmetic using C# | By @SejalShah1511
U1P1 Form Application of Calculator for power, factorial, log using C# | @SejalShah1511
Переглядів 155Рік тому
U1P1 Form Application of Calculator for power, factorial, log using C# | @SejalShah1511
#CheckBoxList control in ASP.NET using C# | By Sejal Shah
Переглядів 728Рік тому
#CheckBoxList control in ASP.NET using C# | By Sejal Shah
#RadioButtonList in ASP.NET using C# | By Sejal Shah
Переглядів 413Рік тому
#RadioButtonList in ASP.NET using C# | By Sejal Shah
#DropDownList #Label #Textbox # Button in ASP.NET using C# | By Sejal Shah
Переглядів 579Рік тому
#DropDownList #Label #Textbox # Button in ASP.NET using C# | By Sejal Shah
#CodeRenderBlock in ASP.NET using C# | By Sejal Shah
Переглядів 404Рік тому
#CodeRenderBlock in ASP.NET using C# | By Sejal Shah
#PanelControl in ASP.NET using C# | By Sejal Shah
Переглядів 386Рік тому
#PanelControl in ASP.NET using C# | By Sejal Shah
#Stack #StackOperations #StackImplementation in C | By Sejal Shah
Переглядів 136Рік тому
#Stack #StackOperations #StackImplementation in C | By Sejal Shah
#HitCounter using Global.asax in ASP.NET | By Sejal Shah
Переглядів 500Рік тому
#HitCounter using Global.asax in ASP.NET | By Sejal Shah
#Literal Control in ASP.NET with C# | By Sejal Shah
Переглядів 461Рік тому
#Literal Control in ASP.NET with C# | By Sejal Shah
Global.asax file in ASP.NET | How to use Global.asax | By Sejal Shah
Переглядів 460Рік тому
Global.asax file in ASP.NET | How to use Global.asax | By Sejal Shah
App_Code directory in ASP.NET | By Sejal Shah
Переглядів 591Рік тому
App_Code directory in ASP.NET | By Sejal Shah
#CssClass Property in ASP.NET | By Sejal Shah
Переглядів 505Рік тому
#CssClass Property in ASP.NET | By Sejal Shah
AutoCompleteType Property of TextBox in ASP.Net | By Sejal Shah
Переглядів 981Рік тому
AutoCompleteType Property of TextBox in ASP.Net | By Sejal Shah
Thank you. 🤗
Thank you so much sejal maam I'm in your clg student ❤🤗lost of love 😊
😉 'promo sm'
Thank you so much maam ❤🤗
Keep watching
@@SejalShah1511 Sure maam.
Very nice video 🙏😄