Одну секунду
Что-то сучилось. Попробуйте еще раз.
Qa mysql смотреть последние обновления за сегодня на .
Welcome to the MySQL Quality Assurance Training Series! Find out what is upcoming in the MySQL QA Training Series in this short 5-minute introduction! Roel Van de Paar kicks off a 13-part MySQL QA & Bash/Linux training series. Relevant whether you're a Linux or MySQL newbie or a seasoned QA engineer. MySQL QA Episode 1: Linux & Bash/GNU Tools Upskill & Scripting Fun (🤍 MySQL QA Episode 2: Build a MySQL Server: Git, Compiling, Build Tools (🤍 MySQL QA Episode 3: Debugging: GDB, Backtraces, Frames, Library Dependencies MySQL QA Episode 4: QA Framework Setup Time! percona-qa, pquery, reducer & more MySQL QA Episode 5: Preparing Your QA Run: mtr_to_sql.sh and pquery-run.sh MySQL QA Episode 6: Analyzing and Filtering: pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh MySQL QA Episode 7: Reducing Testcases for Beginners: single-threaded reducer.sh MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right MySQL QA Episode 11: Valgrind Testing: Pro's, Con's, Why and How MySQL QA Episode 12: Multi-node Cluster Testing Using Docker MySQL QA Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving Presented by Roel Van de Paar of Percona
Topic : Installing MySQL, Working with SQL Workbench & Command Line Clients ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLTutorial #MySQLInstallation #WorkbenchSetup #DatabaseManagement #SQLforBeginners #LearnSQL #MySQLBasics #WorkbenchTutorial #DatabaseInstallation #SQLDatabase #MySQLServer #SQLWorkbench #MySQLTutorial #SQLInstallationGuide #DatabaseAdmin #SQLServerSetup #DatabaseDevelopment #SQLTraining #MySQLAdmin #WorkbenchInstallation #SQLTips #DatabaseDesign #MySQLQueries #SQLForDataAnalysis #WorkbenchBasics #DatabaseSetup #SQLProgramming #MySQLDeveloper #SQLBeginner #WorkbenchTips #DatabaseTutorial #SQLLearning #MySQLManagement #WorkbenchDevelopment #SQLMastery #DatabaseEngine #MySQLSkills #SQLHowTo #WorkbenchTricks #DatabaseInstallationGuide #SQLForNewbies #MySQLQueries101 #WorkbenchEssentials #DatabaseAdminSkills #SQLExplained #MySQLWorkshop #WorkbenchPro #DatabaseSetupGuide #SQLFundamentals #MySQL101
🚀 Все мои курсы и полезные материалы: 🤍 Второй урок в блоке тестирования баз данных будет посвящен тому: как создавать таблицы и базы данных в MySQL. На данном занятии научимся удалять, изменять, вносить новые данные в таблицы и базы данных, т.е. начнем изучение SQL для тестировщика. А также узнаем: как установить свой первый SQL-сервер. В конце занятия покажу каким ресурсом можно пользоваться для тренировки и оттачивании ваших навыков тестировщика базы данных, так как без этих данных QA не QA 😊 📢 Полезные ссылки 💡 Скачать MySQL Community Server 🤍 💡 MySQL: Типы данных 🤍 💡 Практика по SQL 🤍 Приятного просмотра :) P.S. Все таймкоды есть в описании 😉 _ 00:00 - Intro. Анонс следующих уроков в рамках тестирования баз данных 00:42 - Как установить SQL сервер? 05:00 - Какие типы данных применяются в SQL? 07:56 - Как создавать базы данных? Основные операции с БД 12:16 - Как создавать таблицы в базах данных? Основные операции с таблицами 24:19 - Домашнее задание по SQL. Что могут спросить на интервью по SQL? 25:49 - Практический тренажер для отработки навыков работы с SQL 27:12 - Outro 🤠 Я В ИНТЕРНЕТЕ: - Подпишись на этот YouTube канал :) - Telegram (много плюшек): 🤍 - Instagram: 🤍 Music: 🤍bensound.com #SQLдлятестировщика #тестировщикснуля #базыданныхтестировщик
sql для тестировщиков #sqlдлятестировщиков #sql #длятестировщиков В продолжении видео про базы данных, рассказываю про sql. SQL для начинающих может показаться давольно сложным занятием. Но всё гораздо проще, когда понимаешь что нужно знать 10 sql запросов. А остальное обрастает с опытом. Для тестировщика любой sql запрос в начале выглядит как что-то очень большое и страшное. А вообще лучше не подходить. Именно по этому я хочу донести, что всё гораздо проще. И каждый может с этим разобраться. Знания программирования совсем не нужны. Нужна математика не старше 5-го класса. Смотрите весь плэйлист. 🤍 А также другие видео по тестированию 🤍
P.S. Изменение название базы данных силами графического интерфейса MySQL Workbench не выполнить Домашнее задание: создать базу данных через графический интерфейс, удалить её и создать повторно через SQL запрос, а также создать еще одну базу данных с названием "Заводы производителей" любым способом Команды: CREATE SCHEMA - создание базы данных ALTER SCHEMA - изменение базы данных DROP SCHEMA - удаление базы данных SHOW DATABASES - просмотр всех баз данных USE название схемы - работа с конкретной базой данных Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
Домашнее задание: создать таблицу cars в БД dealer_cars и добавить к ней столбцы год выпуска и цену И таблицу по продаже запчастей, которые имеют колонки id, название запчасти, каталожный номер и цену В БД заводов производителей создать таблицы BMW и AUDI с полями id, марка автомобиля, модель автомобиля и таблицы запчастей для этих марок автомобилей с полями id, название запчасти и каталожный номер Команды: CREATE TABLE - создание таблицы ALTER TABLE - изменение таблицы DROP TABLE - удаление таблицы SHOW TABLES - просмотр всех таблиц в базе данных SHOW COLUMNS FROM название таблицы - просмотр полей таблицы Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
Домашнее задание: заполнить таблицы обеих баз данных используя графический интерфейс и SQL срипты Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
View Notes Here - 🤍 In this video, I have explained how to install the MySQL Server and the MySQL Workbench for practicing SQL in a detailed step by step manner.
Topics: - 1. What is DBMS & RDBMS 2. What is Database 3. What is SQL 4. Database Components - Client & Server ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLTutorial #DatabaseBasics #DBMSIntroduction #RDBMSExplained #SQLBeginners #DatabaseFundamentals #LearnSQL #DBMSTutorial #RDBMSTutorial #SQLForBeginners #DatabaseOverview #SQL101 #DBMS101 #RDBMS101 #SQLDatabase #DBMSEssentials #RDBMSEssentials #SQLQueries #DatabaseManagement #SQLBasics #DBMSOverview #RDBMSOverview #SQLSyntax #DatabaseDesign #SQLTraining #DBMSTraining #RDBMSTraining #SQLTips #DatabaseSystems #SQLSkills #DBMSConcepts #RDBMSConcepts #SQLExamples #DatabaseArchitecture #SQLLearning #DBMSFundamentals #RDBMSFundamentals #SQLDatabases #DBMSExplained #RDBMSExplained #SQLProgramming #DatabaseModels #SQLQueries101 #DBMSBasics #RDBMSBasics #SQLMastery #DatabaseDesign101 #SQLMentor #DBMSMadeEasy #RDBMSMadeEasy
Типичные вопросы на собеседовании по языку SQL. Решаем задачи вместе. У Вас скоро собеседование по SQL или Вы считаете себя Гуру? Проверьте свои знания! Попытайтесь решить каверзные задачи ;) Моя книга самоучитель по SQL: 🤍 #SQL, #Базыданных #Собеседование #ИльяХохлов #КурсыПрайм
MySQL Built-in Functions in SQL - 1) Strings functions - operate on string data types 2) Numeric functions - operate on numeric data types 3) Date functions - operate on date data types 4) Aggregate functions - operate on all of the data types and produce summarized result sets ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLFunctions #MySQLFunctions #SQLBuiltInFunctions #MySQLTutorials #SQLTips #DatabaseFunctions #SQLQueries #MySQLLearning #SQLMastery #DataManipulation #SQLBasics #MySQLTraining #SQLSyntax #DatabaseSkills #SQLDevelopment #MySQLQueries #SQLFunctionsGuide #LearnSQL #MySQLFunctions101 #SQLForBeginners #DataAnalysis #SQLServer #MySQLDatabase #SQLLanguage #CodingSQL #MySQLFundamentals #SQLProgramming #DataManagement #QueryingData #MySQLSyntax #SQLTipsAndTricks #DatabaseTutorial #SQLReference #MySQLExplained #SQLQueries101 #DataManipulationSQL #LearnMySQL #SQLFunctionsExplained #DatabaseDevelopment #SQLSkills #MySQLData #SQLQuerying #AdvancedSQL #MySQLFunctionsTutorial #SQLDatabases #DataProcessing #SQLTutorialSeries #MySQLQuery #SQLByExample
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. Want more from Mike? He's starting a coding RPG/Bootcamp - 🤍 The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. You can get PopSQL to follow along here: 🤍 🔗Company Database Code: 🤍 ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: 🤍 🐦Follow Mike on Twitter: 🤍 🔗The Giraffe Academy website: 🤍 Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍
Topics : - 1) What is Database Testing? 2) Difference between User-Interface Testing and Database Testing 3) Database Testing Vs ETL Testing Vs BI Testing 4) Types of Database Testing ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool * ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript * ► 🤍 Playwright with Javascript * ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL * ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter ► 🤍 Maven,Jenkins,Git,Github,CI/CD ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #DatabaseTesting #BackendTesting #TestingOverview #PracticalApproach #SoftwareTesting #DatabaseManagement #QualityAssurance #QAEngineer #BackendDevelopment #TestingTechniques #TestingStrategies #TestAutomation #DataIntegrity #PerformanceTesting #TestDrivenDevelopment #DatabasePerformance #BackendArchitecture #TestCases #LoadTesting #DataValidation #AgileTesting #DatabaseSecurity #BackendScalability #TestCoverage #DatabaseMaintenance #BackendDeployment #RegressionTesting #TestFrameworks #DataMigrations #BackendAPIs #TestEnvironment #DatabaseDesign #BackendErrorHandling #CodeReview #DatabaseOptimization #BackendIntegration #TestManagement #DataBackup #BackendPerformance #UsabilityTesting #DatabaseNormalization #ContinuousIntegration #BackendMonitoring #TestDataGeneration #DataConsistency #DatabaseIndexing #BackendReliability #ExploratoryTesting #DataSecurity #BackendDebugging
Topics: - 1) Create database 2) Create Table Student 3) Insert data into Student table. 4) Select/Retrieve data from a table ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLTutorial #DatabaseCreation #TableCreation #InsertingRecords #DataRetrieval #SQLBeginner #SQLQueries #DatabaseDesign #TableStructure #DataManipulation #SQLCommands #SQLBasics #LearnSQL #DatabaseManagement #SQLMastery #SQLFundamentals #SQLTraining #DatabaseSetup #TableSchema #SQLInsert #SQLSelect #SQLTips #SQLLearning #DatabaseDevelopment #TableDesign #SQLData #SQLSkills #SQLQueries101 #DatabaseTutorial #TableManagement #DataInsertion #SQLTutorialSeries #SQLSyntax #SQLForBeginners #DatabaseCreation101 #TableCreationTips #DataManipulationSQL #SQLCommands101 #SQLEssentials #LearnSQLNow #DatabaseDesign101 #SQLTableSchema #SQLInsertion #SQLDataRetrieval #SQLDatabaseSkills #TableDesign101 #SQLDataTips #SQLQueryMastery #SQLDataManagement #DatabaseAndSQL
Внешний ключ (FK) — это столбец или сочетание столбцов, которое применяется для принудительного установления связи между данными в двух таблицах с целью контроля данных, которые могут храниться в таблице внешнего ключа. Домашнее заданее: добавить ограничения на столцы id_brand_cars и id_type_body Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
Commands covered in this episode: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir Full-screen viewing recommended Index to full series: 🤍 Index to all Linux episodes: 🤍 Presented by Roel Van de Paar of Percona
From ls to xargs, from cp to gnuwin32, from df to arrays - whether you are a Linux beginner or a seasoned Bash expert, you are sure to learn something new in the 13 parts of this episode. Discover what topics will be covered in MySQL Quality Assurance Episode 1 in this short introductory video! Individual commands covered in each part: 1. echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname, date, time, cat, mkdir 2. find, wc, sort, shuf, tr 3. Redirection 4. Vars, ' vs ", $0, $$, $!, screen, chmod/chown 5. grep, regex 6. sed 7. awk 8. xargs 9. subshells 10. if, for, while, seq 11. Arrays & more 12. Scripting Examples 13. Gnuwin32 Full-screen viewing recommended Index to full series: 🤍 Index to all Linux episodes: 🤍 Presented by Roel Van de Paar
Topic : 1. JDBC 2. Java Database Connectivity with MySQL ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #JDBCMySQL #JavaDBConnection #MySQLIntegration #JavaDatabase #DatabaseConnectivity #JavaSQL #MySQLJDBC #JavaMySQLConnector #DatabaseProgramming #JavaDBAccess #MySQLQueries #JDBCConnectionPool #JavaDatabaseDevelopment #MySQLJavaApp #DatabaseInteraction #JavaBackend #MySQLDriver #JDBCTutorial #JavaMySQLConnection #DatabaseConnect #JDBCDevelopment #MySQLDataAccess #JavaSQLQueries #DatabaseIntegration #JavaMySQLDevelopment #JDBCProgramming #MySQLConnector #JavaDatabaseQueries #DatabaseConnectionPool #JavaDBMS #MySQLJDBCTutorial #JDBCBasics #JavaDatabaseConnectionPool #MySQLJavaProgramming #DatabaseQuery #JavaJDBCExample #MySQLIntegrationTutorial #JDBCBestPractices #JavaDatabaseAccess #MySQLJDBCConnection #DatabaseDesign #JavaMySQLApp #JDBCPerformance #MySQLConnectionPool #DatabaseManagement #JavaDatabaseProgramming #JDBCDataSource #MySQLJavaIntegration #DatabaseSecurity #JavaMySQLConnectivity
In this episode we will start working with reducer.sh. If you have never used reducer.sh, or you need a recap, start with this episode. Topics covered; 1. reducer.sh introduction/concepts 2. Basic configurable variables & their default/vanilla reducer.sh settings 2.1 INPUTFILE options 2.2 MODE=x 2.3 TEXT="text" 2.4 WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY 2.5 MYEXTRA 2.6 MYBASE 2.7 PQUERY_MOD & PQUERY_LOC 2.8 MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT 2.9 How to learn more about each of the settings 3. Manual example 4. Introduction to the script's self-recursion concept - subreducer 5. Quick setup re-cap, details of an already executed pquery / pquery Framework QA run 7. Examples from pquery-prep-red.sh 8. Gotcha's 9. QUERYTIMEOUT & STAGE1_LINES Variables Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
Learn how to use GDB like a pro! In this episode I cover GDB & related debugging topics; 1. GDB Introduction 2. Back trace, Stack trace 3. Frames 4. Commands & Logging 5. Variables 6. Library dependencies 7. cfilt 8. Handy references 8.1 GDB Cheat sheet (page #2): 🤍 8.2 From Crash to testcase: 🤍 Also expands on live debugging & more Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
Домашнее задание: выбрать все данные из таблицы bmw, найти уникальные значения в таблице audi по полю модель автомобиля, и переименовать поля и название таблицы в таблице cars
Topic : SQL Joins and Sub Queries ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLJoins #SubQueries #SQLTutorial #DatabaseJoin #InnerJoin #OuterJoin #LeftJoin #RightJoin #FullOuterJoin #SelfJoin #CrossJoin #NaturalJoin #SQLQueries #QueryOptimization #DatabaseSkills #LearnSQL #SQLBasics #SQLMastery #SQLDatabase #StructuredQueryLanguage #SQLSyntax #DatabaseManagement #SQLSkills #JoiningData #SQLCoding #SQLForBeginners #SQLTips #SQLTricks #SQLExamples #SQLCommunity #DatabaseDesign #SQLDevelopment #DataAnalysis #SQLLearning #SQLPractice #DatabaseQueries #SQLServer #SQLExpress #DataManipulation #SQLPerformance #DatabaseNormalization #AdvancedSQL #SQLQuerying #QueryOptimization #SQLConcepts #DatabaseJoining #SubQueryExamples #SQLStudents #JoiningTables #SQLPro
WATCH PART 2 HERE: 🤍 WATCH PART 3 HERE: 🤍 NEW NAVICAT TUTORIAL - 🤍 In this SQL tutorial for beginners, you'll learn how to write basic SQL queries to ask for data from databases in just 15 minutes. To become a business intelligence analyst, you'll need to know this valuable skill! Here I'll teach you what is SQL. What you learn over the course of these videos can be applied to MySQL, PostgreSQL, SQL Server and others. ☕️ WANT TO SAY A QUICK THANK YOU? Why not Buy Me A Coffee? Thanks for your support! 🤍 🔵 LEARNSQL.COM A comprehensive set of 56 hands-on online SQL courses for teams and individuals 🤍 🎓 SKILLSHARE - Get a 30-day free trial of Skillshare Premium! 🤍 ✅ Navicat - Get 5% Off With This Link 🤍 📊 DATA HUBS FOR GOOGLE DATA STUDIO, EXCEL AND MORE: Power My Analytics: 🤍 Supermetrics: 🤍 🔴 Don't forget to subscribe: 🤍 00:00 Introduction 01:12 Why learn SQL for BI? 02:22 Tutorial start 03:43 SQL SELECT statement 05:07 AS field alias 05:32 WHERE clause 09:54 ORDER BY clause 10:54 INNER JOIN 13:08 Aliasing tables 14:00 GROUP BY clause 15:58 HAVING clause 16:49 Outro 🙏 SUPPORT THE CHANNEL 🙏 Paypal Donations - 🤍 👀 RECOMMENDED WATCHING 👀 - Business Intelligence For Beginners Playlist 🤍 🎓 VITAMIN BI EDUCATION ONLINE COURSES 🎓 LEARN BUSINESS INTELLIGENCE WITH DATA STUDIO 🤍 🛠 TOOLS AND SERVICES I RECOMMEND 🛠 🧰 The tool I use to help me manage my channel, get video ideas, rank videos and more: 🤍?afmc=7ho 📹 Everything I use to make videos and stream: 🤍 📖 ⬇️ FREE EBOOKS TO DOWNLOAD ⬇️ 📖 7 Steps to Landing Your First BI Analyst Job 🤍 7 Top Tips For Better Dashboard Design 🤍 The Skills You Need To Succeed In Business Intelligence 🤍 📖 THE DATA VISUALISATION BIBLE 📖 🤍 🎥 MY YOUTUBE GEAR My Camera - 🤍 Most Used Lens - 🤍 B-Roll Lens - 🤍 Main Tripod - 🤍 Vlogging Tripod - 🤍 Main Key Light - 🤍 Softbox - 🤍 LED Panel Kit - 🤍 Teleprompter - 🤍 Main Microphone - 🤍 Mic Boom Arm - 🤍 Lavelier Microphone - 🤍 C-Stands - 🤍 Computer - 🤍 Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏 ✅ LET'S CONNECT: For business inquiries visit 🤍 Sign up for my mailing list to be the first to hear about new videos and special offers 🤍 Twitter - 🤍learnbi_online Facebook - 🤍learnbionline Get the database here - 🤍 mysql #sqltutorial #sql #learnsql
In this episode we'll look into setting up our QA Framework: percona-qa, pquery, reducer & more! 1. All about percona-qa 2. pquery! $ cd ~; bzr branch lp:percona-qa 3. reducer.sh! $ cd ~; bzr branch lp:randgen $ vi ~/randgen/util/reducer/reducer.sh 4. Short introduction to pquery framework tools The tools introduced in this episode will be covered further in next two episodes. Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
После просмотра урока вы научитесь создавать простейшие SQL-запросы на выборку с условием WHERE, увидите результат выполнения запроса с использованием логических операций AND и OR, узнаете как использовать в условиях ключевые слова LIKE, NOT LIKE, IN, BETWEEN, ESCAPE. Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
Learn to compile/build Percona Server and/or MySQL Server. Various methods of building explained Also expands on git, bzr (bazaar), build-binary.sh, cmake, make, build_percona.sh and get_percona.sh Full-screen viewing recommended Presented by Roel Van de Paar of Percona
Welcome to MySQL QA Episode 9! In this episode you'll learn how to be an expert when it comes to reducing SQL testcases. Topics for today: 1. Expert configurable variables & their default reducer.sh settings 1.1 PQUERY_MULTI 1.2 PQUERY_MULTI_THREADS 1.3 PQUERY_MULTI_CLIENT_THREADS 1.4 PQUERY_MULTI_QUERIES 1.5 PQUERY_REVERSE_NOSHUFFLE_OPT Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar from Percona
My server is crashing... Now what? This episode is for customers or users experiencing a crash or bug in Percona Server or any other flavor of MySQL. 1) A crash? 1.1 Cheat sheet: 🤍 r r m B q i 1.2 Sever install & crash sudo yum install -y 🤍 sudo yum install -y Percona-Server-client-56 Percona-Server-server-56 sudo service mysql start 2) Gimme Stacks! 2.1 Debug info packages sudo yum install -y Percona-Server-56-debuginfo 3) Testcase? Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
This episode introduces mtr_to_sql.sh and pquery-run.sh. Fun guaranteed: this is the first episode in which we get to trigger actual bugs! pquery-run.sh (the main wrapper around pquery) is capable of generating 80-120 MySQL Server crashes - per hour! See how it all works in this episode... Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
Welcome to the 10th episode in the MySQL QA series! Today we'll talk about reproducing and simplifying: How to get it Right. Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode will largely be non-interesting for you. However, what you may like to see - especially if you watched episodes 7 and possibly 8 and 9 - is how reducer automatically generates handy start/stop/client (cl) etc. scripts, all packed into a handy bug tarball, in combination with the reduced SQL testcase. This somewhat separate part is covered directly after the introduction (ends at 11:17), as well as with an example towards the end of the video (starts at time index 30:35). The "in between part" (11:17 to 30:35) is all about reproducing and simplifying, which - unless you are working on a remote case - can likely be skipped by most: remember that 85-95% of bugs reproduce & reduce very easily - and for this - episode 7, episode 8 (especially the FORCE_SKIPV/FORCE_SPORADIC parts), and the script-related parts of this episode (start to 11:17 and 30:35 to end) would suffice. As per the above, the topics covered in this video are: 1. percona-qa/reproducing_and_simplification.txt 2. Automatically generated scripts (produced by Reducer) = Example excerpt for copy/paste - as per the video Though the testcase above should suffice for reproducing the bug, the attached tarball gives the testcase as an exact match of our system, including some handy utilities $ vi {epoch}_mybase # Update base path in this file (the only change required!) $ ./{epoch}_init # Initializes the data dir $ ./{epoch}_start # Starts mysqld (MYEXRA option) $ ./{epoch}_stop # Stops mysqld $ ./{epoch}_cl # To check mysqld is up $ ./{epoch}_run # Run the testcase (produces output) using mysql CLI $ ./{epoch}_run_pquery # Run the testcase (produces output) using pquery $ vi /dev/shm/{epoch}/error.log.out # Verify the error log $ ./{epoch}_gdb # Brings you to a gdb prompt $ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb; standard and full var gdb stack traces Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
Learn how to write SQL Queries(Practice Complex SQL Queries) In this video, I will explain the thinking behind writing an SQL query. We shall go through five different complex SQL queries and try to solve it. The intention is to practice complex SQL queries. The idea is to not just write SQL Queries but also to explain you the thinking behind how to choose a particular approach to solve a SQL query and how to choose different SQL functions or concepts to solve a problem. Link to my blog where I have posted all of these SQL Queries: 🤍 In this blog, you will find 9 SQL queries along with all the scripts to create the table, load data into these tables and also the solved SQL Queries. Out of these 9 SQL Queries, In this video, I have only solved 5 of them in order to reduce the video length. Timeline: 00:00 Intro 01:36 Intro about the blog 03:25 SQL Query to fetch duplicate records from a table using window function 09:27 SQL Query to fetch doctors working in same hospital using self join 15:55 SQL Query to fetch users who logged in consecutively 3 or more times 25:10 SQL Query to fetch days when the temperature was very cold for consecutively 3 or more days 36:13 SQL Query to fetch top 2 accounts with maximum patients per month Learning SQL Concepts and practically writing SQL queries are two different things. You may be familiar with the concept such as window function but until and unless you apply these concepts to write SQL queries, you will never truly understand SQL. May of the queries I am going to solve in this video, I will be using window function such as LEAD, LAG, RANK, ROW_NUMBER etc. However, some of the queries are solved using self join, sub queries or inner joins. The idea behind making this video, is to explain the thinking behind solving an SQL question. How to read the question and understand the problem statement and then analyze the existing data so that we can come up with an approach to write a query which can return the required result. These steps are very important in order for us to determine the different SQL concepts or functions to be used to solve the problem. Please comment below your feedback if you liked this kind of video or if you have any doubts on any other queries mentioned in the blog. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq
DELETE — это команда, которая удаляет данные в таблице. UPDATE — это команда, которая обновляет данные в таблице. Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
Поддержать меня: 🤍 Я в основном проходил интервью на должность Backend или Full-stack программиста, а эти интервью очень часто сопровождались вопросами по SQL. Может мне везет, а может я так уверенно всегда отвечаю на первые вопросы, что мне уже не задают более сложных, но на мой взгляд на интервью всегда были очень простые вопросы по базам данных SQL. В этом видео расскажу о тех вопросах, которые мне регулярно задавали. Обо мне: 🤍 Мой ИТ блог 🤍 и 🤍 Мой просто блог 🤍 Tweeter: 🤍 Инстаграмм: 🤍 Телеграмм: 🤍
Первичный ключ – это поле, которое используется для обеспечения уникальности данных в таблице. Это означает, что значение (информация) в поле первичного ключа в каждой строке (записи) таблицы может быть уникальным. Вторичный ключ – это поле, значения которого могут повторяться в разных записях, то есть он не является уникальным. Домашнее задание: создать таблицу с типом кузова для всех автомобилей, наполнить ее данными, а также добавить столбец в таблицу cars согласно 3НФ Заходите также: Telegram канал: 🤍 Группа в FaceBook: 🤍 Instagram: 🤍 Яндекс.Дзен: 🤍
In MySQL QA Episode 8 - Reducing Testcases for Engineers: tuning reducer.sh - I will cover the following topics; 1. Advanced configurable variables & their default reducer.sh settings 1.1 FORCE_SKIPV 1.2 FORCE_SPORADIC 1.3 TIMEOUT_COMMAND & TIMEOUT_CHECK 1.4 MULTI_THREADS 1.5 MULTI_THREADS_INCREASE 1.6 QUERYTIMEOUT 1.7 STAGE1_LINES 1.8 SKIPSTAGE 1.9 FORCE_KILL 2. Some examples 2.1. FORCE_SKIPV/FORCE_SPORADIC 2.2. TIMEOUT_COMMAND/TIMEOUT_CHECK Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
Commands/Topics covered in this episode: Gnuwin32, Gnuwin32 escaping & path name/binary selection gotcha's, untar, unzip, gzip -d for Windows Full-screen viewing recommended Index to full series: 🤍 Index to all Linux episodes: 🤍 Presented by Roel Van de Paar of Percona
Commands/Topics covered in this episode: variables, export, set, whoami, sleep, ' vs ", $0, $$, $!, kill, sh, grep, sudo, su screen, pwd, chmod, chown Full-screen viewing recommended Index to full series: 🤍 Index to all Linux episodes: 🤍 Presented by Roel Van de Paar
In this episode we continue building on the test setup done in episodes 4 & 5. We are now going into analyzing and filtering, using pquery-prep-red.sh, pquery-clean-known.sh and pquery-results.sh 1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. pquery-clean-known.sh 4. pquery-results.sh 5. Bonus: pquery reach - pquery-reach.sh Full-screen viewing 🤍 720p resolution recommended Presented by Roel Van de Paar of Percona
In this episode, we look at various already existing/production scripts to touch on various items not covered yet in previous episodes. Full-screen viewing recommended. Recommended that you watch earlier parts of episode 1 (1 to 11) first. Index to full series: 🤍 Index to all Linux episodes: 🤍 Presented by Roel Van de Paar of Percona
.svg){kind=small}
