Posts

Showing posts with the label DATABASE

Be A White Hat Hacker and Pen Tester

Image
Be A White Hat Hacker and Pen Tester About this Course Become a white hat hacker and learn all the practical techniques for penetration testing with this amazing course which will provide conceptual framework to your security training. The course not only covers theoretical concepts but cover the practical demonstrations of various tools like Metasploit , Scapy and WireShark. The course is divided into the following main sections: Ethical Hacking Concepts -What is Ethical Hacking? Know about different types of hackers. Get to know about hacktivism and practical pen testing techniques Real World Information Gathering -Learn about foot printing and reconnaissance, Email harvesting, Learn and master SSL scan, Maltego, Whatweb, HttpRecon. Work on techniques like IP address geolocation, DNS and Mail Server Enumeration Scanning and Vulnerability Gathering -Learn to use scapy for packet crafting and port scanning, Learn to use network scanning techniques and work on vulnerability

Business Data Analyst:Excel/VBA/Macros/PowerQuery/PowerPivot

Image
What you'll learn Creating a data models Building relationships with connected data sources Preparing queries Enhancing queries Cleansing data Transforming data Creating Pivot Tables and Pivot Charts Creating Lookups Using DAX to link data Analyzing data with PivotTables and PivotCharts Using Power Query with PowerPivot Refreshing Data Source Creating and editingMacros Debugging Macros VBA Scripting Show less Requirements Basic knowledge of Excel is useful Description As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media. For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products fr

Practical Database Course for Beginners : 6 courses in 1

Image
Requirements No prior technical knowledge and experience required Description What our students says regarding this course! --- "I am a beginner with Databases and SQL and this course has been very informative and easy to follow." --  Eve Grant "The Course is very efficient i would highly recommend this course to all the newbies who are willing to learn Databases"  -- Ikram Khizer "Lovely! Compact course with proper guideline." --  Pensee Chouinard "Good information to get started."  -- Debashish Majumda " Detailed explanation about installing XAMPP and MySQL Workbench " -- Samuel Omokhafe Yusuf By completing this course, you will be able to read and write basic and complex queries using both RDBMS databases and NoSQL Databases. This course gives you hands-on and practical experience on the world most popular RDBMS databases like MySQL, and NoSQL databases like MongoDB,  Redis, more. This skills are also applicable to any ot

SQL Masterclass: SQL for Data Analytics

Image
What you'll learn Knowledge of all the essential SQL commands Become proficient in SQL tools like GROUP BY, JOINS and Subqueries Become competent in using sorting and filtering commands in SQL Master SQL's most popular string, mathematical and date-time functions Enhance the performance of your Database by using Views and Indexes Increase your efficiency by learning the best practices while writing SQL queries Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas Solid understanding of SQL Requirements Just a PC with any web browser Description 6 Reasons why you should choose this SQL course Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses Comprehensive - covers basics, advanced SQL statements, interview tips and performance tuning tips as well Business related examples and case studies Ample practice exercises because SQL requires practice Downloadable resources You

The Complete SQL Bootcamp 2021: from Zero to Hero SQL

Image
What you'll learn Create your own database or interact with existing databases Answer company performance or sales questions using data Model real-world data and generate reports using SQL Use SQL to query a database Replicate real-world situations and query reports Write complex SQL queries across multiple tables The freedom to query anything you like from a database Tons of exercises that will solidify your knowledge Get maximum preparation for real-life database management Obtain the Skills that are Necessary to Land a Job as a SQL Developer Requirements No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome. No prior technical experience is required! All you need a computer! Description WELCOME TO Full SQL Bootcamp of  SS ACADEMY! If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to  MySQL ,

MySQL Database Development Mastery

Image
What you'll learn Basic Database Design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization) How to Use install and MySQL Workbench SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping) DELETE: How to remove data from a database INSERT INTO: How to insert data into a table UPDATE: How to update existing data Overall Database Development Best Practices Creating Relationships and Foreign Keys How to craft SQL statements based on real scenarios How to export Query Results to Excel Using Aggregate Functions in SQL How to query related data from multiple tables Requirements A Reliable Computer A desire to learn database development Description Overview This is a zero to hero course on MySQL Database Server and MySQL Workbench. There are no pre-requisites for this course. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you. Why Learn MySQL MySQL is the world’s most

SQLite & SQL - Pirate Adventure with Shady Deals & Rum!

Image
Requirements No requirements needed Description Welcome to SQisLand where a SQL Pirate Adventure awaits you! Learn SQL while making short work of criminals with the Governor, helping the Lieutenant Commander to find convicted inmates and making a deal with the shady Padre Luigi. Ending in the ultimate construction of a sugar plantation with attached rum distillery! You are going to be a SQL-Pirate and unlock the treasures of SQL! Yarr har fiddle dee dee, Do what you want cause a pirate is free, you are a pirate! This course teaches you about: Why learn SQL?, Who should learn SQL?, Difference of Lightweight and Centralized Databases, Choose a suitable Database Solution, Database Design, Relational Databases, Filtering Records, Advanced Query Modifiers, Grouping Records, Sorting Records, Aggregating Records, Filtering on already aggregated Records, Table Design, SQLite Studio In this course you will live through the following adventures: Start as a pirate candidate on your wa