What you'll learn
- Working environments and SQL tools
- Data selection, modification, insertion, updating, and deletion
- Table sorting and limiting
- SQL functions and aggregation
- Creating and managing databases and tables
- Adding rules to data tables
- Managing and Joining Multiple Tables
Who is this course for
- SQL Newbies
- Programmers and developers
- Non-Programmers
- Software Developers
- Data Engineers and Scientists who aim to become Professional Database Engineers in the future
After finishing this course, you will have essential training in SQL Programming.
With this, you can get free access to
- Course Materials for Life
- Intermediate Expertise in all things related to SQL Programming
About Us
Over 100,000 students have received instruction from this online academy in topics including Lift Style, Fitness Training, Cyber Security, Ethical Hacking, Facebook Ads, SEO, Email Marketing, eCommerce, Business Investing, Social Media Marketing, Launching Your Own Business, and Marketing/Ad Agency!
We provide a wide variety of top-notch online courses that educate through real-world examples from subject matter experts and tried-and-true research, all supported by top-notch, studio vocally narrated videos! Teaching practical life skills, which are crucial in today's environment, is the focus.
Every course offered by this online learning academy is instructed by subject-matter specialists who genuinely love what they do and want to share it with others.
Course Curriculum
- 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
Frequently Asked Questions
When does the course start and finish?
The course has begun and will never stop! You set the start and end dates for this entirely self-paced online course.
How long do I have access to the course?
Lifetime access—how does that sound? You receive unrestricted access to this course after registering for as long as you like, on any device you own.
Do I get a certificate?
Yes, when you complete the course, you will receive a certificate of completion which you can happily add to your resume or LinkedIn profile.
Can I cancel my subscription?
Yes you can. You have a 15-days money-back guarantee.
