Introduction To Database Queries - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Introduction To Database Queries (/Thread-Introduction-To-Database-Queries)

Introduction To Database Queries - OneDDL - 02-21-2024 Free Download Introduction To Database Queries Published 2/2024 MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz Language: English | Size: 1.00 GB | Duration: 3h 1m Learning to Program Relational Databases What you'll learn Apply queries from a table to retrieve data. Apply queries from multiple tables to retrieve data. Apply queries in SQL to create and update data in a database. Apply queries in SQL to delete data in a database. Requirements No programming experience required. You will learn what you need from this course Description This program will teach you everything you need to know to use a relational database management system in the Web, the Cloud, and embedded applications. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The courses utilize the open-source relational database MySQL. MySQL and its open-source fork, MariaDB, are used in millions of web apps to persist the application data and provide query processing. Students gain valuable hands-on experience programming SQL queries in the labs. In addition to the applied SQL labs, you will also gain an understanding of relational databases in general, learning how to design your database so it's robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data, and query that data through extensive hands-on practices.This self-paced program provides an undergraduate-level introduction to database programming and administration that will help prepare students for advanced undergraduate computer science, information technology, or cybersecurity coursework.Course ObjectivesBy the end of this program, students should be able to:Apply queries in relational algebra to retrieve data.Apply queries in SQL to create, read, update, and delete data in a database.Apply the concepts of entity integrity constraint and referential integrity constraint (including the definition of the concept of a foreign key).Describe the normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) of a relation.Apply normalization to a relation to create a set of BCNF relations and denormalize a relational schema.Describe functional dependency between two or more attributes that are a subset of a relation.Understand multi-valued dependency and identify examples in relational schemas.Sketch conceptual data models (including ER) to describe a database structure.Apply SQL to create a relational database schema based on conceptual and relational models.Apply stored procedures, functions, and triggers using a commercial relational DBMS.Describe concurrency control and how it is affected by isolation levels in the database.This is the 1st course of 3 in the program and focuses on learning to query a database. We will drill into tools, single-table queries, multiple-table queries, and queries that modify data in the database. Overview Section 1: Welcome Lecture 1 Welcome Message Section 2: Week 1 - Database Overview Lecture 2 Overview Lecture 3 SQL Statements Lecture 4 Call Level Interfaces Lecture 5 Database Overview Resources Section 3: Week 2 - Database Tools Lecture 6 Topic Introduction Lecture 7 Sample Database Lecture 8 Creating Sample Database in MySQL WorkBench Lecture 9 Database Tools Resources Section 4: Week 3 - Querying the database - Single Table Lecture 10 Querying the database - Single Table Lecture Lecture 11 Calculated Columns Lecture 12 Where Statement Lecture 13 Resources Section 5: Week 4 - Querying the database - Multiple Tables Lecture 14 Topic Introduction Lecture 15 Other Joins Lecture 16 Unions Lecture 17 Resources Section 6: Week 5 - Modifying the database Lecture 18 Topic Introduction Lecture 19 Update & Delete Statements Lecture 20 Resources Beginner programmers Homepage [To see links please register or login] Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live [To see links please register or login] No Password - Links are Interchangeable