This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Programming The SQL Database Programming Essentials Training 2022
Course Lectures
01. Introduction (7:47)
02. SQL Overview (1:52)
03. Installations and Setup (6:27)
04. SQL syntax theory (3:49)
05. SELECT Statement theory (2:02)
06. SELECT Statement hands-on (5:57)
07. SELECT DISTINCT Theory (1:18)
08. SELECT DISTINCT hands-on (5:03)
09. WHERE Statement theory (1:44)
010. WHERE Statement hands-on (5:35)
011. Count rows theory (1:42)
012. Count rows hands-on (5:33)
013. Insert data theory (1:43)
014. Insert data hands-on (6:42)
015. NULL OP Theory (2:03)
016. NULL and Not OP hands-on (5:50)
017. UPDATE DATA RECORDS theory (2:10)
018. UPDATE DATA RECORDS hands-on (7:01)
019. DELETE Data theory (1:46)
020. DELETE Data hands-on (5:15)
021. Operators IN - NOT IN theory (0:31)
022. Operators - IN and Not IN hands-on (3:50)
023. SQL Logical Operators theory (1:39)
024. Operators- logical op hands-on (9:44)
025. Operators - Arithmetic op hands-on (5:02)
026. Operators - Comparisons hands-on (7:23)
027. Operators- SQL BETWEEN and NOT hands-on (7:04)
028. Data Types (1:37)
029. Ordering theory (1:52)
030. Ordering and sorting hands-on (8:24)
031. LIMIT with condition hands-on (5:33)
032. Smallest and Largest Values hands-on (7:14)
033. Counting records with different ways hands-on (3:34)
034. Average of numeric columns hands-on (3:32)
035. Total sum for numerics hands-on (3:11)
036. Create DB and Tables hands-on (8:36)
037. deleting newOrders hands-on (3:45)
038. ALTER ADD OR DELETE fileds hands-on (3:14)
039. Renaming tables hands-on (3:07)
040. Constraints theory (2:29)
041. Constraints hands-on (4:01)
042. Joining tables hands-on (8:04)
043. Combining result-sets hands-on (6:31)
044. Power of Aliases hands-on (5:32)
045. Set conditions hands-on (3:54)
046. Exercise Project to put all together (1:22)
047. Solution Project to put all together (4:36)
Exercise files
012. Count rows hands-on
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock