Curriculum For This Course
Video tutorials list
-
Introduction to MTA 98-381 Exam and Python Programming Language
Video Name Time 1. Visual Studio Code 10:00 2. Installing Visual Studio Code 10:00 3. Introduction to Python 3:00 4. Introduction to Programming & Sequence 10:00 -
Variables & Data Types
Video Name Time 1. Variables 16:00 2. Data Types 11:00 3. Python Variables 19:00 4. Python Data Types 21:00 5. Python Data Type Conversion 6:00 6. Variable Operators 9:00 -
If-Statements and Conditional Logic
Video Name Time 1. If-Statements and Conditional Logic 4:00 2. If-Statements and Conditional Logic in Python 15:00 -
Loops and Iteration
Video Name Time 1. Loops and Iteration 10:00 2. Loops and Iteration in Python - Part 1 7:00 3. Loops and Iteration in Python - Part 2 11:00 -
Arrays
Video Name Time 1. Arrays 11:00 2. 2D Arrays 15:00 3. Multidimensional Arrays & Examples 14:00 4. Functions 22:00 5. Function in Python 15:00 6. File Input/ Output 26:00 7. Input/ Output and Files in Python 11:00 -
Object-oriented Programming
Video Name Time 1. Introduction to Object-oriented Programming 16:00 2. Objects and Classes 9:00 3. Methods 5:00 4. Encapsulation and Data Hiding 7:00 5. Message Passing 4:00 6. Inheritance 10:00 7. Polymorphism 6:00 8. Generalization and Specification 3:00 9. Links and Associations 7:00 -
Advanced Concepts in Python
Video Name Time 1. Sending Emails to multiple receivers with Python 11:00 2. XML parsing 16:00 3. Multithreading in Python 8:00 -
Beyond MTA 98-381 Exam: From Python to SQL - Using Databases to Store Data
Video Name Time 1. Introduction to SQL 4:00 2. Why SQL is so important? 2:00 3. Setting up XAMPP, Apache, MySQL Database Server and SQLYOG as a Database Client 5:00 4. Starting Database Services 2:00 5. Creating our 1st Database 4:00 6. Dropping your 1st Database and Recreating it 3:00 7. Creating out First Tables in our Database 6:00 8. Dropping Tables in a Database 1:00 9. Insert Statements 4:00 10. Create Table based on Another Table 2:00 11. Select Statement 1:00 12. Where Clause 4:00 13. Operators in SQL Statements 4:00 14. Update Data using Update Queries 4:00 15. Delete Data with Delete Statements 2:00 16. Like Operators in Where Clause 3:00 17. Limit Data using LIMIT/ TOP/ ROWNUM in MYSQL/ MSSQL/ Oracle Databases 4:00 18. Using Order-By Clause to Order Data 3:00 19. Using Group-By Clause to Group Data Based on Columns 4:00 20. Using Distinct Clause To Return only Unique Values 3:00 21. TRUNCATE TABLE Command to Delete the Data Inside a Table and Conclusions 4:00
Add Comment