SQL for Beginners: Learn SQL using MySQL and Database Design
- Offered byUDEMY
SQL for Beginners: Learn SQL using MySQL and Database Design at UDEMY Overview
Duration | 8 hours |
Total fee | ₹360 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
SQL for Beginners: Learn SQL using MySQL and Database Design at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Get full lifetime access of the course material
- Learn from 29 downloadable resources
SQL for Beginners: Learn SQL using MySQL and Database Design at UDEMY Course details
- For anyone who wants to learn how to use SQL and MySQL
- Creating, Modifying and Deleting Tables in a Database (DDL)
- Inserting, Updating and Deleting Data from Tables (DML)
- Select Queries
- Joins
- Aggregate Functions
- Subqueries
- The database design section isn't covered in the majority of SQL courses on Udemy
- This section alone, will give students a huge edge over other applicants for jobs
- Through the course they will go through creating an example database for a cinema online booking system using concepts taught in the database design section
- Become skilled as a database developer generally needs you to learn SQL, a database, and then database design
SQL for Beginners: Learn SQL using MySQL and Database Design at UDEMY Curriculum
Course Introduction
Installation and Setup
Section Introduction
Databases, SQL and MySQL
Relational Database Management System
Data Definition Language
Primary and Foreign Keys
Creating the Coffee Store Database
Modifying Tables: Adding and Removing Columns
Deleting Tables
Truncating Tables
More On Alter Table
Primary and Foreign Keys
Creating the Coffee Store Database
Modifying Tables: Adding and Removing Columns
Deleting Tables
Truncating Tables
Data Manipulation Language
Selecting from a Table
Section Introduction
Updating Data in Tables
Deleting Data from Tables
Completing the Coffee Store Database
Selecting From Multiple Tables
Using Inequality Symbols
Null Values
Exercise 1
Solution 1
In, Not In
Between
Database Design