Introduction to SQL and Database

About Course

This course covers the introduction and core fundamentals of Structured Query Language (SQL) and database knowledge from definition and concept to their usages for working with data.

SQL is the language used in relational databases, which stores much of the world’s information from customer purchase records to internet traffic histories. In today’s data career, you’ll need to work with SQL and databases from data extraction to data retrieval, data definition statements, and data manipulation. We will cover data types, syntaxes, clauses, CRUD, how to aggregate data, how to query a database and so much more. In this course, you’ll be introduced to everything you need to know about relational databases and SQL syntax to get started working with popular databases like SQL Server in no time.

In the end, you will have practice exercises, quizzes, and a project to test your understanding. Your instructors will be here to assist you when needed.

After finishing this course, the learners will be able to:
Aggregate and query to get insights from data
Read, write, and transform data in tables
Query data productively from tables in the SQL Server database.
Understanding the concept of a database and how to use it.
Understanding the concept of Structure Query Language (SQL).
Explain system databases and objects.
Discussion of database concepts - definition of a database management system.

Course Content

Database and SQL
In this topic, we are going to learn the basic concept of database and structured query language (SQL). You will get to know the different types of databases, the syntax of how to create a database, and different types of SQL statements.

Introduction to database
Database Management System (DBMS)
OLAP and OLTP
Introduction to SQL
Quiz 1 – Topic 1
Assignment 1

Data Types
In this topic, You will learn how to use Data types in SQL servers include numeric, string, date, and time and how to convert those data types into one another. You will find the example with a clear explanation along with each lesson.

Data Manipulation Language (DML)
In this topic, we are going to focus on SQL data manipulation language, which is used to retrieve and manipulate data in a relational database. We will learn about their syntaxes like CREATE, INSERT, UPDATE and DELETE.

Data Query Language (DQL)
In this topic, we are focusing on SQL data query language. You are going to learn about the SELECT statement and how to use SELECT with various conditions to retrieve data. After finishing this chapter you should be able to: Use SELECT statement to query columns from tabless to get data that you want Use SELECT DISTINCT to retrieve the distinct value How to work with NULL data Minimize the query result by using condition in the WHERE clause How to search patterns in your string data by using Wildcard and LIKE clause How to work with SQL operator OR, AND and BETWEEN Use aggregation in SQL Using SQL statement keyword GROUP BY, ORDER BY, and HAVING in your queries

Syntax SELECT
SELECT Multiple Columns and SELECT DISTINCT
SELECT with condition WHERE
Working with NULL
AND, OR, BETWEEN
Wildcard and LIKE
Aggregations
ORDER BY, GROUP BY, HAVING
Topic 4 – Quiz 4
Assignment 4

Add this certificate to your CV profile to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 2 Ratings

2 Ratings

0 Rating

4 years ago

gggood

4 years ago

great one!

About Course

What Will You Learn?

Course Content

Database and SQL
In this topic, we are going to learn the basic concept of database and structured query language (SQL). You will get to know the different types of databases, the syntax of how to create a database, and different types of SQL statements.

Introduction to database

Database Management System (DBMS)

OLAP and OLTP

Introduction to SQL

Quiz 1 – Topic 1

Assignment 1

Data Types
In this topic, You will learn how to use Data types in SQL servers include numeric, string, date, and time and how to convert those data types into one another. You will find the example with a clear explanation along with each lesson.

Numeric Data Types

Character STRING Data Types

DATE and TIME Data Types

Data Type Conversion

Topic 2 – Quiz 2

Assignment 2

Data Manipulation Language (DML)
In this topic, we are going to focus on SQL data manipulation language, which is used to retrieve and manipulate data in a relational database. We will learn about their syntaxes like CREATE, INSERT, UPDATE and DELETE.

SQL CREATE Statement

SQL INSERT INTO Statement

SQL UPDATE Statement

DELETE Statement

Topic 3 – Quiz 3

Assignment 3

Syntax SELECT

SELECT Multiple Columns and SELECT DISTINCT

SELECT with condition WHERE

Working with NULL

AND, OR, BETWEEN

Wildcard and LIKE

Aggregations

ORDER BY, GROUP BY, HAVING

Topic 4 – Quiz 4

Assignment 4

Earn Your Certificates

PROGRAMS

COMPANY

COMMUNITY

About Course

What Will You Learn?

Course Content

Database and SQL In this topic, we are going to learn the basic concept of database and structured query language (SQL). You will get to know the different types of databases, the syntax of how to create a database, and different types of SQL statements.

Introduction to database

Database Management System (DBMS)

OLAP and OLTP

Introduction to SQL

Quiz 1 – Topic 1

Assignment 1

Data Types In this topic, You will learn how to use Data types in SQL servers include numeric, string, date, and time and how to convert those data types into one another. You will find the example with a clear explanation along with each lesson.

Numeric Data Types

Character STRING Data Types

DATE and TIME Data Types

Data Type Conversion

Topic 2 – Quiz 2

Assignment 2

Data Manipulation Language (DML) In this topic, we are going to focus on SQL data manipulation language, which is used to retrieve and manipulate data in a relational database. We will learn about their syntaxes like CREATE, INSERT, UPDATE and DELETE.

SQL CREATE Statement

SQL INSERT INTO Statement

SQL UPDATE Statement

DELETE Statement

Topic 3 – Quiz 3

Assignment 3

Syntax SELECT

SELECT Multiple Columns and SELECT DISTINCT

SELECT with condition WHERE

Working with NULL

AND, OR, BETWEEN

Wildcard and LIKE

Aggregations

ORDER BY, GROUP BY, HAVING

Topic 4 – Quiz 4

Assignment 4

Earn Your Certificates

Student Ratings & Reviews

PROGRAMS

COMPANY

COMMUNITY

Database and SQL
In this topic, we are going to learn the basic concept of database and structured query language (SQL). You will get to know the different types of databases, the syntax of how to create a database, and different types of SQL statements.

Data Types
In this topic, You will learn how to use Data types in SQL servers include numeric, string, date, and time and how to convert those data types into one another. You will find the example with a clear explanation along with each lesson.

Data Manipulation Language (DML)
In this topic, we are going to focus on SQL data manipulation language, which is used to retrieve and manipulate data in a relational database. We will learn about their syntaxes like CREATE, INSERT, UPDATE and DELETE.