Expires December 07, 2119 23:59 PST
Buy now and get 98% off
Intro to SQLite Databases for Python Programming
KEY FEATURES
SQLite is one of the most popular databases and is a great database for just about all your needs. In this course, you'll learn the basics of using SQLite with Python, one of the most popular and powerful programming languages today. You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more. This course may require a very basic knowledge of Python programming.- Access 23 lectures & 1 hour of content 24/7
- Understand how to use SQLite Databases w/ Python
- Install Python, SQLite, Git Bash & Sublime Text
- Learn how to explore what's in the database whenever you want
- Create a database table & learn how to update and delete data from the database
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic understanding of Python programming
THE EXPERT
Instructor
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly-traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.Learn SQL with Microsoft SQL Server
KEY FEATURES
This course will teach you SQL in a fast and easy way. You'll download and use the free trial version of Microsoft SQL Server and learn exactly how to use it like a pro. This 33-lecture course will start with fundamental database concepts and then go with setting up and using Microsoft SQL Server. By the end of this course, you'll learn SQL, from the basic concepts to the more advanced ones.- Access 33 lectures & 1 hour of content 24/7
- Download & use the free trial version of Microsoft SQL Server
- Learn fundamental database concepts including tables, rows, columns & data types
- Understand & use SQL w/ databases
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic understanding of Python programming
THE EXPERT
Instructor
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly-traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.Using MySQL Databases with Python
KEY FEATURES
MySQL is one of the most popular databases and is a great database for just about all your needs. In this course, you'll learn the basics of using MySQL with Python, one of the most popular and powerful programming languages today. You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more. This course may require a very basic knowledge of Python programming.- Access 24 lectures & 2 hours of content 24/7
- Understand how to use MySQL Databases w/ Python
- Install Python, MySQL, Git Bash & MySQL Connector
- Learn how to explore what's in the database whenever you want
- Create a database table & learn how to update and delete data from the database
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic understanding of Python programming
THE EXPERT
Instructor
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly-traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.PostgreSQL Bootcamp: SQL & PostgreSQL Database Masterclass
KEY FEATURES
The knowledge of SQL and PostgreSQL is a must for IT professionals and this course is a one-stop-shop for gaining this necessary and in-demand skill. With 60 lectures, this course will guide you through a step-by-step approach on how to write SQL queries. It will cover different techniques, models, operators, ways, and processes. Be a better data analyst and get into the field of Data Science, Data Analysis, and Data Visualization.- Access 60 lectures & 5 hours of content 24/7
- Learn all the SET Operators in PostgreSQL
- Understand the Northwind Data Model
- Filter, group & slice data from tables in PostgreSQL
- Learn data conversion functions
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Internet access required
THE EXPERT
Instructor
Prathap is an IT professional who has 15 years of Experience and diversified knowledge across multiple domains in the industry and working in a leading Product/Cloud provider company. He has taken various roles in his career from Developer, Designer, Consultant, Architect, Performance Management and is currently ramping up his skills on Next-Generation Tools and Products.REST API Testing Using Python for Beginners
KEY FEATURES
Do you want to become a better QA analyst or an API architect? If your answer is yes, then this course is for you. This course is designed for the beginners and freshers to gain knowledge on concepts of REST and SOAP API and to perform the REST API testing using Python modules like REQUESTS, JSON, JSON PATH, and pytest. Throughout the course, you'll be able to see actual Python modules and API testing. This course also includes practice files, quizzes, and assignments.- Access 30 lectures & 4 hours of content 24/7
- Learn the architecture of REST & SOAP API
- Perform real-time REST API testing using Python modules
- Understand the various methods of API like GET, POST, PUT & DELETE
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic knowledge of Python
THE EXPERT
Instructor
Prathap is an IT professional who has 15 years of Experience and diversified knowledge across multiple domains in the industry and working in a leading Product/Cloud provider company. He has taken various roles in his career from Developer, Designer, Consultant, Architect, Performance Management and is currently ramping up his skills on Next-Generation Tools and Products.Oracle SQL: Mastering Oracle SQL Performance Tuning
KEY FEATURES
This course is designed to take the Oracle SQL Developers, Analysts, DBA to the next level in SQL Query Tuning. With 59 lectures, you will learn how to troubleshoot badly performing SQL queries. It will also cover Oracle components that need to be checked and looked at. This course will also teach you how to interpret various components and identify the actual reason why the SQL Query is taking time. Not only that, but you'll also learn what fixes could be applied to make the SQL Query work faster. By the end of the course, you'll get the skills required to write highly efficient Oracle SQL queries.- Access 59 lectures & 6 hours of content 24/7
- Identify potential performance bottlenecks by reading the Explain plan of the queries
- Identify how internal Oracle components affect the performance of the SQL query
- Understand how statistics & cardinality affects SQL Query performance
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate
Requirements
- Basic understanding of Oracle SQL Query writing
THE EXPERT
Instructor
Prathap is an IT professional who has 15 years of Experience and diversified knowledge across multiple domains in the industry and working in a leading Product/Cloud provider company. He has taken various roles in his career from Developer, Designer, Consultant, Architect, Performance Management and is currently ramping up his skills on Next-Generation Tools and Products.