Databases for Back-End Development FULL COURSE
🔹🔹Introduction to Databases for Back End Development 🔹🔹
🏆What you will learn
✔️Concepts and principles that underpin how databases work.
✔️ Plan and execute a simple database development project.
🔸🔸🔸🔸⌚⌚Timestamp⌚⌚🔸🔸🔸🔸
0:00:00 Introduction to databases
0:03:44 A day in the Life of a Database Engineer
0:09:59 What is a database?
0:15:40 How is data related?
0:19:23 Alternative types of databases
0:24:05 What is Structured Query Language?
0:26:07 SQL usage
0:29:53 Advantages of SQL
0:32:27 SQL syntax introduction
0:37:15 What are tables in databases?
0:41:06 Types of keys in a database table
0:45:03 Module summary: Introduction to Database
0:47:13 Numeric data types
0:50:33 String data types
0:54:28 Default values
0:58:49 CREATE and DROP database
1:01:32 CREATE TABLE statement
1:03:35 ALTER TABLE statement
1:07:30 INSERT statement
1:12:00 SELECT statement
1:15:32 INSERT INTO SELECT statement
1:18:54 Updating data
1:22:36 Deleting data
1:25:50 Module summary: Create, Read, Update and Delete (CRUD) Operations
1:29:04 SQL Arithmetic Operators
1:33:23 Operators in use
1:38:22 SQL Comparison operators
1:44:26 ORDER BY clause
1:49:53 WHERE clause
1:57:29 SELECT DISTINCT clause
2:01:33 Module summary: SQL operators and sorting and filtering data
2:03:15 Database schema
2:06:34 Schema in use
2:11:22 Types of database schema
2:14:00 Table relationships
2:17:54 Primary key
2:20:47 Foreign key
2:25:39 Finding entitites
2:29:13 What is database normalization?
2:34:01 First normal form 1NF
2:38:28 Second normal form 2NF
2:44:30 Third normal form 3NF
2:48:46 Module summary: Database design
2:50:57 Course Recap: Introduction to databases for back-end development
2:53:38 Congratulations, you have completed Intro to databases for back-end development!
📒📒About this Course📒📒
Back-end developers write applications that end-users use to interact with databases. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data.
Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work.
In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. You’ll also learn to distinguish between different types of database management systems. You’ll then practice basic creation and data selection tasks with the use of Structured Query Language (SQL) commands.
By the end of this course, you’ll be able to:
Demonstrate a working knowledge of the concepts and principles that underpin how databases work
Identify and explain the different types of core technology and management systems used in
databases
Identify and interpret basic SQL statements and commands
Manipulate records in a database with the use of SQL statements and commands
Outline alternatives to SQL
and plan and design a simple relational database system
You’ll also gain experience with the following:
Fundamental concepts in database
Basic MySQL syntax and commands
Database management systems
Relational databases
All rights reserved by (Meta)
❌❌PLEASE IGNORE THESE TAGS❌❌
#IntroductiontoDatabasesforBack-EndDevelopmentFullCourse #DatabasesforBack-EndDevelopmentTUTORIAL #MetaBackEndDeveloperProfessionalCertificate |
