Duration 3 days – 21 hrs.
Overview
This intensive 3-day training course is designed for database developers and professionals aiming to build a strong foundation in developing SQL databases. Participants will delve into essential concepts, hands-on exercises, and real-world scenarios to master the skills needed to design, implement, and optimize SQL databases effectively.
Objectives
- Understand the fundamentals of database development.
- Explore the lifecycle of database development.
- Install and configure SQL Server.
- Familiarize with SQL Server Management Studio (SSMS).
- Master the principles of Entity-Relationship Diagrams (ERD).
- Apply normalization techniques for effective data modeling.
- Work with advanced data modeling concepts like views, indexes, and triggers.
- Implement Temporal Tables for time-based data storage.
- Acquire proficiency in T-SQL syntax and data types.
- Perform data retrieval with SELECT statements.
- Utilize joins, subqueries, and Common Table Expressions (CTEs).
- Implement dynamic SQL and stored procedures.
- Create and manage stored procedures.
- Develop user-defined functions and implement triggers.
- Analyze query execution plans for optimization.
- Implement indexing strategies for enhanced performance.
- Manage security at the database and object levels.
- Implement secure data encryption.
- Design and implement backup and recovery strategies.
- Monitor and maintain SQL Server databases.
Audience
- Database Developers: Individuals responsible for designing, implementing, and maintaining databases.
- Database Administrators (DBAs): DBAs seeking to enhance their skills in database development and optimization.
- SQL Server Developers: Developers working specifically with SQL Server databases and aiming to deepen their knowledge.
- Data Analysts and Data Scientists: Professionals involved in data analysis and scientific research who want to strengthen their database development skills.
- Business Intelligence (BI) Developers: BI professionals working with SQL Server databases as part of their data analysis and reporting tasks.
- IT Professionals and System Administrators: IT professionals and system administrators involved in managing and maintaining SQL Server databases.
- Software Engineers and Architects: Software engineers and architects interested in database design and interaction with SQL Server databases.
- Technology Managers: Managers overseeing technology teams, wanting to ensure their teams are well-versed in SQL database development.
- IT Students and Graduates: Students pursuing a career in IT, computer science, or related fields with an interest in database development.
- Business Analysts: Business analysts involved in querying databases to extract meaningful insights for decision-making.
- Anyone Involved in Database Development: Individuals from various roles who interact with databases and want to improve their database development skills.
Pre- requisites
- Must know how to use computer
- Proficiency in spreadsheets is an advantage.
- Basic knowledge in SQL is an advantage.
Course Content
Module 1 : Data Warehouse Overview
- Data Warehouse Basics
- Data Warehouse architecture
- Data Warehouse infrastructure
- Columnar storage
- OLTP vs OLAP
Module 2: Data Modeling
- Setting up an ETL process
- Dimensional Modeling: Facts & Dimensions
- Implementing a complete data warehouse hands-on
- Slowly Changing Dimensions
Module 3: Data Transformation
- Understanding ETL tools
- ELT vs. ETL
- Data sources
- ETL with SSIS
Module 4: Optimization, Deployment, and Processing Technique
- Optimizing a data warehouse using indexes
- Cloid vs on-premises data warehouse
- Massive parallel processing
- Columnar storage
