Description
Have you ever been interested in learning about SQL Databases or a keen developer wishing to pursue a career in databases/programming or someone who needs an online course where you can learn at your own pace with a course that teaches you everything you need to know about SQL, than look no further, ENROL TODAY!
This course will be sent to you via email/pdf format you will have unlimited and lifetime access to this course, so you can refer back to it at anytime you wish.
What you will learn:
DB Approach & Applied Technologies (introduction)
PART 1: DB Approach & Applied Technologies – Databases, separation and isolation of data, duplication of data, history or database systems, DBMS environment/components, roles, database designs, data mapping and independence, database languages
PART 2: The Relational Model – Terminology, mathematics, data independence, low redundancy, database integrity types, domain constraints, SQL data manipulation, MIN, MAX and AVG functions
PART 3: SQL Data Manipulation Language – Grouping, having, ISO, sophisticated SQL, queries, JOIN, UNION, INTERSECT, EXCEPT
PART 4: Conceptual Database Design – Entity-Relationship Modelling CORE CONCEPTS, constraints, EER introduction, ER/EER Modelling Process
PART 5: Logical Design for Relational Databases – Logical design for relational databases, Derive Relations for Logical Data Model, rules
PART 6:SQL Data Definition Language (DDL) – Data Types, Database Integrity, SQL Statements, Views & Privileges
PLEASE NOTE: YOU WILL RECEIVE THE COURSE IN PDF FORMAT
Reviews
There are no reviews yet.