Complete WAMP & MySQL Course

Complete WAMP & MySQL Course

3 Hours
Deal Price$19.00
Suggested Price
$50.00
You save 62%
Complete WAMP & MySQL Course
$19.00$50.0062% OFF
Complete WAMP & MySQL Course

46 Lessons (3h)

  • First Section
    1) intro0:41
    3) What is a Database?1:35
    4) What will this class cover?0:47
    5) Lets discuss a music festival1:46
    6) Look at these examples of Databases1:42
    7) Tools In Our Database Toolbox3:10
    8) Initial Discussion About Tables5:38
    9) Foreign Keys1:49
    10) Download WAMP1:16
    11) Needs Fixes Installing WAMP3:41
    12) Simple Tour Of PHPMyAdmin1:24
    13) Creating Our Database and First Table5:14
    14) Walk Through of PHP My Admin From a Database Standpoint1:37
    15) Creating Our Vendor And Customer Tables5:47
    16) Creating our first vendor and customer table5:47
    18) Filling out Our Data8:26
  • Second Section
    20) Fill Out Vendors10:44
    21) Insert 1 Record By Script3:10
    22) Massive Customer Import4:38
    23) Massive Import Script4:38
    24) Working Examples of a Select Statement6:25
    25) answers to those excercises3:20
    26) Order by Clause3:30
    27) Where Clause In Detail4:56
    28) The Like Statement3:53
    30) How to export and import data2:15
    31) Database Redesign5:31
    32) Lets do another Foreign Key6:40
  • Third Section
    33) Adding a band member table8:09
    35) Answer to exercise0:53
    36) The IN Statement5:16
    37) Using Rand Function to make random data5:58
    38) Create random demographic data4:11
  • Fourth Section
    39) What is a sub-query and how to use it7:27
  • Fifth Section
    40) SQL Exercise1:09
    42) Explanation of the exercise2:17
    43) Basic analytics using aggregate functions1:51
    45) Explanation of the analytics exercise2:36
  • Sixth Section
    46) Our first Group By4:03
Complete WAMP & MySQL Course
$19.00$50.0062% OFF
View similar items
DescriptionInstructorImportant DetailsRelated Products

Use WAMP & MySQL Together to Create a Database

BS
Bill SimsBill Sims has spent his life teaching others how to be better developers and master the art of software engineering. He has designed many enterprise-level applications as well as iOS and Android applications. The skills he teaches in his courses are the same skills that he uses every day to do everything from running his teams to consulting on projects. In his career, he has found classes like this to be helpful in advancing his career, and he hopes to drive you to the next level in your own career. For more details on this course and instructor, click here.

Description

You may have heard the term LAMP, and WAMP is an equivalent Web stack for Windows operating systems. Together, Windows, Apache, MySQL, and PHP become the canvas on which amazing apps are developed. This course will teach you to create a database using WAMP and SQL so that you will be able to manage extremely large amounts of data with ease.

  • Create a database using WAMP & SQL w/ 46 lectures & 3 hours of content
  • Design a complex database for any line of business application
  • Write complex SQL statements
  • Manipulate a massive amount of data in milliseconds
  • Understand what a relational database is
  • Understand primary & foreign keys
  • Study SQL statements, views, stored procedures, triggers & user-defined functions
  • Install WAMP & MySQL

Specs

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...