Home | Back to Courses
Complete SQL & Relational Database Management System
Partner: Udemy
Affiliate Name:
Area:
Description: In this course, you will learn about Relational Database Management systems and Structured Query Language (SQL)You will learn about the Relational Database Management system:Introduction to Relational DatabasesInformation and Data ModelsTypes of RelationshipsMapping Entities to tablesAdvanced relational model constraintsWhat is Primary KeyWhat is Foreign keyWhat is Entity, Attributes´Data Definition Language(DDL) & Data Manipulation Language (DML)Types of SQL statementsWhat is DDL (Data Definition Language)What is DML (Data Manipulation Language)How to get started with Database - install and set up Microsoft SQL Server Management studioHow to create a table in a Microsoft SQL server with CREATE TABLE commandHow to insert data in a table in a Microsoft SQL server with INSERT INTO statementHow to retrieve data from a table with a SELECT statementAdvanced DDL & DML statements : How to use string pattern, range of values and set in the SELECT statementhow to sort data with ORDER BY statementhow to group by data with GROUP BY clausehow to use GROUP BY HAVING clause Working with multiple tablesHow to use different tablesunderstand the use of Primary key</str
Category: IT & Software > Other IT & Software > SQL
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course