Old Search System: sql 2014




  • Oreilly - Exploring SQL Server 2016: Fundamentals

    Oreilly - Exploring SQL Server 2016: Fundamentals by Integrity Training | Released March 2019 |...


    The Exploring SQL Server 2016: Fundamentals course helps the experienced database professionals to update their SQL Server skills to the new features introduced in the SQL Server 2016. The new features covered in this course are for performance, security, availability, scalability, reporting and data access. This course also covers the...


  • Oreilly - SQL Server Core 2016

    Oreilly - SQL Server Core 2016 by Integrity Training | Released March 2019 | ISBN:...


    This course will introduce students to SQL Server Core 2016, as well as teach them about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries. This SQL Server Core 2016 course introduces the students to the SSMS and Data Tools ,Server Configuration ,Using Management Studio,...


  • Oreilly - How Hackers Find SQL Injections in Minutes with Sqlmap

    Oreilly - How Hackers Find SQL Injections in Minutes with Sqlmap by Dawid Czagan |...


    Learn About the Most Powerful Tool for Automated SQL Injection Detection and ExploitationAbout This VideoLearn how to dump database table entries with sqlmap, install a backdoor, and how to go from SQL injection to remote code execution.Learn how to automatically detect and exploit SQL injection vulnerabilities with sqlmap.In DetailAutomated SQL...


  • Lynda - Learning SQL Server 2017

    Lynda - Learning SQL Server 2017 Microsoft SQL Server can be an intimidating system. In...


    Table of ContentsIntroduction1. Getting Started2. Working with the Server3. SQL Server Management Studio (SSMS)4. Write Transact-SQL CommandsConclusion


  • Oreilly - T-SQL Data Manipulation: Inserting, Updating, Deleting, and Merging in SQL Server

    Oreilly - T-SQL Data Manipulation: Inserting, Updating, Deleting, and Merging in SQL Server by John...


    This video course teaches how to go beyond writing SELECT statements and to manipulate data within your database tables. You'll begin with an introduction to Data to Data Manipulation Language (DML) that covers the INSERT, UPDATE, and DELETE statements. You'll use these three statements most often, and they are the...


  • Oreilly - T-SQL Querying: Writing a SELECT Statement

    Oreilly - T-SQL Querying: Writing a SELECT Statement by John Deardurff | Released December 2018...


    This video provides you with the knowledge to write SELECT statements to retrieve data from a SQL Server database. The video begins with an explanation of fields and records, followed by the anatomy of a SELECT statement. It continues with how to use a WHERE clause to filter specific records...


  • Lynda - Learning SQL Server Development on Linux

    Lynda - Learning SQL Server Development on Linux The release of Microsoft SQL Server 2017...


    Table of ContentsIntroduction1. New Features Overview2. Adaptive Query Processing3. SQL Server on Linux4. SQL Server Operations StudioConclusion


  • Lynda - Microsoft SQL Server 2019 Essential Training

    Lynda - Microsoft SQL Server 2019 Essential Training Master the fundamentals of SQL Server 2019,...


    Table of ContentsIntroduction1. Get Started2. Log into the Server3. Create Databases4. Table Design for Healthy Databases5. Structured Query Language6. Query Performance7. Query Programmability8. Backup and Restore9. Security10. Monitoring and ManagementConclusion


  • Lynda - Learning SQL Programming

    Lynda - Learning SQL Programming SQL (Structured Query Language) is a common tool for retrieving...


    Table of ContentsIntroduction1. Ask for Data from a Database2. Ask for Data from Two or More Tables3. Data Types, Math, and Helpful Functions4. Add or Modify DataConclusion


  • Lynda - Microsoft SQL Server 2016 Essential Training

    Lynda - Microsoft SQL Server 2016 Essential Training SQL Server supports mission-critical applications and big...


    Table of ContentsIntroduction1. Overview of SQL Server 20162. Installing SQL Server 20163. Working with Tools4. Creating and Configuring Databases5. Creating Tables in a Database6. Creating Views in Databases7. Understanding Programmability8. Working with XML9. Working with JSON10. Backup and Restore11. Monitoring and Management12. Security13. Performance14. CloudConclusion


  • Lynda - Microsoft SQL Server 2016: Installation and Administration

    Lynda - Microsoft SQL Server 2016: Installation and Administration SQL Server is the database used...


    Table of ContentsIntroduction1. Installation and Configuration2. Database Instances3. Performance Considerations4. Security5. Managing Data6. High Availability OptionsConclusion


  • Lynda - Microsoft SQL Server 2016: Query Data

    Lynda - Microsoft SQL Server 2016: Query Data Many of the world's most powerful programs...


    Table of ContentsIntroduction1. SQL Query Fundamentals2. Query the Database3. Filtering Results4. Querying Multiple Tables5. Grouping and Sorting6. Querying with Data Type Considerations7. Subqueries and Table Expressions8. Programming with T-SQL9. Query PerformanceConclusion


  • Lynda - Oracle Database 12c: Basic SQL

    Lynda - Oracle Database 12c: Basic SQL Mastering the SQL language is an essential skill...


    Table of ContentsIntroduction1. Introduction to SQL2. Preparing the Course Environment3. Using Oracle SQL Developer4. Basic SELECT Queries5. String, Number, and Date Functions6. Joining Table Data7. Manipulating Data8. Grouping Data9. Advanced TopicsConclusion


  • Lynda - Oracle Database 12c: Advanced SQL

    Lynda - Oracle Database 12c: Advanced SQL Mastering SQL is an essential skill for any...


    Table of ContentsIntroduction1. Setting Up the Environment2. Subqueries3. Indexes4. The Oracle Data Dictionary5. Database Concurrency6. Advanced Oracle Schema Objects7. Table PartitioningConclusion


  • Oracle SQL Developer : Essentials, Tips and Tricks

    Oracle SQL Developer : Essentials, Tips and Tricks English | 03:39:39 | Video 720p |...


    What you'll learn You will learn how to Install and customize SQL Developer in a way that works and feels best for you You will learn how to take full advantage of all the basic features of the tool You will learn how to create and share beautiful and interactive...


  • Lynda - Microsoft SQL Server 2014: Backup and Recovery

    Lynda - Microsoft SQL Server 2014: Backup and Recovery Being able to perform a database...


    Table of ContentsIntroduction1. Backups in General2. Basics3. Logs4. Partial Backups and Restores5. Other Backup TopicsConclusion


  • Mastering SQL Query With SQL Server

    Mastering SQL Query With SQL Server English | 02:50:54 | Video 720p Introduction To...


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


  • SQL for Developers and Analysts with MS SQL Server (Updated 9/2019)

    SQL for Developers and Analysts with MS SQL Server English | 03:41:52 | Video 720p...


    What you'll learn Hands-on learning of SQL and databases using Microsoft SQL Server Download a free copy of SQL Server 2017 Edition and setting up a working environment A basic structure of a SQL query structure Different SQL clauses in a way that will make more sense for you to...


  • Lynda - Migrating Access Databases to SQL Server

    Lynda - Migrating Access Databases to SQL Server At one point Access was adequate. But...


    Table of ContentsIntroduction1. Getting Started2. Digging into SQL Server3. Using SQL Server Migration Assistant4. Making the Transition5. Connecting Access to SQL Server Databases6. Upsizing Access 2010 databasesConclusion


  • Lynda - NoSQL for SQL Professionals

    Lynda - NoSQL for SQL Professionals NoSQL databases can store non-relational data on a super...


    Table of ContentsIntroduction1. Why Change?2. Is Hadoop NoSQL?3. Understanding NoSQL Databases4. NoSQL Options in Microsoft SQL Server 20145. Exploring Cloud-Based NoSQL Databases6. Case Studies and Scenarios7. Important Tips for StartupsConclusion