Name: The SQL Programming Essentials Immersive Training
Rating: 4.5 (1643 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created bySDE Arts, Ahmed El Mohandes

Last updated 6/2023

English

What you'll learn

SQL tools and the working environments
Selecting, Modifying, Inserting, Updating and deleting Data
Working with Different data types and operations in SQL
Sorting and limiting tables
Powerful SQL functions and aggregation
Building Database and tables easily and handling them
Setting rules to tables data
Managing and Joining Multiple tables at the same time
Set Conditions and insert the true values in a column in the result-set
Handling the result-set headers
Solve the the useful exercise of this training to apply everything you learnt
Get the Instructor QA Support

Course content

9 sections • 47 lectures • 3h 26m total length

Introduction to course7:47
Master the SQL programming language to manage tables and databases, perform queries, updates, and joins, and build databases from the ground up with practical, step-by-step guidance.
SQL quick intro1:52
Installing the working environment: DB Manager6:27
Install and use the DB Browser for SQLite, a cross-platform open-source database manager, to create databases and tables and to execute SQL commands easily.

SQL syntax theory3:49
Outline sql statement types: dml (select, delete), ddl (create, alter, drop), dcl (grant, revoke), and tcl (begin, commit, rollback); cover semicolon use and comments (## single-line, /* ... */ multi-line).
SELECT Statement theory2:02
SELECT Statement hands-on5:57
SELECT DISTINCT Theory1:18
SELECT DISTINCT hands-on5:03
WHERE Statement theory1:43
Discover how the where statement filters records by a condition in a select query, extracting specific columns from a table using the syntax select, from, and where.
WHERE Statement hands-on5:35
Count rows theory1:42
Count rows hands-on5:33
Insert data theory1:43
Insert data hands-on6:42
Practice inserting a new record into the seller table using insert into and the values statement, handle auto-incremented ids, and verify results with a select query.
NULL OP Theory2:03
NULL and Not OP hands-on5:50
Updating data records theory2:10
The update statement modifies existing records in a table by setting column values, optionally using a where clause to target specific records; without a where clause, all records update.
Updating data records hands-on7:01
Deleting data theory1:45
Deleting data hands-on5:15

Operators IN - NOT IN theory0:31
Operators - IN and Not IN3:50
Learn how the in and not in operators filter data by multiple values in sql queries, using a select from seller example to show country matches and exclusions.
SQL Logical Operators theory1:39
Operators- Logical op hands-on9:44
Operators - Arithmetic op hands-on5:02
Operators - Comparisons hands-on7:23
Operators- SQL BETWEEN and NOT hands-on7:03
SQL Data Types1:37

Create DB and Tables hands-on8:36
Deleting newOrders hands-on3:45
Use the drop table statement to delete an existing table, such as new orders. Be aware that dropping a table results in data loss.
ALTER ADD OR DELETE fields hands-on3:14
Learn to use the alter table statement to add, drop, or modify columns in an existing table, demonstrated on the customer table with a new column and verification.
Renaming tables hands-on3:06
Constraints theory2:29
Discover how constraints enforce data rules in SQL by defining not null, unique, primary key, foreign key, check, and default values for columns in an existing table.
Constraints hands-on4:01
Set sql constraints on a table with the DB Browser for SQLite, including not null, unique, primary key, check, default, and create index on the buyers table.

Requirements

No requirements to take this course

Description

Hello and welcome to The SQL Programming Essentials 2023 Immersive Training.

Mastering How to build, work with, handle and manage databases can be a very useful skill for any programmer, developer and also, non-programmers. And by the end of this course you'll be able to build, work with and manage databases easily and in no time!

This is a very powerful tool for everyone who wants to become a professional developer, engineer or data scientist.

Structure Query Language(SQL) is one of the most important skills that any programmer, developer, engineer or even an expert must possess, who wants to succeed in his practical life. It really facilitates a lot and a lot in accessing and manipulating data.

In this immersive training you'll learn everything you need to program with the SQL language the right way, and you'll become a SQL Programming Rockstar.

You'll learn:

SQL tools and the working environments
Selecting, Modifying, Inserting, Updating and deleting Data
Working with Different data types and operations in SQL
Sorting and limiting tables
Powerful SQL functions and aggregation
Building Database and tables easily and handling them
Setting rules to tables data
Managing and Joining Multiple tables at the same time
Set Conditions and insert the true values in a column in the result-set
Handling the result-set headers
Solve the the useful exercise of this training to apply everything you learnt

All that and more, in addition to the instructor QA Support.

Hi, My name is Ahmed Ibrahim, I'm A Data and Machine Learning Software Engineer and I'll be the instructor for this SQL Programming Course. And if you need any help during this immersive training, please don't hesitate to ask me, and I'll answer you as soon as possible.

Learn and practice the essential concepts of SQL Programming to become a professional database engineer effectively and quickly without wasting your valuable time.

So, what are you waiting for, enroll now to go through this immersive and powerful training of the most popular Database Programming Language on the market, SQL.

Become A SQL Programmer and Rockstar in no time!

Let’s get started

Who this course is for:

SQL Beginners
Developers and Programmers
Non-Programmers
Software Engineers
Anyone who wants to become a Professional Database Engineer in the future
Data Engineers and Scientists

What you'll learn

Explore related topics

Course content

Introduction and Installation3 lectures • 16min

The Basics of SQL Programming17 lectures • 1hr 5min

SQL Operations and Data8 lectures • 37min

Ordering and Limitations3 lectures • 16min

Powerful Functions and Aggregation4 lectures • 18min

Playing with DB tables and constraints6 lectures • 25min

Working with and combining multiple tables2 lectures • 15min

Temporary names and conditions2 lectures • 9min

Exercise: Apply the SQL Concepts2 lectures • 6min

Requirements

Description

Who this course is for: