One Month SQL

سرفصل های دوره

Go from a Beginner to Intermediate in SQL & Databases

1 - Section 1 Week 1 Learn SQL in One Month

1 - Step 1 Welcome to Learn SQL at One Month

2 - Step 2 How Does SQL Work With a LAMP PHP or Python Tech Stack

3 - Step 3 6 Reasons to Learn SQL

4 - Step 4 What is SQL

5 - Step 5 Getting Setup With a SQL Database

6 - Step 6 How to Set Up Web Hosting and a MYSQL Database

7 - Step 7 How to Use cPanel

8 - Step 8 How to Create a New Database

2 - Section 2 WEEK 2 Basic SQL Commands

9 - Step 2 How to IMPORT Data into a Database

10 - One-Month-SQL-Files.zip

10 - Step 1 Download Course Files.html

11 - Step 3 How to EXPORT Data from a Database

12 - Step 4 SQL SELECT Statements

13 - Step 5 Using a SELECT Statement on Big Data

14 - Step 6 SQL SELECT LIMIT

15 - Step 7 SQL WHERE

16 - Step 8 SQL LIKE

17 - Step 9 AGGREGATE OPERATORS in SQL

18 - Step 11 SQL Code Quiz

19 - Step 10 How PHP and Python Scripts Use SQL

20 - Step 12 Answers to the SQL Code Quiz

21 - Step 13 SQL INSERT INTO

22 - Step 14 SQL UPDATE Statement

23 - Step 15 SQL DELETE Statement

24 - Step 16 CRUD Examples

3 - Section 3 WEEK 3 Intermediate SQL Commands

25 - Step 1 How to Create a New Table with SQL CREATE TABLE

26 - Step 2 Building a Facebook Users Table

27 - Step 3 SQL Structure Command

28 - Step 4 Data Types in SQL

29 - Step 5 SQL Join

30 - Step 6 SQL Join Part II

31 - Step 8 Assignment 1 JOIN our Comments Table

32 - Step 7 AS in SQL

33 - Step 9 Answer 1 JOIN our Comments Table

34 - Step 10 Assignment 2 A New Table for our ECommerce Store

35 - Step 11 Answer 2 A New Table for our ECommerce Store

36 - Step 12 Assignment 3 Display Zero Comments Make Chris Cry

37 - Step 13 Answer 3 Display Zero Comments

4 - Section 4 WEEK 4 Advanced SQL Commands

38 - Step 1 FULL OUTER JOIN

39 - Step 2 UNION Statement

40 - Step 3 GROUP BY

41 - Step 4 Subquery and IN

42 - Step 5 Truncate vs Drop

43 - Step 6 What to do next with your new Superpowers

5 - Section 5 Extra Tutorials

44 - Step 2 How to Install MAMP Mac or Windows

45 - Step 3 MySQL with MAMP

46 - Step 4 MAMP as a Server

47 - Step 1 Why Do We Need a Server

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy