SQL: Master SQL With PhpMyAdmin and MYSQL Engine
Overview
Course Description
In this fantastic course you will learn the SQL query language for the MySQL Engine. We will install MySQL with PhpMyAdmin to make learning as easy as possible. This course will teach you all about database relationships, creating tables, selecting data, inserting data, updating data, deleting data, subqueries and joining multiple tables together. Taught by a professional freelance software engineer with a 1st class bachelors degree in Computer Science and over 13 years experience you cannot go wrong with this course! By the end of this course you will understand SQL very well and should have no trouble passing your university level assignments
What you'll learn
Requirements
No course requirements
Who this course is for
Course Content
- Lecture 1 - Introduction 02:14 Preview
- Lecture 2 - Installing Mysql and PHPMyAdmin 06:25 Preview
- Lecture 3 - Understanding The Database Internals 05:01 Preview
- Lecture 4 - Learn To Create Database Tables Along With Inserting Data Into Them With Sql 12:44
- Lecture 5 - Selecting And Retrieving Data From The Database With Sql 07:33
- Lecture 6 - Updating The Records In The Database With Sql 04:54
- Lecture 7 - Creating A Medical Database 10:40
- Lecture 8 - Relationships In A Database 04:43
- Lecture 9 - Joining Data And Tables In Sql 12:54
- Lecture 10 - Ordering Data In Sql 02:55
- Lecture 11 - Deleting Database Records In Sql 02:18
- Lecture 12 - Subqueries In Sql 06:33
- Lecture 13 - Conclusion 00:33
About the instructor
- 4.85 Instructor Rating
- 10 Reviews
- 344 Students
- 13 Courses
Daniel McCarthy
Dragon Zap Instructor
I am a software engineer that has been programming for 14+ years. My experience is vast and covers web development all the way to compiler and interpreter development. I have also developed bootloaders and kernels that can boot from the FAT(File Allocation Table) filesystem.I have developed two programming languages of my own. One is called Craft language. The other is called Marble which is a web language like PHP. I am currently developing a C compiler.
I have experience in the following programming languages: C, C++, Java, x86 Assembly language, PHP, HTML5, JAVASCRIPT, CSS, Craft, Marble
I also have programmed Linux kernel modules professionally in the workplace.
These days I am focused on providing my years of expertise to students to help them grow as professional software engineers.
Student feedback
- Stars 5
- Stars 4
- Stars 3
- Stars 2
- Stars 1
0.00
Course Rating
Reviews
Rate This Course
What would you rate this course?
-
Related Courses
Not sure?
Every course comes with a 30-day money-back guarantee