Database Engineerdba Mysql Mongodb Sqlite

User Accessibility Options Preview 05:49

Preferences Options Preview 03:14

General Editor Preferences Preview 05:06

SQL Editor Preference Preview 13:52

Administration Preferences Preview 01:55

Modelling Preferences Preview 07:31

Fonts and Colors Preview 02:03

SSH Prefrences Preview 02:55

Other Preferences Preview 02:58

MySQL Workbench Home Screen Preview 08:16

What is Data Modelling Preview 01:49

Creating a model -part 1 Preview 11:05

Creating a model -part 2 Preview 06:25

Basic Modelling Preview 06:06

Creating a new MySQL Connection Preview 05:50

Managing Server Connections Preview 05:42

Client Connections Preview 05:16

Checking Server Status Preview 04:32

Administration of users and privileges Preview 07:35

Checking performance dashboard Preview 06:42

Using MySQL Utilities Preview 06:24

Using Object Browser Preview 03:14

Showing existing databases Preview 02:57

Showing list of tables Preview 02:40

Creating a database Preview 02:03

Creating a table Preview 06:59

Executing Basic SQL Commands Preview 02:40

Displaying Table Structure Preview 04:24

Changing Table Sructure Preview 05:04

MySQL Naming Convention Preview 05:05

Creating MySQL Database Preview 06:31

Using IF NOT EXIST DROP Preview 04:41

Creating a table in MySQL Database Preview 12:43

Setting a default database Preview 05:03

Using MySQL Comments Preview 05:38

Primary Keys Preview 04:09

Foreign Keys Preview 06:00

WHERE Preview 02:37

DISTINCT Preview 05:57

GROUP BY Preview 03:56

HAVING Preview 06:31

ORDER BY Preview 06:10

LIMIT Preview 06:18

CHARACTER Function Preview 01:59

CONCAT Function Preview 02:42

MySQL SELECT Statement Preview 08:22

MySQL INSERT Statement Preview 08:48

MySQL UPDATE Statement Preview 10:51

MySQL DELETE Statement Preview 05:06

What is a subquery Preview 04:37

Nested Subqueries Preview 03:22

Derived Tables Preview 04:15

MySQL INNER Join Preview 11:57

MySQL LEFT Join Preview 06:05

MySQL RIGHT Join Preview 04:13

MySQL SELF Join Preview 08:07

What are MySQL Views Preview 05:15

Creating a MySQL View Preview 04:07

Querying MySQL Views Preview 03:38

Modifying Views Preview 06:16

Dropping Views Preview 02:50

What are stored procedures Preview 03:46

Creating a stored procedure Preview 06:54

Modifying a stored procedure Preview 05:13

Creating an advanced stored procedure Preview 07:26

Calling and deleting stored procedures Preview 05:32

BETWEEN Operator Preview 06:39

IN Operator Preview 08:38

LIKE Operator Preview 11:00

UNION Operator Preview 08:05

What are aggregate functions Preview 02:05

AVG Aggregate function Preview 03:29

COUNT Aggregate function Preview 08:49

SUM Aggregate function Preview 04:22

MIN Aggregate function Preview 02:25

MAX Aggregate function Preview 02:48

MySQL Access Privilege Preview 06:21

MySQL Privileges restrictions Preview 01:12

Static and dynamic privileges Preview 02:51

Applying dynamic priviledges Preview 05:17

Migrating SUPER privileges Preview 05:44

MySQL Priviledges Preview 08:06

Data export and import methods Preview 04:54

Using Table Wizard Preview 09:58

SQL Data export and import wizard Preview 08:21

Result data export and import Preview 05:44

Visual SQL editor Preview 13:52

Object browser Preview 03:14

Introduction to MySQL Backup and Recovery Preview 03:26

Backup and recovery types Preview 09:56

Setting up backup directory Preview 05:04

Exporting data from MySQL Preview 01:30

Export result set of a query Preview 04:04

Backing up databases Preview 08:09

Restore databases from backup Preview 08:16

Backing up a single table Preview 03:16

Restore table from backup Preview 07:27

What is MongoDB Preview 01:48

Installing MongoDB on Windows Preview 02:08

Install MongoDB on Mac Preview 01:14

Modifying environment variables Preview 06:16

Creating storage directory for MongoDB Preview 03:14

Starting and stopping MongoDB Preview 02:21

What is Node.js Preview 03:01

Download and install Node.js Preview 02:30

What is NPM Preview 05:00

What is JSON Preview 03:29

JSON Syntax Preview 11:06

Creating JSON Object Preview 07:42

What is Python Preview 05:16

Install Python Preview 04:34

Install Httpie Preview 03:46

Data Modelling with MongoDB Preview 06:02

Create a sample JSON document Preview 03:23

MongoDB Data Types Preview 03:20

MongoDB Vs RDBMS Preview 03:11

What is CRUD Preview 02:02

Creating a database Preview 05:42

Dropping a database Preview 04:31

Inserting documents into MongoDB Preview 06:12

Querying a document in MongoDB Preview 05:40

Updating documents in MongoDB Preview 08:24

Deleting documents in MongoDB Preview 06:33

Limiting Data Preview 05:39

Indexes Preview 05:05

Connecting to MongoDB using Python Preview 08:28

Query MongoDB Using Python Preview 05:14

Create a document with Python Preview 07:37

Inserting a document with Python Preview 05:41

Creating CSV Files Preview 05:15

Exploring dataset structures Preview 02:41

Using Mongoimport tool Preview 04:54

Importing data into MongoDB Preview 05:24

Joining Collections Preview 10:25

Backing up MongoDB Database Preview 04:18

Restoring MongoDB Database Preview 01:22

What is SQLite Preview 07:31

Download and install SQLite Preview 06:40

Download SQLite Studio Preview 05:50

Attaching Sample Database Preview 07:16

Database Concepts Preview 09:00

SQLite3 Tool Preview 03:10

Common SQLite3 Commands Preview 10:31

SQLite Dump Command Preview 08:06

SQLite SELECT Statement Preview 05:37

Query data from all columns in a table Preview 04:53

Query data from specific columns in a table Preview 05:17

Sorting data using ORDER BY Clause Preview 08:21

Removing duplicate records Preview 05:29

Filtering data with WHERE clause Preview 06:59

Identifying NULL Values Preview 04:30

SQLite Data Types Preview 07:23

SQLite Aliases Preview 06:03

SQLite Constraints Preview 04:21

SQLite Create Table Statements - Part 1 Preview 06:46

SQLite Create Table Statements - Part 2 Preview 07:03

SQLite INSERT INTO Table Statement Preview 07:43

SQLite UPDATE Statement Preview 03:47

SQLite DELETE Statement Preview 02:41

SQLite DROP Statement Preview 01:37

SQLite BETWEEN Operator Preview 04:28

SQLite IN Operator Preview 04:53

SQLite LIKE Operator Preview 06:51

SQLite GLOB Operator Preview 05:38

SQLite LIMIT Preview 05:18

What is a SubQuery Preview 02:52

Building Subqueries with WHERE Clause Preview 03:37

Building Subqueries with IN operator Preview 02:43

Building Subqueries with FROM Clause Preview 02:54

SQLite LEFT Join Preview 05:51

SQLite INNER Join Preview 05:43

SQLite CROSS Join Preview 05:20

SQLite SELF Join Preview 07:04

Introduction to Aggregate Functions Preview 03:30

SQLite AVG Function Preview 03:32

SQLite COUNT Function Preview 04:29

SQLite SUM Function Preview 02:25

SQLite MAX Function Preview 01:08

SQLite MIN Function Preview 02:53

SQLite GROUP CONTACT Function Preview 01:45

SQLite GROUP BY Clause Preview 04:17

SQLite HAVING Clause Preview 06:43

Thank You Preview 00:09