+44 20 7 193 893 7 info@zero2hero.training
+44 20 7 193 893 7 info@zero2hero.training
Zero To Hero IT Training
  • Home
  • About Us
  • Meet The Team
  • Courses
  • Contact Us
  • Home
  • -
  • Courses
  • -
  • SQL/Database for Beginners for 2 days
IMG_7674

SQL/Database for Beginners for 2 days

By: Alper Atay Date: Nov 14, 2019

This course will introduce you to relational databases (RDBMSs), and SQL (Structured Query Language) – the language used to create, modify, manage and query them. Using real world examples you will create tables, set permissions, insert, update and delete data, and retrieve your data using standard SQL. You will also learn about the most common […]

0 student
£149.99
361 Comments off
  • Overview
  • Curriculum
  • Instructor
  • Reviews

This course will introduce you to relational databases (RDBMSs), and SQL (Structured Query Language) – the language used to create, modify, manage and query them. Using real world examples you will create tables, set permissions, insert, update and delete data, and retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard language supported by the two most common databases – Microsoft SQL Server and Oracle.

OUR COURSES WILL OPEN IF MIN 3 PARTICIPANTS

Who is this course for :

This course is for anyone who wants to learn basics about SQL.

What you will learn:

DB Approach & Applied Technologies (introduction)

  • 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
    • Installation of MySQL/MySQL Workbench
  • The Relational Model
    • Terminology
    • mathematics
    • data independence
    • low redundancy
    • database integrity types
    • domain constraints
    • SQL data manipulation
    • MIN, MAX and AVG functions
  • SQL Data Manipulation Language
    • Grouping, having, ISO, sophisticated SQL, queries, JOIN, UNION, INTERSECT, EXCEPT
  • Conceptual Database Design
    • Entity-Relationship Modelling CORE CONCEPTS
    • constraints
    • EER introduction
    • ER/EER Modelling Process
  • Logical Design for Relational Databases
    • Logical design for relational databases
    • Derive Relations for Logical Data Model
    • rules
  • SQL Data Definition Language (DDL)
    No items in this section
  • Data Types, Database Integrity, SQL Statements
    • Views & Privileges
User Avatar
Alper Atay
As our rhapsodist tutor and training manager, Alper is a qualified software developer and solution consultant with outstanding experience in education, aviation, engineering, electrical and electronic manufacturing industries. He has more than 20 years of experience in IT industry as a software developer and trainer.

Reviews

Average Rating

0
0 ratings

Detailed Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
User Avatar

Alper Atay

As our rhapsodist tutor and training manager, Alper is a qualified software developer and solution consultant with outstanding experience in education, aviation, engineering, electrical and electronic manufacturing industries. He has more than 20 years of experience in IT industry as a software developer and trainer.

Course Tags

  • bestcourse
  • DATABASE
  • javaperformance
  • SQL
  • sqlforbeginner
  • webdeveloper

Related Courses

Java Performance Tuning

Java Performance Tuning

By: Zero To Hero Date: Nov 12, 2019

This Java Performance Tuning training teaches performance tuning concepts applicable to the Java programming language.

No student enrolled £399.00
485 No comments
Learn Now

Subscribe

To Our Newsletter

Footer logo

A learning curve is essential to growth and could be achieved by involvement. Involve, Learn, Innovate

GET IN TOUCH

+44 20 7 193 893 7 info@zero2hero.training www.zero2hero.training Salisbury House, 29 Finsbury Circus, EC2M 7AQ, London

Useful Links

  • Become a Teacher
  • Upcoming Events
  • Courses
Copyright © 2021 Zero To Hero IT Training. All Rights Reserved.