Home » Members

Name	Apurva Mathur
Course	Bachelor of Technology (B.Tech) in Computer Science
College / University	ITM Gwalior, MP
Technical Skills	Python, Django, JavaScript, HTML, CSS, C, C++, MySQL

Her submissions

MCQs

1. OOPs MCQs
2. Project Management MCQs
3. Operating System MCQs
4. Energy and Environment Engineering MCQs
5. MySQL MCQs

Django

1. What is the difference between null=True and blank=True in Django?
2. How to Check Django Version?
3. What is 'SLUG' in Django?
4. What does on_delete do on Django models?
5. Set up a scheduled job in a Django project?
6. Django – How to filter empty or NULL names in a QuerySet?
7. Creating a JSON response using Django and Python

CSS

1. What does the '+' (plus sign) CSS selector mean?
2. How to apply !important using .css()?
3. Space between two rows in a table using CSS
4. Can I use a ::before or ::after pseudo-element on an input field?
5. CSS force image resize and keep aspect ratio
6. Hiding a scroll bar on an HTML page
7. Can the :not() pseudo-class have multiple arguments?
8. Limit text length to n lines using CSS
9. Why em instead of px?
10. Make body have 100% of the browser height
11. Changing the color of an HR element
12. How do I wrap text in a pre tag?
13. What does the '~' (tilde/squiggle/twiddle) CSS selector mean?
14. CSS opacity only to background color, not the text on it?
15. Stretch and scale a CSS image in the background - with CSS only
16. How to make a vertical line in HTML using CSS?
17. How can I make a div stick to the top of the screen once it's been scrolled to?
18. How do I center floated elements using CSS?
19. How can I 'disable' zoom on a mobile web page?
20. Should I size a textarea with CSS width / height or HTML cols / rows attributes?
21. How to remove the underline for anchors (links)?
22. Create a Page with Sidebar and Main Content Area using HTML & CSS
23. Styling First Letters with CSS ::first-letter
24. Table Fixed Header and Scrollable Body
25. Is it possible to include one CSS file in another?
26. How to center your website horizontally with CSS?
27. How to create a 3-column layout grid with CSS?
28. How to create a 4-column layout grid with CSS?
29. How to create CSS3 Rounded Corners?
30. Change Bullet Color for Lists with ::marker CSS Selector
31. How to Create a Triangle Using CSS clip-path?
32. Indent Text with CSS text-indent Property
33. Managing Spacing between Words with CSS word-spacing Property
34. How to create a navigation menu with an input field inside of it?
35. How margin and padding properties work?
36. Change Image Opacity on Mouse Over
37. How to create an unordered list without bullets using CSS?
38. How to create equal height columns with CSS?
39. How to center an element vertically and horizontally with CSS?
40. How to create Border Images in CSS?
41. How to create a fixed footer using CSS?
42. How to create different dividers with CSS?
43. How to use google fonts on your webpage?
44. Does 'display:none' prevent an image from loading?
45. How to place text blocks over an image using CSS?
46. How to create a search button with CSS?
47. How to align images side by side with CSS?
48. How to create rounded and circular images with CSS?
49. How filter property works in CSS?
50. Applying Hue Rotation on Image using CSS3
51. How to change the thickness of <hr> tag?
52. How to add visual effects to images with CSS?
53. How to create a black and white image with CSS?
54. How to create a contact form with CSS?
55. Difference between '.' and '#' selector in CSS
56. How to create an email newsletter with CSS?
57. Text in Transparent Box using CSS3
58. How to Create CSS3 Keyframe Animations?
59. How to change background color in CSS?
60. Change Cursor Color with CSS caret-color Property
61. How to set Text alignment in HTML using CSS?
62. How to change link underline color using CSS?
63. How to style a checkbox using CSS?
64. How to right-align the flex item?
65. How to create icon buttons with CSS?
66. How to create Previous and Next buttons with CSS?
67. How to create and style text buttons with CSS?

MySQL

1. MySQL Introduction
2. MySQL Workbench Installation
3. MySQL RDBMS
4. MySQL SQL
5. MySQL CREATE DATABASE Statement
6. MySQL SELECT Database
7. MySQL DROP DATABASE
8. MySQL CREATE TABLE
9. MySQL INSERT INTO
10. MySQL ALTER TABLE
11. MySQL SHOW TABLES
12. MySQL UPDATE
13. MySQL DELETE
14. MySQL DROP TABLE
15. MySQL RENAME TABLE
16. MySQL WHERE Clause
17. MySQL DISTINCT Clause
18. MySQL ORDER BY Clause
19. MySQL LIMIT Clause
20. MySQL GROUP BY Clause
21. MySQL AS Clause
22. MySQL HAVING Clause
23. MySQL FROM Clause
24. MySQL AND Operator
25. MySQL OR Operator
26. MySQL NOT Operator
27. MySQL LIKE Operator
28. MySQL IN Operator
29. MySQL BETWEEN Operator
30. MySQL NOT EQUAL TO (!=) Operator
31. MySQL ANY Operator
32. MySQL EXISTS Operator
33. MySQL IS NULL Operator
34. MySQL IS NOT NULL Operator
35. MySQL PRIMARY Key
36. MySQL UNIQUE Key
37. MySQL CANDIDATE Key
38. MySQL FOREIGN Key
39. MySQL SUPER Key
40. MySQL Comments
41. MySQL Data Types
42. MySQL DESCRIBE Statement
43. MySQL TRUNCATE TABLE
44. MySQL Copy Table
45. All MySQL date/time Functions
46. ADDDATE() Function
47. DATE_ADD() Function
48. DATE() Function
49. CURDATE() Function
50. CURRENT_DATE() Function
51. DATEDIFF() Function
52. DAY() Function
53. DAYOFMONTH() Function
54. DAYNAME() Function
55. DAYOFWEEK() Function
56. DAYOFYEAR() Function
57. FROM_DAYS() Function
58. HOUR() Function
59. ADDTIME() Function
60. CURRENT_TIME() Function
61. CURRENT_TIMESTAMP() Function
62. CURTIME() Function
63. LAST_DAY() Function
64. LOCALTIME() Function
65. LOCALTIMESTAMP() Function
66. MAKEDATE() Function
67. MAKETIME() Function
68. MICROSECOND() Function
69. MINUTE() Function
70. MONTH() Function
71. MONTHNAME() Function
72. NOW() Function
73. PERIOD_ADD() Function
74. PERIOD_DIFF() Function
75. QUARTER() Function
76. SEC_TO_TIME() Function
77. SECOND() Function
78. DATE_FORMAT() Function
79. TIME() Function
80. TIME_FORMAT() Function
81. TIME_TO_SEC() Function
82. TIMEDIFF() Function
83. TIMESTAMP() Function
84. TO_DAYS() Function
85. STR_TO_DATE() Function
86. SUBDATE() Function
87. SUBTIME() Function
88. SYSDATE() Function
89. WEEK() Function
90. WEEKDAY() Function
91. WEEKOFYEAR() Function
92. YEAR() Function
93. YEARWEEK() Function
94. How can you order the result obtained by select query in MySQL?
95. Difference between ALTER and UPDATE Commands in MYSQL
96. Difference Between Left, Right and Full Outer Join in MySQL
97. Difference Between Inner Join and Outer Join in MySQL
98. Difference Between WHERE Clause and HAVING Clause
99. Difference between DELETE and TRUNCATE
100. How to list/show tables in MySQL database?
101. How to create and select a MySQL database?
102. How to describe a table in MySQL?