Gain insights into SQL and database fundamentals. Delve into data manipulation, administration, and normalization with practical tasks using SQL functions for backup, recovery, and user management.

Learn SQL - A Practical Guide for SQL Server and Database Fundamentals.png

sqldockerfile.tar.gz

sql_spa-copy

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experience with the fundamentals of the SQL Server database including database administration.

The course covers the fundamentals of relational databases and database normalization. It offers a practical learning experience of retrieval, definition, manipulation, presentation and transformation of data through SQL functions. You will also learn database administration for backup, recovery and restore followed by managing the users, roles and privileges.

This course will teach you how to perform tasks related to SQL Server databases with hands-on experience. It covers the complete range of day-to-day operations.

A Practical Guide to SQL  and Database Fundamentals

# SQL Server Management Studio
SQL Server Management Studio (SMSS) is Microsoft’s interface for interacting with SQL databases. It’s free and is an excellent tool for learning and managing database servers. 

As of May 2023, Microsoft has versions 18.11 and up. Link to the old and latest versions are available, plus 16.5.3 and 18.8. However, there’s no reason not to try the latest, as Microsoft keeps adding more features/enhancements to the later versions.

- [Latest SSMS version](https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15)

Simply click to download the preferred version.

With previous versions, we use the pane on the right side of the browser to cycle through the versions and choose the one we like. 

Once it has downloaded, we go ahead and run the installer. Both versions run through the standard installation process. So we can keep the default settings and let it perform the installation. After it’s finished, we are almost ready to connect!

# Starting the Database Engine services

After installing the instance, it’s time to log in.

The first step is checking to ensure the database service is running. This service is under the list of specific services running under the Windows OS. There are a few ways we can locate the service: 

 1. Hold the “Windows” key and press the “R” on the keyboard to bring up the “Run” command. Once it comes up, we enter “services.msc” to bring up the list of services. 




Learn to download and install SQL Server Management Studio.

Introduction

Database Components

Structuring the Database

Data Retrieval

Data Definition

Data Manipulation

Transforming Data and Functions

Database Administration

Conclusion

Appendix

Download SQL Server Management Studio (SSMS)

SQL Server Management Studio