-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `lovekbkg_owalam`
--

-- --------------------------------------------------------

--
-- Table structure for table `blogcategories`
--

CREATE TABLE `blogcategories` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blogcategories`
--

INSERT INTO `blogcategories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Business', '2024-05-07 12:45:13', '2024-05-07 12:45:13'),
(2, 'Finance', '2024-05-07 12:45:17', '2024-05-07 12:45:17'),
(3, 'Web Design', '2024-05-07 12:45:22', '2024-05-07 12:45:22'),
(4, 'Counsiling', '2024-05-07 12:45:27', '2024-05-07 12:45:27'),
(5, 'IT Service', '2024-05-07 12:45:32', '2024-05-07 12:45:32');

-- --------------------------------------------------------

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `slug` text DEFAULT NULL,
  `heading` text DEFAULT NULL,
  `categoryid` int(11) NOT NULL,
  `status` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `slug`, `heading`, `categoryid`, `status`, `image`, `tags`, `description`, `created_at`, `updated_at`) VALUES
(8, 'conquering-the-sats-your-key-to-unlocking-merit-scholarship-dollars', 'Conquering the SATs: Your Key to Unlocking Merit Scholarship Dollars', 5, 'active', '1722317991WhatsApp Image 2024-07-26 at 21.08.35_904e36ce.jpg', 'school,SAT,scholarships', '<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">For many high school students, the SAT looms large as a crucial hurdle in the college admissions race. But beyond just securing a coveted acceptance letter, a strong SAT score can be your golden ticket to a treasure trove of merit-based scholarships. Here\'s how scoring high on the SATs can significantly boost your chances of landing valuable financial aid.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Merit Aid Magnet: How SATs Open Scholarship Doors</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Colleges use a variety of factors to evaluate scholarship applications, and a high SAT score is a prominent one. It demonstrates your academic ability and preparedness for college-level coursework. This, in turn, makes you a more attractive candidate in the eyes of scholarship committees. Many universities offer merit-based scholarships with specific SAT score thresholds. Scoring above these thresholds can guarantee you a certain level of scholarship funding, making college significantly more affordable.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Beyond Thresholds: The Scholarship Spectrum</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Even if your target schools don\'t offer guaranteed scholarships based solely on SAT scores, a high score still plays a vital role. It strengthens your overall application, making you a more competitive applicant for scholarships with broader criteria. Scholarship committees often consider a combination of factors like GPA, extracurricular involvement, and &ndash; you guessed it &ndash; SAT scores. A strong performance on the SATs can tip the scales in your favor, giving you an edge over applicants with similar GPAs or activities.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The Money Matters: Bigger Scores Mean Bigger Awards</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The impact of a high SAT score goes beyond just increasing your chances of receiving a scholarship. In many cases, the higher you score, the more scholarship money you might be eligible for. Some universities offer tiered merit scholarships, with progressively larger awards for students who score within specific SAT ranges. So, pushing yourself to achieve a top score on the SATs can translate into a substantial financial benefit, potentially covering a significant portion of your college expenses.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Beyond the Score: A Well-Rounded Approach</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">While a high SAT score is undeniably valuable, it\'s important to remember that it\'s just one piece of the puzzle. Colleges are looking for well-rounded individuals, so don\'t neglect other aspects of your application. Maintain a strong GPA, participate in meaningful extracurricular activities, and craft compelling essays that showcase your unique voice and aspirations.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Optimizing Your SAT Strategy: Tips for Success</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">So, how can you ensure you conquer the SATs and unlock the door to scholarship opportunities? Here are some key strategies:</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Start Early:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Don\'t wait until the last minute to begin preparing. Familiarize yourself with the test format and content areas well in advance.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Practice Makes Perfect:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Take advantage of practice tests and identify your strengths and weaknesses. Focus your prep efforts on areas that need improvement.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Seek Guidance:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Consider enrolling in an SAT prep course or working with a tutor to get personalized guidance and strategies.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Manage Test Anxiety:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Develop relaxation techniques to stay calm and focused during the actual test.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The Bottom Line: Acing the SATs is an Investment in Your Future</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">By dedicating time and effort to preparing for the SATs, you\'re not just improving your chances of college acceptance &ndash; you\'re opening doors to significant financial aid opportunities. A strong SAT score can be the key to unlocking merit-based scholarships that ease the financial burden of higher education. So, take control of your future, conquer the SATs, and watch those scholarship dollars roll in!</span></p>', '2024-07-30 09:13:52', '2024-07-30 09:39:51'),
(9, 'bright-futures-take-flight-african-student-enrollment-soars-at-top-us-universities-2022-data', 'Bright Futures Take Flight: African Student Enrollment Soars at Top US Universities (2022 Data)', 4, 'active', '1722318025WhatsApp Image 2024-07-26 at 21.08.36_af7fbfda.jpg', 'students,Scholarship,Technology', '<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">In 2022, US universities witnessed a significant rise in the number of African students receiving full-ride scholarships.</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> This exciting trend highlights the immense potential of African talent and the growing commitment of US institutions to fostering a diverse and vibrant academic environment.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Why This Matters:</span></strong></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">A Rising Tide of Talent:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> This surge in admissions reflects the exceptional academic achievements of African students. It\'s a testament to their dedication and a positive indicator for global knowledge exchange.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Diversity on Campus:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> A wider range of nationalities enriches the learning experience for all students. Exposure to different perspectives fosters innovation and critical thinking.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Investing in the Future:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> By supporting African scholars, US universities are investing in future leaders who will contribute to positive change on a global scale.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">What We Don\'t Know (Yet):</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Unfortunately, official data on the exact number of African students receiving full rides in 2022 might not be readily available until later in the year. However, several universities have reported an increase in applications and acceptances from African countries.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Stay Tuned!</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">We\'ll update this post with specific figures once official data is released. In the meantime, let\'s explore some of the factors contributing to this positive trend:</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Increased Scholarship Opportunities:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Many universities are establishing dedicated scholarships specifically for African students. This makes studying in the US a more attainable dream for many talented individuals.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Focus on STEM Fields:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> There\'s a growing recognition of the exceptional talent African students bring to STEM fields (Science, Technology, Engineering, and Math). Universities are actively seeking these scholars.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Improved University Outreach:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> US institutions are increasingly reaching out to high-performing students in Africa, providing them with guidance and support throughout the application process.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Are You an Aspiring African Student?</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">If you\'re a high-achieving student from Africa dreaming of studying in the US, here are some resources to get you started:</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo3; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">List of Top Scholarships for African Students in the US</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> ([scholarships for african students in usa ON Degreeola degreeola.com])</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo3; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">US Department of State: Educational Programs</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> ([US Department of State educational programs ON U.S. Department of State (.gov) state.gov])</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Join the Conversation!</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Share your thoughts and experiences in the comments below. Are you an African student who has been accepted to a US university with a full scholarship? We\'d love to hear your story!</span></p>', '2024-07-30 09:15:41', '2024-07-30 09:40:25'),
(10, 'score-high-play-hard-landing-a-us-college-sports-scholarship-as-an-international-student-athlete', 'Score High, Play Hard: Landing a US College Sports Scholarship as an International Student-Athlete', 4, 'active', '1722318075WhatsApp Image 2024-07-26 at 21.08.36_51107590.jpg', 'College,Scholarship,Student-Athlete', '<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">For international student-athletes, the dream of competing in the US while earning a degree is an exciting one. But the path to securing a coveted sports scholarship can seem daunting. This guide unlocks the secrets for international athletes to leverage their academic prowess alongside their athletic talent, maximizing their chances of landing the perfect scholarship opportunity.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Academic Benchmarks: The SAT Score Matchup</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">The NCAA, the governing body for college athletics in the US, sets academic eligibility requirements. These include core-course completion and minimum SAT or ACT scores. To be eligible for a Division I or II scholarship, your SAT score should ideally <strong>match or exceed</strong> the score on the NCAA sliding scale that corresponds to your core-course GPA.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Here\'s where international students need to be extra proactive. The SAT is not universally administered in all countries. If your national exams aren\'t accepted by the NCAA, you\'ll need to take the SAT itself. Plan well in advance to register for the test at a testing center in your region.</span></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Beyond the Score: Building a Strong Academic Profile</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">A high SAT score is a fantastic starting point, but remember, scholarships are awarded to well-rounded individuals. Here\'s how to strengthen your academic profile:</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Maintain a strong GPA:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Consistent academic performance throughout high school demonstrates your commitment to learning and your ability to manage a demanding schedule.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Highlight rigorous coursework:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Take challenging courses in core subjects like math, science, and English. This showcases your academic preparedness for a US college curriculum.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l0 level1 lfo1; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Consider standardized tests in your country:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> If your country has a national standardized test, include it in your application. It provides additional evidence of your academic ability.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Promoting Your Athletic Prowess</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">While academics are crucial, your athletic skills are the key that unlocks the scholarship door. Here\'s how to showcase your talent:</span></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Create a compelling highlight video:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Invest in a high-quality video showcasing your best athletic moments during games and competitions. Edit it professionally and share it with coaches via email or recruiting platforms.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Connect with coaches directly:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Research colleges with strong programs in your sport and contact the coaches. Briefly introduce yourself, highlight your achievements, and express your interest in their program.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l1 level1 lfo2; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Utilize recruiting services:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Consider using reputable recruiting services specializing in connecting international athletes with US colleges. Their expertise can streamline the process and increase your visibility.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Additional Tips for International Student-Athletes</span></strong></p>\r\n<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo3; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">NCAA Eligibility Center:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Register with the NCAA Eligibility Center early. This ensures compliance with NCAA amateurism rules and allows colleges to verify your academic credentials.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo3; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Language proficiency:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Demonstrate your English language proficiency by taking the TOEFL or IELTS exams. Strong communication skills are essential for success in a US college environment.</span></li>\r\n<li class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal; mso-list: l2 level1 lfo3; tab-stops: list .5in;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Visa considerations:</span></strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\"> Research student visa requirements for the US and initiate the application process well in advance.</span></li>\r\n</ul>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><strong><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Conclusion</span></strong></p>\r\n<p class=\"MsoNormal\" style=\"mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; line-height: normal;\"><span lang=\"EN-GB\" style=\"font-family: \'Times New Roman\',serif; mso-fareast-font-family: \'Times New Roman\'; mso-font-kerning: 0pt; mso-ligatures: none; mso-fareast-language: EN-GB;\">Landing a US college sports scholarship as an international student-athlete requires a strategic approach. By focusing on academic excellence, crafting a strong athletic profile, and taking advantage of available resources, you can turn your dream into reality. Remember, hard work, dedication, and strategic planning are the keys to unlocking your full potential and achieving success on and off the field.</span></p>', '2024-07-30 09:16:58', '2024-07-30 09:41:15');

-- --------------------------------------------------------

--
-- Table structure for table `community_chat`
--

CREATE TABLE `community_chat` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `message` longtext DEFAULT NULL,
  `send_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `community_chat`
--

INSERT INTO `community_chat` (`id`, `userid`, `message`, `send_by`, `created_at`, `updated_at`) VALUES
(102, 92, 'hello', 92, '2024-05-10 19:22:08', '2024-05-10 19:22:08'),
(103, 93, 'Hi', 93, '2024-05-10 19:23:55', '2024-05-10 19:23:55'),
(104, 92, 'how are you', 92, '2024-05-10 19:24:27', '2024-05-10 19:24:27'),
(105, 93, 'im good.', 93, '2024-05-10 19:24:44', '2024-05-10 19:24:44'),
(106, 92, 'cool', 92, '2024-05-10 19:25:17', '2024-05-10 19:25:17'),
(107, 96, 'wonderful', 96, '2024-05-10 19:54:39', '2024-05-10 19:54:39'),
(108, 97, 'Ok', 97, '2024-05-13 03:24:06', '2024-05-13 03:24:06'),
(109, 92, 'hello !', 92, '2024-05-14 20:16:56', '2024-05-14 20:16:56'),
(110, 96, 'How\'s everyone doing today? What part of the world are you signing in from?', 96, '2024-05-24 02:26:55', '2024-05-24 02:26:55');

-- --------------------------------------------------------

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `subject` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` (`id`, `name`, `email`, `subject`, `phone`, `message`, `created_at`, `updated_at`) VALUES
(106, 'Driscoll Barr', 'wegesiqyq@mailinator.com', 'Temporibus a in cupi', '+1 (517) 863-8187', 'Amet mollit deserun', '2024-05-08 03:40:55', '2024-05-08 03:40:55');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lectures`
--

CREATE TABLE `lectures` (
  `id` int(11) NOT NULL,
  `slug` text DEFAULT NULL,
  `heading` text DEFAULT NULL,
  `lectureby` text DEFAULT NULL,
  `category` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `link` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lectures`
--

INSERT INTO `lectures` (`id`, `slug`, `heading`, `lectureby`, `category`, `description`, `tags`, `image`, `link`, `created_at`, `updated_at`) VALUES
(1, 'data-handling-and-analysis-with-pandas', 'Data Handling and Analysis with Pandas', 'By Angela', 'Development', '<h2 class=\"mb-3\">Python for Data Science &amp; Machine Learning</h2>\r\n<p class=\"mb-4\">The Python for Data Science &amp; Machine Learning course is designed to equip learners with the fundamental skills and knowledge needed to excel in the rapidly growing field of data science and machine learning. This comprehensive course covers essential Python programming concepts along with advanced topics specific to data analysis, visualization, and machine learning algorithms.</p>\r\n<ul class=\"p-0 m-0 single-check-inner mt-3 pt-3 mb-5\">\r\n<li><img src=\"../website/images/about/5.png\" alt=\"img\">&nbsp;Students will work on a real-world predictive analysis project, where they apply machine learning algorithms to predict outcomes based on historical data. They will learn how to preprocess data, select appropriate features, train machine learning models, and evaluate model performance.</li>\r\n<li><img src=\"../website/images/about/5.png\" alt=\"img\">&nbsp;Through a hands-on data visualization project, participants will create informative and visually appealing plots to communicate insights from a given dataset. They will apply various visualization techniques learned in the course to present data effectively.</li>\r\n</ul>\r\n<h4>Assessment and Certification</h4>\r\n<p>Throughout the course, learners will engage in quizzes, assignments, and projects to reinforce their understanding of the concepts covered. Upon successful completion of the course, participants will receive a certificate of completion, validating their proficiency in Python for data science and machine learning.</p>\r\n<div class=\"row\">\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-3\">\r\n<li>Learn fundamental Python programming concepts</li>\r\n<li>Master data handling and analysis with Pandas</li>\r\n<li>Create insightful plots using Matplotlib and Seaborn</li>\r\n<li>Understand supervised and unsupervised learning</li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-4\">\r\n<li>Explore popular machine learning algorithms</li>\r\n<li>Apply machine learning for predictive modeling</li>\r\n<li>Reinforce learning with interactive assessments</li>\r\n<li>Earn recognition for mastering Python for data science</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<p>The Python for Data Science &amp; Machine Learning course offers a structured learning path for individuals aspiring to enter the field of data science or enhance their existing skills. With a blend of theoretical knowledge and practical experience gained through hands-on projects, participants will be well-prepared to tackle real-world data challenges and make meaningful contributions in the data-driven industry.</p>', 'Development,Learning,Education', '17151505981.png', NULL, '2024-05-08 01:43:18', '2024-05-08 01:43:18');
INSERT INTO `lectures` (`id`, `slug`, `heading`, `lectureby`, `category`, `description`, `tags`, `image`, `link`, `created_at`, `updated_at`) VALUES
(2, 'fundamentals-of-machine-learning', 'Fundamentals of Machine Learning', 'By John', 'Design', '<p style=\"text-align: left;\">The Python for Data Science &amp; Machine Learning course is designed to equip learners with the fundamental skills and knowledge needed to excel in the rapidly growing field of data science and machine learning. This comprehensive course covers essential Python programming concepts along with advanced topics specific to data analysis, visualization, and machine learning algorithms.</p>\r\n<ul class=\"p-0 m-0 single-check-inner mt-3 pt-3 mb-5\" style=\"text-align: left;\">\r\n<li>&nbsp;Students will work on a real-world predictive analysis project, where they apply machine learning algorithms to predict outcomes based on historical data. They will learn how to preprocess data, select appropriate features, train machine learning models, and evaluate model performance.</li>\r\n<li>Through a hands-on data visualization project, participants will create informative and visually appealing plots to communicate insights from a given dataset. They will apply various visualization techniques learned in the course to present data effectively.</li>\r\n</ul>\r\n<p><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"data:image/png;base64,[BLOB]\" width=\"211\" height=\"151\"></p>\r\n<h4 style=\"text-align: left;\">Assessment and Certification</h4>\r\n<p style=\"text-align: left;\">Throughout the course, learners will engage in quizzes, assignments, and projects to reinforce their understanding of the concepts covered. Upon successful completion of the course, participants will receive a certificate of completion, validating their proficiency in Python for data science and machine learning.</p>\r\n<div class=\"row\" style=\"text-align: left;\">\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-3\">\r\n<li>Learn fundamental Python programming concepts</li>\r\n<li>Master data handling and analysis with Pandas</li>\r\n<li>Create insightful plots using Matplotlib and Seaborn</li>\r\n<li>Understand supervised and unsupervised learning</li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-4\">\r\n<li>Explore popular machine learning algorithms</li>\r\n<li>Apply machine learning for predictive modeling</li>\r\n<li>Reinforce learning with interactive assessments</li>\r\n<li>Earn recognition for mastering Python for data science</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<p style=\"text-align: left;\">The Python for Data Science &amp; Machine Learning course offers a structured learning path for individuals aspiring to enter the field of data science or enhance their existing skills. With a blend of theoretical knowledge and practical experience gained through hands-on projects, participants will be well-prepared to tackle real-world data challenges and make meaningful contributions in the data-driven industry.</p>', 'Development,Design,Learning,Education,Python Programing,Flask', '17151510844.png', 'https://www.interactions.com/wp-content/uploads/2017/06/machine_learning_wp-5.pdf', '2024-05-08 01:51:24', '2024-05-08 03:30:17');
INSERT INTO `lectures` (`id`, `slug`, `heading`, `lectureby`, `category`, `description`, `tags`, `image`, `link`, `created_at`, `updated_at`) VALUES
(3, 'python-for-data-science-machine', 'Python for Data Science & Machine', 'By Marshell', 'Programing', '<h2 class=\"mb-3\">Python for Data Science &amp; Machine Learning</h2>\r\n<p class=\"mb-4\">The Python for Data Science &amp; Machine Learning course is designed to equip learners with the fundamental skills and knowledge needed to excel in the rapidly growing field of data science and machine learning. This comprehensive course covers essential Python programming concepts along with advanced topics specific to data analysis, visualization, and machine learning algorithms.</p>\r\n<div class=\"row\">\r\n<div class=\"col-md-6 mb-3 mb-md-0\"><img class=\"w-100\" src=\"../website/images/course/1.png\" alt=\"img\"><img class=\"w-100\" style=\"float: right;\" src=\"../website/images/course/2.png\" alt=\"img\"></div>\r\n</div>\r\n<ul class=\"p-0 m-0 single-check-inner mt-3 pt-3 mb-5\">\r\n<li><img src=\"../website/images/about/5.png\" alt=\"img\">&nbsp;Students will work on a real-world predictive analysis project, where they apply machine learning algorithms to predict outcomes based on historical data. They will learn how to preprocess data, select appropriate features, train machine learning models, and evaluate model performance.</li>\r\n<li><img src=\"../website/images/about/5.png\" alt=\"img\">&nbsp;Through a hands-on data visualization project, participants will create informative and visually appealing plots to communicate insights from a given dataset. They will apply various visualization techniques learned in the course to present data effectively.</li>\r\n</ul>\r\n<h4>Assessment and Certification</h4>\r\n<p>Throughout the course, learners will engage in quizzes, assignments, and projects to reinforce their understanding of the concepts covered. Upon successful completion of the course, participants will receive a certificate of completion, validating their proficiency in Python for data science and machine learning.</p>\r\n<div class=\"row\">\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-3\">\r\n<li>Learn fundamental Python programming concepts</li>\r\n<li>Master data handling and analysis with Pandas</li>\r\n<li>Create insightful plots using Matplotlib and Seaborn</li>\r\n<li>Understand supervised and unsupervised learning</li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-6\">\r\n<ul class=\"p-0 m-0 single-check-inner style-dot mt-4\">\r\n<li>Explore popular machine learning algorithms</li>\r\n<li>Apply machine learning for predictive modeling</li>\r\n<li>Reinforce learning with interactive assessments</li>\r\n<li>Earn recognition for mastering Python for data science</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<p>The Python for Data Science &amp; Machine Learning course offers a structured learning path for individuals aspiring to enter the field of data science or enhance their existing skills. With a blend of theoretical knowledge and practical experience gained through hands-on projects, participants will be well-prepared to tackle real-world data challenges and make meaningful contributions in the data-driven industry.</p>', 'Development,Education,learning,Coding', '17151528125.png', 'https://docs.python.org/3/', '2024-05-08 02:20:12', '2024-05-08 02:20:12');

-- --------------------------------------------------------

--
-- Table structure for table `practice_lectures`
--

CREATE TABLE `practice_lectures` (
  `id` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `link` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `practice_lectures`
--

INSERT INTO `practice_lectures` (`id`, `heading`, `image`, `slug`, `link`, `created_at`, `updated_at`) VALUES
(3, 'Math Practice Test', '1715705712GCSE-Mathematics-Paper-Class_V4 (1).jpg', 'math-practice-test', 'https://www.youtube.com/watch?v=I3GWzXRectE', '2024-05-14 20:55:12', '2024-05-14 20:55:12'),
(4, 'English Practice Test', '1715705793images.jpeg', 'english-practice-test', 'https://www.youtube.com/watch?v=I3GWzXRectE', '2024-05-14 20:56:33', '2024-05-14 20:56:33');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blogcategories`
--
ALTER TABLE `blogcategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categoryid` (`categoryid`);

--
-- Indexes for table `community_chat`
--
ALTER TABLE `community_chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `send_by` (`send_by`);

--
-- Indexes for table `contactus`
--
ALTER TABLE `contactus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `lectures`
--
ALTER TABLE `lectures`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `practice_lectures`
--
ALTER TABLE `practice_lectures`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blogcategories`
--
ALTER TABLE `blogcategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `community_chat`
--
ALTER TABLE `community_chat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT for table `contactus`
--
ALTER TABLE `contactus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lectures`
--
ALTER TABLE `lectures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `practice_lectures`
--
ALTER TABLE `practice_lectures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_ibfk_1` FOREIGN KEY (`categoryid`) REFERENCES `blogcategories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `community_chat`
--
ALTER TABLE `community_chat`
  ADD CONSTRAINT `community_chat_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `community_chat_ibfk_2` FOREIGN KEY (`send_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

