December 5, 2024

What is SQL?

SQL stands for Structured Query Language. It is a programming language used for interaction with relational database management systems (RDBMS). This includes fetching, updating, inserting, and removing data from tables. It is a case-insensitive language.

What is MySQL?

MySQL is a DBMS developed by Oracle that implements SQL. A Database Management System (DBMS) allows users to manage and alter data. MySQL is a software that helps us create, read, update, and delete data.

Let’s discuss the steps now how to Install SQL Server 2022 Developer Edition

Step 1: Go to Google and type: “SQL Server 2022 Developer Edition”

				
					console.log( 'Code is Poetry' );

Step 2: Enter the link leading to the Microsoft website

Step 3: Click on the first option SQL Server Downloads and then click on “Developer Download” now.

Step 4: Click on SQL Server Download, then click on Pop up, select Yes, then we will get a pop-up again choose “Basic”.

Step 5: Click on “Accept”

Step 6: Click on “install”

Step 7: Now it will download the package and installation will start.

Step 8: Installation is successful and now click on Install SSMS

Step 9: Click on latest version Download SSMS

Step 10: Click on the exe file and now click on Install

Step 11: Now open it and go to Start type SQL Server Management Studio 2022. Click on open

Step 12: The server name appears below, then click on the Connect button.

Step 13: If the server name does not appear then from the server name drop down click on browse for more as shown below

Step 14: After clicking on browse for more a dialog box will appear as shown below select on local server and expand the database engine and from the list of options select the first one as shown below. Finally, click on the Ok button then click on Connect button.

Step 15: After downloading, give the server name as local and click on the connect button if you are facing issue after giving server name as local follow the NOTE mentioned above.

Step 16: Select the complete above query and click on “execute”.

				
					CREATE TABLE EMPLOYEE (
EMP_NO int,
ENAME varchar(255),
JOB varchar(255),
MGR varchar(255),
HIRE_DATE varchar(255),
SALARY float,
COMM float,
DEPT_NO float);

Step 17: Click on the new query and paste the below query to insert the data in the table.

				
					INSERT INTO EMPLOYEE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE,SALARY,
COMM, DEPT_NO) VALUES (7369, 'SMITH', 'CLERK', 7902, '17-Dec-80' ,800, NULL,
20);
INSERT INTO EMPLOYEE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE,SALARY,
COMM, DEPT_NO) VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '20-Feb-81' ,1600,
300, 30);
INSERT INTO EMPLOYEE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE,SALARY,
COMM, DEPT_NO) VALUES (7521, 'WARD', 'SALESMAN', 7698, '22-Feb-81' ,1250,
500, 30);
INSERT INTO EMPLOYEE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE,SALARY,
COMM, DEPT_NO) VALUES (7566, 'JONES', 'MANAGER', 7839, '2-Apr-81' ,2975,
NULL, 20);

Step 18: Write a query to check whether the table is inserted successfully or not.

Query:

Select*

From EMPLOYEE;

Conclusion

Configuring SQL Server on your laptop is essential for local development, testing, and learning. It enables you to develop database-driven applications, practice SQL skills, and experiment with configurations without relying on remote servers. Remember to practice, stay updated with the latest trends in SQL COURSE, and maintain a positive attitude throughout your interview process.It also offers cost efficiency, offline access, and control over your database environment.

Also read:

Structured Query Language(SQL)Interview Questions & Answer

The different operators in SQL

Different Joins In SQL

AGGREGATE FUNCTION IN SQL

Popular Courses

Digital Marketing
Certification Course