Coder Baba

Don't forget to understand these essential SQL topics if you're just starting out. 1. SQL Basics - SELECT Statement: It's like asking the database for specific information. - FROM Clause: Tells the database where to look for that information. - WHERE Clause: Filters out the stuff you don't need. - ORDER BY Clause: Arranges the results in a specific order. 2. Data Manipulation - INSERT: Adds new data. - UPDATE: Changes existing data. - DELETE: Removes data. - MERGE: Combines these actions. 3. Data Definition - CREATE TABLE: Makes a new table. - ALTER TABLE: Edits an existing table. - DROP TABLE: Deletes a table. - INDEXES: Helps with finding data quickly. 4. Constraints - PRIMARY KEY: Ensures each row is unique. - FOREIGN KEY: Keeps data relationships intact. - UNIQUE: Ensures values are unique. - DEFAULT: Sets a value if none is given. 5. Joins (Really Important) - INNER JOIN: Combines data from different tables. - LEFT JOIN: Gets all data from one table and matching data from another. - RIGHT JOIN: Opposite of LEFT JOIN. - FULL JOIN: Gets data if it's in either table. - SELF JOIN: Links data within the same table. 6. Subqueries: - Correlated Subqueries: Subqueries connected to the main query. - Scalar Subqueries: Subqueries that return a single value. - Subquery in FROM Clause: Using a subquery as a table. 7. Aggregation Functions: - SUM, COUNT, AVG, MAX, MIN: Math on groups of data. - GROUP BY: Groups data before doing math. - HAVING: Filters groups based on math results. 8. Views: - CREATE VIEW: Makes a pretend table. - ALTER VIEW: Changes the pretend table. - DROP VIEW: Deletes the pretend table. 9. Transactions: - BEGIN TRANSACTION, COMMIT, ROLLBACK: Ensures data stays safe and consistent. - ACID Properties (Important): Rules for safe transactions. 10. Database Security: - GRANT and REVOKE: Decides who can do what. - Roles: Groups of permissions for users. 11. Normalization (Important): - 1NF, 2NF, 3NF, BCNF, 4NF: Ways to organize data for efficiency and accuracy. 12. Indexes: - Clustered vs. Non-Clustered Indexes: Different ways to find data quickly. 13. Database Management Systems (DBMS): - Different software tools for working with databases, like MySQL etc.

TempData Vs Session in ASP .NET MVC: 👉🏻TempData ✅TempData allow us to persisting data for the duration of single subsequent request. ✅ASP. net MVC will automatically expire the value of tempdata once consecutive request returned the result (it means, it alive only till the target view is fully loaded). ✅It valid for only current and subsequent request only ✅TempData has Keep method to retention the value of TempData. Example: TempData.Keep(), TempData.Keep(“EmpName”) ✅TempData internally stored the value in to Session variable. ✅It is used to stored only one time messages like validation messages, error messages etc. 👉🏻Session: ⚡️Session is able to store data much more long time, until user session is not expire. ⚡️Session will be expire after the session time out occurred. ⚡️It valid for all requests. ⚡️N/A ⚡️Session variable are stored in SessionStateItemCollection object (Which is exposed through the HttpContext.Session property of page). ⚡️It is used to stored long life data like user id, role id etc. which required throughout user session. ⚡️TempData and session, both required typecasting for getting data and check for null values to avoid run time exception.

Java Programming PROBLEM: DIFFERENT DATATYPES Write a program to ask the user to enter an int, float, char, string, long and boolean data type values and to print its value. Input and Output Format: Refer Sample Input and Output for formatting specifications. Sample Input and Output: [All text in bold corresponds to input and the rest corresponds to output] Hint: Use String format() method or Math.round() method - for all floating point values displayed correct to 2 decimal place. Enter integer 56 Enter float 56.65 Enter character A Enter string Java Enter long 12345678910 Enter boolean true 56 is an integer value 56.65 is a float value A is a character value Java is a string value 12345678910 is a long value true is a boolean value

5 certifications to take your career to the next level 👨‍💻👩‍💻 1. Computer Science https://pll.harvard.edu/course/cs50-introduction-computer-science 2. JavaScript https://freecodecamp.org/learn/javascript-algorithms-and-data-structures/ 3. Python https://cs50.harvard.edu/python/2022/ 4. Digital Marketing https://learndigital.withgoogle.com/digitalgarage/course/digital-marketing 5. Project Management https://msicertified.com/project-management/project-management-essentials-certified/

Java Tutorial Video Links ————————————- Java Tutorial Videos link ------------------ Java variable part-1 https://youtu.be/ndDR0iAsrvA?si=T0BdzPnyqRg7asFw Java Data Type part-2 https://youtu.be/FwTRYI0f3Mc?si=ME81T4tOkW9dkinJ Token,Identifier, keywords, constant and Literal in java Programming part-3 https://youtu.be/mLFRI12RMC0?si=uZhTUxJJXJQpGznE Member and Local variable in java part-4 https://youtu.be/LeZrhL6hpDo?si=VQL9NR90T5Rd6I0k Principles of OOP in Java part=5 https://youtu.be/LeZrhL6hpDo?si=VQL9NR90T5Rd6I0k Fundamental characteristic of OOPs in Java part-6 https://youtu.be/zsogM0R_HH8?si=4GeR0P1Y543v_hIO Introduction of Java | Definition of Java | History of Java part-7 https://youtu.be/uu1FH_NSz54?si=RwKbrXL_8Pm_cYsW How java programming language created part-8 https://youtu.be/C-dE5efh044?si=NSGuH7t6lbn5hOBu Edition of Java programming part-9 https://youtu.be/Q1JYvPyEdbQ?si=KjHThTPl2JzO2bLT Characteristics of Java part-10 https://youtu.be/-WS8lg2oz5M?si=WATdzluOPhycThzW what is Entry Controlled Loop and Exit Controlled Loop in Java part-11 https://youtu.be/DD2MAGBFN-M?si=0XBljXOpKStfymkK Java Installation part-12 https://youtu.be/U2zJ3_Spq0s?si=HLS3nhYKw4Nr1lol what is Method in java part-13 https://youtu.be/PF3RIcsuNEg?si=LDvts0GrjJwW3IW8 Source code, source file, compilation in java part-14 https://youtu.be/qhzKRxby9_I?si=h5VvERnII7FzDXhS why java is platform Independent? https://youtu.be/Hb8-2uoJ9sI?si=xOSS9UIJO8idqImR Java Eclips IDE installation https://youtu.be/3Qjf8pznQIU?si=Yx6Rk9U2jy8Kr0XM Java Architecture | how to execute java code https://youtu.be/XJ2yU4IcUy0?si=FCz5x1IePstOSdPq Analysis of Interpreter https://youtu.be/-VvmMmuZtqI?si=TFmNdWX47jRAWxVJ java architecture https://youtu.be/p-3OwLNKm3A?si=xePYR39A18e26SAn java development kit (JDK) https://youtu.be/WyJ7fceuJIY?si=KtUOHSA1AbuAwwKF Java Standard Library in Java https://youtu.be/joex1oDMcR0?si=oOOWFDLZ2YUlpKbD Java Exercise questions https://youtu.be/2bMJ1TjmTOQ?si=clD0xqxEEDM3bImv Hello world programm in Java https://youtu.be/Mig8Tq5Nrjg?si=cv0lM7xm6jFkP7m2 type of comments in java https://youtu.be/P8nztKcV_wg?si=RYRh48s2WOYDlIzn java character set https://youtu.be/t8mWSgM9vaI?si=66VF0IVBqMKkSVXE Keywords in Java https://youtu.be/iUKZxe4wXx0?si=b6L375wxFopH1Isg Identifiers in java https://youtu.be/fpeZtmNvwYs?si=90bqJzkluutRZPLa Constants in java https://youtu.be/UUCrSnx-Nqo?si=mmP_clW_2vX4FplI

Java Data Type https://youtu.be/FwTRYI0f3Mc?si=ME81T4tOkW9dkinJ