From the course: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Dialect nuances in MySQL - SQL Tutorial
From the course: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud
Dialect nuances in MySQL
- [Amata] Now, we're going to review some fundamentals of using SQL. We're going to look at CRUD statements which is create, read, update, and delete. We are doing this in MySQL even though this is something you can do in every database. Once again, MySQL was built for simplicity and speed unless you are planning to do advanced query work in your database, the loss functionality may not even be that relevant. After we go over the CRUD statements, we will also go over two things that MySQL does that not all data warehouses cannot do, so Postgres can not do this thing. We're going to look at the if null statement and look at case sensitive. So now we're going to start by reviewing CRUD, which is create, read, update, delete. And again, this is a pretty basic concept in computer science. So first we're going to look at create and in order to create a SQL in MySQL, we do an insert. So we have a customer's table and we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.