SQL for Beginners: Learn SQL using MySQL and Database Design

About Course
Discover the Power of SQL & Databases: A Comprehensive Guide for Aspiring Tech-Savvies!
Are You a Student or Professional Eager to Master SQL?
Embarking on a journey into the realm of databases? Yearning to grasp the intricacies of SQL and databases, but unsure where to kick things off? Whether you’re a budding developer, a data enthusiast, or simply someone aiming to amplify your career horizons, understanding SQL and databases is your stepping stone.
Why This Course Stands Out
- Dive Deep into SQL & MySQL: Unlock the secrets of SQL and MySQL – the powerhouse among global databases.
- Master Database Design & Analysis: Most courses barely scratch the surface; we offer you an immersive dive into database design, a critical skill often overlooked.
- Real-world Applications: Engage with a hands-on project – setting up an online cinema booking database, offering you practical exposure to concepts learned.
Core Modules Include:
- SQL Basics: The language that’s reshaping the tech landscape.
- MySQL In-Depth: One of the world’s most renowned databases.
- Database Design & Data Analysis: Equip yourself with these sought-after skills.
- Hands-on Tutorials: From creating to modifying databases, we’ve got you covered.
- Cross-Platform Installation Guides: Be it Windows, Mac, or Linux, we’ve got your back.
What Will You Learn?
- Have a detailed knowledge and understanding of using MySQL, one of the most widely used databases in the world.
- Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
- In-depth knowledge of database design will give students an edge over other applicants.
Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
1. Course Introduction
2. Installation and Setup
- 00:41
- 03:08
- 02:18
- 15:00
- 12:17
- 11:07
- 13:13
- 03:24
3. Data Definition Language
4. More On Alter Table
- 01:26
- 05:30
- 05:25
- 04:56
- 03:25
- 03:15
- 04:44
- 01:30
- 08:27
5. Data Manipulation Language
6. Selecting from a Table
- 01:14
- 01:46
- 04:53
- 03:03
- 03:10
- 01:06
- 03:55
- 03:44
- 04:04
- 04:52
- 06:19
- 00:55
- 04:23
- 05:11
- 02:56
- 02:03
- 00:50
- 03:45
7. Selecting From Multiple Tables
- 01:08
- 03:08
- 08:55
- 05:23
- 03:15
- 04:33
- 01:06
- 05:55
8. Database Design
- 01:23
- 05:23
- 03:30
- 06:27
- 09:30
- 01:05
- 02:30
- 02:01
- 04:00
- 03:53
9. Creating a Cinema Booking System Database
- 01:11
- 07:26
- 04:55
- 02:53
- 02:19
- 04:45
- 03:53
- 03:52
- 04:35
- 05:22
10. Aggregate Functions
- 00:41
- 02:30
- 02:38
- 02:36
- 02:39
- 02:09
- 00:46
- 04:09
- 08:52
- 01:44
- 00:44
- 04:11
11. Subqueries
- 00:32
- 04:11
- 05:11
- 05:48
- 04:41
- 01:19
- 06:59
12. MySQL Functions – String Functions and Date Functions
- 01:08
- 01:46
- 06:49
- 08:09
- 03:50
- 01:12
- 09:52
- 07:30
- 04:37
- 03:11
- 01:07
- 04:08
- 09:52
13. Challenges
- 00:56
- 00:27
- 01:51
- 00:22
- 04:34
- 00:26
- 03:31
- 00:26
- 04:08
- 00:37
- 07:20
- 00:38
- 03:55