Watch my latest course – Play by Play: Pinal Dave where I demonstrate how to tune your SQL Server in real time. Geoffrey Grosenbach sits down with me and ask many difficult questions, at times I was not sure how will do tune the server. Finally, I go over my basics and end up over optimizing queries and fine-tuning the server.

Click to View Course

SQL Server 2014 Administration New Features

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancements, Resource Governor, General Administration, Azure integration, extensions with SQL Server 2014 and more.
Click to View Course

SQL Server Performance: Introduction to Query Tuning

SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
Click to View Course

SQL Server Performance: Indexing Basics

Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is a good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of the server.
Click to View Course

SQL Server Questions and Answers

This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works. This course is for anyone working with SQL Server databases who wants to improve her knowledge and understanding of this complex platform.
Click to View Course

MySQL Fundamental – 1

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. This course covers the fundamentals of MySQL, including how to install MySQL as well as written basic data retrieval and data modification queries.
Click to View Course

MySQL Fundamental – 2

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced topics such as stored procedures & user-defined functions, subqueries & joins, views and events & triggers.
Click to View Course

MySQL Indexing for Performance

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of Indexes and further explore practical tips and tricks for performance tuning.
Click to View Course

MySQL Query Optimization and Performance Tuning

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.
Click to View Course

Play by Play: Pinal Dave

Geoffrey Grosenbach sits down with Pinal Dave to see what a SQL Server Admin does in the real world. This Play-by-Play will focus on SQL Server performance tuning. Pinal goes over optimizing queries and fine-tuning the server.
Click to View Course

MySQL Workbench Guided Tour

A detailed exploration of MySQL Workbench, a unified visual tool for data modeling, SQL development, and comprehensive administration tools for MySQL. This course will guide you through maximizing the power of MySQL Workbench and getting productive quickly with MySQL.
Click to View Course

phpMyAdmin Fundamentals

phpMyAdmin is a free and open source tool written in PHP for the administration of MySQL via a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. This course will guide you through maximizing the power of phpMyAdmin to get productive quickly with MySQL.
Click to View Course

MySQL Backup and Recovery Fundamentals

Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strategies are often discussed after the disaster has already happened. In this introductory course we will explore a few of the basic backup strategies every business should implement for data safely. We will explore how we can recover our server quickly after any unfriendly incident to our MySQL database.
Click to View Course

Building a High Traffic, Profitable Blog

Everybody can write, and everybody can build a blog. But not everyone can make their blog a popular point of reference for their subject matter. Content is king – but a king also has ministers to help, and good content needs help from various aspects of the real world.
Click to View Course

Building a Successful Blog

Expressing yourself is the most common behavior of humans. Blogging has made easy to express yourself. Just like a letter or book has a structure and formula, blogging also has structure and formula. In this introductory course on blogging we will go over a few of the basics of blogging and show the way to get started with blogging immediately. If you already have a blog, this course will be even more relevant as this will discuss many of the common questions and issue you face in your blogging routine.
Click to View Course

Introduction to ColdFusion

ColdFusion is rapid web application development platform. In this course you will learn the basics of how to use ColdFusion platform and rapidly develop web sites. The course begins with learning basics of ColdFusion Markup Language and moves to common development language practices. From there we move to frequent database operations and advanced concepts of Forms, Sessions and Cookies. The last module sums up all the concepts covered in the course with sample application.
Click to View Course

Introduction to SQuirreL Universal SQL Client

Every single database has its own integrated development environment (IDE) to facilitate database developers to perform various database tasks like writing code, automating processes, and debugging. SQuirreL SQL Client is a universal SQL client supporting over 60 different popular databases. It allows users to view the structure of a database, browse the data in tables, issue SQL commands, and more.
Click to View Course

PostgreSQL: Getting Started

PostgreSQL is commonly known as Postgres and is is often referred to as a the world’s most advanced open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.
Click to View Course

PostgreSQL: Introduction to SQL Queries

PostgreSQL, commonly known as Postgress, is often called the world’s most advanced open-source database. In this course, we will learn about various datatypes and their impact on performance and database designs. We will learn about various table operations, schemas, keys, and constraints. We will also learn how to efficiently retrieve data and make modification to data with insert, update, and delete operations.
Click to View Course

PostgreSQL: Advanced SQL Queries

PostgreSQL is commonly known as Postgress. It is often referred to as the world’s most advanced open source database. In this course, we will discuss advanced queries for PostgreSQL. We will learn about functions and operators, type conversions, and transactions.
Click to View Course

PostgreSQL: Advanced Server Programming

PostgreSQL is one of the most advanced and popular open-source databases out there. If you’re a database developer looking to expand your skills and understanding of triggers, rules, and procedural language in PostgreSQL, this course is for you.
Click to View Course

PostgreSQL: Index Tuning and Performance Optimization

PostgreSQL is commonly known as Postgress. Data is critical to any application, and database performance goes hand-in-hand with it. In this course, you’ll get to see some ways to maximize database performance with PostgreSQL, covering indexes, best practices, and more.
Click to View Course