Database Systems with SQL - Full Course
5.0
(0)
6 learners
What you'll learn
This course includes
- 4.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 78 lessons • 4.5 hours of video
Database Systems with SQL - Full Course
78 lessons
• 4.5 hours
Database Systems with SQL - Full Course
78 lessons
• 4.5 hours
- Database Systems - Intro to Data 02:44
- Database Systems - Intro to Databases and DBMS 02:23
- Database Systems - User Roles 01:30
- Database Systems - Intro to Transactions 02:00
- Database Systems - Intro to Architecture 01:46
- Database Systems - Relational vs NoSQL Databases 02:53
- Database Systems - What is SQL - Structured Query Language 02:51
- Database Systems - Database Design Process - Analysis, Logical and Physical Phase 04:53
- Database Systems - Installing MySQL Workbench and Starting the Database Server 05:46
- Database Systems - Database Model and Relational Model 03:57
- Database Systems - Intro to Tables, Columns, and Rows 01:49
- Database Systems - Data Types 02:41
- Database Systems - Structural Rules and Data Independence 01:22
- Database Systems - NULL Values 02:48
- Database Systems - Primary Keys and Foreign Keys 03:24
- Database Systems - Referential Integrity on Primary and Foreign Keys 01:48
- Database Systems - Inner and Outer Joins 04:59
- Database Systems - View Tables 04:36
- Database Systems - Normization - 1NF, 2NF and 3NF Normal Form 04:18
- Database Systems - Relational Algebra and Query Optimization 02:33
- Database Systems - ER Diagram - Entity Relationship Diagrams 03:25
- Database Systems - Data Discovery, Glossary, and ER Diagrams - APPFICIAL 02:03
- Database Systems - Dependency Relationships - Independent and Dependent Entities 01:42
- Database Systems - IsA Relationship - Supertype and Subtype Entities 02:47
- Database Systems - Database Design: Implementing Entities, Relationships and Attributes 03:55
- Database Systems - Boyce-Codd Normal Form - BCNF Normalization and Table Denormalization 02:19
- Database Systems - Cardinality 02:27
- Database Systems - Introduction to SQL with Examples 03:42
- Database Systems - How to create a Database - CREATE DATABASE Statement 06:54
- Database Systems - SQL Data Types - INT FLOAT VARCHAR and more! 02:30
- Database Systems - CREATE TABLE Statement - Creating Tables in SQL 05:20
- Database Systems - Primary Keys - Creating Tables with a Primary Key in SQL 03:54
- Database Systems - Foreign Key Example - How to use the FOREIGN KEY Constraint 01:49
- Database Systems - Foreign Key ON DELETE and ON UPDATE Actions 02:04
- Database Systems - Table Column Constraints - NOT NULL - DEFAULT - UNIQUE - CHECK - CONSTRAINT 05:09
- Database Systems - INSERT UPDATE and DELETE SQL Statements 05:30
- Database Systems - The SELECT Statement - SELECT * FROM Table WHERE Condition 03:30
- Database Systems - Selecting Rows with WHERE and ORDER BY in a SELECT Statement 05:25
- Database Systems - Aggregate Functions COUNT SUM MIN MAX AVG and Using GROUP BY 03:55
- Database Systems - SQL Functions - Numeric, String, and Date Time Function with Examples 04:56
- Database Systems - SQL Subquery and Correlated Subqueries with Examples 03:59
- Database Systems - Storage Media and Table Structures - Heap Hash Sorted and Table Clusters 04:58
- Database Systems - Single Level Indexes - Primary Secondary Clustering Dense and Sparse Index 04:32
- Database Systems - Multi-Level Indexes and Other Index Types: Hash Bitmap Logical and Function Index 04:17
- Database Systems - Tablespaces 01:55
- Database Systems - Partitions - Horizontal vs Vertical Partition and Shards 02:23
- Database Systems - Physical Design Process and Storage Engines 02:49
- Database Systems - Transactions with Commit and Rollback - ACID Properties 03:07
- Database Systems - Transaction Schedules and Isolation Levels 03:27
- Database Systems - Concurrency - Locks and Deadlocks, 2PL, and Snapshot Isolation 05:00
- Database Systems - Backup and Recovery, Log Files, and Failure Types 03:17
- Database Systems - Transactions with SQL - SET TRANSACTION - COMMIT - ROLLBACK - SAVEPOINT 02:21
- Database Systems - MySQL Architecture Explained 03:33
- Database Systems - Cloud Databases and Cloud Computing Explained SaaS PaaS IaaS - APPFICIAL 06:25
- Database Systems - Distributed Databases and Transactions - CAP Theorem - APPFICIAL 04:15
- Database Systems - Replicated Databases and Catalogs 03:34
- Database Systems - Data Warehouses and Data Mart - ETL and Star Schema Explained - APPFICIAL 05:34
- Database Systems - Architecture Types: In-Memory, Embedded, Federated, and Data Lake - APPFICIAL 02:54
- Database Systems - Simple and Complex Data Types 02:13
- Database Systems - Collection Data Types - Set Multiset List and Array - APPFICIAL 02:22
- Database Systems - Document Data Types - JSON and XML - Structured vs. Unstructured Data - APPFICIAL 03:12
- Database Systems - Spatial Types Geometric vs. Geographic - POINT LINESTRING POLYGON and GEOMETRY 03:02
- Database Systems - Object Types - Object Oriented Programming OOP - Object Relational Mapping ORM 03:17
- Database Systems - Programming Languages and Database Programming - Imperative vs Declarative 03:06
- Database Systems - Embedded SQL Database Programming - SQLJ - Pro*C - Cursors - Dynamic/Static SQL 03:46
- Database Systems - Procedural SQL PL/SQL - CREATE PROCEDURE Statement - Cursors and Triggers 04:44
- Database Systems - MySQL APIs for Programming Languages - JDBC DB-API ODBC PDO APO.NET API 02:05
- Database Systems - Python Database Programming - Connector/Python 07:31
- Database Systems - Python Database Programming with Stored Procedure Call Example - APPFICIAL 02:22
- Database Systems - Java Database Programming with MySQL and Connector/J - Using Query Parameters 07:47
- Database Systems - Java Database Programming with Stored Procedure Calls - CallableStatement 02:34
- Database Systems - Web Database Programming with PHP Data Objects PDO - APPFICIAL 05:14
- Database Systems - PHP Database Programming with Stored Procedure Calls for Web - APPFICIAL 01:55
- Database Systems - Intro to Big Data and NoSQL Key-Value Pair Databases - APPFICIAL 03:51
- Database Systems - NoSQL Key-Value Pair Databases Overview - APPFICIAL 02:44
- Database Systems - Wide Column Databases - NoSQL Databases Overview - APPFICIAL 02:18
- Database Systems - Document Databases - NoSQL Overview - Appficial 03:05
- Database Systems - Graph Databases - NoSQL Overview - APPFICIAL 02:58
Take this course with you
Download the app to continue lessons from your phone anytime.
