پیشنهاد فرادرس

آموزش SQL با دیتابیس MySQL از مقدماتی تا پیشرفته

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

در این آموزش تصویری با نحوه کار با دستورات SQL در دیتابیس MySQL از مقدماتی تا پیشرفته آشنا می شوید. این دوره آموزشی محصول موسسه Udemy است.

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

  • SQL چیست؟
  • نصب پایگاه اطلاعاتی MySQL روی Windows
  • نصب پایگاه اطلاعاتی MySQL روی Mac
  • نصب پایگاه اطلاعاتی MySQL روی Linux
  • اضافه کردن پایگاه داده جدید
  • بررسی SQL
  • DBMS و RDBMS چیست؟
  • استفاده از پایگاه داده
  • استفاده از جدول
  • اضافه کردن سطر و ستون
  • آشنایی با کلمات کلیدی، ثابت و متغیرها
  • کار با دستورات SQL
  • تعریف داده های DDL
  • دستکاری داده ها DML
  • کار با دستور SELECT DISTINCT
  • کار با WHERE
  • استفاده از حلقه WHERE
  • استفاده از عملگر OR
  • کار با دستورات شرطی
  • کار با مقادیر ثابت
  • نحوه مقایسه اپراتورها
  • استفاده از عملگر LIKE
  • کار با توابع date و time
  • کار با دستور GROUP BY
  • کار با دستور HAVING
  • ارتباطات بین جداول پایگاه داده
  • نحوه گروه بندی داده ها و مرتب سازی
  • به روز رسانی داده ها
  • استفاده از دستور DELETE
  • نحوه ایمن سازی پایگاه داده
  • کار با دستورات Insert ، Read ، Update و Delete
  • کار با دستور INNER JOIN در SQL
  • کار با دستور OUTER JOIN در SQL
  • کار با دستور RIGHT OUTER JOIN در SQL
  • کار با دستور FULL OUTER JOIN در SQL
  • کار با انواع توابع در SQL
  • کار با تابع ()COUNT
  • کار با تابع ()FIRST
  • کار با تابع ()LAST
  • کار با تابع ()SUM
  • کار با تابع ()MIN
  • کار با تابع ()MAX
  • کار با تابع ()AVG
  • کار با تابع ()UCASE
  • کار با تابع ()ROUND
  • کار با تابع ()FORMAT
  • کار با تابع ()CHAR_LENGTH
  • کار با تابع ()NULLIF
  • کار با اعداد صحیح
  • و...

عنوان دوره: Udemy SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert مدت زمان: 9 ساعت نویسنده: Pradnyankur Nikam

توضیحات:

Udemy SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

9 Hours All Levels Pradnyankur Nikam

Learn SQL and Database Development: SQL Tutorial for learning Structured Query Language using MySQL Database SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert Why should you take this SQL course? Course updated: 8 April 2016 (Quiz for section 7 and 8 added.) Subtitles: English Captions or Subtitles for all the lectures are available. This course is one of the biggest, best rated and top selling SQL course on Udemy Marketplace! You will learn SQL with practical examples. By learning structured query language, you will be able to work in any database system like MySQL, PostgreSQL, SQL Server, DB2, Oracle etc. You will learn Database designing, Database modeling, SQL RDBMS concepts, Database relationships and much more, everything by using SQL commands. You get a SQL video tutorial course which will teach you how to use structured query language statements in MySQL command line client tool. The SQL statements are common to all major database management systems. The course includes 8 Quizzes with 160+ SQL Questions and Answers for the Job interview. Lightning fast support to all your queries: I personally respond to all the students queries via PM or on the discussion board within 1 hour to 24 hours. I respond on weekends too. So If you have any question feel free to PM me or ask on the discussion board. Lifetime access to all the content and future updates of this course. 30 days money back guarantee. (I am sure you will never need this.) You will understand how SQL works and learn effective database design for your applications. In this course we'll learn SQL with practical example on every topic. We will learn in more detail about, Database Installation and SQL fundamentals. Data Definition Language(DDL) and Data Manipulation Language(DML). SQL Joins, SQL functions and SQL data types. Database Relationships and Database Normalization. Database Export and Import. MySQL workbench. Do you know the Benefits of learning SQL? Learning the Structured Query Language gives you a powerful tool which can be implemented in variety of application development including web, desktop and mobile application development. SQL is ANSI standard and used in all major database management systems. SQL skill opens a new dimension in the jobs where you can work as a database administrator in IT companies or you can work as a freelancer. Database development is very important factor in any application development So learning database development skill is very beneficial for you. Checkout this SQL tutorial Overview The section 1 to 3 covers Introduction, Database Installation, SQL Overview and learn terminology used in Structured Query Language. In section 4 to 9 we will learn Data Manipulation Language, Clauses, Various Conditions and Operators, Data Filtering and sorting, SQL Joins and the most Important SQL Functions. In section 10 to 13 we will understand SQL Data Types in more detail, Data Definition Language, Database Normalization & Database Export and Import functionality. The section 15 covers MySQL Workbench a unified visual tool for database development. The section 16 contain bonus lecture. What students say about this course? Checkout some of my students reviews for this course. I recommend this course to every student who want to learn SQL. - By Rachel I really love this course. I am now in the middle of the course and I can't believe how much I've been learning. There are a lot of things to learn! The teacher is very concise and practical, giving as well enough theory to back all up. - By Victor This is the best course about SQL I've seen so far. The instructor provided very detailed instructions with a lot of examples. - By Tho Ngoc Le The course was very thorough, methodical and focused on applications of SQL. The instructor was very helpful in demystifying any ambiguities that were present and clearly explained with examples any concerns. The course is very good to learn SQL using the command-line which is very crucial and there is a full section on using MySQL workbench which is the GUI part my MySQL. I do recommend this course for anyone who wants to learn MySQL and SQL in general. - By Nader I loved the way instructor explained each topic with different practical examples using MySQL command line client. - By sgsArcade Learning the SQL skill was helpful for my project. - By Elisabeth Excellent course and the Trainer has skill in delivering information at the correct speed and focuses on things we need to focus on. - By Sunil Note: Checkout more reviews in the Reviews section. Watch introduction video and click the Full Curriculum link to see the list of all the sections and lectures included with this SQL course. What are the requirements? No coding, design or technical knowledge required. A computer with any operating system installed on it. Basic computer knowledge is required to learn from this course. You don't need to buy any software. We will install and use MySQL which is absolutely free. What am I going to get from this course? Over 115 lectures and 9 hours of content! Understand the Database terminology and Structured Query Language fundamentals. At the end of this course, You will be able to use SQL statements in any database management system. You will learn from SQL basics to advanced topics like JOINS, Database Relationships, Database Normalization. You will learn each topic step by step with practical examples. You will learn the skills useful for professional Database Development (Database Modeling) and Database Management. You will also learn about MySQL Workbench, a unified visual tool for database architects, developers, and Database Administrators. What is the target audience? Database developers and database administrators. Desktop & mobile application developers. Network applications developers. Graduate and undergraduate students for academic purpose. People who love to learn new skills. Non technical, startups and Job seekers.

Section 1: Introduction Lecture 1 Course Introduction 01:13 Lecture 2 What is SQL? 02:23 In this lecture we will learn briefly about, What is SQL? The full form of SQL? Who developed SQL? The benefits of learning SQL and How to pronounce SQL. Lecture 3 Who should learn SQL? 02:17 Quiz 1 Introduction 12 questions Did you complete this section? Solve the section 1 quiz to know how much you understood from this section. If you got multiple wrong answers, please watch the videos again to improve your understanding. If you have any question suggestion feel free to ask me on the discussions board. Section 2: Setup a Testing Environment Lecture 4 Install MySQL database server on Windows operating system 13:31 Lecture 5 Install MySQL database server on Mac operating system 12:49 Lecture 6 Install MySQL database server on Linux operating system 06:58 Lecture 7 How to add a new database user and add privileges 10:04 Lecture 8 MySQL shortcut for Windows users 06:40 Quiz 2 Setup a Testing Environment 10 questions Section 3: An Overview of SQL Lecture 9 What is DBMS and RDBMS? 03:02 Lecture 10 Difference between Database Engine, Database Server and Database Software 02:31 Lecture 11 What is a database? How to create and use a database? 05:53 Lecture 12 What is a database table? How to create and use a database table? 08:44 Lecture 13 How to add the data rows to a database table? 07:19 Lecture 14 Understand Keywords, Identifiers, Constants and Clauses 02:56 Lecture 15 Learn about SQL Statements 01:30 Lecture 16 Data Definition Language(DDL) and Data Manipulation Language(DML)? 02:34 Quiz 3 An Overview of SQL 38 questions Solve the section 3 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board. Section 4: Important SQL Clauses (Data Manipulation Language) Lecture 17 Create example databases, tables and data rows 10:50 Lecture 18 Learn about SQL SELECT Clause 05:33 Lecture 19 SQL SELECT DISTINCT Statement 05:16 Lecture 20 Learn about SQL FROM Clause 03:10 Lecture 21 Learn about SQL WHERE Clause 04:56 Quiz 4 Important SQL Clauses 10 questions Section 5: Conditions and Operators (Data Manipulation Language) Lecture 22 SQL True Condition 04:18 Lecture 23 SQL False Condition 04:42 In this lecture lets use WHERE clause with FALSE condition. Lecture 24 SQL AND Operator 05:59 Use more than one condition in the SQL statement using AND Operator. Lecture 25 SQL OR Operator 06:58 Use more than one condition in the SQL statement using OR Operator. Lecture 26 SQL IN Operator 05:09 Evaluate multiple values on a single data column using IN Operator. Lecture 27 SQL EXISTS Condition 07:49 Evaluate the data rows with constant values using EXISTS condition. Lecture 28 SQL NOT IN or NOT EXISTS? Conditions 04:48 Revert the IN or EXISTS condition using NOT keyword. Lecture 29 SQL Comparison Operators 04:17 Compare the two values using Comparison Operators. Lecture 30 SQL LIKE Operator 05:40 Search for a specific pattern in a string using LIKE Operator. Lecture 31 SQL BETWEEN Operator 04:35 The BETWEEN Operator tests a range of values with a column value. Lecture 32 SQL Numeric Operators 04:14 The Numeric Operators are used for mathematical calculations. Lecture 33 SQL Concatenation Operator 02:22 The Concatenation Operator joins the two strings together. Lecture 34 SQL Temporal Operator 01:59 The Temporal Operators are useful for date time calculations. Quiz 5 Conditions and Operators 22 questions Solve the section 5 quiz so that you will know how much you understood from this section. If you have any question suggestion feel free to ask me on the discussions board. Section 6: Data grouping, sorting, select and dates (Data Manipulation Language) Lecture 35 Learn about SQL GROUP BY Clause 07:34 Aggregate many rows into one using the GROUP BY Clause. Lecture 36 Learn about SQL HAVING Clause 05:45 Use the HAVING Clause to filter the group rows produced by the GROUP BY Clause. Lecture 37 Learn about SQL ORDER BY Clause 04:53 Systematically order or sort the data rows in a result set using ORDER BY Clause. Lecture 38 SQL LIMIT or TOP Clause 02:55 Get only specific number of data rows using LIMIT or TOP Clause. Lecture 39 SQL Wildcards 04:56 Use SQL Wildcards to substitute any other characters in a string. Lecture 40 SQL Aliases 06:05 Assign temporary names to database tables or a columns using SQL Aliases. Lecture 41 SQL Dates 04:07 Store date, time or date and time together using SQL Dates. Quiz 6 Data grouping, sorting, select and dates 15 questions Section 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language) Lecture 42 Add the data rows in a table using INSERT INTO Statement 06:04 Lecture 43 SQL INSERT INTO SELECT Statement 06:10 Lecture 44 Update data rows using UPDATE Statement 07:10 Lecture 45 Delete data rows using DELETE Statement 03:38 Lecture 46 What is SQL Injection and How to secure a database? 05:49 Quiz 7 Insert, Read, Update, Delete the Data Rows (Data Manipulation Language) 22 questions Section 8: SQL JOINS (Data Manipulation Language) Lecture 47 What are JOINS in SQL? Types of SQL JOINS 05:01 Lecture 48 Learn about INNER JOIN in SQL 10:32 Lecture 49 Learn about LEFT OUTER JOIN in SQL 07:31 Lecture 50 Learn about RIGHT OUTER JOIN in SQL 07:32 Lecture 51 Learn about FULL OUTER JOIN in SQL 03:52 Lecture 52 Learn about CROSS JOIN in SQL 04:29 Lecture 53 SQL UNION Operator 04:31 Lecture 54 SQL VIEWS 08:12 The SQL VIEWS are the database objects similar to virtual tables. Lecture 55 Derived Tables or Inline Views 05:22 Quiz 8 SQL JOINS (Data Manipulation Language) 33 questions Section 9: SQL Functions Lecture 56 Functions in SQL and Types of SQL functions 01:17 Lecture 57 SQL COUNT() Function 05:44 Lecture 58 SQL FIRST() Function 02:26 The FIRST function returns the first data row value of the given column. Lecture 59 SQL LAST() Function 02:47 The LAST function returns the last data row value of the given column. Lecture 60 SQL SUM() Function 02:52 The SUM function returns the total sum of a given numeric column. Lecture 61 SQL MIN() Function 03:27 The MIN or MINIMUM function returns the smallest value of the given column. Lecture 62 SQL MAX() Function 03:14 The MAX or MAXIMUM function returns the largest value of the given column. Lecture 63 SQL AVG() Function 03:12 The AVG or AVERAGE function returns the average value of the given numeric column. Lecture 64 SQL UCASE() Function 02:27 The UCASE function converts string data row values to uppercase. Lecture 65 SQL LCASE() Function 02:13 The LCASE function converts string data row values to lowercase. Lecture 66 SQL MID() Function 02:51 The MID function extracts characters from the given string data. Lecture 67 SQL LEN() Function 02:25 The LEN function returns the length of the given string value. Lecture 68 SQL ROUND() Function 03:23 The ROUND function is used to round a floating point number to the given decimal numbers. Lecture 69 SQL FORMAT() Function 02:48 The FORMAT function is used to round a floating point number to the given decimal numbers. Lecture 70 SQL SUBSTRING() Function 03:05 The SUBSTRING function extracts characters from the given string data. Lecture 71 SQL COALESCE() Function 02:43 The COALESCE function return the first non-NULL value from the given list. Lecture 72 SQL CHAR_LENGTH() Function 02:45 The CHAR_LENGTH function returns the length of the given string value. Lecture 73 SQL CAST() Function 03:41 The CAST function is used to change the data type of a value. Lecture 74 SQL CASE() Function 06:25 The CASE function returns a value or NULL by evaluating series of conditions. Lecture 75 SQL NULLIF() Function 06:12 The NULLIF function returns NULL value, if the two parameter values are equal. Section 10: SQL Data Types Lecture 76 What is data type in SQL? 02:04 Lecture 77 Integer Numbers in SQL (Exact Values) 03:01 Lecture 78 Fixed-Point Numbers in SQL (Exact Values) 03:30 Lecture 79 Floating-Point Numbers in SQL (Approximate Values) 03:12 The Floating Point Numbers or Approximate Values in SQL are stored using FLOAT, REAL and DOUBLE PRECISION data types. Lecture 80 CHAR and VARCHAR in SQL (String Values) 02:47 Lecture 81 NCHAR and NVARCHAR in SQL (String Values) 01:12 Lecture 82 CLOB and BLOB in SQL (String Values) 00:57

آیا این نوشته را دوست داشتید؟
Udemy SQL Tutorial Learn SQL with MySQL Database - Beginner2Expert

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 708.0MB Udemy SQL Tutorial Learn SQL with MySQL Database - Beginner2Expert_git.ir.rar