مطالب پیشنهادی از سراسر وب

دوره WAMP + MySql = Awesome

دسته بندی ها: آموزش مای اس کیو ال (MySQL) ، آموزش های یودمی (Udemy) ، آموزش پایگاه داده

در این آموزش تصویری با نصب WAMP و استفاده از MYSQL آشنا می شوید. این دوره کار با ابزار ها و ویژگی های پایگاه داده MySQL و نحوه نصب و راه اندازی WAMP و MySQL را مورد بررسی قرار می دهد. در ادامه کار با دستورات ، کلید های خارجی ، ساخت جداول ، طراحی پایگاه داده و نحوه به روز رسانی سایت را آموزش می دهد. این دوره آموزشی محصول موسسه Udemy است.

سرفصل های دوره:

  • کار با پایگاه داده
  • کار با کلاس ها
  • ساخت پایگاه داده
  • کار با ابزارها
  • نحوه ساخت جداول
  • کار با کلید های خارجی
  • کار با PHP My Admin
  • معرفی WAMP
  • کار با لیست ها
  • نحوه اسکریپت نویسی
  • استفاده از دستور select
  • کار با دستور ORDER BY
  • استفاده از تابع rand
  • کار با کوئری ها
  • نحوه به روز رسانی پایگاه داده
  • و...

عنوان دوره: Udemy WAMP + MySql = Awesome مدت زمان: 3 ساعت نویسنده: Bill Sims

توضیحات:

I teach you how to install WAMP and MySQL and I show you how to use these 2 tools together to create a Really cool DB.
Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more.
In this course you will Design a database from scratch so that you understand the thought process that goes into such a design. We will then bring in the basic skills of SQL and give you example upon example of how to use this skill while building on those basic skills adding in more technique and more difficulty until they become more advanced. You will learn skills that even you average DBA doesn't do properly.
SQL Statements
Views
Stored Procedures
Triggers
User Defined Functions
and a lot more!
When you are done with this course, you will be able to walk into a interview with a calm confidence and show them that you know what you are doing and apply these skills to build the database back end for an application that will stand the test of time.
If you want a better career take this course you will not be disappointed.
Enroll with confidence! Your enrollment is backed by Udemy's 30-day, no-questions-asked, money-back guarantee!
What are the requirements?
You don't need to know anything before taking this course
What am I going to get from this course?
Design a Complex Database For Any Line Of Business Application
Be Able To Write Complex SQL Statements
Be able to manipulate a massive amount of data in milliseconds.
Understand what a Relational Database Is
Understand Primary and Foreign Keys
What is the target audience?
If you have ever wanted to understand databases you should take this course
If you want to know how to speed up Queries you should take this course.
If You have never Seen a Database You Should Take this course

Section 1: Let's Discuss The Project We Will Do Throughout this class Lecture 1 Intro 00:44 Lecture 2 What Is This Course About? 00:41 Lecture 3 Hit the HD button for the best experience 00:11 Lecture 4 What is a Database 01:35 Lecture 5 What will this class cover 00:47 Lecture 6 Look at these quick examples of Databases 02:48 Lecture 7 Let's Introduce Our Project 01:46 Lecture 8 Lets Have An Initial Design Discussion About Our Database 01:42 Lecture 9 Tools In Our Database Toolbox 03:10 Lecture 10 Initial Discussion About Tables 05:38 Lecture 11 Foreign Keys 01:49 Lecture 12 Download WAMP 01:16 Lecture 13 Simple Tour Of PHP My Admin 01:24 Lecture 14 Creating Our Database and First Table 05:14 Lecture 15 Walk Through of PHP My Admin From a Database Standpoint 01:37 Lecture 16 Creating Our Vendor and Customer Tables 05:47 Lecture 17 Band List Lecture 18 Filing Out Our Data 08:26 Section 2: Basic SQL Lets Discuss The Select Statment Lecture 19 Vendor List Lecture 20 Fill Out Our Vendors 10:44 Lecture 21 Insert 1 Record By Script 03:10 Lecture 22 Massive Customer Import 04:38 Lecture 23 Massive Import Script Lecture 24 Working Examples Of A Select Statement 06:25 Lecture 25 Answers to Our Excercises 03:20 Lecture 26 Order By Clause 03:30 Lecture 27 Where Clause In Detail 04:56 Lecture 28 The Like Statement 03:53 Lecture 29 DataExport Lecture 30 How To Export and Import Data 02:15 Lecture 31 Database Redesign 11:11 Lecture 32 Lets Do another Foreign Key 06:39 Section 3: Creating Random Data Lecture 33 Adding A Band Member Table 08:09 Lecture 34 SQL Excercise : Add The Remaining 3 Band Members Lecture 35 Answer to Excercise 00:53 Lecture 36 The In Statement 05:16 Lecture 37 Using The Rand Function To Make Random Data 05:58 Lecture 38 Create Random Demographic Data 04:11 Section 4: Sub-queries Lecture 39 What is a Sub-query and how to use it 07:27 Section 5: Analytics Lecture 40 SQL Exercise: Update Genre Based on GenreID and Use A Sub-query To Do It 01:09 Lecture 41 Solution To The Sub-Query Excercise Lecture 42 Explaination of the Excercise 02:17 Lecture 43 Basic Analytics Using Aggregate Functions 01:51 Lecture 44 Answer To the Analytics Excercise Lecture 45 Explanation of the Analytics Excercise 02:36 Section 6: Analytics With A Group By Lecture 46 Our First Group BY 04:03

حجم فایل: 461MB

آیا این نوشته را دوست داشتید؟
Udemy WAMP Plus MySql Awesome

پیشنهاد آموزش مرتبط در فرادرس

لینک های دانلود Udemy WAMP Plus MySql Awesome_git.ir.rar