|Section 1: How This Course Is Structured|
Overview Of How This Course Is Structured
Description Of The Inventory Management Project
PyMySQL Methods Summary Document
|Section 2: Setting Up Your Development Environment|
Overview Of Setting Up Your Environment: Python, XAMPP PyMySQL & MySQL
Important Note on Live Walkthrough Video Below
Live Walkthrough Of Downloads, Installations And Configurations
|Section 3: Creating Database Tables In Python|
Set Up Project Database Tables In Python Overview
Code Walkthrough Of Setting Up Project Database Tables In Python
|Section 4: Working With Database Inserts And Selects In Python|
Database Inserts And Selects In Python Overview
Code Walkthrough Of Project Database Inserts And Selects In Python
|Section 5: Working With Multiple Inserts, Updates And Complex MySQL Selects|
Multiple Inserts, Updates And Complex MySQL Selects In Python Overview
Code Walkthrough Of Multiple Inserts, Updates And Complex MySQL Selects
|Section 6: Creating Reports With MySQL And Python|
Overview Of Project Reports
Code Walkthrough Of Creating Reports WIth MySQL And Python
|Section 7: Resources: Powerpoint Downloads and Code Download|
All Powerpoint Slides For Each Section
Python Source Code For The Inventory Management Project
This is a deep dive course on understanding how SQL Server works to effectively choose the right high availability and disaster recovery solution that will address every organization’s need to protect digital assets. Packed with videos explaining concept and demos to reinforce the lessons, this course is what every IT professional needs to properly manage and protect a SQL Server database.
This course is over 6 hours in length and will cover all aspects of IPv4. Students will learn IP addressing, Subnetting, VLSM, Route Summarization, and Wildcard Masking. The course will also show students how to assign IP addresses to PC’s and Routers. Students will gain an understanding of the TCP/IP properties such as gateways, DNS, WINS, and the use of alternate addresses.
DISCLAIMER: Please note that the simulators/emulators used in this course are not part of the course. It is the students responsibility to have these to practice with. The Cisco Packet Tracer and/or VIRAL (Virtual Internet Routing Lab) are Cisco proprietary software and can only be obtained through Cisco. It is up to each student to obtain the simulator/emulator of their choice to study along with this course.
Do you want to master in Data warehousing, keen to become an expert ? Me being worked on several Data Warehousing implementation projects in last 12 years here in UK. I will give you the grain of what’s needed to implement a successful Data Warehouse project.
We’ve heard it all, big data and the intelligence to understand these chunks of data. Most persons have to start from scratch or meet mid-way to become an expert in business Intelligence domain.
Course is meant for someone who wants to understand fundamentals of DW and various architectural pieces around it and eventually become a part of big data revolution.
- Save time and resources by learning these helpful data extraction tools and techniques!
In this course, we’ll review a variety of data extraction methods in a series of short tutorials aimed at beginner and intermediate-level computer users.
By the end of this course, you’ll be able to use these tools and techniques with confidence, so you can get the data you need more quickly and with less effort!
HOW IS THIS COURSE DIFFERENT?
Discover how to use MySQL, a popular choice of database for use in powerful web applications!
During this 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics.
Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.
Be part of the NoSQL movement and learn to create large scale data oriented web solutions with our amazing course on NoSQL and Mongo DB. This course from Eduonix aims to teach you the tips, tricks and motivation behind the NoSQL database systems. It will teach you the concepts from ground up and will help you understand why the control of data is at times more important than availability.
You will also learn about the best cases for NoSQL implementation which are real time web applications dealing with massive amount of data. The course will provide a complete new dimension to the traditional database developers and will help them design their systems beyond the constraints of RDBMS systems.
This Apache Cassandra training course Infinite Skills teaches you the basics of working with Cassandra. This course is designed for the absolute beginner, meaning no experience with Cassandra is required. Experience with databases, SQL, and programming is recommended.
You will start by learning how to install Cassandra, and then move onto understanding ways to communicate with Cassandra. From there, this course will teach you how to create a database, create a table, and insert and model data. This video tutorial will also cover creating an application, updating and deleting data, selecting hardware, and adding nodes to a cluster. You will also learn how to monitor a cluster, repair and remove nodes, and redefine a cluster.