• Post category:StudyBullet-3
  • Reading time:5 mins read


Learn how to use SQL to query and manipulate databases with practical hands on examples

What you will learn

Understand basic database concepts

Create a database table

Create a view

Add data into a table

Update existing data in a table

Delete data in a table

Read data from a table

Query a database

Use Aliases with queries

Understand C.R.U.D

Description

There is so much information around today and there has to be efficient mechanism in

place to manage tthe huge volume of data. This is where relational database

management systems -RDBMS comes in handy. An RDBMS is used to manage

databases.

What is a database? This is where information or data is stored. Databases actually

stored information or data inside tables which in turn consists of columns and rows just

like an excel spreadsheet. The columns represents the data fields for example LastName

while the rows represents individual records like Anderson. Database administrators or

data analyst need to interact with the data from the database from time to time and the

way they do that is by using SQL.

What is SQL – It stands for structural query language. It is an internationally used


Get Instant Notification of New Courses on our Telegram channel.


lanaguage used to manipulate databases. With SQL you can do the following and much more:

Create a database
Create a table
create a view
Update a record
DeleteΒ  a record
Add a record
Read data from a table
Automate tasks

This course is a basic introductory course to SQL that will teach you the basic functions it

is used for on a database such as Create Read Update and DeleteΒ Β  collectively referred

to as C.R.U.D.Β  Over 85 percent of what you will do on a database will be CRUD related.

If you want to become a database administrator or developer this course will be a good

starting point.

What you learn on the course include:

Basic database concepts
How to create a Table
How to create a view
How to update data in a table
How to add data into a table
How to delete records in a table
How to use Aliases

I look forward to you signing up to the course.

English
language

Content

The basics and Lab
Introduction
What is SQL
Database concepts
What is a query
MSDN Virtual Labs
Exploring MSDN Virtual Labs
C.R.U.D
Introduction to C.R.U.D
How to create a database table
Adding records into a tabale
Reading data from a table
Updating records in a table
Deleting records from a database table
Creating views
Using Aliases
Conclusion