Group By and Having Concept in MySQL - MySQL Tutorial for Beginners
Learn to use GROUP BY and HAVING clauses in MySQL for data aggregation and filtering. Includes practical demonstrations to master these essential SQL concepts for effective database querying.
Case Statement in MySQL - MySQL Tutorial for Beginners
Learn about Case Statements in SQL. In many cases, there’s not any ELSE clause and when none of the conditions are true and we don’t even have an ELSE clause, then NULL is returned.
Azure Tutorial for Beginners - Microsoft Azure Full Course
Comprehensive introduction to Microsoft Azure, covering key concepts, services, and features. Ideal for beginners seeking to understand cloud computing fundamentals and Azure's capabilities.
Oracle SQL Tutorial
Comprehensive introduction to Oracle SQL, covering table creation, relational models, functions, clauses, joins, and database objects. Ideal for beginners seeking practical skills in data management and manipulation.
MongoDB Tutorial for Absolute Beginners
Comprehensive introduction to MongoDB, covering NoSQL concepts, installation, database creation, CRUD operations, and querying. Ideal for beginners seeking hands-on experience with this popular document-oriented database.
SQL Triggers - SQL Tutorial for Beginners with Examples
Learn SQL triggers: automate database actions, enhance data integrity, and streamline workflows. Explore syntax, types, and practical examples for efficient database management.
MySQL Playlist
Comprehensive MySQL tutorial covering installation, database operations, constraints, indexing, views, joins, and stored procedures, with interview preparation and query solving.
MongoDB with Python
Learn to integrate MongoDB with Python, covering installation, CRUD operations, querying, updating, aggregation, and cloud deployment using MongoDB Atlas.
Geodatabase Talk
Explore Esri's Geodatabase technology through a comprehensive podcast series covering key concepts, functionalities, and advanced features in GIS data management and analysis.
MySQL Stored Procedures and Functions
Learn to create and use MySQL stored procedures and functions, including variables, syntax, and database API integration.
DB2 Tutorials
Comprehensive guide to DB2 SQL: from basics to advanced concepts. Learn data structures, CRUD operations, relationships, normalization, and integrity constraints for effective database management.
SQL Basics for Data Analysts
Learn essential SQL commands for data analysis: Select, From, Where, Group By, and Order By. Create tables, insert data, and prepare for intermediate SQL concepts.
Intermediate SQL Tutorials
Explore advanced SQL concepts like joins, unions, case statements, and data manipulation to enhance your database querying skills and data analysis capabilities.
Advanced SQL Tutorials
Enhance SQL skills with CTEs, temp tables, string functions, stored procedures, and subqueries for advanced database management and analysis.
Data Analyst Portfolio Projects
Comprehensive guide to building a data analyst portfolio through hands-on projects in SQL, Tableau, Python, and Excel, covering data exploration, visualization, cleaning, and analysis.
Data Science Fundamentals
Learn essential data science skills: exploration, manipulation, cleaning, and analysis using Python, Pandas, SQL, and more. Ideal for beginners seeking practical knowledge.
SQL - Database Programming
Comprehensive SQL tutorial covering database basics, CRUD operations, advanced queries, and schema design. Ideal for beginners learning MySQL and database management fundamentals.
Database Design
Comprehensive exploration of database design concepts, from basics to advanced topics, covering relationships, keys, normalization, and SQL joins for a deeper understanding of database architecture.
Oracle SQL Tutorials
Comprehensive Oracle SQL tutorial series covering database design, SQL fundamentals, data types, constraints, and querying. Ideal for beginners and intermediate learners seeking practical skills.
SQL Tutorials
Learn essential SQL concepts, from database basics to advanced queries, with hands-on practice using MySQL. Ideal for beginners starting their data science journey.
Spring Boot Tutorial Using JDBC, Connection Pool, Flyway, JDBC Template, SQL, and Docker
Learn to integrate JDBC, connection pools, Flyway, and JDBC Template with Spring Boot for efficient database operations. Covers Docker setup, SQL queries, and practical implementation techniques.