- TypeWebinar
- Location Online Event
- Date 06-09-2022 - 08-09-2022
Education/Teaching/Training/Development
Information Technology
Date: 06th -08th Sep
Time: 08.00 -10.00 PM (IST)
Speaker: NAWAJ
Agenda for the Bootcamp
â¡ï¸ Relational Database & introduction to SQL
• Why use SQL?
• Why use MySQL?
• Introducing Databases
• Relational Database Fundamentals
• Comparing Databases and Spreadsheets
• Important Database Terminology
• The Concept of Relational Schemas: Primary Key
• The Concept of Relational Schemas: Foreign Key
• The Concept of Relational Schemas: Unique Key and Null Values
• The Concept of Relational Schemas: Relationships Between Tables
â¡ï¸ Installation & get to know MySQL
• Installing MySQL Workbench and Server
• Installing Visual C
• Installing MySQL on Windows, macOS and Unix systems
• The Client-Server Model
• Linking GUI with the MySQL Server
• Creating a New User and a New Connection to it
• Familiarize Yourself with the MySQL Interface
• SQL Fundamentals – MySQL Session and Databases
• SQL Fundamentals – DROP, CREATE, SELECT, INSERT, DELETE
â¡ï¸ Best SQL Practices
• Coding Tips and Best Practices
Register now: https://www.infosectrain.com/events/all-about-sql-with-nawaj/
Date: 06th -08th Sep Time: 08.00 -10.00 PM (IST) Speaker: NAWAJ