SKILLSHARE SQL INTRODUCTION TO QUERYING DATABASES

SKILLSHARE SQL INTRODUCTION TO QUERYING DATABASES

SKILLSHARE SQL INTRODUCTION TO QUERYING DATABASES
English | Size: 513.72 MB
Category: Tutorial

In this class you will learn the basics for how to query a database. You will learn how to:

Use the SELECT statement to return data from a table.
Filter your data selection using the WHERE clause.
Use the IN, LIKE and BETWEEN statements to filter your results in more detail.
Order your results sets. [Read more…]

SKILLSHARE SQL MASTER DATABASE QUERIES IN 90 MINUTES

SKILLSHARE SQL MASTER DATABASE QUERIES IN 90 MINUTES
English | Size: 252.85 MB
Category: CBTs

Last time you tried to get a report from your raw data, however writing SQL queries proved to be a troublesome task..

But it doesn’t have to be this way!

You Will Walk Away With…

MORE TIME!
Master writing SQL queries in just 90 minutes!
Understand the essence of these queries, without memorizing them!
See how each of these queries are used with real examples!
After this class you will be able to:
[Read more…]

SKILLSHARE THE COMPLETE SQL SERVER FOR BEGINNERS

SKILLSHARE THE COMPLETE SQL SERVER FOR BEGINNERS
English | Size: 1.19 GB
Category: Tutorial

Welcome to the Complete SQL Server For Beginners Course, The ultimate practical guide to master SQL Server for developers.

This course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course.

This course will guide you how to install SQL Server on a local machine step by step and even how to create your own cloud databases on the most required cloud services providers in the market…AWS (Amazon Web Services) and Microsoft Azure. [Read more…]

SQL Server Step By Step For Beginners

SQL Server step by step for beginners
English | Size: 2.55 GB
Category: CBTs

sql server for beginners
These step by step video lessons will teach you SQL Server step by step from scratch.

Description
It has 20 labs which covers the below syllabus.

Lab 1:- Basic Fundamentals Database, Tables, rows and columns.

Lab 2:- Primary key, foreign key, referential integrity and constraints.
[Read more…]

PluralSight SQL Server 2017 Diagnosing Performance Issues with DMVs

PluralSight SQL Server 2017 Diagnosing Performance Issues with DMVs
English | Size: 341.26 MB
Category: Tutorial

Release Notes: It is very common for SQL Server instances to have workload performance problems in one or more ways. In this course, SQL Server 2017: Diagnosing Performance Issues with DMVs, you will see more than 45 DMV
queries you can use to easily examine performance information related to your workload, instance health, and storage health. First, you will learn how to detect and correct many common performance issues related to the overall activity on the SQL Server instance and around the storage subsystem. Next, you will be shown how to investigate memory and CPU issues at the instance level. Finally, you will see how to drill into the database level and investigate performance issues there By the end of this course, you will be able to find and correct the most common SQL Server performance issues. This course is perfect for anyone who is responsible for a SQL Server 2017 instance, with most
topics also applicable to SQL Server 2016 and earlier versions [Read more…]

SQL & PostgreSQL From beginner to pro

SQL & PostgreSQL From beginner to pro
English | Size: 873.09 MB
Category: Tutorial

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 designed to help you master SQL & PostgreSQL, one of the most highly in-demand skills in the computer science sector today.

It doesn’t matter who you are, whether you are a business owner, marketer or programmer. This course will teach you everything even if you don’t have any previous experience. I try to make this course as engaging as possible. Yes, that’s right, it’s possible to make an engaging course on databases. [Read more…]

SAMS SQL SERVER REPLICATION FUNDAMENTALS LIVELESSONS

SAMS SQL SERVER REPLICATION FUNDAMENTALS LIVELESSONS
English | Size: 5.81 GB
Category: Tutorial

Everything you need to know in order to implement and work with SQL Server Replication! Replication is a common method of moving from one SQL Server to another. It enables moving data to a reporting server, creating a basic failover site, providing data to development environments, and addresses many other issues. Most DBAs have or will encounter Replication when working with SQL server. The Replication system is large enough that it is often difficult to master without some form of training. SQL Server Replication Fundamentals LiveLessons provides the information needed in order to work with replication [Read more…]

SAMS SQL SERVER 2016 FUNDAMENTALS FOR THE ACCIDENTAL DBA LIVELESSONS

SAMS SQL SERVER 2016 FUNDAMENTALS FOR THE ACCIDENTAL DBA LIVELESSONS
English | Size: 16.72 GB
Category: Tutorial

SQL Server is installed behind many third-party applications and behind Microsoft development tools such as Visual Studio. System administrators and developers alike are increasingly responsible for working with and managing SQL Server with no prior exposure or background. Further, they need to understand thebasics of relational databases and technologies, such as indexing and stored procedures, to effectively develop applications. This video covers SQL Server from their perspectives and gives them what they need to manage these instances
[Read more…]

PEARSON ORACLE PL SQL PROGRAMMING FUNDAMENTALS LIVELESSONS

PEARSON ORACLE PL SQL PROGRAMMING FUNDAMENTALS LIVELESSONS
English | Size: 5.36 GB
Category: CBTs

Oracle PL/SQL Programming Fundamentals LiveLessons covers the basics of Oracle’s language extension for SQL and the Oracle relational database. The focus is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and packages using the PL/SQL language.
[Read more…]

PEARSON ORACLE PL SQL PROGRAMMING FUNDAMENTALS TO ADVANCED

PEARSON ORACLE PL SQL PROGRAMMING FUNDAMENTALS TO ADVANCED
English | Size: 9.24 GB
Category: CBTs

Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons begins with a fundamentals module that covers the basics of Oracle’s language extension for SQL and the Oracle relational database. The focus is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and packages using the PL/SQL language.
[Read more…]

Skip to toolbar