MySQL for Beginners_1

MySQL for Beginners, available at $19.99, with 24 lectures, 17 quizzes, and has 1 subscribers.

You will learn about Work with MySQL Workbench and Command Line Use MySQL DBMS statements Avoid Common Database Design Mistakes Use SQL to analyze data Prepare for the interview This course is ideal for individuals who are software developers or administrators or testers or data analysts It is particularly useful for software developers or administrators or testers or data analysts.

Enroll now: MySQL for Beginners

Summary

Title: MySQL for Beginners

Price: $19.99

Number of Lectures: 24

Number of Quizzes: 17

Number of Published Lectures: 24

Number of Published Quizzes: 17

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Work with MySQL Workbench and Command Line

Use MySQL DBMS statements

Avoid Common Database Design Mistakes

Use SQL to analyze data

Prepare for the interview

Who Should Attend

software developers

administrators

testers

data analysts

Target Audiences

software developers

administrators

testers

data analysts

The course does not require the purchase of additional licenses – all software used in the course is free. The course covers the fundamentals of the SQL language for relational databases. The world is full of information, and the ability to store and interact with it in a structured way is an extremely important skill.

The training program is designed in the most convenient way for the assimilation of the material presented. Consistently with each lesson, the complexity and volume of the covered material will increase. But this will not become an obstacle for you on the way to achieving your goals, right?

The target audience is aspiring software developers, testers, data analysts and administrators.

The course is aimed at the practical use of the full range of tools provided. You can consolidate the information provided by completing homework and test questions. The basis for confident progress will be laid by a theory tested by several sources.

The motivation for creating the course was the desire to combine the most important aspects necessary for understanding in one place, which will significantly save you a lot of time, and therefore money.

Together we will analyze the most common interview questions and prepare for answers to the most tricky of them.

The bonus will be the connection of the database we created to the project in Inteliji Idea by using Java Database Connectivity. You will be proud to note the knowledge of MySQL and JDBC DBMS in your resume.

Start improving your skills right now. Welcome to the MySQL for Dummies course!

Course Curriculum

Chapter 1: Introduction. SQL language overview

Lecture 1: About course

Lecture 2: The Types of Databases. Database managment system (DBMS)

Lecture 3: SQL: group of statements, tables and its structure.

Chapter 2: MySQL Installation Guide

Lecture 1: Installing MySQL on Microsoft Windows

Chapter 3: Data Types and Keywords

Lecture 1: MySQL Data Types

Lecture 2: Keywords and Reserved Words in MySQL

Chapter 4: Owerview Command Line and Workbench

Lecture 1: Using MySQL from Command Line

Lecture 2: Using MySQL from MySQL Workbench

Chapter 5: Primary and Foreign Key. Relationships between tables.

Lecture 1: Primary and Foreign Key Constraints

Lecture 2: Database Relationships in MySQL with Examples

Chapter 6: Attributes and Comments

Lecture 1: Attributes of fields

Lecture 2: Comments

Chapter 7: Queries with SELECT statement

Lecture 1: AND/OR/IN/NOT INT/BETWEEN/GROUP BY/ORDER BY/WHERE

Lecture 2: MySQL Aggregate Functions

Lecture 3: MySQL Subquery

Lecture 4: ALTER TABLE Statement

Lecture 5: MySQL Branch statements

Lecture 6: Working with strings in MySQL

Lecture 7: Working with numeric data in MySQL

Lecture 8: Working with dates and times in MySQL

Lecture 9: Working with NULL values in MySQL

Lecture 10: LIMIT, HAVING, LIKE

Chapter 8: Join Tables: How-To with Example

Lecture 1: INNER, CROSS, LEFT, RIGHT, FULL, NATURAL

Chapter 9: MySQL Variables

Lecture 1: What is Variable and example of usage

Instructors

Karpovych Vladyslav
Java Developer

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 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!