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