Everything About MySQL Database
Everything About MySQL Database, available at $19.99, has an average rating of 3.65, with 55 lectures, based on 14 reviews, and has 118 subscribers.
You will learn about Write MySQL queries Create and updating databases and tables Use MySQL built-in functions Store and filter data Update tables with triggers Work with subselects and views Create and use a stored function This course is ideal for individuals who are If you are familiar with the terms "database" and know their purpose or If you know want to know how SQL specifically MySQL works or If you are a little familiar with database relationships and why we need them or If you would like to know how MySQL works with your programming language of choice such as PHP It is particularly useful for If you are familiar with the terms "database" and know their purpose or If you know want to know how SQL specifically MySQL works or If you are a little familiar with database relationships and why we need them or If you would like to know how MySQL works with your programming language of choice such as PHP.
Enroll now: Everything About MySQL Database
Summary
Title: Everything About MySQL Database
Price: $19.99
Average Rating: 3.65
Number of Lectures: 55
Number of Published Lectures: 55
Number of Curriculum Items: 55
Number of Published Curriculum Objects: 55
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Write MySQL queries
- Create and updating databases and tables
- Use MySQL built-in functions
- Store and filter data
- Update tables with triggers
- Work with subselects and views
- Create and use a stored function
Who Should Attend
- If you are familiar with the terms "database" and know their purpose
- If you know want to know how SQL specifically MySQL works
- If you are a little familiar with database relationships and why we need them
- If you would like to know how MySQL works with your programming language of choice such as PHP
Target Audiences
- If you are familiar with the terms "database" and know their purpose
- If you know want to know how SQL specifically MySQL works
- If you are a little familiar with database relationships and why we need them
- If you would like to know how MySQL works with your programming language of choice such as PHP
MySQL is by far the most popular database management system for small- to medium-sized web projects. Only the proprietary Oracle database and the small embeddable SQLite are more widely deployed. MySQL is named after the eldest daughter of Ulf Michael Widenius, the main author of the original version of MySQL whose daughter’s name is My.
MySQL routines the Structured Query Language also known as SQL to define, update and query the database. SQL is used on fundamentally all major relational database systems, on many platforms and in many applications. I will cover the necessary skills to use and program a database using MySQL. It is the nature of database management systems that there is marvellous divergence between how SQL is implemented in each system. Most of this course is keen on showing you how SQL is implemented by MySQL and how it can be used effectively in your database applications.
In this course, I will provide clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. We will start with the basic syntax of SQL as it’s implemented by MySQL. I will explain how to use the select statement, and how to create, update, and delete data from your tables. I’ll show you specifically where the MySQL version of SQL differs from the standard, and how to get the most out of MySQL specific dialect.
I also will explore the
- basic syntax,
- using SQL statements to
- Create
- Insert
- Update
- And delete data from your tables
- I will also cover creating a new database from scratch
- Data types
- Transactions
- Subselects
- Views
- And stored routines
Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.
I will cover creating and deleting databases, data types, transactions, sub selects, views, and stored routines. And finally, I will show you a full working CRUD application. CRUD is an acronym for Create, Read, Update and Delete. MySQL is one of the most widely deployed database management systems in the world. Understanding MySQL will serve you well in your database applications.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Welcome
Lecture 2: What is MySQL
Lecture 3: Using The Files
Lecture 4: Installation Information
Lecture 5: Setup a Package Manager
Lecture 6: Setup Working Environment
Lecture 7: Changing Time Zone for MySQL
Chapter 2: MySQL Syntax
Lecture 1: SELECT, Keyword, Expressions and Functions
Lecture 2: Row Selection
Lecture 3: Column Selection
Lecture 4: ORDER BY ASC and DESC
Lecture 5: WHERE Clause
Lecture 6: LIKE and IN Clauses
Lecture 7: REGEXP and RLIKE
Lecture 8: Using INSERT INTO to Insert Data
Lecture 9: Using UPDATE SET to Update Data
Lecture 10: DELETE and DROP
Lecture 11: Strings
Lecture 12: What is NULL?
Chapter 3: Creating Database
Lecture 1: CREATE and USE DATABASE
Lecture 2: Using Tables
Lecture 3: Using Indexes
Lecture 4: Using Constraints
Lecture 5: AUTO_INCREMENT, PRIMARY KEY and SERIAL
Lecture 6: FOREIGN KEY
Lecture 7: ALTER TABLE
Chapter 4: Data Types
Lecture 1: Data Type Introduction
Lecture 2: Numeric Types
Lecture 3: String Types
Lecture 4: DATE and TIME Types
Lecture 5: BIT
Lecture 6: BOOLEAN Types
Lecture 7: ENUM and SET
Chapter 5: Functions
Lecture 1: String Function
Lecture 2: Numeric Functions
Lecture 3: Date and Time Functions
Lecture 4: Time Zone Support
Lecture 5: DTAE_FORMAT Function
Lecture 6: Grouping Functions
Lecture 7: Conditional Function
Chapter 6: Transactions
Lecture 1: How To Use Transactions?
Lecture 2: Transactions and Performance
Chapter 7: Triggers
Lecture 1: Using TRIGGER
Lecture 2: Using TRIGGER Preventing Auto Update
Lecture 3: Triggers and Transactions
Chapter 8: Views and Subselects
Lecture 1: How To Use Subselect and SUBSTR?
Lecture 2: Searching Within a Result Set
Lecture 3: How To Create VIEWs?
Lecture 4: How To Create JOIN VIEW?
Chapter 9: Routines
Lecture 1: What Are Routines?
Lecture 2: MySQL Functions
Lecture 3: MySQL Procedures
Chapter 10: PHP Data Objects
Lecture 1: What is PDO?
Lecture 2: PDO and Prepared Statement
Lecture 3: PHP and CRUD Application
Instructors
-
Eric Azimi
Software Engineer and Web Developer
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 0 votes
- 3 stars: 3 votes
- 4 stars: 4 votes
- 5 stars: 5 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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024