MySQL: An Introduction For Beginners

MySQL: An Introduction For Beginners, available at $19.99, has an average rating of 4, with 54 lectures, based on 3 reviews, and has 688 subscribers.

You will learn about Install MySQL Create new MySQL Connection Use MySQL Workbench Create Database Create Table Manage Server Connections Check Server Status Update Database Records Delete Database Records Query Database Set Default Database INSERT data into database Perform Table Joins Administer users and priviledges Use Aggregate Functions Use Various Operators This course is ideal for individuals who are Beginners to MySQL or Anyone who wants to learn something new It is particularly useful for Beginners to MySQL or Anyone who wants to learn something new.

Enroll now: MySQL: An Introduction For Beginners

Summary

Title: MySQL: An Introduction For Beginners

Price: $19.99

Average Rating: 4

Number of Lectures: 54

Number of Published Lectures: 54

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Install MySQL
Create new MySQL Connection
Use MySQL Workbench
Create Database
Create Table
Manage Server Connections
Check Server Status
Update Database Records
Delete Database Records
Query Database
Set Default Database
INSERT data into database
Perform Table Joins
Administer users and priviledges
Use Aggregate Functions
Use Various Operators

Who Should Attend

Beginners to MySQL
Anyone who wants to learn something new

Target Audiences

Beginners to MySQL
Anyone who wants to learn something new

MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.

The MySQL is the world’s most popular open source database.

The MySQL relational database is used to store data that can be manipulated using queries. It is used a lot in web development and other areas. In this course we are only covering the basics which should enable you write your own queries to get data from a database.

MySQL is currently owned and supported by the database giant Oracle. There is a commercial licensed version of MySQL that can be purchased that comes with premium support MySQL is a popular ,reliable and scalable relational database management system that is used by lots of companies and establishments all over the world. For example the social networking site Pinterest and The Space company Nasa just to mention a couple. In this basic beginners course, we’ll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.

Here is what you will learn:

MySQL Installation

MySQL Data Types.

Basic CRUD Operations

MySQL Access Privileges

MySQL Table Joins

Aggregate Functions

MySQL Clauses

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modelling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.

Course Curriculum

Chapter 1: Getting Started with MySQL

Lecture 1: Introduction

Lecture 2: What is MySQL

Lecture 3: MySQL Installation ( Windows )

Lecture 4: MySQL Installation ( Macs )

Lecture 5: Some Database Concepts

Lecture 6: MySQL Data Types

Lecture 7: What is MySQL Workbench

Lecture 8: MySQL Workbench Home Screen

Lecture 9: Creating a new MySQL Connecction

Lecture 10: Managing Server Connections

Lecture 11: Checking Server Status

Chapter 2: Basic C R U D ( Create|Read |Update|Delete) Operations

Lecture 1: MySQL Naming Convention

Lecture 2: Creating MySQL Database

Lecture 3: Creating MySQL Table

Lecture 4: Using Primary Keys

Lecture 5: Using Foreign Keys

Lecture 6: Setting Default Database

Lecture 7: INSERT Data

Lecture 8: Reading Data with SELECT Statement

Lecture 9: UPDATE Records

Lecture 10: DELETE Records

Chapter 3: Some Keywords and Clauses

Lecture 1: DISTINCT Keyword

Lecture 2: GROUP BY Clause

Lecture 3: HAVING Clause

Lecture 4: ORDER BY Clause

Lecture 5: WHERE Clause

Lecture 6: LIMIT Clause

Chapter 4: MySQL Access Privilege System

Lecture 1: What is MySQL Access Priviledge

Lecture 2: Static and Dynamic Priviledges

Lecture 3: Applying dynamic priviledges

Lecture 4: Migrating SUPER priviledges

Lecture 5: Administration of Users and Privileges

Chapter 5: MySQL Table Joins

Lecture 1: INNER JOIN

Lecture 2: LEFT JOIN

Lecture 3: RIGHT JOIN

Lecture 4: SELF JOIN

Chapter 6: Introduction to Aggregate Functions

Lecture 1: Introduction to Aggregate Functions

Lecture 2: COUNT Aggregate Functions

Lecture 3: SUM Aggregate Functions

Lecture 4: MIN Aggregate Functions

Lecture 5: MAX Aggregate Functions

Chapter 7: Some MySQL Operators

Lecture 1: BETWEEN Operator

Lecture 2: IN Operator

Lecture 3: LIKE Operator

Lecture 4: UNION Operator

Chapter 8: Data Modeling

Lecture 1: Introduction to data modelling

Lecture 2: Creating a model: Part 1

Lecture 3: Creating a model: Part 2

Lecture 4: Basic Data Modelling

Lecture 5: Thank You

Chapter 9: Performance Optimization and Indexing

Lecture 1: Understanding Query Optimization Techniques

Lecture 2: Analyzing Query Execution Plans

Lecture 3: Creating Indexes for Performance Improvement

Lecture 4: Optimizing SQL Queries for Better Performance

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 2 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu