16 Oct
|
Training Basket
|
Noida
16 Oct
Training Basket
Noida
• Design, develop, and maintain SQL databases, tables, views, and stored procedures.
• Write and optimize complex SQL queries for data retrieval and reporting.
• Develop stored procedures, functions, triggers, and database scripts.
• Perform database performance tuning and query optimization.
• Ensure data accuracy, integrity, consistency, and security.
• Troubleshoot database-related issues and resolve errors.
• Work with large datasets and perform data extraction, transformation, and loading (ETL).
• Create database reports and support business intelligence requirements.
• Collaborate with developers, data analysts, and other technical teams.
• Assist in database backup, recovery, and maintenance activities.
• Maintain proper documentation of database structures and SQL scripts.
Requirements
• Strong knowledge of SQL and RDBMS concepts.
• Hands-on experience with MySQL, Microsoft SQL Server, PostgreSQL, or Oracle.
• Good understanding of SQL queries, joins, subqueries, and aggregate functions.
• Knowledge of stored procedures, functions, triggers, and views.
• Understanding of database normalization and indexing.
• Familiarity with database design and data modeling.
• Knowledge of query optimization and performance tuning.
• Understanding of primary keys, foreign keys, and database constraints.
• Basic knowledge of ETL processes and data warehousing.
• Solid analytical and problem-solving skills.
📌 SQL Developer (Noida)
🏢 Training Basket
📍 Noida