Old Search System: sql 2014




  • Lynda - SQL Server 2014: Developing Databases

    Lynda - SQL Server 2014: Developing Databases Learn how to develop databases with the latest...


    Table of ContentsIntroduction1. Working with SQL Server Development Tools2. Designing Data Tables3. Understanding the Concept of Constraints4. Storage and Indexes5. Designing Views6. Working with Stored Procedures7. Performing Data Modification with Triggers8. In-Memory DatabasesConclusion


  • Lynda - SQL Server 2014: Installation and Administration

    Lynda - SQL Server 2014: Installation and Administration Get up to speed on installing and...


    Table of ContentsIntroduction1. Installing SQL Server 20142. Learning the SQL Server Tools3. Understanding Data Storage4. Automating Maintenance of SQL Server5. Implementing a Backup Plan6. Importing and Exporting Data7. Indexing the Databases8. Monitoring SQL Server9. Understanding SQL Server SecurityConclusion


  • Lynda - SQL Server 2017: Linux, Docker, and macOS

    Lynda - SQL Server 2017: Linux, Docker, and macOS SQL Server has traditionally run only...


    Table of ContentsIntroduction1. Working in Linux2. Install SQL Server on Ubuntu3. Connect to SQL Server on Linux4. Get Started with Docker5. Work in a Docker Container6. SQL Tools on macOS7. SQL Operations CenterConclusion


  • Lynda - SQL Server 2017: What's New

    Lynda - SQL Server 2017: What's New SQL Server 2017 is the start of the...


    Table of ContentsIntroduction1. Run SQL Server on Linux2. Execute External Python Scripts3. Process Data with Graph Databases4. Other Enhancements and AdditionsConclusion


  • Lynda - SQL Server 2016: Provision a Database

    Lynda - SQL Server 2016: Provision a Database Learn the key skills you need to...


    Table of ContentsIntroduction1. Deploy Microsoft Azure SQL Database2. Plan for a SQL Server Installation3. SQL Server Instances4. Configure Secure Access to Azure SQL Databases5. Configure SQL Performance Settings6. Manage SQL Server Instances7. Deploy Applications to Azure SQL Database8. Deploy Applications to SQL Server on Azure VMs9. Migrate Client ApplicationsConclusion


  • Lynda - SQL Server 2016: Administer a Database Infrastructure

    Lynda - SQL Server 2016: Administer a Database Infrastructure SQL Server comes with many features...


    Table of ContentsIntroduction1. Configure Encryption2. Configure Data Access and Permissions3. Configure Auditing4. Develop a Backup Strategy5. Restore Databases6. Manage Database Integrity7. Monitor Database Activity8. Monitor Queries9. Manage Indexes10. Manage Statistics11. Monitor SQL Server Instances12. Implement Log Shipping13. Implement Always On Availability GroupsConclusion


  • Lynda - Using Vapor with SQL and NoSQL Databases

    Lynda - Using Vapor with SQL and NoSQL Databases One of the most compelling aspects...


    Table of ContentsIntroduction1. Using Databases with Vapor2. Installing Database Providers3. Working with Data Models4. User Authentication and Authorization5. RESTful ServicesConclusion


  • Lynda - SQL Tips, Tricks, & Techniques

    Lynda - SQL Tips, Tricks, & Techniques Get Ben Sullins's 12 must-have SQL techniques for...


    Table of ContentsIntroduction1. SQL Tips and TricksConclusion


  • Lynda - SQL: Data Reporting and Analysis (2016)

    Lynda - SQL: Data Reporting and Analysis (2016) Do you rely on IT to get...


    Table of ContentsIntroduction1. Use SQL to Report Data2. Group your SQL Results3. Merge Data from Multiple Tables4. Advanced Features and Taking Your Learning Forwards


  • Cloud NoSQL for SQL Professionals

    Cloud NoSQL for SQL Professionals https://www.lynda.com/NoSQL-tutorials/Cloud-NoSQL-SQL-Professionals/2819073-2.html NoSQL databases can store nonrelational data on a super...


    Introduction 1. The Road to NoSQL 2. Understanding NoSQL Databases 3. Use Key-Value NoSQL 4. Use Columnar NoSQL 5. Use Document NoSQL 6. Use Graph NoSQL 7. Use Specialty NoSQL 8. Understand NoSQL Trends Conclusion


  • Lynda - SQL Server: Security, Encryption, and Masking

    Lynda - SQL Server: Security, Encryption, and Masking Learn how to build more secure applications...


    Table of ContentsIntroduction1. Row-Level Security (RLS)2. Encryption in SQL Server3. Data Masking in SQL ServerConclusion


  • Lynda - SQL Server: Security for Developers

    Lynda - SQL Server: Security for Developers Learn how to protect databases and preserve the...


    Table of ContentsIntroduction1. Roles and Privileges in SQL Server2. SQL Injection3. Securing Your NetworkConclusion


  • Lynda - SQL Server 2008 Essential Training

    Lynda - SQL Server 2008 Essential Training In SQL Server 2008 Essential Training, Simon Allardice...


    Table of ContentsIntroduction1. Getting Started2. Installing SQL Server 2008 R23. Tools and System Databases4. Creating Databases5. Importing Existing Data6. Retrieving Data with SQL7. Inserting and Updating Data8. SQL Functions9. Stored Procedures and Transactions10. Core Administration Tasks11. Backing Up and Restoring12. Security Features13. Reporting Services14. Integration ServicesConclusion


  • Lynda - SQL Essential Training (2018)

    Lynda - SQL Essential Training (2018) Whatever database application you create—whether it's for bookkeeping, sales,...


    Table of ContentsIntroduction1. Installation2. SQL Overview3. Fundamental Concepts4. Relationships5. Strings6. Numbers7. Dates and Times8. Aggregates9. Transactions10. Triggers11. Views and Subselects12. Defined Functions13. A Simple CRUD ApplicationConclusion


  • Lynda - SQL Server Performance for Developers

    Lynda - SQL Server Performance for Developers Developers face an array of challenges when trying...


    Table of ContentsIntroduction1. Query Execution2. What Not to Do with SQL Server3. Datatypes and Design4. Temporary Objects5. Indexing6. Columnstore7. Isolation LevelsConclusion


  • Lynda - SQL for Statistics Essential Training

    Lynda - SQL for Statistics Essential Training Descriptive statistics help us understand the overall structure...


    Table of ContentsIntroduction1. Basic Descriptive Statistics2. Percentiles and Frequencies3. Correlations and Ranks4. Linear ModelsConclusion


  • Lynda - SQL for Exploratory Data Analysis Essential Training

    Lynda - SQL for Exploratory Data Analysis Essential Training Learn how to use SQL to...


    Table of ContentsIntroduction1. Introduction to Exploratory Data Analysis2. Data Quality Checks3. Calculating Quartiles4. Histograms5. Checking Correlation between AttributesConclusion

  • SQLPro Studio 2020.18

    tnt-reloaded

    SQLPro Studio 2020.18

    SQLPro Studio 2020.18 | macOS | 85 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).
    +...


  • Lynda - Learning Microsoft SQL Server 2016

    Lynda - Learning Microsoft SQL Server 2016 SQL Server can be intimidating, especially for people...


    Table of ContentsIntroduction1. Get Started2. Work with the Server3. SQL Server Management Studio4. Write Transact-SQL CommandsConclusion


  • Lynda - Learning Microsoft SQL Server 2019

    Lynda - Learning Microsoft SQL Server 2019 Never worked with a database before? In this...


    Table of ContentsIntroduction1. Get Started with SQL Server2. Work with the Server3. SQL Server Management Studio4. Write Transact-SQL CommandsConclusion