Tag: MySQL Database

Duration

14 hours (usually 2 days including breaks)

Requirements

Fundamental knowledge of any database and SQL language.

Overview

MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.

The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.

Course Outline

MySQL Server Files and Scripts

• MySQL Programs
• MySQL Server
• MySQL Client
• GUI Tools

MySQL Server Configuration

• mysqld Options
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Process

MySQL Security Issues

• Securing MySQL Against Attacks
• Security-Related mysqld Options
• Security Issues with LOAD DATA LOCAL

MySQL Access Privilege System

• MySQL Privilege System Overview
• Privileges Provided by MySQL
• Connecting to the MySQL Server – Stages
• Access Control, Stage 1: Connection Verification
• Access Control, Stage 2: Request Verification
• Access Denied Errors

MySQL User Account Management

• Users and Passwords
• Creating New Users
• Deleting User Accounts
• Limiting User Resources
• Changing Passwords

MySQL Database Maintenance

• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Getting Table Information
• MySQL Local Setting
• National Characters and Sorting
• MySQL Server Time Zone

MySQL Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Log File Maintenance and Rotation

Running Multiple MySQL Servers on the Same Machine

• Running Multiple Servers in Windows
• Running Multiple Servers in Windows as Services
• Running Multiple Servers in Unix and Linux
• Using Client Tools in a Multi-Server Environment

Software Manual Testing Concepts (Basic to Advance), Interview Questions with Best Practices

Ready to attend and crack Experience Level Software Manual Testing interviews

Practical working knowledge of JIRA from QA point of view, Will be ready to use JIRA for Bug Tracking & Task Management

Practical exposer to Database Testing (using MySQL database) & Backend Testing using (Unix/Linux)

Working exposer to API Testing using Postman Tool

Requirements

• Basic understanding of need of Software Testing in IT industry
• Basic understanding about Role of Software Tester / QA professional

Description

Software Testing Course: course includes Software Manual Testing (Basics & Advanced) concepts + Practical understanding of JIRA for Bug and Task Management + Agile Methodology, Database Testing( SQL) + Basics of API testing in very simple language and decent pace.

Here you are going to get all mandatory sections which are required to become a expert Software Tester. 

Here you will also going to get basic information of mobile application manual testing, database testing, api testing, agile concepts and interview questions.

This software testing QA training course is designed by experts working professionals having 20+ yrs industry experience in a way that, it will progress from introducing you to the basics of software testing to advanced topics creating a test plan, Agile model, along with introduction and familiarity with Automation testing and test management tools JIRA and Postman.

Manual Testing Coverage:

• Different types of Software Testing ( Functional, Performance)
• Agile- Scrum Model (Real time usage and implementation)
• Functional and Performance Testing.
• Test Case Designing with real-time scenario.
• Realtime Project Implementation.
• Testing Best Practices.
• Bug Life Cycles in different scenario

JIRA : For Bug Tracking & Task Management

• JIRA Setup for Practice for 7days
• Bug Reporting by a Tester and end to end cycle.Task Management
• End to End Bug Life Cycle in JIRA

Database Testing using SQL

• Setup Database for Practice
• Write Basic Select Queries
• Write Advance Select Queries
• Joins, Conditions, Grouping
• How to use SQL for Database Testing
• API Testing using Postman
• What is API, Different types of API
• Setup postman for REST API testing
• Test GET | POST | PUT | DELETE Operations
• Practice Sets

Who this course is for:

• Freshers/Professionals looking opportunity in Software testing
• BA/ Support or Other IT Professionals looking to start career as Software Tester

Show less

Course content

1 section • 5 lectures • 43m total length

Introduction & Environment Setup5 lectures • 44min

• Introduction to Software Testing08:56
• Types of Applications09:02
• Levels of Testing06:58
• Different Types of Mandatory Testing04:12
• Bug Life Cycle14:45

Python databses programming using MySQL

Requirements

• Python Data Types, Control Structures, Loops, etc.
• SQL Basics.

Description

MySQL is one of the most popular database management systems (DBMSs) on the market today. It ranked second only to the Oracle DBMS in this year’s DB-Engines Ranking. As most software applications need to interact with data in some form, programming languages like Python provide tools for storing and accessing these data sources.

Using the techniques discussed in this course, you’ll be able to efficiently integrate a MySQL database with a Python application. You’ll develop a small MySQL database for a movie rating system and learn how to query it directly from your Python code.

By the end of this course, you’ll be able to:

• Identify unique features of MySQL
• Connect your application to a MySQL database
• Query the database to fetch required data
• Handle exceptions that occur while accessing the database
• Use best practices while building database applications

To get the most out of this course, you should have a working knowledge of Python concepts like for loops, functions, exception handling, and installing Python packages using pip. You should also have a basic understanding of relational database management systems and SQL queries like SELECT, DROP, CREATE, and JOIN.

SQL stands for Structured Query Language and is a widely used programming language for managing relational databases. You may have heard of the different flavors of SQL-based DBMSs. The most popular ones include MySQL, PostgreSQL, SQLite, and SQL Server. All of these databases are compliant with the SQL standards but with varying degrees of compliance.

Being open source since its inception in 1995, MySQL quickly became a market leader among SQL solutions. MySQL is also a part of the Oracle ecosystem. While its core functionality is completely free, there are some paid add-ons as well. Currently, MySQL is

Who this course is for:

• Beginner Python Developers

Course content

11 sections • 15 lectures • 1h 16m total length

An intro Course illustrating SQL equivalents in Python

Requirements

• Basic Knowledge of Python

Description

Overview

In this course you will learn how to use the Python Pandas library to achieve the core SQL functionality listed below.

If you are ready to make the leap from SQL to Python, this course will help you through your adoption and increased usage of Python for data manipulation, transformation and ultimately data analysis.

Understanding how to achieve SQL data manipulation features in Python will serve as your foundation for using Python for advanced analysts, data science and other machine learning tasks. 

Prerequisites

This course is recommended for anyone who is comfortable with SQL and would like to increase their adoption of Python for their day to day. It’s also recommended that you have a base understanding of Python or some familiarity of any programming language in order to get the most of this course. Other prerequisites will be outlined in the Introduction video, but having the following set up on your computer ahead of time will allow you to dive right in.

• Python 3.7 or above installed
• pandas library installed (pip install pandas)
• IDE (e.g. PyCharm, VS Code)
• Git (optional, for cloning repo with code examples)

Core Concepts taught in this course

Core SQL Concepts translated to Python Pandas code are:

• SQL Limit
• SQL Distinct
• SQL Where
• SQL WHERE / AND (Multiple Predicates)
• SQL IN ( )
• SQL NOT IN ( )
• SQL Aggregate Functions
  • SQL MIN
  • SQL MAX
  • SQL COUNT
  • SQL COUNT DISTINCT
  • SQL AVERAGE / MEAN
• Mode (Not usually available in most SQL databases)
• SQL Group by Aggregates
• SQL Row Number over (partition by / order by)
• SQL Case Statements
• SQL Joins

Thank you for enrolling in this course! Enjoy!

Who this course is for:

• Data Analysts
• Data Scientists new to Python
• Business Intelligence Analysts

Course content

3 sections • 20 lectures • 43m total length

Know python statements required to connect with MySQL database for an application

Requirements

• MySQL and Python Basics

Description

MySQL Database Connectivity using Python course is designed for developer who are working on Database Projects where the concept of front end and back end is used many times for developing an application.

Outcomes of the course are

Participants will be able to

●Know python statements required to connect with MySQL database

●Create simple application of python – database connectivity

●Prerequisite : MySQL basics, Python basics

In this course Concept explanation video will be followed by hands on session /demonstration of all the concept of MySQL Database Connectivity using Python

.Tools used for this course are XAMPP server having MySQL database creation facility and Anaconda Navigator with Jupyeter Notebook for python code demonstration. Both tools/softwares are Free and Open source and Popular also

Contents are

In First and Second Section we cover for prerequisite, that is demonstration of MySQL with its tool and Python basics with Jupyeter Notebook and other tools which are available

●What is Relational database?

In this session participants will get information about Relational database and SQL queries

●MySQL connector module

In this session participants will get information about MySQL connector module required for connectivity

●connect method and cursor object

In this session participants will get information about connect method of MySQL connector module and cursor object for execution queries

●Code in Python to

a)Create Database

a)Create table

b)Insert Values

c)Display values

d)Alter table

e)Update/Delete rows

These sections are for explaining and demonstrating all SQL queries which can be executed in Python code. That is concept of front end and back end.

●Create simple application of python – database connectivity

Who this course is for:

• Beginner for Python developer and Database Application developer
• Beginner for Python application developer

Course content