Old Search System: sql 2014




  • Complete Microsoft SQL Server from Scratch: Bootcamp

    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...


  • Microsoft SQL for Beginners (SQL Server and T-SQL)

    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...


  • Google BigQuery and PostgreSQL: SQL for Data Analysis

    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...


  • Oreilly - Implementing Business Intelligence with SQL Server 2019

    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...


  • Oreilly - SQL Server 2017 Express Basics

    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...


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

    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...

  • SQLPro Studio 2020.59

    tnt-reloaded

    SQLPro Studio 2020.59

    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).
    +...


  • Oreilly - Creating a Database with SQLite

    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...


  • Oreilly - Introducing SQL and Relational Databases

    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...


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

    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...


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

    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...


  • Mastering SQL Query With SQL Server (Updated 5/2020)

    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...


  • The complete Advanced Databases & SQL Querying

    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...


  • Lynda - Advanced SQL – Window Functions

    Advanced SQL – Window Functions https://www.lynda.com/SQL-tutorials/Advanced-SQL-Window-Functions/2824360-2.html Window functions are one of the most radical, fundamental...


    Introduction 1. Tools, Files, and Query Processing Review 2. Window Functions and the OVER Clause 3. Framing, Exclusions, and Shortcuts 4. Aggregate Window Functions 5. Rank and Distribution Window Functions 6. Offset Window Functions Conclusion


  • DataCamp Track - SQL Server Toolbox

    DataCamp Track - SQL Server Toolbox https://www.datacamp.com/tracks/sql-server-toolbox SQL | 17 hours | 4 courses Take...





  • DataCamp Track - SQL Server Fundamentals

    DataCamp Track - SQL Server Fundamentals https://www.datacamp.com/tracks/sql-server-fundamentals SQL | 22 hours | 5 courses Gain...





  • DataCamp Track - SQL Server for Database Administrators

    DataCamp Track - SQL Server for Database Administrators https://www.datacamp.com/tracks/sql-server-for-database-administrators SQL | 28 hours | 7...





  • DataCamp Track - SQL for Database Administrators

    DataCamp Track - SQL for Database Administrators https://www.datacamp.com/tracks/sql-for-database-administrators SQL | 16 hours | 4 courses...





  • DataCamp Track - SQL for Business Analysts

    DataCamp Track - SQL for Business Analysts https://www.datacamp.com/tracks/sql-for-business-analysts SQL | 20 hours | 5 courses...





  • DataCamp Track - Data Analyst with SQL Server

    DataCamp Track - Data Analyst with SQL Server https://www.datacamp.com/tracks/data-analyst-with-sql-server SQL | 45 hours | 11...