Course Name : SQL & Database Basics - (for Non-IT Professionals)
Duration : 12 hours
Course Description
The SQL & Database Basics course is specifically designed for non-IT professionals who wish to gain a solid foundation in SQL and database management. Over 12 hours of live, online instruction, participants will learn how to efficiently manage, query, and maintain databases, with a focus on practical applications in an ERP environment.
Course Objectives
☑️ Understanding Databases: Learn the core concepts of databases, including what they are, why they are essential, and how they are used in real-world scenarios.
☑️ Hands-On Experience: Gain practical experience with Microsoft SQL Server Express, from installation to creating and managing databases.
☑️ SQL Fundamentals: Master the basics of SQL, including querying databases, creating stored procedures, and understanding database objects.
☑️ Advanced SQL Techniques: Explore advanced SQL topics such as window functions, cursors, and temporary tables, and learn best practices for data reconciliation.
☑️ Personalized Support: Benefit from tailored guidance and support, ensuring that you can apply what you learn directly to your professional environment.
Course Content
Introduction to Databases and SQL
☑️ What is Data and Information?
☑️ Overview of Databases and Database Servers
☑️ Advantages of Database Management Systems (DBMS)
☑️ Installation and Setup of Microsoft SQL Server Express
Database Creation and Management
☑️ Creating and Restoring Databases
☑️ Database File Structure and Objects
☑️ Importing and Managing Data in SQL Server Express
☑️ Introduction to Data Warehousing
Basic SQL
☑️ Introduction to Database Languages
☑️ Writing Basic SQL Queries
Database Objects and Advanced SQL
☑️ Working with Stored Procedures, Views, Triggers, and Functions
☑️ Advanced SQL Techniques: Window Functions, Cursors, and Temporary Tables
☑️ Best Practices in Data Reconciliation
Practical Application
☑️ Applying Knowledge to Real-World Scenarios
☑️ Practical Examples and Case Studies
Who Should Attend
This course is ideal for non-IT professionals, particularly those in accounting, auditing, sales, marketing, HR, administration, or management, who need to enhance their database and reporting skills within an ERP environment.
Certification
Upon successful completion of the course, participants will receive a digital badge titled SQL & Database Basics-Beginner. This badge, issued via Credly, can be showcased on professional profiles to demonstrate your competency in SQL and database management.
Course Logistics
☑️ Platform: Microsoft Teams (100% live sessions)
☑️ Language: Sinhala or English
To elevate your database management skills and improve your efficiency in handling data-driven tasks in your professional role.
Enroll Now