SQLAlchemy Mastery: Database Interaction & ORM in Python
Master the art of database interaction with our comprehensive SQLAlchemy training program. Learn from industry experts as you delve into core concepts and advanced features of SQLAlchemy. Gain practical skills in managing databases efficiently using both Core and ORM techniques. Enroll now to elevate your Python programming expertise.
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Subsidies
What you'll learn
- Master performing basic SQL operations: INSERT, SELECT, UPDATE, DELETE.
- Manage connections and sessions effectively.
- Learn how to create and manage tables using SQLAlchemy Core.
- Establish relationships between tables using SQLAlchemy ORM.
- Understand the differences between SQLAlchemy Core and ORM.
- Define ORM models and map classes to database tables.
- Construct complex queries with filtering, ordering, grouping.
- Implement database migrations and schema management using Alembic.
Why should you attend?
SQLAlchemy is a powerful library in Python that facilitates database interaction and object-relational mapping (ORM). This course provides an in-depth exploration of SQLAlchemy, starting with an introduction to its core components and ORM capabilities. Participants will learn how to install and set up SQLAlchemy, ensuring they have the necessary environment to follow along with the course material. The course delves into database interaction using SQLAlchemy Core, covering the basics of SQL queries, table creation and management, and performing essential SQL operations such as INSERT, SELECT, UPDATE, and DELETE. Following this, learners will transition to working with SQLAlchemy ORM, where they will define ORM models, map classes to database tables, and establish relationships between tables. Managing database sessions and transactions is another critical aspect covered in this course. Participants will gain insights into managing connections and sessions effectively, handling transactions through commit, rollback, and savepoint mechanisms. The course also emphasizes querying data using ORM techniques, handling relationships through joins and loading strategies, and constructing complex queries with filtering, ordering, and grouping. Advanced ORM features are explored to optimize performance further. Topics include defining inheritance in ORM models, optimizing queries with indexes, efficient pagination of large datasets, and implementing connection pooling and scaling strategies. Finally, the course addresses database migrations and schema management using Alembic. Learners will automate schema changes and handle version control for database schemas efficiently.
Course Syllabus
Day 1
Short Break
15 minsShort Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsShort Break
15 minsShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Ratings and Reviews
Instructor
Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.
Instructor Reviews
Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert.
Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly.
I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for.
FAQs
Courses you may like
Why should you attend?
SQLAlchemy is a powerful library in Python that facilitates database interaction and object-relational mapping (ORM). This course provides an in-depth exploration of SQLAlchemy, starting with an introduction to its core components and ORM capabilities. Participants will learn how to install and set up SQLAlchemy, ensuring they have the necessary environment to follow along with the course material. The course delves into database interaction using SQLAlchemy Core, covering the basics of SQL queries, table creation and management, and performing essential SQL operations such as INSERT, SELECT, UPDATE, and DELETE. Following this, learners will transition to working with SQLAlchemy ORM, where they will define ORM models, map classes to database tables, and establish relationships between tables. Managing database sessions and transactions is another critical aspect covered in this course. Participants will gain insights into managing connections and sessions effectively, handling transactions through commit, rollback, and savepoint mechanisms. The course also emphasizes querying data using ORM techniques, handling relationships through joins and loading strategies, and constructing complex queries with filtering, ordering, and grouping. Advanced ORM features are explored to optimize performance further. Topics include defining inheritance in ORM models, optimizing queries with indexes, efficient pagination of large datasets, and implementing connection pooling and scaling strategies. Finally, the course addresses database migrations and schema management using Alembic. Learners will automate schema changes and handle version control for database schemas efficiently.
What you'll learn
- Master performing basic SQL operations: INSERT, SELECT, UPDATE, DELETE.
- Manage connections and sessions effectively.
- Learn how to create and manage tables using SQLAlchemy Core.
- Establish relationships between tables using SQLAlchemy ORM.
- Understand the differences between SQLAlchemy Core and ORM.
- Define ORM models and map classes to database tables.
- Construct complex queries with filtering, ordering, grouping.
- Implement database migrations and schema management using Alembic.
Course Syllabus
Day 1
Short Break
15 minsShort Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsShort Break
15 minsShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Instructor Reviews
Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert.
Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly.
I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for.
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Subsidies
Ratings and Reviews
Instructor
Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.
FAQs
Courses you may like
Our Offers
Become a Trainer
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant
Academy for Business
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to job category and role! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis
Top companies choose Academy for Business
201601037204 (1208145-P)
