Data Management in SQL
Data Management in SQL
The primary goal of this program is to learn principles and practices of database management and database design with Structured Query Language (SQL). The journey begins with an exploration of conceptual data modeling, relational database design, normalization, and SQL queries, where you’ll discover various methods for analyzing, manipulating, and extracting insights from data.
Building on this foundation, you’ll gain a deeper understanding of the theory, application and management of relational database technology. The program concludes with an extension to big data analytics, ensuring you are prepared to handle vast and complex data sets. By mastering how to approach and solve business challenges through data organization and manipulation, you’ll be equipped to apply your knowledge within your organization and beyond, distinguishing yourself in today’s competitive business environment. This program utilizes a hands-on approach with practical problems used as theory reinforcement.
Data Management in SQL is offered in two different programs – SQL Basic and SQL Advanced.
Certificate of Completion: Participants who complete the 8-hour session of SQL Basic or the 8-hour session of SQL Advanced will receive a Mercer certificate of completion.
SQL Basic
At every level within an organization, interacting with databases has become a common task, often essential for generating meaningful analytics. In this basic course, you will discover how datasets can be explored and manipulated using Structured Query Language (SQL). The course will cover topics including an overview of the relational data model, understanding entities and relationships, designing logical data models and database design using the process of normalization. We will also learn how to create basic SQL queries to manage and retrieve data within a relational database, thereby yielding valuable insights and demonstrating best practices that you can apply directly to your role.
SQL Advanced
This advanced course expands upon the foundational concepts introduced in the basic course, where you will learn how to effectively approach the structure of relational databases and apply that expertise to understand how intricate business questions are addressed. During the journey, you will discover how to systematically tackle advanced SQL queries by utilizing a variety of new clauses, conditional logic and temporary tables, empowering you to leverage the full potential of the database for your organization. This course concludes with advanced topics including big data analytics, scalability, and automation. A hands-on approach will be used throughout the course to reinforce the concepts discussed.