To install SQL Server, the first thing we need to do is go to google, type keywords: download sql server, or go directly to the following link:

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Next step, choose 1 of 2 developer or express versions as shown and proceed to download + install step by step according to the video above

After installing according to the video, connect to the database using SSMS according to the information as shown below:

Note: there are 2 methods to authenticate with Microsoft SQL Server: through accounts (SQL Server Authentication) or authentication with windows (windows authentication). So multiple accounts can access SQL server. With Windows Authentication, the operating system authentication system to log in to SQL Server Database, it can only authenticate on a single computer device, cannot be used on any other machine.

After successful authentication login, the interface will display as follows:

Introduction to Database

Database is a collection (list) of data stored as files on the hard drive. A data database holds the actual data.

SQL Server databases are made up of a collection of tables that store specifically structured data sets. A table consists of a set of rows (also known as records or tuples) and columns (also known as attributes). Each column in the table is intended to store a specific type of information, for example, date, name, amount, and number.

SQL Server 2019 supports 3 types of databases as follows:

• System Databases
• User-defined databases
• Sample Databases

System Databases

SQL Server uses system databases to support the various components of the DBMS. Each database has a role that authenticates and stores the business information required by SQL Server. System database stores data on tables, will contain views, stored procedures (will be learned in later lessons) and other database objects. They also link to database files (.mdf, .ldf files), which are physical files stored on the SQL Server server.

System databases available in SQL Server 2019

Database	Describe
master	The database records record all the system layer information of the SQL Server instance
msdb	The database is used by SQL Server Agent to schedule database alerts and various jobs
model	Database is used as a template for all databases to be created in SQL Server 2019
resources	This is a read-only database. It contains system objects in SQL 2019
tempdb	This is a database containing temporary object dodois or intermediate result sets

User-defined databases

Using SQL Server 2019, users can create their own database, called user-defined database, and work with it. The purpose of these databases is to store user data.

AdventureWork2019 Database

The sample database, named AdventureWorks, was introduced in SQL Server 2005. This database demonstrates the moiws features of SQL server. This database simulates a fictional company called Adventure Works Cycles. Adventure Work Cycles is a large, multinational manufacturing company. The company manufactures and sells alloy bicycles to the North American, European, Asian markets… In SQL Server 2019, the new version of AdventureWorks2019 is used as sample data, including datasets, datasets, and datasets. commands and operations available in a simulated data environment.

Video tutorial to import AdventureWorks database into SQL Server:

https://www.youtube.com/watch?v=EW5yg-Z-WkE

The AdventureWorks2019 database schema includes many functions for a fictional bicycle manufacturer. These areas include:

• Customer/sales force automation, data analysis
• Human resources (human resources)
• Electronic data exchange of purchase/supplier
• Production Process Flow

The database includes several features. Some of the main features are as follows:
A database engine that includes administrative utilities, data accessibility, full-text search facility, Common Language Runtime (CLR), etc.
A set of integrated templates for two business models Human Resource and Storefront with many features:

• Analysis Services and Integration Services
• Notification service
• Cloning facility
• Reporting Service

The sample database includes 3 main components:

• AdventureWorks2019: Sample OLTP database
• AdventureWorks2019DW: Sample Data warehouse
• AdventureWorks2019AS: Sample analysis Services database

To download adventurewrork and use it, see the following link:

https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

SSMS User Interface Explanation

SSMS provides several option menus, toolbars, and panes to work with. The pane shown in Figure 1.1 above is called Object Explorer. It displays all the objects on the server in a tabular format and provides user interfaces for managing them.

Role and structure of Object Explorer in SQL Server

The structure of Object Explorer in SQL Server 2019 is shown in the figure below:

This structure includes database, security, server objects, replications, and possibly some other features like AlwaysOn High Availability, Management, Integration Services Catalogs… Object Explorer can be accessed through SSMS by connecting connect to the database server.

The different components of Object Explorer are as follows:

• Databases : a collection of databases stored in a data set with a defined structure.
• Security : Used to provide flexible and reliable security configurations in SQL Server 2019. This includes logins, roles, credentials, audits, etc.
• Server Objects : Used to monitor the activity of instances in SQL Server.
• Replication : Use to copy and distribute data and database objects from one database to another, and then synchronize between databases to maintain consistency.
• AlwaysOn High Avalability : Use for high availability and disaster recovery. It is commonly used for applications that require high uptime and fault protection.
• Management : used to manage policies, resources, events, maintenance plans, etc.
• Integration Services Catalogs : Catalog of integration services that stores all the objects of the project after the project has been destroyed.

Query Window

The Query Window is an area where you can write Transact-SQL (T-SQL) query commands. The results of the queries will be displayed in this window.

Create and organize script files

Script files are files that contain a collection of SQl statements. Script files can contain one or more SQL statements, script files are stored in a .sql file that helps SQL Server recognize and execute the script.

The conceptual lopws in script files can be organized as shown below:

Solution in the picture can be understood as a file in which all SQL Server projects are stored, meaning it is the top layer of the hierarchy. The Solution file is stored as a text file with the extension .ssmssqlprj . Script files are core files that will be queried and executed. The script file has the extension .sql

The example below is a script file named: insertdata.sql

Transact-SQL Queries

Transact-SQL (T-SQL) queries are written and stored under the .sql script file and can be executed directly in the query window in SSMS. The steps to execute Transact-SQL are as follows:

• In the Query window, select the code to execute
• Click on the excute button in SSMS or select the query menu and click excute, in addition, it can be executed via the keyboard shortcut F5, alt+X or Ctrl+E

The results will be displayed in 3 different formats, the formats are grid (grid), text (text), file view (file).