SQL Databases Using SQLAlchemy E-Learning Training

Bestel deze geweldige, bekroonde SQL Databases Using SQLAlchemy E-Learning Training cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

Cursusinhoud

SQL Databases Using SQLAlchemy: Getting Started

Course: 1 Hour, 21 Minutes

• Course Overview
• Installing MySQL on Windows
• Installing MySQL on MacOS
• Installing SQLAlchemy and Connecting to a Database
• Creating a Table and Inserting Data
• Inserting Data into Tables
• Performing Valid and Invalid Insert Statements
• Creating and Using SQL Unique Constraints
• Using SQL Not Null and Primary Key Constraints
• Course Summary

SQL Databases Using SQLAlchemy: Manipulating Data

Course: 1 Hour, 25 Minutes

• Course Overview
• Using Where Clauses to Filter the Output of Select Queries
• Constructing Queries Using SQLAlchemy Methods
• Using the SQL Alter Command
• Updating Data in Tables
• Updating Data with Preserved Parameter Order
• Deleting and Recreating a Table
• Using Logical Operators to Filter Data
• Filtering Data Using Subqueries
• Adding SQL Foreign Key Constraints
• Course Summary

SQL Databases Using SQLAlchemy: Querying Data

Course: 1 Hour, 26 Minutes

• Course Overview
• Filtering Data Using the SQL Between Operator
• Filtering Data Using the Order by, Limit, and Offset Clauses
• Using the fetchone() Method
• Using the fetchmany() Method
• Performing Joins Using the Select Clause
• Performing Joins Using the join() Method
• Using the Group by Clause
• Using the Group by Clause to Calculate Aggregate Statistics
• Using the Having Clause to Perform Filter Operations
• Course Summary

SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes

Course: 1 Hour, 17 Minutes

• Course Overview
• Using the Some and All SQL Operators
• Performing Three-way Joins
• Creating SQL Views
• Querying SQL Views Using the Where Clause
• Inserting Data into Views
• Understanding SQL Indices
• Creating Composite Indices
• Course Summary

SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions

Course: 1 Hour, 19 Minutes

• Course Overview
• Using Triggers to Automate Tasks in SQL
• Creating Complex Triggers in SQL
• Creating and Invoking Stored Procedures
• Creating Stored Procedures with Input Arguments
• Querying SQL Views Using the Where Clause
• Working with Transactions
• Using Python with Blocks for Transactions
• Working with Transaction Aborts
• Course Summary

SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM

Course: 1 Hour, 5 Minutes

• Course Overview
• Implementing Check Constraints
• Creating Custom Foreign Key Constraints
• Creating Tables Using the SQLAlchemy ORM
• Querying Data Using the SQLAlchemy ORM
• Using Automap Base to Convert Tables to Classes
• Inserting Data into Tables Using the ORM
• Course Summary