By the end of this course, you will be able to
What's meant by a database, how it works, the different database types and differences between them, and what is the importance of the database.
Exploring the Relational Database Management Systems (RDMS), coding SQL, categorizing SQL commands into groups, and exploring what commands each category contains.
Creating a database from scratch with tables and users, controlling database users' privileges. Then, inserting, updating, deleting, and retrieving data from a table.
Course details
- 2 h 15 m/40 lessons
- Last updated: 9/11/2022
- 1 learning resources
- Course completion certificate
Course Content
Course Introduction
Introduction to Database
Relational VS Non-Relational Databases
Relational Database Management Systems (RDBMS)
Course Introduction
Introduction to Database
Relational VS Non-Relational Databases
Relational Database Management Systems (RDBMS)
Introduction to SQL
Important Note
PostgreSQL Download and Installation
How to Initiate PostgreSQL in Command Prompt
Ubuntu Download and Installation
PostgreSQL Package in Ubuntu
Create Database
Create table
Create User
SQL Constraints
Data Types in PostgreSQL
Practice Test 1
DROP
Drop User
TRUNCATE
ALTER
GRANT
REVOKE
Practice Test 2
INSERT
DELETE
DROP - TRUNCATE - DELETE Summary
UPDATE
SELECT
Practice Test 3
ALIAS
Operators
Comparison Operators
Aggregate Functions
DISTINCT
LIMIT
GROUP BY and HAVING
JOINS INTUITION
INNER JOIN
OUTER JOIN (Left, Right and Full)
CREATE VIEW
About this course
Data analysis requires working with a large amount of data and performing manipulation on it. If you are interested in data science and want to pursue a career in it, SQL is listed as one of the most in-demand skills in the skill set for data analyst roles, it is an easy-to-learn and robust programming language. Therefore, this course was prepared to help you learn more about SQL coding, its principles from the beginning, how it works, and its different types.
Course requirements and prerequisites
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Mentor
Moustafa Ahmed
Data Analyst
2,811 Learners
2 Course