- info@webcapz.com.ng
- Mon - Sat: 8.00 am - 6.00 pm
We are creative, ambitious and ready for challenges! Hire Our Talents
Data Analysis with SQL
// Data Analysis with SQL Training in Port Harcourt
Become A Certified
Become A Certified
Data Analyst
Accelerate your career in data, and earn a data analysis certification.
Data analysis is an ever-evolving discipline with lots of focus on new predictive modelling techniques coupled with rich analytical tools that keep increasing our capacity to handle big data. To make informed business decisions, organizations must have a data analyst that can help analyze and interpret business data. Gain the tools and credentials to launch a rewarding career in the field of modern technology.
Our data analysis training is beginner-friendly, practical and project-based. It is designed to help participants gain mastery of data analysis with SQL tool that are used to make informed decision. It is tailored to help you gain real-world experience that can get you a job and grow your career.
// From Beginner To Mastery
Who Should Attend
01
Career Switch
Those who are switching career to tech industry for freelancing or to get a remote job.
02
Next Level
Those who have programming skills but want to take their skill to next level with real-life projects.
03
Travel Abroad
Those planning to travel abroad and seeking hands-on skill that can make them relevant.
// Benefits of Training at WebCapz
Why Choose Us?
- Expert
- Career
- Certificate
WebCapz is the leading IT Training Institute with over 10 years cognitive experience. Our courses are taught by experienced professionals with a wealth of industry experience. Our approach is beginner-friendly, practical and project-based.
We Commit to your Success! We offer world-class support to our students with over 3,000+ students trained in Nigeria. CV review, interview preparation, LinkedIn profile update, job alert within our alumni community and mentorship.
WebCapz Technologies is a registered IT solution and training company in Nigeria. We collaboration with our international partners in the UK and India that allows us to issue recognized certificate to our students at the completion of the training.
// What You Will Learn
Course Content:
GETTING STARTED
- Overview of SQL
- Install MySQL and the Workbench tool
- Create a database and write your first query
GETTING DATA FROM A SINGLE TABLE
- The SELECT statement
- The SELECT with WHERE clause
- AND, OR & NOT operators
- IN operator
- BETWEEN operator
- LIKE operator
- ORDER BY clause
- LIMIT clause
GETTING DATA FROM MULTIPLE TABLES
- Inner join
- Self join
- Implicit join
- Outer join
- Self Outer join
- The USING clause
- Natural join
- Cross join
INSERT, UPDATE AND DELETE DATA
- Insert a row
- Insert Multiple rows
- Updating a row
- Updating Multiple rows
- Using Subqueries to Update
- Deleting rows
- Restoring the database
SUMMARIZING DATA
- Aggregate function
- The GROUP BY clause
- The HAVING clause
- The ROLLUP operator
VIEWS
- Creating views
- Droping or Altering views
- Updatable views
STORED PROCEDURES
- Stored Procedure Overview
- Creating a Stored Procedure
- Dropping a Stored Procedure
- Parameters
- Parameters with default values
- Output Parameters
- Variables
- Functions
TRIGGERS
- Viewing triggers
- Dropping triggers
- Triggers events
DATABASE DESIGN
- What is database design ?
- Data modeling
- Primary and foreign keys
- Foreign keys constraints
- Normalization
- First, second and third normal forms
INDEXING FOR PERFORMANCE
- Indexes overview
- Creating indexes
- Viewing indexes
- Composite indexes
- Order of columns in composite indexes
CAPSTONE PROJECT
//Take the next step and speak to our admissions team.
Ready To Start Your Tech Journey?
// Your Trusted Career Partner
Where WebCapz Grads. Get Hired
// What Our Student Are Saying
We are Trusted
We are Trusted
3,000+ Students Trained
Christian Onyebuchi,
Graduate
"The training was an eye opener on the vulnerability and inherent risk we run as an institution. The training has empowered me to effectively mitigate the noted flaws in all platforms and block all loop holes that can be exploited by hackers."
Godsreward Ejike,
Programmer
"The training has been very interesting and useful. I learned a lot from one of the world’s leading authorities on Ethical Hacking in the person of Tim Pierson. WebCapz Technologies has done very well by bringing in the best to give the best."
Onome Ogunleye,
UI/UX Designer
"Kickstarting my IT career couldn’t have been easy with WebCapz Technologies, I had the best experience with them, wonderful staffs, and ultimately, with the knowledge I acquired, I got a job of my dream. Thanks to Team WebCapz."
MIke Agada,
General Manager
"This is to testify that the training was conducted in good ethical manner, the hospitality of the host was wonderful. Nancy the Logistic officer did a good job in making us comfortable. Generally, the training is satisfactory."
Peter Goteh
Full-Stack Engineer
"It's always an awesome experience learning at WebCapz Technologies. Support is always available even at the most unimaginable hours of the day and the mentorship even after the training is of immense value. Thank you Team WebCapz."
Ruth Onyije,
Backend Developer
"I used to think that software development is meant for only science students alone, but my experience with WebCapz Technologies changed my thought cause with what I have learned, I can now build & develop software applications."
// Frequently Asked Questions
FAQs
Can I make payment in installment?
Yes, we accept installment payment. You can discuss with our course administrator on available payment plans.
Do I need to have a prior knowledge of programming before I can enroll?
No prior programming experience is required. However, you need to know how to operate the computer efficiently. Our training approach is beginner friendly, and we work on several real-world projects to help our students have a deeper understanding of each module.
Will I be given a job immediately I finish the training?
We do not guarantee job. However, we do refer our students for jobs as different organization do reach out to us to hire our students. Some of our students have gotten job through this process.
What type of Laptop is required?
Depending on your budget, Core i7, 16GB RAM with SSD is best. However, core i3 or i5 with 4GB or 8 GB RAM HDD will also work fine. It can be HP, DELL, Mac or any other brand.
Is it a physical class?
Yes, our training is physical at Ada-George, Port Harcourt. However, those outside Nigeria or living far away can join us online via zoom or Google meet. The experience is similar.
