+91 8142000093 info@tanviinfo.com

MySql

TIS_MySql

MySql

Course Duration : 20 Hours
Course Delivery : Classroom, Online, Weekends
Category:

Course Content

Theory, Terminology and Concepts
• Client/Server Concepts
• Database and Database Objects
Data Definition using SQL
• Databases
• Data Types
• Tables
• Constraints and Indexes
• Views
Basic Data Manipulation using SQL
• Recurring SQL Constructs
• Adding data
• Modifying data
• Removing data
• Searching data
Advanced Data Manipulation using SQL
• Expressions
• Grouping and Aggregate Functions
• Joining Tables
Transactions
• Transaction Concepts
• SQL for working with Transaction
Import/Export
• Tools for Import/Export
• SQL for Import/Export