Mysql And Sql From Beginner To Advanced
A beginners' guide to MySQL queries, database design, transactions and stored procedures.
Last updated 2022-01-10 | 4.5
- Create- query and update databases
- Use triggers
- views and stored procedures
- Understand transactions and database isolation levels.
What you'll learn
* Requirements
* You will need to download and install the free MySQL Server Community Edition and the free MySQL WorkbenchDescription
This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you.
Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database.
MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.
Master Advanced MySQL Features, Starting from the Ground Up
In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures.
You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool.
By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.
Who this course is for:
- This course teaches you MySQL from the very beginning.
- No prior knowledge is required, other than basic knowledge of your computer.
- By the end of the course you will be able to use MySQL to an advanced level.
Course content
19 sections • 136 lectures
Introducing MySQL Preview 07:14
Installing MySQL and the Workbench Preview 06:20
Using the Command Line Preview 07:10
Creating Tables Preview 09:30
Multiple Columns, int and Data Types Preview 04:47
Null Values and Not Null Preview 08:25
Mysql Storage Engines and Configuration Preview 13:04
SQL Modes Preview 13:43
Deleting All the Data in a Table Preview 04:24
Primary Keys Preview 08:10
Auto Increment Preview 05:12
Narrowing Down Select Statements Preview 05:48
Exporting and Importing Data Preview 07:06
Exporting Using the Command Line Preview 05:48
Importing Using the Command Line Preview 04:31
Some Test Data Preview 03:09
Comparison Operators Preview 12:43
Logical Operators Preview 12:47
018 Exclusive Or Preview 07:46
Exercises Part 1 Preview 06:19
Solutions Part 1 Preview 13:44
Mysql Types Preview 03:14
Text Types Preview 13:01
Floating Point Types and Ints Preview 11:30
The Bit Type Preview 06:11
Bool Preview 08:48
Blobs Preview 04:48
Time, Date and Year Preview 11:23
Timestamp and Datetime Preview 08:54
Enumerations Preview 06:45
Brackets and Conditions Revisited Preview 09:47
Exercises 2 Preview 05:33
Solutions 2 Preview 08:27
The distinct keyword Preview 06:22
Counting Distinct Values Preview 06:12
Aggregate Functions Preview 05:10
Arithmetic in MySQL Preview 03:51
The Health Survey Dataset Preview 05:54
Group By Preview 09:48
Having- Restricting Groups By Aggregate Functions Preview 07:00
Exercises 3 Preview 07:57
Solutions 3 Preview 08:18
Naming Columns and Tables Preview 06:13
Foreign Keys Preview 11:57
ER Diagrams Preview 08:17
Joins and Cartesian Products Preview 10:20
Inner Joins Preview 05:47
Left and Right Outer Joins Preview 07:49
Joins on Multiple Tables Preview 05:38
Querying Chains of Tables Preview 04:39
One to Many and One to One Preview 04:48
Many to Many Preview 13:26
Joining Tables to Themselves Preview 13:21
Restrict Foreign Keys Preview 12:03
Cascade Foreign Keys Preview 14:17
Exercises 4 Preview 05:02
Solutions 4 Preview 12:05
Adding Columns Preview 04:33
Adding Foreign Keys Preview 08:22
Adding Indexes Preview 05:38
Indexes on Multiple Columns Preview 04:12
Creating Users Preview 08:35
Granting Privileges Preview 09:19
Exclusive Table Locks Preview 10:02
Shared Table Locks Preview 04:32
Using Variables Preview 06:38
Setting Variables with Selects Preview 03:34
A Select-Update Example Preview 09:29
Fixing Select-Updates with Table Locks Preview 06:43
ACID Preview 05:32
A Simple Transaction Preview 11:08
Start Transaction Preview 04:33
InnoDB Row Locking and Isolation Preview 06:59
ACID Isolation Levels Preview 09:40
Serializable and Row vs Table Locking Preview 12:11
Demonstrating the Other Isolation Levels Preview 09:53
Rolling Back to Savepoints Preview 07:58
The Account Transfer Problem Preview 08:37
Select for Update Preview 12:49
Lock in Share Mode Preview 08:31
String Functions Preview 14:07
Dates, Intervals and Queries Preview 08:29
Date Diff and Dayname Preview 04:49
Str_To_Date and Date_Format Preview 11:30
Control Flow Functions Preview 10:02
Casting Preview 06:25
Functions Exercises Preview 05:24
Functions Solution Preview 15:53
Introducing Stored Procedures Preview 02:40
Changing the Delimiter Preview 03:07
Hello World Preview 07:08
Editing Stored Procedures 2 Preview 05:35
Setting the Definer Preview 07:23
Procedure Permission Preview 06:52
Passing Parameters Preview 05:11
Multiple Parameters Preview 04:18
Select Into Variables Preview 02:44
Out Parameters Preview 05:52
Inout Parameters Preview 06:09
The If Statement Preview 06:10
Local Variables Preview 06:06
Implementing Account Withdrawal Preview 07:36
Transactional Withdrawal Preview 03:26
Errors and Warnings Preview 03:59
Handling Errors Preview 06:50
While Loops Preview 09:57
Labelled Loops Preview 09:59
Generating Random Data Preview 07:59
A Data Generating Procedure Preview 12:24
Cursors Preview 08:25
Fetching Cursor Data in a Loop Preview 11:45
The Case Expression Preview 17:14
Variable Scope and Multiple Cursors Preview 10:54
Exercises 6 Preview 10:26
Solutions 6 Preview 14:22
Introducing Triggers Preview 12:46
Validating with Triggers Preview 07:49
Triggers and Transactions Preview 15:54
Triggers Exercise Preview 02:29
Triggers Solution Preview 06:29
Functions vs Procedures Preview 05:03
User-Defined Functions Preview 11:37
Designing Databases Visually Preview 16:36
Connecting with Java Preview 14:29
Retrieving Data with Java Preview 09:14
Final Exercise Preview 02:41
Conclusion Preview 02:24
This course includes:
- 18.5 hours on-demand video
- Access on mobile and TV
- Certificate of completion
Related Courses
Recent Posts
WordPress hosting choices for 2021
Setting a professional website is not for everyone especially if you don’t belong to this field of work. Sometimes, you need to rely on other ...Read more
The Most Popular Majors In The US In Recent Years
The United States is one of the leading countries in the world, not to say the number one in the world. This country has always ...Read more
Cyber Security salary in the US (average to highest)
Cyber security is one of the most demanding professional fields today. Statistics from the New York Times show that by 2021, there will be 3.5 ...Read more
Courses designed specifically to help you improve your content writing skills
Do you feel like you can be a writer? Many people are confident that they can write, but their writing doesn’t fulfill the standards of ...Read more
Seven things to know about a career in Retail Management
Many people opt for a retail management career, as it offers great job opportunities, but not all of them succeed in this field. This field ...Read more
