Home

All Courses

Python Data Access Tutorial

(0)

0 enrolled on this course

Last updated 09/2023

W3edify Infotech

Lessons

Duration

13 Hours

Skill level

Beginner

Certificate

Lifetime Access

Description

Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by Guido van Rossum during 1985-1990. Like Perl, Python source code is also available under the GNU General Public License (GPL). This tutorial gives enough understanding on Python programming language. It provides various modules to communicate with various databases. In this tutorial, we are going to discuss python modules to communicate with the databases MySQL, PostgreSQL, SQLite and, MongoDB.

This tutorial is designed for python programmers who would like to understand the mysql-connector-python, psycog2, Python sqlite3 module and, pymongo modules in detail.

Before proceeding with this tutorial, you should have a good understanding of python programming language. It is also recommended to have basic understanding of the databases - MySQL, PostgreSQL, SQLite, MongoDB.

What you'll learn

Become a UX designer.

You will be able to add UX designer to your CV

Become a UI designer.

Build & test a full website design.

Create your first UX brief & persona.

How to use premade UI kits.

Create quick wireframes.

Downloadable exercise files

Build a UX project from beginning to end.

Learn to design websites & mobile phone apps.

All the techniques used by UX professionals

You will be able to talk correctly with other UX design.

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

Python MySQL

Python MySQL Introduction

Python MySQL Database Connection

Python MySQL Create Database

Python MySQL Create Table

Python MySQL Insert Data

Python MySQL Select Data

Python MySQL Where Clause

Python MySQL Order By

Python MySQL Update Table

Python MySQL Delete Data

Python MySQL Drop Table

Python MySQL Limit

Python MySQL Join

Python MySQL Cursor Object

Python PostgreSQL

Python PostgreSQL Introduction

Python PostgreSQL Database Connection

Python PostgreSQL Create Database

Python PostgreSQL Create Table

Python PostgreSQL Insert Data

Python PostgreSQL Select Data

Python PostgreSQL Where Clause

Python PostgreSQL Order By

Python PostgreSQL Update Table

Python PostgreSQL Delete Data

Python PostgreSQL Drop Table

Python PostgreSQL Limit

Python PostgreSQL Join

Python PostgreSQL Cursor Object

Python SQLite

Python SQLite Introduction

Python SQLite Establishing Connection

Python SQLite Create Table

Python SQLite Insert Data

Python SQLite Select Data

Python SQLite Where Clause

Python SQLite Order By

Python SQLite Update Table

Python SQLite Delete Data

Python SQLite Drop Table

Python SQLite Limit

Python SQLite Join

Python SQLite Cursor Object

Python MongoDB

Python MongoDB Introduction

Python MongoDB Create Database

Python MongoDB Create Collection

Python MongoDB Insert Document

Python MongoDB Find

Python MongoDB Query

Python MongoDB Sort

Python MongoDB Delete Document

Python MongoDB Drop Collection

Python MongoDB Update

Python MongoDB Limit

Python Data Access Resources

Python Data Access Quick Guide

Python Data Access Useful Resources

Instructor

W3edify Infotech

President of Sales

4.5

Instructor Rating

0 Reviews

0 Students

1188 Course

Student Feedback

Course Rating

70%

15%

20%

Development

Office Productivity

Marketing

Health & Fitness

Python Data Access Tutorial

Description

What you'll learn

Requirements

Course Content

Instructor

W3edify Infotech

Student Feedback

You May Like