SQL Crash Course For Beginners – Learn SQL with PostgreSQL

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

Stand out: Become confident using SQL in any database - for Marketers, Business Analysts, Data Scientists, Researchers

1 - Course Overview and 10 Minutes SQL

1 - Course Overview

2 - 10 Minutes SQL

2 - 10-minutes-sql.zip

3 - Udemy Tipps

2 - Database Introduction a little Terminology and Setup

1 - Database Introduction Quiz.html

4 - Databases Overview

5 - Types of Databases

6 - SQL Standard and Common Groups

7 - Installation of PostgreSQL and DBeaver

8 - Import the course files

8 - sql-with-postgresql.zip

9 - Explore the course projects

9 - SQL-course-project-list.pdf

3 - Tables and Inserting Data with CREATE INSERT

10 - CREATE a Database

11 - CREATE a Table

12 - INSERT Statement

13 - More on the INSERT Statement

4 - Query Data with SELECT WHERE ORDER LIMIT

14 - Query Overview SELECT Everything

15 - SELECT with Columns and Labels

16 - WHERE Condition

17 - DISTINCT Values

18 - NULL Values

19 - ORDER BY Clause

20 - LIMIT and OFFSET

5 - Data Types Numeric String Date Boolean

21 - Data Types Overview

22 - Numeric Data Types

23 - Character Data Types

24 - Date and Time Data Types

25 - Boolean Data Type

6 - Remove Data Objects DROP TRUNCATE

26 - DELETE Statement

27 - TRUNCATE Statement

28 - DROP Table

29 - DROP Database

7 - Modify Data Objects ALTER UPDATE

30 - Overview ALTER and UPDATE

31 - ALTER Statement

32 - UPDATE Statement

8 - Constraints for good data structure

33 - Constraints Overview

34 - DEFAULT Constraint

35 - CHECK Constraint

36 - NOT NULL Constraint

37 - UNIQUE Constraint

38 - PRIMARY KEY Constraint

39 - FOREIGN KEY Constraint

9 - Normalization How to structure a database

40 - Normalization Overview

41 - UnNormalized Form UNF and Primary Key PK

42 - From UnNormalized Form UNF to First Normal Form 1NF

43 - Second Normal Form 2NF

44 - From Second Normal Form 2NF to Third Normal Form 3NF

45 - Create Database Diagrams in DBeaver

10 - Operators for Arithmetic Comparison Logic

46 - Operators Overview

47 - Arithmetic Operators

48 - Comparison Operators

49 - Logical Operators

11 - Functions Builtin Code for Strings Numbers Conversion Dates and more

50 - Functions Overview

51 - String Functions

52 - Formatting and Conversion Functions

53 - Aggregate Functions

54 - Date and Time Functions

55 - Mathematical Functions

56 - Conditional Functions

12 - Joins Bringing 2 tables together

57 - Joins Overview

58 - Cross Join

59 - Inner Join

60 - Left Join

61 - Right Join

62 - Full Join

63 - Self Join

13 - Subqueries How to nest queries

64 - Subquery Introduction

65 - Subquery with EXISTS

66 - Subquery with IN

14 - Security The basics

67 - Create roles and users

68 - Grant and Revoke

15 - Views A way of storing queries

69 - Create and Use Views

16 - Summary Course Wrap up

70 - Congratulations and Surprise

70 - SQL-with-PostgreSQL-cheatsheet.pdf

17 - Extra Material

71 - What to Avoid.html

72 - Bonus Lecture.html

139,000 تومان

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

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

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

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