Introduction to Databases and Sql Querying Assignment 2022

Running head: INTRODUCTION TO DATABASES AND SQL QUERYING
INTRODUCTION TO DATABASES AND SQL QUERYING
Name of the Student
Name of the University
Author Note

INTRODUCTION TO DATABASES AND SQL QUERYING1
Table of Contents
Introduction................................................................................................................................2
Discussion..................................................................................................................................2
Conclusion..................................................................................................................................4
Reference....................................................................................................................................5

INTRODUCTION TO DATABASES AND SQL QUERYING2
Introduction
The course ‘Introduction to Databases and SQL Querying’ is about getting to know
about the fundamental concepts of the database, storing data in a database, and how to make a
query to retrieve any stored data from a database. The course is mainly directed to the
audience who does not have any prior knowledge about database. As a result, this is a perfect
course for them to gain basic awareness by knowing what it is, how to install and set up a
database environment using SQL Management Studio, adding and accessing sample database
to get familiar with the basics (Free Database Management Tutorial - Introduction to Databases
and SQL Querying, 2020). The following parts will detail about the same.
Discussion
The whole course is divided into five sections. They are, ‘Introduction and Setup’,
‘Introduction to Querying’, ‘Deep Dive into Querying’, ‘SQL Joins’ and ‘Dates/ Aggregation
and String Functions’.
Introduction and Setup - This section consists of two lectures the first lecture is about
introduction to database. Here, details like what is database, how data is stored in a particular
database and what is in what format. Details like how particular type of data is retrieved from
a database have also been discussed here with proper, simple and detailed example analysis.
Towards the end section, the entire database process have been simplified into simple
process, which explains the complete database functionalities in simple words. The second
lecture is about using SQL Server in setting up the Environment. It explains about the basic
difference between a database and a tool (also known as IDE) in simple words, which many
people confuses from time to time. The lecture mainly discuss a step by step process on
downloading, installing and setting up database engine along with the tool (Microsoft SQL
Server Express edition) to get things started and running.