Ending In:
Certification Included
access
lifetime
content
9 Hours
enrolled
455
Description
Course Description
Start learning SQL with practical examples, and you'll be working with tons of popular database systems like MySQL and PostgreSQL in no time. This course will teach you how exactly SQL works so you can start to master effective database design overall. These SQL skills have the power to open immense career opportunities from working as a database administrator in IT to working from home as a freelancer.- Learn database installation & SQL fundamentals w/ 115 lectures & 9 hours of content
- Study Data Manipulation Language Clauses, Various Conditions and Operators, Data Filtering & more
- Understand SQL Data Types in more detail
- Study the MySQL Workbench, a unified visual tool for database development
- Study SQL Joins, SQL functions & SQL data types
- Understand database relationships & normalization
- Master database export & import
Instructor
Pradnyankur Nikam is a freelance PHP and WordPress developer from Pune, Maharashtra, India. He has more than seven years of practical experience working in web designing & development, SEO (Search Engine Optimization), SMO (Social Media Optimization), Online Marketing and more. He designs web applications for clients using HTML5, CSS3, JavaScript, JQuery, Ajax, PHP, MySQL, and WordPress. He's also familiar with Java and Android application development.Important Details
- 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: all levels
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Introduction
- Lecture 1: Course Introduction (1:13)
- Lecture 2: What is SQL? (2:23)
- Lecture 3: Who should learn SQL? (2:17)
- 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 (6:58)
- Lecture 7: How to add a new database user and add privileges (10:04)
- Lecture 8: MySQL Command Line Client shortcut for Windows users (6:40)
- An Overview of SQL
- Lecture 9: What is DBMS and RDBMS? (3:02)
- Lecture 10: Difference between Database Engine, Database Server and Database Software (2:31)
- Lecture 11: What is a database? How to create and use a database? (5:53)
- Lecture 12: What is a database table? How to create and use a database table? (8:44)
- Lecture 13: How to add the data rows to a database table? (7:19)
- Lecture 14: Understand Keywords, Identifiers, Constants and Clauses (2:56)
- Lecture 15: Learn about SQL Statements (1:30)
- Lecture 16: Data Definition Language(DDL) and Data Manipulation Language(DML)? (2:34)
- Important SQL Clauses (Data Manipulation Language)
- Lecture 17: Create example databases, tables and data rows (10:50)
- Lecture 18: Learn about SQL SELECT Clause (5:33)
- Lecture 19: SQL SELECT DISTINCT Statement (5:16)
- Lecture 20: Learn about SQL FROM Clause (3:10)
- Lecture 21: Learn about SQL WHERE Clause (4:56)
- Conditions and Operators (Data Manipulation Language)
- Lecture 22: SQL True Condition (4:18)
- Lecture 23: SQL False Condition (4:42)
- Lecture 24: SQL AND Operator (5:59)
- Lecture 25: SQL OR Operator (6:58)
- Lecture 26: SQL IN Operator (5:09)
- Lecture 27: SQL EXISTS Condition (7:49)
- Lecture 28: SQL NOT IN or NOT EXISTS? Conditions (4:48)
- Lecture 29: SQL Comparison Operators (4:17)
- Lecture 30: SQL LIKE Operator (5:40)
- Lecture 31: SQL BETWEEN Operator (4:35)
- Lecture 32: SQL Numeric Operators (4:14)
- Lecture 33: SQL Concatenation Operator (2:22)
- Lecture 34: SQL Temporal Operator (1:59)
- Data grouping, sorting, select and dates (Data Manipulation Language)
- Lecture 35: Learn about SQL GROUP BY Clause (7:34)
- Lecture 36: Learn about SQL HAVING Clause (5:45)
- Lecture 37: Learn about SQL ORDER BY Clause (4:53)
- Lecture 38: SQL LIMIT or TOP Clause (2:55)
- Lecture 39: SQL Wildcards (4:56)
- Lecture 40: SQL Aliases (6:05)
- Lecture 41: SQL Dates (4:07)
- Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
- Lecture 42: Add the data rows in a table using INSERT INTO Statement (6:04)
- Lecture 43: SQL INSERT INTO SELECT Statement (6:10)
- Lecture 44: Update data rows using UPDATE Statement (7:10)
- Lecture 45: Delete data rows using DELETE Statement (3:38)
- Lecture 46: What is SQL Injection and How to secure a database? (5:49)
- SQL JOINS (Data Manipulation Language)
- Lecture 47: What are JOINS in SQL? Types of SQL JOINS (5:01)
- Lecture 48: Learn about INNER JOIN in SQL (11:05)
- Lecture 49: Learn about LEFT OUTER JOIN in SQL (7:31)
- Lecture 50: Learn about RIGHT OUTER JOIN in SQL (7:32)
- Lecture 51: Learn about FULL OUTER JOIN in SQL (3:52)
- Lecture 52: Learn about CROSS JOIN in SQL (4:29)
- Lecture 53: SQL UNION Operator (4:31)
- Lecture 54: SQL VIEWS (8:12)
- Lecture 55: Derived Tables or Inline Views (5:22)
- SQL Functions
- Lecture 56: Functions in SQL and Types of SQL functions (1:17)
- Lecture 57: SQL COUNT() Function (6:02)
- Lecture 58: SQL FIRST() Function (2:26)
- Lecture 59: SQL LAST() Function (2:47)
- Lecture 60: SQL SUM() Function (2:52)
- Lecture 61: SQL MIN() Function (3:27)
- Lecture 62: SQL MAX() Function (3:14)
- Lecture 63: SQL AVG() Function (3:12)
- Lecture 64: SQL UCASE() Function (2:27)
- Lecture 65: SQL LCASE() Function (2:13)
- Lecture 66: SQL MID() Function (2:51)
- Lecture 67: SQL LEN() Function (2:25)
- Lecture 68: SQL ROUND() Function (3:23)
- Lecture 69: SQL FORMAT() Function (2:48)
- Lecture 70: SQL SUBSTRING() Function (3:05)
- Lecture 71: SQL COALESCE() Function (2:43)
- Lecture 72: SQL CHAR_LENGTH() Function (2:45)
- Lecture 73: SQL CAST() Function (3:41)
- Lecture 74: SQL CASE() Function (6:25)
- Lecture 75: SQL NULLIF() Function (6:12)
- SQL Data Types
- Lecture 76: What is data type in SQL? (2:04)
- Lecture 77: Integer Numbers in SQL (Exact Values) (3:01)
- Lecture 78: Fixed-Point Numbers in SQL (Exact Values) (3:30)
- Lecture 79: Floating-Point Numbers in SQL (Approximate Values) (3:12)
- Lecture 80: CHAR and VARCHAR in SQL (String Values) (2:47)
- Lecture 81: NCHAR and NVARCHAR in SQL (String Values) (1:12)
- Lecture 82: CLOB and BLOB in SQL (String Values) (0:57)
- Lecture 83: DATE, TIME and TIMESTAMP in SQL (Temporal Values) (1:33)
- Data Definition Language
- Lecture 84: Learn how to create and display databases (4:11)
- Lecture 85: Select and use existing database (2:45)
- Lecture 86: Remove or delete database from database management system (2:57)
- Lecture 87: Learn how to create the database table using right method (3:41)
- Lecture 88: Modify or update the database table details (6:10)
- Lecture 89: Remove or delete an existing table (2:16)
- Lecture 90: Understand Constraints in SQL (1:00)
- Lecture 91: NOT NULL Constraint in SQL (8:05)
- Lecture 92: UNIQUE Constraint in SQL (6:46)
- Lecture 93: PRIMARY KEY Constraint in SQL (3:23)
- Lecture 94: FOREIGN KEY Constraint in SQL (10:32)
- Lecture 95: CHECK Constraint in SQL (0:55)
- Lecture 96: DEFAULT Constraint in SQL (4:19)
- Lecture 97: AUTO INCREMENT or SEQUENCE in SQL (4:03)
- Database Relationships
- Lecture 98: Understand Database Relationship in SQL (1:43)
- Lecture 99: One-to-One (1:1) Relationship in SQL (8:45)
- Lecture 100: One-to-Many (1:M) Relationship in SQL (5:27)
- Lecture 101: Many-to-Many (M:M) Relationship in SQL (7:08)
- Database Normalization
- Lecture 102: What is Database Normalization in SQL? (2:32)
- Lecture 103: First Normal Form (1NF) in database normalization (1:14)
- Lecture 104: Second Normal Form (2NF) in database normalization (1:30)
- Lecture 105: Third Normal Form (3NF) in database normalization (1:19)
- SQL Database Export and Import
- Lecture 106: What is SQL Export and Import? (1:17)
- Lecture 107: How to Export the database using SQL statement (8:32)
- Lecture 108: How to Import the database using SQL statement (5:16)
- MySQL Workbench
- Lecture 109: What is MySQL Workbench? (5:14)
- Lecture 110: Create a new user and connect to database using MySQL Workbench (4:20)
- Lecture 111: Create, Alter, Drop database using MySQL Workbench (3:38)
- Lecture 112: Create, Alter, Drop table using MySQL Workbench (7:34)
- Lecture 113: Insert, Read, Update, Delete data rows using MySQL Workbench (4:19)
- Lecture 114: Database Export and Import using MySQL Workbench (8:07)
- Thank You!
- Lecture 115: Thank You! (1:20)
access
lifetime
content
9 Hours
enrolled
455