Location

Community Services & Continuing Education - Cairo

Objectives

• Databases are absolutely the most important component of projects.For example, websites, large systems, and applications, most of them use databases to store the information we store in them.

Outcomes

Arrange user data in a way that is easy to access and deal with.Accurately define the types of data that are stored such as text, numbers, dates, currencies, etc..Setting conditions on the data that will be stored in addition to the possibility of setting default values.Access to information very quickly if indexes are used

Course Contents

Overview of database • SQL Statement Fundamentals• SELECT Statement• Challenge: SELECT• SELECT DISTINCT• Challenge: SELECT DISTINCT• COUNT• SELECT WHERE - Part One• SELECT WHERE - Part Two• Challenge: SELECT WHERE• ORDER BY• LIMIT• BETWEEN• IN• LIKE and ILIKE• Introduction to GROUP BY. Aggregation Functions• HAVING• • Overview of JOINS• Introduction to JOINs• AS Statement• Inner Joins• Full Outer Joins• Left Outer Join• Right Joins• UNION• • Overview of Advanced SQL Commands• Timestamps and Extract - Part One• Timestamps and Extract - Part Two• Quick Note on TO_CHAR• Timestamps and Extract - Challenge Tasks• Mathematical Functions and Operators• String Functions and Operators• SubQuery• Self-Join• Data Types• Primary Keys and Foreign Keys• Constraints• CREATE Table• INSERT• UPDATE• DELETE• ALTER Table• DROP Table• CHECK Constraint• Conditional Expressions and Procedures Introduction• CASE• COALESCE• CAST• NULLIF• Views• Imp