InfosecTrain Online, Bangalore
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/
⌛ Event Dates & Venue
Advertisements