Learning Database Online Training

This Learning Database course enables you to delve deeply into database, to better explore, understand and apply relevant skills.

Through this Learning Database course, you will gain a world-class knowledge and understanding with a focus on the Learning Database, based on solving real-life issues.

This Learning Database course includes a whole host of practical tips and advice, helping you to develop your database skills to become the data analyst, data engineer, web designer, researcher, web designer, or related profession you can be.

This is three courses bundle and they are:

Course 1:Microsoft Access Volume 1 - Tables and Queries

Course 2:Access Databases Volume2 - Forms and Reports

Course 3:ESP32 + Databases to Control Anything Anywhere

Course 4:The Complete MS SQL

Packed with videos, PDFs and exercises, it'll equip you with what it takes to be successful in today’s business landscape, covering a broad range of topics, including lookup wizard, creating and managing table relationships, sort and filtering a table, query wizards and much more.

Frontier Education provides those with no previous experience or working professionals with trailblazing, practice-based teaching, aimed to inspire and prepare you for a career in Learning Database.

• Section 1 3:32:29

  • 1: Access Tables and Queries - 1 - Tour of the screen 10:56
  • 2: Access Tables and Queries - 2 - Using Design view to create and edit tables 45:16
  • 3: Access Tables and Queries - 3 - Using the lookup wizard 08:36
  • 4: Access Tables and Queries - 4 - Importing data from Other Data Sources into Acce 17:52
  • 5: Access Tables and Queries - 5 - Linking Tables from Other data Sources into Acce 10:15
  • 6: Access Tables and Queries - 6 - Exporting data from Access to other data types 02:44
  • 7: Access Tables and Queries - 7 - Creating and Managing Table Relationships 10:29
  • 8: Access Tables and Queries - 8 - Database Tools 04:33
  • 9: Access Tables and Queries - 9 - Sort and Filter a Table 05:32
  • 10: Access Tables and Queries - 10 - Basic Queries 22:29
  • 11: Access Tables and Queries - 11 - Prompting the user for the criteria 04:32
  • 12: Access Tables and Queries - 12 - Creating Calculated Fields in a Query 10:20
  • 13: Access Tables and Queries - 13 -Creating Totals Queries 07:43
  • 14: Access Tables and Queries - 14 - Multiple table Queries 11:59
  • 15: Access Tables and Queries - 15 - Viewing the SQL code for an Access Query 05:52
  • 16: Access Tables and Queries - 16 - Using the Query Wizards 09:00
  • 17: Access Tables and Queries - 17 - Creating Subqueries 03:24
  • 18: Access Tables and Queries - 18 - Creating Make Table, Append, Update and Delete 19:28
  • 19: Access Tables and Queries - 19 - Displaying a certain number of records 01:29

• Section 2 2:50:36

  • 20: Access Forms and Reports - 1 - Autoforms 14:01
  • 21: Access Forms and Reports - 2 - Form Wizard 08:52
  • 22: Access Forms and Reports - 3 - Changing a form with design view 26:10
  • 23: Access Forms and Reports - 4 - Adding controls to your form 21:02
  • 24: Access Forms and Reports - 5 - Subforms 14:51
  • 25: Access Forms and Reports - 6 - Using Autoreport to create a report 03:20
  • 26: Access Forms and Reports - 7 - Using the Report Wizard to create a report 07:15
  • 27: Access Forms and Reports - 8 - Changing a report in design view 11:20
  • 28: Access Forms and Reports - 9 - Adding Calculations to your report 09:13
  • 29: Access Forms and Reports - 10 - Adding Groups, Sorts and Totals to reports 16:10
  • 30: Access Forms and Reports - 11 - Making labels with the Label Wizard 04:26
  • 31: Access Forms and Reports - 12 - Form and Report Properties 05:39
  • 32: Access Forms and Reports - 13 - Exporting a report to Excel 03:15
  • 33: Access Forms and Reports - 14 - Creating a menu with the Switchboard Manager 17:14
  • 34: Access Forms and Reports -15 - Finalizing the Application 07:48

• Intro 09:16

  • 35: 1. Introduction 03:52
  • 36: 2. Who We Are 05:24

• Getting coding environment ready 14:08

  • 37: 1. Download and Install Arduino ESP and USB Driver 06:18
  • 38: 2. Download and Install Arduino ESP32 v1 Development environment 04:05
  • 39: 3. Load Your First Code to ESP32 Board 03:45

• Hosting your website 07:54

  • 40: 1. Hosting Your Website 07:54

• Databases 12:06

  • 41: 1. Creating SQL table 12:06

• PHP 29:09

  • 42: 1. PHP Script to Insert Data in Database 16:32
  • 43: 3. PHP Script to Display Readings 12:37

• Coding 22:40

  • 44: 1. Coding ESP Part1 15:31
  • 45: 2. Coding ESP Part2 07:09

• Practical Live Demonstration 10:43

  • 46: 1. Practical Live Demonstration 07:12
  • 47: 2. Add Actual Sensors and display Reading on Webpage 03:31

• Extra 18:31

  • 48: 1. Download and Install Arduino Pro IDE 09:23
  • 49: 2. ESP 32 Pinout v1 DOIT 09:08

• MS SQL 8:45:18

  • 50: 1a. Introduction 03:55
  • 51: 1b. Course Curriculum overview 04:23
  • 52: 1c. Overview of Databases 08:56
  • 53: 2a. MSSQL Installation 27:19
  • 54: 2b. MSSQL SSMS Installation 07:51
  • 55: 2c. Connecting to MS-SQL (Windows Authentication) 04:41
  • 56: 2d. Connecting to MS-SQL (SQL Server Authentication) 05:35
  • 57: 3a Overview of Challenges 02:38
  • 58: 3b SQL statement basic 12:54
  • 59: 3c. SELECT Statement 16:29
  • 60: 3d. SELECT DISTINCT 16:54
  • 61: 3e. Column AS Statement 09:12
  • 62: 3f. COUNT 09:42
  • 63: 3g. SELECT WHERE Clause – One 04:58
  • 64: 3g. SELECT WHERE Clause – Two 11:38
  • 65: 3i. ORDER BY 09:34
  • 66: 3j. TOP in MSSQL 05:39
  • 67: 3k. BETWEEN 13:13
  • 68: 3l. IN Operator - Condition 08:12
  • 69: 3m. LIKE 12:54
  • 70: 4a. Overview of GROUP BY 08:12
  • 71: 4b. Aggregation Function – SUM() 11:52
  • 72: 4c. Aggregation Function – MIN()-MAX() 08:21
  • 73: 4d. GROUP BY – One(theory) 10:55
  • 74: 4e. GROUP BY – Two(practical) 13:55
  • 75: 4f Task on HAVING 01:00
  • 76: 4f. HAVING 14:46
  • 77: 4fa Sol of Task on HAVING 01:00
  • 78: 5a. Overview Assessment Test 1 02:43
  • 79: 6a. Overview of JOINS 06:39
  • 80: 6b. Introduction to JOINS 07:08
  • 81: 6c. AS Statement 03:44
  • 82: 6d. INNER Join 12:21
  • 83: 6e. Full Outer Join 07:24
  • 84: 6f. Left Outer Join 05:59
  • 85: 6g. Right Outer Join 07:51
  • 86: 6h. Union 07:24
  • 87: 6i JOIN Assignment 01:00
  • 88: 6ia Solution for Joins Assignment 01:00
  • 89: 7a. Basic of Advanced SQL Commands 04:20
  • 90: 7b. Timestamp 11:40
  • 91: 7c. Extract from Timestamp 06:22
  • 92: 7d. Mathematical Scalar Functions 11:08
  • 93: 7e. String Functions 16:40
  • 94: 7f. SubQuery 07:09
  • 95: 9a. Basic of Database and Tables 09:41
  • 96: 9b. Data Types 10:54
  • 97: 9c. Select Datatype on SSMS 05:06
  • 98: 9ei. How to set Primary Key 05:37
  • 99: 9eii. How to set Foreign Key 12:11
  • 100: 9f. Create Table using SQL Script 07:12
  • 101: 9g. Insert 06:29
  • 102: 9h. Update 08:02
  • 103: 9i. Delete 06:35
  • 104: 9j. Alter Table 04:20
  • 105: 9k. Drop Table 02:55
  • 106: 9l. Check Constraint 14:07
  • 107: 9m. NOT NULL Constraint 11:46
  • 108: 9n. UNIQUE Constraint 11:15
  • 109: 10a. Overview of Database and Tables 03:32
  • 110: 10b. Creating a Database backup using SSMS 10:51
  • 111: 10c. Restoring a Database from backup using SSMS 07:35

In this Learning Database course, you will learn and understand the core theories and practices in Learning Database, developing a solid base of knowledge. You will understand core Learning Database theories and practices and be able to think critically, actively contributing towards the body of knowledge in the industry and pushing the boundaries with Learning Database skills.

With expert guidance and a combination of videos, PDFs, and worksheets, this course is designed to prepare you for a career or learning journey.

Course curriculum:

Course 1: Microsoft Access Volume 1 - Tables and Queries

Access Tables and Queries - 1 - Tour of the screen

Access Tables and Queries - 2 - Using Design view to create…and edit tables

Access Tables and Queries - 3 - Using the lookup wizard

Access Tables and Queries - 4 - Importing data from Other…es into Access

Access Tables and Queries - 5 - Linking Tables from Other …es into Access

Access Tables and Queries - 6 - Exporting data from Access…er data types

Access Tables and Queries - 7 - Creating and Managing Tab… Relationships

Access Tables and Queries - 8 - Database Tools

Access Tables and Queries - 9 - Sort and Filter a Table

Access Tables and Queries - 10 - Basic Queries

Access Tables and Queries - 11 - Prompting the user for the criteria

Access Tables and Queries - 12 - Creating Calculated Fields in a Query

Access Tables and Queries - 13 -Creating Totals Queries

Access Tables and Queries - 14 - Multiple table Queries

Access Tables and Queries - 15 - Viewing the SQL code for … Access Query

Access Tables and Queries - 16 - Using the Query Wizards

Access Tables and Queries - 17 - Creating Subqueries

Access Tables and Queries - 18 - Creating Make Table, App…elite Queries

Access Tables and Queries - 19 - Displaying a certain number of records

Course 2: Access Databases Volume2 - Forms and Reports

Course 3: ESP32 + Databases to Control Anything Anywhere

Course 4: The Complete MS SQL

You’ll also be able to access several exclusive bonus resources to help you along your Learning Database journey, including:

• form wizard
• adding controls to your form
• select statement and distinct
• join and union
• update

Top reasons to Study Online at Frontier Education

• Tailor-made: Course adapted to market needs and interests

• Flexible programs: study and work at your own pace on easy-to-use web platforms

• Online education: progressive teaching methods with video or easy to understanding the medium

• Multicultural: connect with classmates from all corners of the globe

This Learning Database is ideal for people looking to progress their career into a data analyst, for those who want to become data engineers, as well as looking to further develop their skills and knowledge.

No prior knowledge or experience required

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included