SQL Mastery: Learn Enough SQL To Be A Professional [2023]

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

Learn all the SQL skills you need to know to develop, manipulate, manage and communicate with relational databases

1. Introduction

1. Course Intro

2. Database Overview

3. Tools and Work Environment illustration

4. Work Environment hands-on

5. DBMS & RDBMS Overview

2. The Basics of SQL

1. SQL Queries

2. Select Statement

3. Hands-On Select an existing table

4. Hands-On Select a particular column

5. Hands-On Select number of columns

6. Select Distinct

7. Hands-On Select Distinct and count unique rec

8. Where Statement

9. Hands-On Where and filtering records

10. Add Some Logic for conditions

11. Hands-On Logics for conditions

12. Aliases

13. Hands-On Aliases and renaming columns

14. Limitations

15. Hands-On Limitations by examples

16. Inserting Data

17. Hands-On Inserting records with column names

18. Hands-On Inserting values for all columns

19. Hands-On Inserting data for specified columns

20. Hands-On Inserting many records

21. Updating data

22. Hands-On Updating data by examples

23. Hands-On Updating all records

24. Deleting Data

25. Hands-On Deleting records by examples

26. Comments

27. Hands-On Types of Comments

28. SQL Operators

29. Hands-On SQL Arithmetic Operators

30. Hands-On SQL Comparators

31.1 work files.zip

31. Hands-On SQL BETWEEN and IN Operators

3. SQL Constraints & Data Types

1. Data Types

2. Hands-On Data Types by example

3. Adding Constraints

4.1 work files.zip

4. Hands-On Constraints by examples

4. Creating DB and Tables

1. Creating DB and Tables

2. Hands-On Creating Tables by examples

3. Hands-On Creating Tables from tables

4. Dropping DB and Tables

5. Hands-On Dropping Tables

6. Alter tables

7.1 work files.zip

7. Hands-On Alter table by examples

5. Data Sorting and Conditions

1. Orders

2. Hands-On Order by

3. Union

4. Hands-On Union and Union All

5. Any and All

6. Using Any Operator Hands-On

7. SELECT ALL example 1 Hands-On

8. ALL with two tables example 2 Hands-On

9. Group By

10. Hands-On Group By

11. Having clause

12. Use Having clause to filter data Hands-On

13. Wildcards

14. Hands-On Like and Wildcards

15. Case Statement

16.1 work files.zip

16. Performing tasks with Case Clause Hands-On

6. Functional Programming in SQL

1. The concept of function

2. Aggregate functions

3. Scalar functions

4.1 work files.zip

4. SQL Functions examples hands-on

7. SQL Joins

1. Joins overview

2. Inner Join

3. Inner Join hands-on

4. Left Join

5. Left Join hands-on

6. Right Join

7. Right Join hands-on

8. Full Outer Join

9.1 work files.zip

9. Full Outer Join hands-on

8. More Learning and Applying

1. Views in detail hands-on

2. SQL Project

3.1 work files.zip

3. SQL Project Solution Hints

139,000 تومان

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

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

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

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