MySQL Database : Learn SQL Step By Step
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
399 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL Database : Learn SQL Step By Step to your Wishlist.

Add to Wishlist

MySQL Database : Learn SQL Step By Step

With 200 practical problems
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
399 students enrolled
Created by Testing World
Last updated 1/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Ready to work in Database Testing
  • Ready to apply database skills in realtime project
View Curriculum
Requirements
  • Basic understanding of database
  • Basic understanding of english language
Description

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application

This course is specially designed for newbies who want to start career in Database

This Course covers

1.  Setup and Installation

2.  Database related queries

3.  All type Select Queries

4.  Sorting and Grouping

5.  Group Functions

6.  Joins

7.  Delete commands

8.  Sub queries

9.  Advance Queries

10. Interview Questions

Who is the target audience?
  • Freshers looking opportunity in IT
  • Software Testers looking Opportunity in Database Testing
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:26:31
+
Introduction and Setup
7 Lectures 20:04


Office Table
00:28

Empoyees Table
00:32

Customer Table
03:59


MySQL Structure
01:36
+
Database Commands
6 Lectures 09:23
Show all available Databases
01:35

Create new Database
01:38

Delete Databasse
01:32

Show Selected Database
01:04

Switch to different database
02:10

Show database table Structure
01:24
+
Select Data from Table - Basic Queries
8 Lectures 33:23
Select All data from Table
01:40

Select few columns from table
02:29

Select Column with Alias
04:01

Select data with Concatenation
07:10

Select Unique data from table
03:14

Select Data with Group Functions -Min | Max | Avg | Sum | Count
05:52

Data Sorting - One Column
04:25

Data Sorting - Multiple Columns
04:32
+
Filter Data
5 Lectures 23:47
Select Data with Where clause
06:06

Select Data | Filter with Logical OR
03:47

Select Data | Filter with Logical AND
03:57

Select Data | Filter in a List
06:35

Select Data | Filter in Range | Between Keyword
03:22
About the Instructor
Testing World
4.0 Average rating
1,895 Reviews
16,672 Students
48 Courses
Director of Testing World

Handling Testing World Operations

Involve in Testing Course Video update and management

Handling online and Face to face classes of Testing World

Masters In Computer Science

Expertise in manual testing & Automation testing using Selenium, QTP, LoadRunner, Jmeter and Mobile Automation

Found of Testing World

Trained more than 4000 students online 

Actively involved in corporate training