.pro-gallery-wix-wrapper {display: block !important;} .pro-gallery-wix-wrapper .gallery-item-container {opacity: 1 !important; display: block !important;}

Database Fundamentals

Name: Database Fundamentals
SKU: df_dbfn_a01_it_enus
Availability: InStock

SKU df_dbfn_a01_it_enus

A relational database is a type of database structure that organizes data based on relationships using normalized tables. There are different types of databases such as data warehouses and online transactional-processing (OLTP). The type of database that is used depends on how the organization will use and store its data. A Database Management System (DBMS) includes software and applications to query and manage the data in a database.

Course Details:

This course aims to provide learners with a good knowledge base of the fundamentals of databases and how they are used. It outlines what a database is, how a database can be structured, and how to provide structured and secure access to the database system.

This course contains 2 chapters with 14 modules (Total Duration: 4hrs)

Database Systems & Relational Databases
1. Overview of Databases & DBMSs
2. The Database Architecture & Models
3. Identifying Database Systems
4. Relational Database Concepts
5. The Relational Database Schema
6. Database Normalization
7. Identifying the Relational Database Concepts & Schema
Management of Relational Database Data
1. Relational Algebra Operations
2. Use SQL for Queries & Manipulation
3. Querying & Manipulating Relational Databases
4. Transaction Processing & Concurrency
5. Concurrency Control Locking
6. Security in a Relational Database
7. Implementing Transaction Control & Security

Digital Product Notice:

This is a Digital Product! After course purchase, you'll receive your credentials via email to access the online Student Portal to view your course material.

Refund/Exchange Policy:

Our online courses are digital products that will be delivered via online access through our Student Portal.

Digital products are ineligible for refunds or exchanges.

Course ID Code:

ID: [df_dbfn_a01_it_enus] & [df_dbfn_a02_it_enus] *to be used for course registration*

Recommended Experience:

Beginner Level

This course is suitable for everyone, including students, professionals, and enthusiasts.

Flexible Schedule

Learn at your own pace!

Certificate of Completion

Earn a Professional Career Certification from the State University of New York.

Course
Overviews & Objectives

Install Anaconda Python on Windows & MacOS
Execute commands on the Python shell.
Perform basic math operations.
Execute arithmetic operations on variables.
Work with built-in functions.
Create & use complex data types (lists, tuples, sets, etc.)
Perform type conversions.
Create strings with various quotes.
How to perform basic math and logical operations in Python.
Create Python variables and see how you can assign and access values stored in these variables.
Use built-in functions in the core Python programming language to perform simple calculations and operations.
Explore strings in Python work, creating strings using single, double, and triple quotes depending on the use case.
Examine the use of complex data types, such as lists, tuples, sets, and dictionaries.
When you're finished with this course, you'll be able to execute simple Python commands on Jupyter notebooks.

Overview:

In Module #1, you'll learn the basics of Python and its philosophy, setting up Python, and writing a basic program with built-in data types, loops, and conditionals.

Objectives:

Setting Up
A Basic Program
Data Types
Sequence Types
Collection & Mapping Types in Python
Loops & Conditionals
Practice: Writing a Python Program

Overview:

Python is a lot more than a scripting language, and can be used to create OOP applications using classes, or using a functional paradigm.

This module covers some of the ways Python programs can execute. You'll learn about building your own custom functions and classes, and documentation and file handling.

Objectives:

Modules & Functions
Classes
Documenting Code
Files
Practice: Creating Classes

Course
Overviews & Objectives

Install Anaconda Python on Windows & MacOS
Execute commands on the Python shell.
Perform basic math operations.
Execute arithmetic operations on variables.
Work with built-in functions.
Create & use complex data types (lists, tuples, sets, etc.)
Perform type conversions.
Create strings with various quotes.
How to perform basic math and logical operations in Python.
Create Python variables and see how you can assign and access values stored in these variables.
Use built-in functions in the core Python programming language to perform simple calculations and operations.
Explore strings in Python work, creating strings using single, double, and triple quotes depending on the use case.
Examine the use of complex data types, such as lists, tuples, sets, and dictionaries.
When you're finished with this course, you'll be able to execute simple Python commands on Jupyter notebooks.

Overview:

In Module #1, you'll learn the basics of Python and its philosophy, setting up Python, and writing a basic program with built-in data types, loops, and conditionals.

Objectives:

Setting Up
A Basic Program
Data Types
Sequence Types
Collection & Mapping Types in Python
Loops & Conditionals
Practice: Writing a Python Program

Overview:

Python is a lot more than a scripting language, and can be used to create OOP applications using classes, or using a functional paradigm.

This module covers some of the ways Python programs can execute. You'll learn about building your own custom functions and classes, and documentation and file handling.

Objectives:

Modules & Functions
Classes
Documenting Code
Files
Practice: Creating Classes

Frequently Asked Questions

You will receive a username & password to access the Student Portal and view your course material.

Please allow 24-48 hours for your student registration and credentials to be assigned.
Upon course completion, you will be mailed a Professional Career Certification from the State University of New York.

Database Fundamentals

Course Details:

Digital Product Notice:

Refund/Exchange Policy: