Description

SQLAlchemy is a popular SQL toolkit and Object Relational Mapper. It is written in Python and gives full power and flexibility of SQL to an application developer. It is an open source and cross-platform software released under MIT license. SQLAlchemy is famous for its object-relational mapper (ORM), using which classes can be mapped to the database, thereby allowing the object model and database schema to develop in a cleanly decoupled way from the beginning.

This tutorial is designed for all those Python programmers who would like to understand the ORM framework with SQLAlchemy and its API.

Before you start proceeding with this tutorial, we assume you have a good understanding of the Python programming language. A basic understanding of relational databases, DB-API, and SQL is desired to understand this tutorial.

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

SQLAlchemy Tutorial
SQLAlchemy Introduction
SQLAlchemy Core
SQLAlchemy Core – Expression Language
SQLAlchemy Core Connecting to Database
SQLAlchemy Core Creating Table
SQLAlchemy Core SQL Expressions
SQLAlchemy Core Executing Expression
SQLAlchemy Core Selecting Rows
SQLAlchemy Core Using Textual SQL
SQLAlchemy Core Using Aliases
Using UPDATE Expression
Using DELETE Expression
SQLAlchemy Core Using Multiple Tables
Using Multiple Table Updates
ParameterOrdered Updates
SQLAlchemy Core Multiple Table Deletes
SQLAlchemy Core Using Joins
SQLAlchemy Core Using Conjunctions
SQLAlchemy Core Using Functions
SQLAlchemy Core Using Set Operations
SQLAlchemy ORM
SQLAlchemy ORM Declaring Mapping
SQLAlchemy ORM Creating Session
SQLAlchemy ORM Adding Objects
SQLAlchemy ORM Using Query
SQLAlchemy ORM Updating Objects
SQLAlchemy ORM Applying Filter
SQLAlchemy ORM Filter Operators
Returning List and Scalars
SQLAlchemy ORM Textual SQL
SQLAlchemy ORM Building Relationship
Working with Related Objects
SQLAlchemy ORM Working with Joins
Common Relationship Operators
SQLAlchemy ORM Eager Loading
SQLAlchemy ORM Deleting Related Objects
Many to Many Relationships
SQLAlchemy Dialects
SQLAlchemy Quick Guide
SQLAlchemy Useful Resources
Discuss SQLAlchemy

Instructor

image
W3edify Infotech

President of Sales

4.5
Instructor Rating
0 Reviews
0 Students
1188 Course

Student Feedback

0
Course Rating
70%
15%
20%
3%
2%