SQL | Structured Query Language with MySQL (2024)

Partner: Udemy
Affiliate Name:
Area:
Description: Course Outline: Mastering Databases and SQL with MySQLWhat is a Database?Definition and importanceTypes of databasesUnderstanding SQL and RDBMSIntroduction to SQLWhat is a Relational Database Management System (RDBMS)?Key features of RDBMSInstalling MySQLDownloading and installing MySQLSetting up MySQL WorkbenchCreating Databases and TablesSyntax and examplesPrimary keys and foreign keysAuto-increment fieldsSQL DatatypesOverview of different datatypesChoosing the right datatype for your dataBasic SQL CommandsSELECT, INSERT, UPDATE, DELETEBasic querying and filteringUsing WHERE clauseSQL ConstraintsNOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULTExamples and use casesNormalizationWhat is normalization?Benefits of normalizationTypes of normalization (1NF, 2NF, 3NF,)Types of NormalizationDetailed explanation with examplesPractical applications and best practicesDML (Data Manipulation Language) & DDL (Data Definition Language)Detailed commands and examplesDifferences between DML and DDLJOINS and TypesINNER JOIN, LEFT JOIN, RIGHT JOIN,CROSS JOINExamples and use casesWorking with ViewsCreating a
Category: Development > Database Design & Development > Database Management Systems (DBMS)
Partner ID:
Price: 39.99
Commission:
Source: Impact
Go to Course