SQL

Course Information
Course curriculum
Reviews

SQL forms the cornerstone of all relational database operations. The ability to write the SQL language is essential for those who develop database applications. This course provides a solid foundation of the SQL programming language that enables students to build, query and manipulate databases.

Every Friday 19:30 – 21:30 starting 10 December 2021

Overview
- What is SQL?
- SQL Process
- SQL Commands
RDBMS Concepts
- What is RDBMS?
- SQL Constraints
- Data Integrity
- Database Normalization
- Database – First Normal Form (1NF)
- Database – Second Normal Form (2NF)
- Database – Third Normal Form (3NF)
RDBMS Databases
- MySQL
- MS SQL Server
- ORACLE
- MS ACCESS
Syntax
- Various Syntax in SQL
Data Types
- Data Types
Operators
- What is an Operator in SQL?
- SQL Arithmetic Operators
- Arithmetic Operators – Examples
- SQL Comparison Operators
- Comparison Operators – Examples
- SQL Logical Operators
- Logical Operators – Examples
Expressions
- Boolean Expressions
- Numeric Expressions
- Date Expressions
CREATE Database
- CREATE Database
DROP or DELETE Database
- DROP or DELETE Database
SELECT Database, USE Statement
- SELECT Database, USE Statement
CREATE Table
- Creating a Table from an Existing Table
DROP or DELETE Table
- DROP or DELETE Table
INSERT Query
- INSERT Query
SELECT Query
- SELECT Query
WHERE Clause
- WHERE Clause
AND & OR Conjunctive Operators
- The AND Operator
- The OR Operator
UPDATE Query
- UPDATE Query
DELETE Query
- DELETE Query
LIKE Clause
- LIKE Clause
TOP, LIMIT or ROWNUM Clause
- TOP, LIMIT or ROWNUM Clause
ORDER BY Clause
- ORDER BY Clause
Group By
- Group By
Distinct Keyword
- Distinct Keyword
Constraints
- NOT NULL Constraint
- DEFAULT Constraint
- UNIQUE Constraint
- Primary Key
- Foreign Key
- CHECK Constraint
- INDEX Constraint
- Dropping Constraints
- Integrity Constraints
Using Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- CARTESIAN or CROSS JOIN
UNIONS CLAUSE
- The UNION ALL Clause
- INTERSECT Clause
- EXCEPT Clause
NULL Values
- NULL Values
Alias Syntax
- Alias Syntax
Indexes
- The CREATE INDEX Command
- The CREATE INDEX Command
- INDEX Constraint
ALTER TABLE Command
- ALTER TABLE Command
TRUNCATE TABLE Command
- TRUNCATE TABLE Command
Using Views
- Creating Views
- The WITH CHECK OPTION
Having Clause
- Having Clause
Transactions
- Properties of Transactions
- Transactional Control Commands
Wildcard Operators
- Wildcard Operators
Date Functions
- Date Functions
Temporary Tables
- What are Temporary Tables?
- Dropping Temporary Tables
Clone Tables
- Clone Tables
Sub Queries
- Subqueries with the SELECT Statement
- Subqueries with the INSERT Statement
- Subqueries with the UPDATE Statement
- Subqueries with the DELETE Statement
Using Sequences
- Using AUTO_INCREMENT column
- Obtain AUTO_INCREMENT Values
- Renumbering an Existing Sequence
- Starting a Sequence at a Particular Value
Handling Duplicates
- Handling Duplicates
Injection
- Preventing SQL Injection

Reviews

Average Rating

(0 rating)

Detailed Rating

Price $200.00

Duration 20 hours

Start at December 10

Lectures 88

Enrolled 32 students

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

SQL

SQL

SQL

Every Friday 19:30 – 21:30 starting 10 December 2021

Overview

RDBMS Concepts

RDBMS Databases

Syntax

Data Types

Operators

Expressions

CREATE Database

DROP or DELETE Database

SELECT Database, USE Statement

CREATE Table

DROP or DELETE Table

INSERT Query

SELECT Query

WHERE Clause

AND & OR Conjunctive Operators

UPDATE Query

DELETE Query

LIKE Clause

TOP, LIMIT or ROWNUM Clause

ORDER BY Clause

Group By

Distinct Keyword

Constraints

Using Joins

UNIONS CLAUSE

NULL Values

Alias Syntax

Indexes

ALTER TABLE Command

TRUNCATE TABLE Command

Using Views

Having Clause

Transactions

Wildcard Operators

Date Functions

Temporary Tables

Clone Tables

Sub Queries

Using Sequences

Handling Duplicates

Injection

Reviews

Related Courses

Javascript Coding

Security

Data Science

Machine Learning

Artificial Intelligence

Address

Explore

Information

To apply for group training courses, please complete the form

Modal title