SQL for Beginners: An Intro to Relational Databases | Learningfever, proud to be ahead

SQL for Beginners: An Intro to Relational Databases

Huidige status

Prijs

Gesloten (handmatig toevoegen gebruikers, WooCommerce)

Begin

This cursus is currently closed

Cursus Inhoud

Intro

Les inhoud

0% voltooid 0/3 stappen

What is a Database?

Types of Databases: An Overview

Summary: Introduction to Databases

Les inhoud

0% voltooid 0/5 stappen

What is a Relational Database?

Data in Relational Databases

What is a Relational Database Management System (RDMBS)?

RDBMS Technologies: An Overview

Summary: Introduction to Relational Databases

Les inhoud

0% voltooid 0/6 stappen

MySQL Workbench: Installation

MySQL Workbench: Start-up Guide

MySQL in Docker: Installation

Summary: Introduction to MySQL

Working with SQL

Les inhoud

0% voltooid 0/10 stappen

SQL Create: Creating a Table

SQL Insert: Inserting Data into a Table

SQL Select: Retrieving Data from Tables

SQL Alter: Modifying a Table’s Structure

SQL Update: Changing Data in Tables

SQL Drop: Removing a Table

SQL Delete: Deleting Records in a Table

Summary: Creating, Managing and Inserting Data into Tables in a Database

Exercises: Creating, Managing and Filling Tables with Data in a Database

Les inhoud

0% voltooid 0/6 stappen

Primary Key (PK)

SQL Constraints: Adding Constraints to a Table

Foreign Key (FK)

Join Table: Solving Many-to-Many Relationships

Summary: Establishing Relationships Between Tables in a Database

Exercises: Establishing Relationships Between Tables in a Database

Les inhoud

0% voltooid 0/8 stappen

What are Subqueries?

Indexing and Optimisation in SQL

SQL Transactions: Committing and Rolling Back

Best Practices in SQL

SQL Functions and Expressions

Summary: SQL for Beginners: Bonus Topics

Exercises: SQL for Beginners: Bonus Topics

Database Design

Les inhoud

0% voltooid 0/8 stappen

Entity-Relationship Diagrams (ERDs)

Multiplicity and Cardinality

One-to-One Relationships in an ERD

One-to-Many Relationships in an ERD

Many-to-Many Relationships in an ERD

Introduction to Normalisation and Denormalisation

Summary: Database Design and Modelling

Exercises: Database Design and Modelling

Finishing Up

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Altijd ingeschakeld

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duur	Beschrijving
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Others