• Post category:StudyBullet-14
  • Reading time:9 mins read


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

What you will learn

SQL Introduction, tools and DBMS vs RDBMS

The basics of SQL Queries and CRUD Skills

Working with Different data types and operations in SQL

Manipulating result tables and using aliases

SQL Constraints, Rules & Data Types

Data Sorting and Filtering by Orders

Combining tables with Union & Union All

Managing and Joining Multiple tables at the same time

Set Conditions and filtering fields and records using many ways

Creating DB and tables and essential skills for relational databases

Copying tables and Views

Functional Programming in SQL

Task to apply all the SQL fundamentals to be A SQL Professional

Description

Hi, welcome to This Comprehensive SQL Bootcamp β€œSQL Mastery: Enough SQL To Be A Professional”

Developing, manipulation and managing relational databases with SQL is a very powerful and useful skill for any engineer, developer, programmers and also, non-programmers.

SQL is a tool that will open up many jobs and offers for you because of its great importance and benefits in the software industry and companies.

SQL is a must-have skill for anyone who wants to become a professional developer, engineer, or data scientist.

By the end of this course, you’ll learn all the SQL skills you need to know to develop, manipulate, manage and communicate with relational databases effectively and in no time!

You will be able to manipulate and combine all of the SQL skills together, and you will become truly an expert in SQL and Relational Databases Professional.


Get Instant Notification of New Courses on our Telegram channel.


You’ll learn:

  • SQL Introduction, Work Environment, DBMS vs RDBMS
  • The basics of SQL Queries and CRUD Skills
  • Working with Different data types and operations in SQL
  • SQL Constraints, Rules & Data Types
  • Data Sorting and Filtering by Orders
  • Combining tables with Union & Union All
  • Managing and Joining Multiple tables at the same time
  • Set Conditions and filtering fields and records using many ways
  • Creating Databases and tables and essential skills for relational databases
  • Copying tables and Views
  • Functional Programming in SQL
  • Task to apply all the SQL fundamentals to be A SQL Professional

Hi, my name is Ahmed Ibrahim El-mohandes, I’m a Lead Software Engineer and Data Science Professional and I’ll be the instructor for this SQL Programming Course. I’ll be very very happy to teach you this Course.

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 complete and powerful course to learn on of the most popular skills in the software industry, SQL.

Let’s get started

English
language

Content

Introduction

Course Intro
Database Overview
Tools and Work Environment illustration
Work Environment hands-on
DBMS & RDBMS Overview

The Basics of SQL

SQL Queries
Select Statement
Hands-On Select an existing table
Hands-On Select a particular column
Hands-On Select number of columns
Select Distinct
Hands-On Select Distinct and count unique rec
Where Statement
Hands-On Where and filtering records
Add Some Logic for conditions
Hands-On Logics for conditions
Aliases
Hands-On Aliases and renaming columns
Limitations
Hands-On Limitations by examples
Inserting Data
Hands-On Inserting records with column names
Hands-On Inserting values for all columns
Hands-On Inserting data for specified columns
Hands-On Inserting many records
Updating data
Hands-On Updating data by examples
Hands-On Updating all records
Deleting Data
Hands-On Deleting records by examples
Comments
Hands-On Types of Comments
SQL Operators
Hands-On SQL Arithmetic Operators
Hands-On SQL Comparators
Hands-On SQL BETWEEN and IN Operators

SQL Constraints & Data Types

Data Types
Hands-On Data Types by example
Adding Constraints
Hands-On Constraints by examples

Creating DB and Tables

Creating DB and Tables
Hands-On Creating Tables by examples
Hands-On Creating Tables from tables
Dropping DB and Tables
Hands-On Dropping Tables
Alter tables
Hands-On Alter table by examples

Data Sorting and Conditions

Orders
Hands-On Order by
Union
Hands-On Union and Union All
Any and All
Using Any Operator Hands-On
SELECT ALL example 1 Hands-On
ALL with two tables example 2 Hands-On
Group By
Hands-On Group By
Having clause
Use Having clause to filter data Hands-On
Wildcards
Hands-On Like and Wildcards
Case Statement
Performing tasks with Case Clause Hands-On

Functional Programming in SQL

The concept of function
Aggregate functions
Scalar functions
SQL Functions examples hands-on

SQL Joins

Joins overview
Inner Join
Inner Join hands-on
Left Join
Left Join hands-on
Right Join
Right Join hands-on
Full Outer Join
Full Outer Join hands-on

More Learning and Applying

Views in detail hands-on
SQL Project
SQL Project Solution Hints