SQL Bootcamp Hands-On Exercises — Learn SQL by Coding (2023)

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

Learn SQL by Coding. Learn SQL with Quizzes, Exercises and Real-World Examples.

1 - Relational vs NonRelational Database

1 - Relational vs NoSQL Databases

1 - Relational vs NonRelational.html

1 - nosql database what is nosql.zip

2 - SQL Fundamentals

2 - SQL Query Block

3 - SQL Command Categories

3 - CREATE DATABASE

4 - What is a database

4 - SQL CREATE TABLE Statement

4 - Create temporary table using SELECT INTO statement.html

5 - Create Global Temporary Table.html

5 - SQL Create Table

6 - Solution Create Temporary Table

6 - create-temporary-table.zip

5 - Add Data SQL INSERT INTO Statement

7 - Add data into a table

7 - SQL DML Commands.html

8 - 3-insert-into-patient.zip

8 - Solution SQL INSERT INTO

6 - Query Data SQL SELECT Statement

9 - SQL SELECT

10 - Solution 3 SQL TOP and MySQL LIMIT

7 - Filter Data SQL WHERE

11 - Solution

12 - Solution

13 - Solution

8 - SQL TRUNCATE

9 - SELECT DISTINCT Statement

14 - Solution DISTINCT

10 - SQL CONCAT Function

15 - Solution SQL CONCAT

11 - Filter Data SQL IN Operator

16 - Solution SQL IN

17 - Solution SQL IN

12 - Filter Data SQL NOT IN Operator

18 - Solution SQL NOT IN

13 - Filter Data SQL LIKE Operator

19 - Solution SQL LIKE Operator and Solutions

14 - Sort Data ORDER BY Clause

20 - Order By Solution

15 - Group Data GROUP BY Clause

21 - Solution SQL GROUP BY

16 - Group Data SQL GROUP BY HAVING Clauses

22 - Solution Having Clause

17 - Group Data Aggregate Functions

23 - COUNT AVG MIN MAX and SUM

24 - SQL GROUP Functions and Solutions

18 - SQL Logical Operators

25 - SQL AND OR NOT Logical Operators

19 - SQL Between Operator

26 - SQL Between and NOT Between Logical Operator

20 - SQL Wildcards

27 - SQL Wildcards Explained

21 - IS NULL and NOT NULL Operators

28 - SQL IS NULL and IS NOT NULL

22 - SQL ALIASES

29 - SQL ALIAS

23 - SQL JOINS

30 - SQL JOINS

31 - SQL JOIN LEFT JOIN RIGHT JOIN and UNION Solutions

24 - SQL VIEWS

32 - CREATE VIEW DROP VIEW and RENAME VIEW

25 - Stored Procedures

9 - Stored Procedure.html

26 - Install SQL Server on Docker Optional

33 - Install SQL Server on Docker Optional

33 - Udemy-How-To-Install-SQL-Server-on-Docker.pdf

33 - sql server installation guide.zip

139,000 تومان

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

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

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

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