M
MySQL
by Joshua Mostafa
Start the free chapterVirtual Training Company's MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner's understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.
Course content
Getting Started2 lessons
Database Basics4 lessons
SQL Basics12 lessons
- Finding Your Way About5:551 credit or ad
- Creating a Database2:341 credit or ad
- Creating a Table4:381 credit or ad
- Column Types-String Pt 15:161 credit or ad
- Column Types-String Pt 24:441 credit or ad
- Column Types-Numeric Pt 18:231 credit or ad
- Column Types-Numeric Pt 26:551 credit or ad
- Retrieving Data With Search Criteria5:341 credit or ad
- Changing Existing Data4:351 credit or ad
- Altering A Table5:531 credit or ad
- Keys And Indexes5:311 credit or ad
- Basics Syntax Recap4:241 credit or ad
Operators in MySQL9 lessons
- Arithmetic Operators5:031 credit or ad
- Numeric Comparison Operators8:071 credit or ad
- String Comparison Operators5:341 credit or ad
- Logical Operators8:481 credit or ad
- Bitwise Operators7:211 credit or ad
- Regular Expressions 18:411 credit or ad
- Regular Expressions 2 Pt 16:381 credit or ad
- Regular Expressions 2 Pt 25:101 credit or ad
- Operators Syntax Recap4:531 credit or ad
Querying Your Data7 lessons
More Complex SQL10 lessons
- Using Default Data8:091 credit or ad
- Date And Time 1 Pt 15:161 credit or ad
- Date And Time 1 Pt 24:021 credit or ad
- Date And Time 24:541 credit or ad
- ENUM column type6:491 credit or ad
- SET column type Pt 16:511 credit or ad
- SET column type Pt 25:281 credit or ad
- Using Variables3:121 credit or ad
- Conditional: IF()5:251 credit or ad
- Complex Syntax Recap3:181 credit or ad
Good Practices7 lessons
Security6 lessons
Building A Database Application14 lessons
- Planning The Structure7:121 credit or ad
- Designing The Database Pt 15:331 credit or ad
- Designing The Database Pt 24:491 credit or ad
- Creating The Database Pt 16:251 credit or ad
- Creating The Database Pt 24:331 credit or ad
- Logging In And Out6:381 credit or ad
- Checking Videos In And Out Pt 15:591 credit or ad
- Checking Videos In And Out Pt 27:061 credit or ad
- Searching For A Video6:261 credit or ad
- Adding A New Title8:051 credit or ad
- Signing Up A New Customer3:511 credit or ad
- Hiring And Firing Employees Pt 14:451 credit or ad
- Hiring And Firing Employees Pt 24:281 credit or ad
- Listing Debtors8:031 credit or ad