Fundamentals of MySQL: A Foundational Guide

Fundamentals of MySQL: A Foundational Guide, available at $19.99, has an average rating of 4.35, with 44 lectures, based on 12 reviews, and has 1919 subscribers.

You will learn about Learn the fundamentals of MySQL Learn how to use SQL with Python together Writing queries Creating and updating databases and tables Data types in MySQL Using MySQL built-in functions Working with string and mathematical functions Designing Databases This course is ideal for individuals who are Programmers or Developers It is particularly useful for Programmers or Developers.

Enroll now: Fundamentals of MySQL: A Foundational Guide

Summary

Title: Fundamentals of MySQL: A Foundational Guide

Price: $19.99

Average Rating: 4.35

Number of Lectures: 44

Number of Published Lectures: 28

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 28

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the fundamentals of MySQL
Learn how to use SQL with Python together
Writing queries
Creating and updating databases and tables
Data types in MySQL
Using MySQL built-in functions
Working with string and mathematical functions
Designing Databases

Who Should Attend

Programmers
Developers

Target Audiences

Programmers
Developers

Unlock the power of MySQL, a cornerstone in database management systems for small- to medium-sized web projects. Join us in this comprehensive course, where you’ll embark on a journey through clear and concise tutorials, empowering you to create and manage your own MySQL database.

We’ll start off exploring database fundamentals, as well as MySQL features. Students will learn the basics of MySQL that guide you through creating and maintaining a MySQL database of your own. We’ll explores the basic syntax, using SQL statements to insert, update, and delete data from your tables.

We’ll also cover creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. In addition, you will learn about the key differences between standard SQL and SQL as implemented by MySQL.

Dive into the fundamentals as we explore the basic syntax of MySQL, mastering the art of using SQL statements to seamlessly insert, update, and delete data from your tables. Take command of your database by learning to create one from scratch, and gain proficiency in handling data types, operators, and leveraging string and mathematical functions for efficient data manipulation.

Navigate the intricacies of MySQL with ease as we highlight the key differences between standard SQL and MySQL’s unique implementation. Whether you’re a beginner seeking a solid foundation or an intermediate user aiming to refine your skills, this course equips you with the knowledge and practical insights needed to harness the full potential of MySQL for your web projects. Join us and elevate your database management expertise!

Course Curriculum

Chapter 1: SQL Overview

Lecture 1: Introduction

Lecture 2: Overview of SQL

Lecture 3: Database organization

Lecture 4: Row and Columns

Lecture 5: Data: Inserting, Updating and Deleting

Lecture 6: Joining queries across tables

Lecture 7: Data types

Lecture 8: The CREATE TABLE statement

Lecture 9: Numeric types

Lecture 10: Date and time types

Lecture 11: String & Enumeration types and SERIAL type alias

Lecture 12: Comparison, Logical and Arithmetic Operators

Lecture 13: Operator precedence

Lecture 14: The CASE statement and The IF function

Lecture 15: String comparisons

Lecture 16: Regular expressions and string concatenation

Lecture 17: Numeric conversions

Lecture 18: Trimming and padding

Lecture 19: Case conversion

Lecture 20: Substrings and Soundex

Lecture 21: Value functions

Lecture 22: Basic math and trigonometry

Lecture 23: Logarithms, radians and degrees

Lecture 24: String contactenation

Lecture 25: Quote marks

Lecture 26: Integer division

Lecture 27: Comments

Lecture 28: Conclusion

Instructors

Flow Learning
Programmer & Microsoft Educators

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 0 votes
5 stars: 8 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