11. January 2020 - 9:00
Zero2Hero Training, London
Share it on:

SQL/Database for Beginners, SQL Course for 2 days | Saturday, 11. January 2020

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)


Syllabus,


 


DB Approach & Applied TechnologiesDatabasesSeparation And Isolation Of DataDuplication Of DataHistory Or Database SystemsDBMS Environment/ComponentsRolesDatabase DesignsData Mapping And IndependenceDatabase LanguagesInstallation Of MySQL/MySQL WorkbenchThe Relational ModelTerminologyMathematicsData IndependenceLow RedundancyDatabase Integrity TypesDomain ConstraintsSQL Data ManipulationMIN, MAX And AVG FunctionsSQL Data Manipulation LanguageGrouping, Having, ISO, Sophisticated SQL, Queries, JOIN, UNION, INTERSECT, EXCEPTConceptual Database DesignEntity-Relationship Modelling CORE CONCEPTSConstraintsEER IntroductionER/EER Modelling ProcessLogical Design For Relational DatabasesLogical Design For Relational DatabasesDerive Relations For Logical Data ModelRulesSQL Data Definition Language (DDL)Data Types, Database Integrity, SQL Statements


 



 We make sure to keep our class sizes small( maximum 8 participants in a class) so that every student is able to have their questions answered by the course instructor.



----------------------------------------------------------------------------------


Zero To Hero: to learn from scratch or improve your fortunes significantly to IT/Software/Tech, all skill levels are welcome.


Address: Office 563, 3.Floor, Salisbury House,


29 Finsbury Circus, Moorgate, EC2M 5SQ


Email: email: 020 7 193 893 7Website:  http://zero2hero.training