Report on the 'Introduction to Databases and SQL Querying' Course

This report provides an overview of the 'Introduction to Databases and SQL Querying' course. The course covers fundamental database concepts, including data storage, retrieval, and the use of SQL queries. The report details the course structure, which is divided into five sections: Introduction and Setup, Introduction to Querying, Deep Dive into Querying, SQL Joins, and Dates/Aggregation and String Functions. Each section covers specific topics, such as setting up a database environment, creating and querying tables, using different types of joins, and utilizing date, aggregation, and string functions. The report concludes that the course is suitable for beginners and provides a solid foundation in database knowledge and practical SQL skills.

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

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

2INTRODUCTION TO DATABASES AND SQL QUERYING
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.

3INTRODUCTION TO DATABASES AND SQL QUERYING
Introduction to Querying - This section consists of two lectures. It includes creating
of SQL tables and installing sample database and getting started with querying. The first
lecture in this section explains about how one can write a query and by choosing what option,
they can do so. It also elaborates about creating a new database both by writing a query and
by using menu options in the installed tool. The explanation includes parts like creating a
table, entering table data and retrieving data from the table using SQL commands as well as
using GUI (Graphical User Interface) of the IDE. The second lecture detail about installing
and attaching external database with SQL database in a systematic manner.
Deep Dive into Querying - This section is further divided into basic SQL section and
deep dive into SQL Querying. The first part details about various types of queries that can be
written to retrieve database details have been explained here including data retrieval with and
without using conditions (filters). The second part on the other hand details about creating
temporary table using queries and its uses. It also explains about deleting any specific table
rows from any specific table and update table data using the same (using SQL queries).
SQL Joins - The first part of the SQL Joins section details about using different type
of joins that can be used to retrieve data from multiple number of tables using suitable
diagrams and examples. The second part on the other hand explains the same by showing the
results practically using SQL queries.
Dates/ Aggregation and String Functions - This section detailed mainly about using
date functions and manipulating database retrieval depending of these predefined data
functions. It also includes queries against various tables in the database. The second part of
this section discuss about some inbuilt aggregate and string SQL functions (uppercase,
lowercase, length, trim and many more) and how they can be used.

4INTRODUCTION TO DATABASES AND SQL QUERYING
Conclusion
In the end, it can be concluded that this course is good for the individuals who does
not have any prior knowledge about database and by going through this, they can obtain basic
awareness about database and its usages.

5INTRODUCTION TO DATABASES AND SQL QUERYING
Reference
Udemy. 2020. Free Database Management Tutorial - Introduction To Databases And SQL
Querying. [online] Available at: <https://www.udemy.com/course/introduction-to-databases-
and-sql-querying/> [Accessed 18 April 2020].