🚀 Announcing the Ultimate SQL Server Mastery Course! 🎓
Are you ready to unlock the full potential of SQL Server? Join us for an immersive learning experience in our upcoming SQL Server Mastery Course! 🌟
In this comprehensive course, we're diving deep into the world of SQL Server, covering everything from the fundamentals to advanced techniques. Whether you're a beginner seeking a solid foundation or a seasoned pro aiming to enhance your skills, this course is designed to cater to all levels of expertise. 📚💡
What to Expect:
Comprehensive Curriculum: Explore SQL Server from every angle with a well-structured curriculum designed by industry experts.
Hands-on Learning: Gain practical experience through real-world examples, exercises, and interactive sessions.
Advanced Techniques: Master complex queries, performance tuning, indexing strategies, and more.
Industry Insights: Learn the latest trends, best practices, and strategies used by professionals in the field.
Certification: Earn a certification upon course completion, showcasing your SQL Server proficiency.
Who Should Join:
Database Administrators 🛠
Data Analysts 📊
Developers 👩‍💻
IT Professionals 🖥
Anyone passionate about mastering SQL Server! 🚀
Course Details:
📅 Start Date: [Date]
⏰ Duration: [Number] Weeks
🏢 Location: [Online/Physical Venue]
💰 Investment: Competitive pricing with early bird discounts!
Ready to take your SQL Server skills to the next level? Don't miss this opportunity to elevate your career and expertise. Limited seats available—reserve yours now! 🌐✨
For enrollment details and inquiries, visit [Course Website/Link] or reach out via DM for more information. Let's embark on this SQL Server mastery journey together! 🎯🚀
https://lnkd.in/gPcwV3F8
hashtag#SQLServer hashtag#DatabaseManagement hashtag#DataAnalytics hashtag#SQLCourse hashtag#ProfessionalDevelopment hashtag#TechEducation

LLD handbook - Part 1: https://drive.google.com/file/d/1WKzEBhh0amFa6ubqtJefFdkPk4f1JW0V/view?usp=sharing

Foundational Concepts in System Design - Part 1: https://drive.google.com/file/d/1tkkI1Ql8WEprlm_760psCWkXdKALRr0W/view?usp=sharing

Foundational Concepts in System Design - Part 2: https://drive.google.com/file/d/1UU4OwSx1OXUe2xgGeFxBn32vSAiM1STu/view?usp=sharing

Data stores behind the Databases: https://drive.google.com/file/d/1Oidmacaah8vraKZrtr1bKQY-qcsYtdbq/view?usp=sharing

Replication in Distributed Systems: https://drive.google.com/file/d/1qDABwnKQ_i91wsNZkOKsMG8m-RAmMp2v/view?usp=sharing

Shortest Path Algorithms - A mathematical approach: https://drive.google.com/file/d/1pR2FFGXgUBa7pzqt1YARP8Zgw2H9HZPx/view?usp=sharing

5 Youtube playlists on Design and Algorithms that can help you become a better Software Engineer. 🧡 💯

I still haven’t completed watching all of them, but can definitely say that they hold a plethora of good content. 🔥

☀️ MIT 6.824 Distributed Systems playlist: This playlist touches upon multiple concepts of Distributed Systems like Zookeeper, RAFT, Replication, Consistency, Spanner, Fault Tolerance and much more in depth. ⚡️

☀️ MIT 6.046J Design and Analysis of Algorithms: The playlist holds 34 episodes of in-depth discussion on topics like Divide and Conquer, B-Trees, Basic DP and Advanced Dynamic Programming, Greedy algorithms, Minimum Spanning Tree and much more. This could really be helpful from a DSA and Competitive Programming perspective. 🔥

☀️ CS 436 Distributed Computer Systems: A 24 episode series on Distributed Computer Systems taught in University of Waterloo. 🚀

☀️ Software Architecture - InfoQ: The playlist holds 185 episodes which involves Software Architecture best practices and multiple Design case studies. 💡

☀️ Advanced Algorithms - Harvard: A 25 episode series on advanced Algorithms taught by the legend Jelani Nelson. This one is really advanced! 💯

❌ Day 1 of learning DSA = hard
✅ Day 100 of learning DSA = easy
……………………………………………………………….

❌ Day 1 of corporate job = hard
✅ Day 100 of corporate job = easy
……………………………………………………………….

❌ Day 1 of networking = hard
✅ Day 100 of networking = easy
……………………………………………………………….

𝐊𝐞𝐞𝐩 𝐠𝐨𝐢𝐧𝐠, 𝐢𝐭 𝐰𝐢𝐥𝐥 𝐠𝐞𝐭 𝐞𝐚𝐬𝐢𝐞𝐫 💙

Follow for more ✨

Java Hello World Program | Java Tutorial in Hindi Part-24
https://youtu.be/Mig8Tq5Nrjg

Comments in Java | Java Tutorial in Hindi Part-25
https://youtu.be/P8nztKcV_wg

Java Character Set |Java Tutorial in Hindi Part-26
https://youtu.be/t8mWSgM9vaI


Java Keywords | Java Tutorial in Hindi Part-27
https://youtu.be/iUKZxe4wXx0

Identifiers in java programming| Java Tutorial in Hindi part-28
https://youtu.be/fpeZtmNvwYs


Constants in Java Programming | Java Tutorial in Hindi part-29
https://youtu.be/UUCrSnx-Nqo

—————————————Class Notes—————————-

Cascading Style Sheets:-

CSS stands for Cascading Style Sheets. It is a style sheet language which is used to describe the look and formatting of a HTML document / Web page.CSS describes how HTML elements are to be displayed.

CSS handles the look and feel part of a web page. Using CSS, you can control

1. The color of the text,
2. The style of fonts,
3. The spacing between paragraphs,
4. How columns are sized and laid out,
5. What background images or colors are used,
6. Layout designs,
7. Variations in display for different devices and screen sizes
8. Variety of effects.


CSS used with HTML to change the style of web pages and user interfaces.

“CSS are a collection of formatting rules that control the appearance of content in a web page.”

Style-sheet:- A style sheet is made up of ‘style rules’ that tell a browser how to present a document.

Style Rules (Code-Words) :- each style rule is made up of a selector.

CSS was first proposed by " Håkon Wium Lie " on October 10, 1994.

जिसे W3C – World Wide Web Consortium द्वारा विकसित किया गया है.
First Version of CSS (Cascading Style Sheets level 1) (CSS1) developed in December 1996 , CSS2 developed in May 1998 and “CSS3” is a latest version of CSS. इसका उपयोग एक वेबपेज को सजाने के लिए होता है.

Using HTML we can create web page structure and Using CSS we can decorate this we bpage.

CSS is a combination of a selector and a declaration.

1-first web browser ?
(A) Nexus
(B) Netscape Navigator
(C) Internet Explorer
(D) Mosaic ✅


2- What tag is used to display a picture in a HTML page ?

(A) picture
(B) image
(C) img ✅
(D) src


3-Which is the first Internet search engine?
(A) Google
(B) Archie ✅
(C) Altavista
(D) WAIS

4-The HTML tags that create a table header are
A) <head></head>
B) <ttop></ttop>
C) <th></th> ✅
D) <td></td>
---------------------------

Simple Website Layout using HTML/CSS
https://youtu.be/dqY3ieBsWYU

In HTML has two type of Elements
--------------------------------
1-Block Elements
2-Inline Elements

1-Block Elements:
block elements add a line break before and after them

* <div> tag is a block element
* Other block elements are <table>,<hr>, Headings, List (<ul>,<ol>), <p> and etc.


2-Inline Elements:

inline elements don't break the text before and after them

* <span> is an inline elements.
* Most HTML elements are inline, for Ex: <a>


What is DIV:
the <div> tag defines a division or a section in an HTML document. creates logical division within a page.

Basic CSS question :

Q-1:CSS Font Size:

You can set the size of the text used in an element by using the fontsize property.

syntax:

font-size: value;

There are alot of choices for values:

1- xx-large
2- x-large
3- larger
4- large
5- medium
6- small
7- smaller
8- x-small
9- xx-small
10-length
11-% (percent)

----------------------------------

Q-2 Text Decoration:
You can decorate text with the following:
syntax:
text-decoration: value;


Possible values are:-
1- none
2- underline
3- overline
4- line through
5- blink

-----------------------------

Q-3 Text Transform
You can control the size of letters in an HTML element with the
following CSS properties:

syntax: text-transform: value;


Possible values are-
1- none
2- capitalize
3- lowercase
4- uppercase

-----------------------------------

Q-4 Word Spacing
You can adjust the space between words in the following manner. You
can use negative values.
Possible values are:-

1- normal
2- length

Example: word-spacing: value;

word-spacing: 10px;

---------------------------------

Q-5 Font Style:
You can set the style of text in a element with the font-style property

font-style: value;

Possible values are:-
1- normal
2- itailc
3- oblique

example:
font-style:italic;

-------------------------

Q-6 Cursor CSS property:
You can control the style of cursor to be used in an element with the
cursor property

syntax: cursor: value;

Values:

1- auto
2- crosshair
3- default
4- help
5- move
6- pointer
7- text
8- url
9- wait
10- e-resize
11- ne-resize
12- nw-resize
13- n-resize
14- se-resize
15- sw-resize
16- s-resize
17- w-resize

Q ) What is the difference between padding and margin?

Answer:
In CSS, the margin is the property by which we can create space around elements. We can even create space to the exterior defined borders.
In CSS, we have margin property as follows:
• margin-top
• margin-right
• margin-bottom
• Margin-left
Margin property has some defined values as shown below.
• Auto – Using this property browser calculates the margin.
• Length – It sets the margin values in px,pt,cm etc.
• % – It sets the width % of the element.
• Inherit – By this property we can inherit the margin property from the parent element.

In CSS, padding is the property by which we can generate space around an element’s content as well as inside any known border.

CSS padding also has properties like,
1. Padding-top
2. Padding-right
3. Padding-bottom
4. Padding-left
Negative values are not allowed in padding.

<html>
<head>
<style>
div {
padding-top: 60px;
padding-right: 40px;
padding-bottom: 50px;
padding-left: 70px;
}
</style>
</head>

<body>
<div> Advance Computer Center</div>
</body
</html>

css position property video tutorial
https://youtu.be/e01pGTr8DY0

Dev., [3/16/2021 9:45 AM]
JavaScript Engine
JavaScript engine in the browser interprets, compiles and executes JavaScript code which is in a web page. It does memory management, JIT compilation, type system etc

Dev., [3/16/2021 9:45 AM]
Advantages of JavaScript
• JavaScript is easy to learn.
• It executes on client's browser, so eliminates server side processing.
• It executes on any OS.
• JavaScript can be used with any type of web page e.g. PHP, ASP.NET, Perl etc.
• Performance of web page increases due to client side execution.
• JavaScript code can be minified to decrease loading time from server.

Dev., [3/16/2021 9:46 AM]
JavaScript Variable

A JavaScript variable is simply a name of storage location. Variable means anything that can vary. variables hold the data value and it can be changed anytime.
JavaScript uses reserved keyword var to declare a variable. A variable must have a unique name. You can assign a value to a variable using equal to (=) operator when you declare it or before using it.
var one = 1; // variable stores numeric value

var two = 'two'; // variable stores string value

var three; // declared a variable without assigning a value



Declare Variables:
var one ;
var two ;


Variable Declaration and Initialization :
Var Number= 'two';
Var age= 20 ;
Var name;
Name= ” Rahul ”;

Or
Var Name =” Rakesh”;

Dev., [3/16/2021 9:46 AM]
JavaScript Identifiers:
All JavaScript variables must be identified with unique names.
These unique names are called identifiers.
dentifiers can be short names (like x and y) or more descriptive names (age, sum, totalVolume).
1. Name must start with a letter (a to z or A to Z), underscore( _ ), or dollar( $ ) sign.
2. After first letter we can use digits (0 to 9), for example value1.
3. JavaScript variables are case sensitive, for example x and X are different variables.
4. Names are case sensitive (y and Y are different variables)
5. Reserved words (like JavaScript keywords) cannot be used as names
Example:
Correct JavaScript variables
1. var x = 10;
2. var _value="sonoo";

Incorrect JavaScript variables
1. var 123=30;
2. var *aa=320;

Dev., [3/16/2021 9:46 AM]
JavaScript local variable
A JavaScript local variable is declared inside block or function. It is accessible within the function or block only. For example:
<script>
function abc(){
var x=10;//local variable
}

</script>

Or

<script>
If(10<13){
var y=20;//JavaScript local variable
}
</script>

JavaScript global variable
A JavaScript global variable is declared outside the function or declared with window object. It can be accessed from any function.
example:
<script>
var data=200;//gloabal variable
function a(){
document.writeln(data);
}
function b(){
document.writeln(data);
}
a();//calling JavaScript function
b();
</script>

Javascript Data Types


Data type indicates characteristics of data. It tells the compiler whether the data value is numeric, alphabetic, date etc., so that it can perform the appropriate operation.

There are two types of data types in JavaScript.
1. Primitive data type
2. Non-primitive (reference) data type
What are Primitive Data Types in JavaScript?:
These are the predefined or built in types of data that are supported by the programming language by default. JavaScript mainly supports the following types of primitive data types.

• Boolean: logical entity having values as true or false.
• Numbers: Represents numeric values and can store integers and decimals.
• Strings: Represent a sequence of characters such as “Hello World.” Strings can store in single quotes or double-quotes.
• Undefined: A variable that has an unassigned value will have an undefined default value.
a variable without a value, has the value undefined. The type is also undefined
• Null: In JavaScript, null means”nothing.” It is something that doesn’t exist.

JavaScript non-primitive data types
The programming language does not predefine these data types, but instead, the programmer creates it. Additionally, the composite data types come into existence when the grouping of multiple values happens. Few of the JavaScript supported composite DataTypes are:
• Object: It is an instance of a class that accesses the data and members encapsulated in the class.
• Arrays: It is a group of similar kinds of values.

Dev., [3/27/2021 10:20 AM]
Prefix increment (++A):
If you use the ++ operator as a prefix like: ++A, the value of 'A' is incremented by 1; then it returns the New incremented value.

Example 1:
var A=2;
document.write(++A);
output:
3

-----------------------------
Postfix Increment (A++):
If you use the ++ operator as a postfix like: A++, the original value of A is returned first; then A is incremented by 1.
Example :

B=2;

doucument.write(B++);
output: 2

Note: here B++ return old value which is 2 and then after printing 2 it will increment value of B by 1

---------------------------

some examople:

Ex: 1

var a=10;
++a; increment value of a by 1
document.write(a);

document.write("<br>");
document.write(++a); //increment the value of a by 1 then display output

----------------------
output
11
12

-------------------------

ex:2

var num=5;
var result= (++num) + (++num) + (++num);
document.write(result);



------------------------
ex:3

var a=4;
document.write(++a); //increment the value of a by 1 then display output
document.write("<br>");
document.write(a++);// display output then increment the value of a by 1

output:
5
5

Dev., [4/2/2021 10:47 AM]
Question :1
What is switch statement and define its rules and explain with Example.

Ans:

A switch statement allows a variable to be tested for equality against a list of values. Each value is called a case, and the variable being switched on is checked for each switch case.

Syntax:
----------------------------------


switch(expression) {

case expression :
statement1;
break; /* optional */

case expression :
statement2;
break; /* optional */

/* you can have any number of case statements */
default : /* Optional */
statement3;
}

------------------------------

The following rules apply to a switch statement :−



1-: You can have any number of case statements within a switch. Each case is followed by the value to be compared to and a colon.

2-: The expression for a case must be the same data type as the variable in the switch.

3-: When the variable being switched on is equal to a case, the statements following that case will execute until a break statement is reached.

4-: When a break statement is reached, the switch terminates, and the flow of control jumps to the next line following the switch statement.

5-: Not every case needs to contain a break. If no break appears, the flow of control will fall through to subsequent cases until a break is reached.

6-: A switch statement can have an optional default case, which must appear at the end of the switch. The default case can be used for performing a task when none of the cases is true. No break is needed in the default case.


-----------
Example:

<script>

var grade = 'B';

switch(grade) {
case 'A' :
alert("Excellent!\n" );
break;
case 'B' :
case 'C' :
alert("Well done\n" );
break;
case 'D' :
alert("You passed\n" );
break;
case 'F' :
alert("Better try again\n" );
break;
default :
alert("Invalid grade\n" );
}

</script>

Online class for Javascript
Learn by Watching Video
https://youtu.be/jzhACpD2Ebk

What is Operators in python:
Operators are special symbols in Python that carry out arithmetic or logical computation is called operator.


Type of Operators;
1-Arithmetic operators ( + - * / % )
2-Assignment operators ( = == += -= *= /+ )
3-Comparison operators/Relational (> < <= >= != ==)
4-Logical operators (and, or, not )
5-Identity operators (is , is not)
6-Membership operators (in, not in)
7-Bitwise operators

📚 Master ASP.NET C# Web Development: Create a Library Management System

Embark on an immersive journey into ASP.NET C# web application development with our comprehensive tutorial on building a sophisticated Library Management System. 🌐💻

In this step-by-step course, you'll delve into the intricacies of creating a robust library system from scratch. Whether you're a seasoned developer or a newcomer to programming, this course caters to all skill levels, providing clear and concise guidance at every stage of the development process.

What you'll learn:

Fundamentals of ASP.NET C#: Gain a solid understanding of ASP.NET framework and C# programming language.
Web Application Development: Learn how to develop dynamic and interactive web applications using ASP.NET.
Database Integration with SQL Server: Implement seamless database management using SQL Server for efficient data handling.
Functionalities of a Library Management System: Design and implement features such as book management, user authentication, borrowing, and more.
Best Practices in Web Development: Acquire industry-standard techniques and best practices for developing scalable web applications.
Join this course and unlock the secrets of building a sophisticated Library Management System using ASP.NET C#. Empower yourself with practical skills that are highly sought-after in the tech industry. Let's create, innovate, and bring your web development aspirations to life! 🚀📖

Enroll now and become a proficient ASP.NET C# developer! #ASPNETCSharp #WebDevelopment #LibraryManagementSystem #OnlineCourse
https://youtube.com/playlist?list=PLMoluEXvWXK7iAOcTw4AndY-ZwIOKlKZP&si=fLByRSN7gTHwAzBe