Old Search System: data flow




  • Lynda - Programming Foundations: Databases

    Lynda - Programming Foundations: Databases Once you get beyond basic programming, you'll need a database....


    Table of ContentsIntroduction1. Database Foundations2. Tables3. Relationships4. Database Optimization5. Querying a Database6. Querying a DatabaseConclusion


  • Lynda - PHP: Object-Oriented Programming with Databases

    Lynda - PHP: Object-Oriented Programming with Databases Learn how to interact with databases using object-oriented...


    Table of ContentsIntroduction1. Overview and Project Setup2. The Database Connection3. Define a Database-Driven Class4. Object-Oriented CRUD5. Object-Oriented Authentication6. Object-Oriented PaginationConclusion


  • Oreilly - Introduction to Graph Modeling and Graph Databases (Neo4j)

    Oreilly - Introduction to Graph Modeling and Graph Databases (Neo4j) by Joshua Yu | Released...


    Recorded live at Data Modeling Zone Asia Pac! We start off with an overview to graph modeling, followed by an explanation of graph databases and their roles within our organizations. Learn the top use cases for graph databases, along with best practices in graph modeling. Neo4j is used as an...


  • Lynda - Oracle 12c Database: Administration

    Lynda - Oracle 12c Database: Administration Oracle Database 12c is the world's leading relational database...


    Table of ContentsIntroduction1. Architecture2. Instance Memory Pools3. Instance Background Processes4. Client Connections5. Physical Database Structures6. Multitenant Database7. Start and Stop the Database8. Install Oracle 12c software9. Create a Database Instance10. Tools for Developers and DBAs11. ManagementConclusion


  • Lynda - Learning Oracle Database 12c

    Lynda - Learning Oracle Database 12c In this course, Oracle expert and author Bob Bryla...


    Table of ContentsIntroduction1. Design Methodology and Tools2. SQL Query Basics3. Advanced Data Manipulation4. Modify and Create Database Object5. Database Architecture6. DBA Configuration Tools7. Manage Tablespaces and Disk Space8. Table Compression9. Manage System-Related Tablespaces10. Database MonitoringConclusion


  • Lynda - Learning Relational Databases

    Lynda - Learning Relational Databases Have you ever opened up a database that someone else...


    Table of ContentsIntroduction1. Relational Database Basics2. Preventing Data Anomalies3. Gathering Requirements4. Developing the Conceptual Data Model5. Normalizing Your Data6. Logical Design Considerations7. Developing the Physical DatabaseConclusion


  • 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: Backup and Recovery

    Lynda - Oracle Database 12c: Backup and Recovery Keeping the information in an Oracle database...


    Table of ContentsIntroduction1. Backup and Recovery Core Concepts2. Failure Categories and Backup Types3. Preparing the Course VM4. User-Managed Backups5. Recovery Manager (RMAN)6. Oracle Data Pump7. Oracle FlashbackConclusion


  • Lynda - Oracle Database 12c: Security

    Lynda - Oracle Database 12c: Security Database security is one of the hottest topics for...


    Table of ContentsIntroduction1. Database Security Fundementals2. Advanced Database Security Concepts3. Download and Set Up the Course VM4. Users and Permissions5. Database Roles6. Auditing Access to Data7. Data EncryptionConclusion


  • 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


  • Lynda - Programming Foundations: Databases (2015)

    Lynda - Programming Foundations: Databases (2015) Discover how a database can benefit both you and...


    Table of ContentsIntroduction1. Understanding Databases2. Database Fundamentals3. Database Modeling: Tables4. Database Modeling: Relationships5. Database Modeling: Optimization6. Database Modeling: Querying7. Database Modeling: Indexing and Optimization8. Database OptionsConclusion


  • 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 - PHP: Accessing Databases with PDO and MySQLi

    Lynda - PHP: Accessing Databases with PDO and MySQLi Now that PHP has true object-oriented...


    Table of ContentsIntroduction1. Why Use Object-Oriented PHP to Access a Database?2. PHP Data Object (PDO) Basics3. PDO-Prepared Statements and Transactions4. Advanced PDO Fetch Methods5. MySQL Improved Basics6. MySQLi Prepared Statements and Transactions7. Diving Deeper into MySQLiConclusion


  • Construction Productivity-How to build Productivity DataBase

    Construction Productivity-How to build Productivity DataBaseVideo: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz,...


    What you\'ll learn
    How to Monitor performance on site
    Use and examine published productivity database and sheets.
    Record productivity data on site
    Extract data from historical data and reports (Daily, weekly and monthly)
    Use site observations to collect data in current projects (with a good excel sheet)
    Calculate productivity rate...


  • Lynda - Learning NoSQL Databases

    Lynda - Learning NoSQL Databases Explore the possibilities NoSQL databases offer developers for unparalleled flexibility...


    Table of ContentsIntroduction1. Overview2. Accessing NoSQL Databases3. Querying Schemaless Data4. CouchDB Applications5. NoSQL Trade-Offs6. Other NoSQL DatabasesConclusion


  • Using Excel in C# - Export Excel Data to SQL Database in C# (Updated 3/2020)

    Using Excel in C# - Export Excel Data to SQL Database in C# (Updated 3/2020)Video:...


    What you'll learn
    Install SQL Server 2014 in Win 7, Win 10
    Load data from Excel file in C#
    Save Excel data file in SQL Server Database
    Download and use Excel free component in C#
    Create SQL Server Data base and Table
    Create Excel data to SQL Converter
    Add Pro...


  • Oracle Database 19c: Basic SQL

    Oracle Database 19c: Basic SQL https://www.lynda.com/Oracle-tutorials/Oracle-Database-19c-Basic-SQL/2260956-2.html Mastering SQL is an essential skill for any Oracle...


    Introduction1. Client Tools2. SELECT Statements3. Data Dictionary4. String Manipulation5. Filtering Rows6. Sorting Rows7. Single-Row Functions8. Aggregation and Multiple-Row Functions9. Joining Tables10. Using the Oracle Data Dictionary11. DML: INSERT12. DDL: Creating Objects13. Dropping ObjectsConclusion


  • Udemy - MySQL for Data Analysis - SQL Database for Beginners

    Udemy - MySQL for Data Analysis - SQL Database for Beginners https://www.udemy.com/course/mysql-for-data-analysis/ See why this...


    Description See why this is one of the TOPRATEDSQL/MySQLCourses on Udemy:"Clear presentation of information and with enough repetition of important SQLconcepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"- Maggi M."I totally loved this course! Everything was very easy to understand, but it...


  • MySQL for Data Analysis - SQL Database for Beginners

    MySQL for Data Analysis - SQL Database for BeginnersVideo: .mp4 (1280x720, 30 fps(r)) | Audio:...


    What you'll learn
    Write SQL queries to explore and analyze databases with MySQL Workbench
    Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
    Analyze data across multiple tables with powerful MySQL JOIN statements
    Solve practical hands-on assignments and real-world business use cases
    Master unique...


  • Database Management System : MySQL and Database Modelling

    Database Management System : MySQL and Database ModellingVideo: .mp4 (1280x720, 30 fps(r)) | Audio: aac,...


    What you'll learn
    Introduction to Data and Data Types in SQL perspective
    Introduction to information Systems
    System Analysis & E-R Modelling and Relationships
    Different ways to for Database Modeling
    Querying using Structure Query Language
    Data Definition language (DDL)
    Data Manipulation language (DDL)
    Installing MySQL Server and building your own live...