SQL - The Query Writing Bootcamp

Old Search System: SQL - The Query Writing Bootcamp

Advanced Search

Category Select

T-SQL (Transact-SQL) for beginners with Microsoft SQL Server

Broknote

T-SQL (Transact-SQL) for beginners with Microsoft SQL Server Video: .mp4 (1280x720, 30 fps(r)) | Audio:...

What you\'ll learn
Learn Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.
Write Transact-SQL statements to perform CRUD(create| Read | update |delete) operations on SQL Server database
Installing SQL Server
Writing CREATE queries
Writing INSERT INTO queries
Writing SELECT queries
Writing...

READ MORE
Full Php Course with basic My SQL

Broknote

Full Php Course with basic My SQL Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...

What you'll learn
You guyz can make awesome websites on php after this course
Requirements
all you need is just a pc
Description
Knowing PHP has allowed me to make enough money to stay home and make courses like this one for students all over the world. Being a PHP developer can allow...

READ MORE
The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners

Broknote

The Complete Microsoft SQL Bootcamp :Learn SQL For Beginners Video: .mp4 (1280x720, 30 fps(r)) |...

What you\'ll learn
You will learn how to write SQL statements in a SQL Server Database
Get employed as a SQL Expert in a SQL Server Database
Being a SQL Expert , you will be able to insert information into a SQL Server Database
Being a SQL Expert , you...

READ MORE
Export Excel Data to SQL in C#-Barcode Scanner in C# and SQL

Solid

Export Excel Data to SQL in C#-Barcode Scanner in C# and SQLEnglish | 15:15:41 |...

What you'll learn
Quick Learning on SQL Server
Read Excel Data in C#
Using Barcode Scanner in C#
Auto Search Barcode by Barcode Scanner
Create Sample Barcode List in SQL
Learn Quickly to Use SQL Database in C#
Search Something in SQL by Using C#
Save Excel data file in SQL Server Database
Export Excel Data to SQL by...

READ MORE
The Beginner\'s SQL Course

Broknote

$The Beginner\'s SQL Course$

The Beginner's SQL Course Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch...

What you\'ll learn
Modeling a System
SQL Overview
The Major Components of SQL
System Development Overview
Balancing Performance and Correctness
Requirements
Using ability an operating system
Description
This SQL training course from Infinite Skills teaches you how to use SQL to manage data that is held in relational databases. This training course is...

READ MORE
SQL Server Database Engine For Beginners

Broknote

SQL Server Database Engine For Beginners Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100...

What you\'ll learn
Installing SQL Server
Installing SQL Server Management Studio (SSMS)
Connecting to Database Engine
Writing Transact -SQL Statements
Create a database
Create a table
Insert rows into table
Query table
Updating Database Records
Delete Rows
Truncate Table
Drop Table
Drop Database
Explore Basic Navigation in Database Engine Tuning...

READ MORE
SQLPro Studio 2020.61

tnt-reloaded

SQLPro Studio 2020.61 | macOS | 88 mbSQLPro Studio is the premium database management tool...

Some of the great features include:

+ Intellisense/SQL autocompletion.
+ Syntax highlighting with customizable themes (including dark).
+ Tabbed based interface for an optimal user experience.
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ SQL Beautifier/formatter.
+ Database wide searching.
+ NTLMv2 supported (but not required).
+...

READ MORE
Complete Microsoft SQL Server from Scratch: Bootcamp

Solid

Complete Microsoft SQL Server from Scratch: BootcampEnglish | 01:18:08 | Video 720p | SubtitlesBuild Your...

What you'll learn
learn to use MS SQL professional way, learn new SQL!
know how to prepare data structures
create basic SQL queries
create left, right, inner and full outer joins
know how to simplify reports like spreadsheets! with huge data sets
you will learn secure user logins
learn how to protect your data by doing backup...

READ MORE
Microsoft SQL for Beginners (SQL Server and T-SQL)

Broknote

Microsoft SQL for Beginners (SQL Server and T-SQL)Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...

What you'll learn
T-SQL
SQL
Microsoft SQL Server
Basic SQL - Select, Filter, Where and More…
Advanced SQL - Group By, Having, Temporary Tables
Joins
Working with Tables - Insert, Update, Deletes
Programmability - Stored Procedures and Views
Requirements
No prior knowledge of Databases, SQL or SQL Server is needed. We...

READ MORE
Google BigQuery and PostgreSQL: SQL for Data Analysis

Broknote

Google BigQuery and PostgreSQL: SQL for Data AnalysisVideo: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...

What you'll learn
Knowledge of all the essential SQL commands in BigQuery and PostgreSQL
Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
Become competent in using sorting and filtering commands in SQL
Requirements
Just a PC with any web browser
Description
6 Reasons why you should choose this PostgreSQL and...

READ MORE
Oreilly - Implementing Business Intelligence with SQL Server 2019

Coktum

Oreilly - Implementing Business Intelligence with SQL Server 2019 by Jess Dale Dela cruz |...

A one-stop guide to help database developers build Business Intelligence applications from scratch!About This VideoUnderstand basic Data Warehousing, OLTP, and OLAP.Use SSDT (SQL Server Data Tools) to develop SSIS packages and design reports.Learn about SSIS, SSAS, and SSRS architectures and their components.In DetailIn the course, you will cover topics including...

READ MORE
Oreilly - SQL Server 2017 Express Basics

Coktum

Oreilly - SQL Server 2017 Express Basics by Tom Owziak | Released June 2018 |...

An updated course incorporating SQL Server 2017!About This VideoClearly and succinctly describes the fundamentals needed to really understand the later stuff.A very good overview with some depth added with basic extensions to updating and selection parameters.In DetailMost Important: Friends, please be sure to look through the course curriculum with meticulous...

READ MORE
Oreilly - An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

Coktum

Oreilly - An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course by Tom O. |...

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!About This VideoLearn how to import data into SQL Server from other programs, how to bring tables into first, second and third normal form, how to work with XML in SQL Server and ASP.NET Controls.Build a web-based data entry...

READ MORE
SQLPro Studio 2020.59

tnt-reloaded

SQLPro Studio 2020.59 | macOS | 88 mbSQLPro Studio is the premium database management tool...

Some of the great features include:

+ Intellisense/SQL autocompletion.
+ Syntax highlighting with customizable themes (including dark).
+ Tabbed based interface for an optimal user experience.
+ Context aware database tree navigation, including quick access to tables, views, columns, indexes and much more!
+ SQL Beautifier/formatter.
+ Database wide searching.
+ NTLMv2 supported (but not required).
+...

READ MORE
Oreilly - Creating a Database with SQLite

Coktum

Oreilly - Creating a Database with SQLite by Allen Taylor | Released September 2018 |...

Journey to database mastery as you learn how to create a simple database and manipulate its data. In this video, SQL expert Allen Taylor explains how to build a simple database with SQLite, an open source database engine. Part 1 introduces SQLite and explores its basic features. In Part 2...

READ MORE
Oreilly - Introducing SQL and Relational Databases

Coktum

Oreilly - Introducing SQL and Relational Databases by Allen Taylor | Released September 2018 |...

Start on the road to mastery of SQL and databases: two of the most important topics in IT. In this video, SQL expert Allen G Taylor covers the basics of SQL. Part 1 explains where SQL came from, why data should be organized, and the value of databases as a...

READ MORE
Oreilly - SQL Server 70-767: Implementing a Data Warehouse Using SQL

Coktum

Oreilly - SQL Server 70-767: Implementing a Data Warehouse Using SQL by Scot J. Reagin...

8+ Hours of Video Instruction Prepare for Microsoft Exam 70-767: Implementing a Data Warehouse Using SQL, and develop practical skills to design, configure, and manage a data warehouse with SQL Server Overview In this video training, Scot Reagin couples discussion with demonstration to give you not only the technical and...

READ MORE
Oreilly - SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014

Coktum

Oreilly - SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and...

More than 19 hours of video instruction to help you learn and master the skills necessary to pass Exam 70-762: Developing SQL Databases, required for the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development certification. Overview Through detailed presentations and hand-on demos, this complete video course guides you through...

READ MORE
Mastering SQL Query With SQL Server (Updated 5/2020)

Broknote

Mastering SQL Query With SQL ServerVideo: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz,...

What you'll learn
Why We Need To Create Multiple Tables
How To Create Tables In A Database Using SQL statements
How To Create Tables In A Database Using SQL SSMS
How To Insert Data Into A tables
How To Updated Saved Data Using Update Statements
How To Remove unwanted Data...

READ MORE
The complete Advanced Databases & SQL Querying

Broknote

The complete Advanced Databases & SQL QueryingVideo: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100...

What you'll learn
Know the different TSQL functionalities that exist
Write more efficient TSQL code
Requirements
Must be comfortable writing TSQL code and must know basic syntax like SELECT, INSERT, UPDATE etc.
Description
Prerequisite SQL Skills Assessment
In this section we'll address the core SQL/MySQL skills that you should be comfortable with...

READ MORE

Showing 460-480