4.6
stars
233 ratings

Taught by Meta Staff

14,948 already enrolled

Offered By

About this Course

133,592 recent views

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

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

You do not need prior database experience. Only basic internet navigation skills and an eagerness to get started with coding.

Approx. 27 hours to complete

English

What you will learn

Concepts and principles that underpin how databases work.
Plan and execute a simple database development project.

Skills you will gain

MySQL
Database (DBMS)
database administration

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

You do not need prior database experience. Only basic internet navigation skills and an eagerness to get started with coding.

Approx. 27 hours to complete

English

Instructor

Instructor rating

4.8/5 (49 Ratings)

Taught by Meta Staff

293,526 Learners

67 Courses

Offered by

Syllabus - What you will learn from this course

Content Rating94%(2,155 ratings)

Week1

Week 1

4 hours to complete

Introduction to Databases

In this module, you’ll receive an introduction to the course and explore possible career roles that you could follow as a database engineer. You’ll also review some tips on how to take this course successfully and discuss what it is that you hope to learn. As part of your introduction, you’ll learn about the basics of databases and data and how they work. You’ll then receive an introduction to SQL, or Standard Query Language, the coding syntax used to interact with databases. Finally, you’ll explore the basic structure of databases and discover the different types of keys they use.

4 hours to complete

12 videos (Total 47 min), 10 readings, 4 quizzes

12 videos

Introduction to databases3mA day in the Life of a Database Engineer6mWhat is a database?5mHow is data related?3mAlternative types of databases4mWhat is Structured Query Language?2mSQL usage3mAdvantages of SQL2mSQL syntax introduction4mWhat are tables in databases?3mTypes of keys in a database table3mModule summary: Introduction to Databases2m

10 readings

Course syllabus: Introduction to databases10mHow to be successful in this course10mRelational data example charts10mDatabase Evolution15mAdditional resources10mCommon SQL Commands15mAdditional resources10mTables overview15mDatabase structure overview15mAdditional resources10m

4 practice exercises

Knowledge check: Databases and data15mKnowledge check: SQL syntax review15mKnowledge check: Database structure15mModule quiz: Introduction to Databases30m

Week2

Week 2

11 hours to complete

Create, Read, Update and Delete (CRUD) Operations

In this module, you’ll explore CRUD, or Create, Read Update and Delete operations. You’ll begin with an exploration of SQL data types and learn how to differentiate between numeric data, string data and default values. You’ll also embark upon several exercises in which you’ll learn how to utilize these different data types within your database projects. You’ll then move on to learn how to Create and Read data within a database. You’ll discover how to create databases and tables and populate them with data using SQL statements. Lastly, you’ll explore the SQL statements used for updating and deleting data in a database. And to demonstrate your ability with CRUD operations, you’ll complete exercises that will task you with creating and managing data.

11 hours to complete

12 videos (Total 42 min), 4 readings, 10 quizzes

12 videos

Numeric data types3mString data types3mDefault values4mCREATE and DROP database2mCREATE TABLE statement2mALTER TABLE statement3mINSERT statement4mSELECT statement3mINSERT INTO SELECT statement3mUpdating data3mDeleting data3mModule summary: Create, Read, Update and Delete (CRUD) Operations3m

4 readings

Additional resources15mCreating tables15mAdditional resources10mAdditional resources5m

10 practice exercises

Self review: Working with numbers15mSelf review: Working with strings12mSelf review: Working with default values12mSelf review: Choosing the right data type for a column15mSelf-review: Create database, create table and insert data15mSelf review: Practicing table creation15mKnowledge check: Create, insert and select15mSelf-review: Record deletion12mKnowledge check: Update and Delete15mModule quiz: Create, Read, Update and Delete (CRUD) Operations30m

Week3

Week 3

5 hours to complete

SQL Operators and sorting and filtering data

In this module, you’ll explore SQL operators and learn how to sort and filter data. You’ll begin this module with a lesson on SQL operators. As part of this first lesson, you’ll explore the syntax and process steps used to deploy SQL arithmetic and comparison operators within a database. Next, you’ll discover how to sort and filter data using clauses. The clauses that you’ll learn about include the Order By clause, Where clause and Select Distinct clause. In each lesson item, you’ll receive an overview of how each clause is used to sort and filter data in a database. You’ll also view demonstrations of these clauses and then receive an opportunity to try them for yourself.

5 hours to complete

7 videos (Total 34 min), 7 readings, 3 quizzes

7 videos

SQL Arithmetic Operators4mOperators in use4mSQL Comparison operators5mORDER BY clause5mWHERE clause7mSELECT DISTINCT clause4mModule summary: SQL operators and sorting and filtering data1m

7 readings

SQL Arithmetic Operator Examples30mSQL Comparison operator examples30mAdditional resources10mTypes of ordering / sorting30mWHERE Clause uses30mSELECT DISTINCT clause in use15mAdditional resources10m

3 practice exercises

Knowledge Check: Operators30mSelf-review: ORDER BY and WHERE12mModule quiz: SQL operators and sorting and filtering data30m

Week4

Week 4

6 hours to complete

Database design

In this module, you’ll learn about database design. In the first lesson, you’ll receive an overview of how to design a database schema. As part of this overview, you’ll learn about basic database design concepts like schema and find out about different types of schemas. The next lesson focuses on relational database design. In this lesson, you’ll explore how to establish relationships between tables in a database using keys. You’ll also learn about the different types of keys that are used in relational database design, such as primary keys and foreign keys.

6 hours to complete

12 videos (Total 48 min), 9 readings, 6 quizzes

12 videos

Database schema3mSchema in use4mTypes of database schema2mTable relationships3mPrimary key2mForeign key4mFinding entitites3mWhat is database normalization?4mFirst normal form 1NF4mSecond normal form 2NF6mThird normal form 3NF4mModule summary: Database design2m

9 readings

Exploring database schema15mBuilding a schema15mAdditional resources10mRelational model15mKeys in depth15mEntity relationship diagrams (ERD)30mAdditional resources15mData normalization15mAdditional resources10m

6 practice exercises

Knowledge check: Database schema15mKnowledge check: Defining keys15mDatabase relations and keys15mKnowledge Check: Database normalization12mSelf-review: Database schema examples15mModule quiz: Database design24m

Reviews

4.6

66 reviews

5 stars
71.61%
4 stars
19.49%
3 stars
6.35%
2 stars
0.84%
1 star
1.69%

TOP REVIEWS FROM INTRODUCTION TO DATABASES FOR BACK-END DEVELOPMENT

by EASep 6, 2022

Very awesome course. You're gonna work realy hard to get your certificate in the end. But you're up for the challenge. Vamos!!

by AOOct 19, 2022

This cours is overall a good course to resfresh or learn the basis of SQL, but the tests could be better, especially the last one (it has a lot of formatting problems).

by JADec 19, 2022

This is one of the best courses so far in this specialization. Very well presented, very easy to grasp, and very enjoyable. I highly recommend.

by NSAug 23, 2022

Information was good, instruction was good, some errors and typos apparent in the assessments.

View all reviews

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Introduction to Databases for Back-End Development

About this Course

What you will learn

Skills you will gain