MySQL is one of the most popular database management systems for small-to-medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as working with data types, operators, and string and mathematical functions. Plus, learn about the key differences between standard SQL and SQL as implemented by MySQL.
If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com
Get More Tutorials and Support Us -->> https://CourseWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Introduction/01 - Harness the power of MySQL.mp4
2.2 MB
~Get Your Files Here !/01 - Introduction/01 - Harness the power of MySQL.srt
1.5 KB
~Get Your Files Here !/01 - Introduction/02 - The exercise files.mp4
2.3 MB
~Get Your Files Here !/01 - Introduction/02 - The exercise files.srt
2.3 KB
~Get Your Files Here !/02 - 1. Overview of SQL/01 - A brief overview of SQL.mp4
6 MB
~Get Your Files Here !/02 - 1. Overview of SQL/01 - A brief overview of SQL.srt
7.3 KB
~Get Your Files Here !/02 - 1. Overview of SQL/02 - Database organization.mp4
4.9 MB
~Get Your Files Here !/02 - 1. Overview of SQL/02 - Database organization.srt
4.5 KB
~Get Your Files Here !/02 - 1. Overview of SQL/03 - Selecting rows.mp4
12.6 MB
~Get Your Files Here !/02 - 1. Overview of SQL/03 - Selecting rows.srt
8.6 KB
~Get Your Files Here !/02 - 1. Overview of SQL/04 - Selecting columns.mp4
4.6 MB
~Get Your Files Here !/02 - 1. Overview of SQL/04 - Selecting columns.srt
3.6 KB
~Get Your Files Here !/02 - 1. Overview of SQL/05 - Counting rows.mp4
5.9 MB
~Get Your Files Here !/02 - 1. Overview of SQL/05 - Counting rows.srt
4.4 KB
~Get Your Files Here !/02 - 1. Overview of SQL/06 - Inserting data.mp4
6.1 MB
~Get Your Files Here !/02 - 1. Overview of SQL/06 - Inserting data.srt
4.8 KB
~Get Your Files Here !/02 - 1. Overview of SQL/07 - Updating data.mp4
7.8 MB
~Get Your Files Here !/02 - 1. Overview of SQL/07 - Updating data.srt
6.3 KB
~Get Your Files Here !/02 - 1. Overview of SQL/08 - Deleting data.mp4
7.7 MB
~Get Your Files Here !/02 - 1. Overview of SQL/08 - Deleting data.srt
6.3 KB
~Get Your Files Here !/02 - 1. Overview of SQL/09 - Joining queries across tables.mp4
10.8 MB
~Get Your Files Here !/02 - 1. Overview of SQL/09 - Joining queries across tables.srt
6 KB
~Get Your Files Here !/02 - 1. Overview of SQL/10 - Finding databases, tables, and columns.mp4
2.2 MB
~Get Your Files Here !/02 - 1. Overview of SQL/10 - Finding databases, tables, and columns.srt
2.3 KB
~Get Your Files Here !/03 - 2. Data Types/01 - What are data types.mp4
6.4 MB
~Get Your Files Here !/03 - 2. Data Types/01 - What are data types.srt
7.1 KB
~Get Your Files Here !/03 - 2. Data Types/02 - The CREATE TABLE statement.mp4
5.5 MB
~Get Your Files Here !/03 - 2. Data Types/02 - The CREATE TABLE statement.srt
4.9 KB
~Get Your Files Here !/03 - 2. Data Types/03 - Numeric types.mp4
8.6 MB
~Get Your Files Here !/03 - 2. Data Types/03 - Numeric types.srt
8.1 KB
~Get Your Files Here !/03 - 2. Data Types/04 - Date and time types.mp4
7.8 MB
~Get Your Files Here !/03 - 2. Data Types/04 - Date and time types.srt
5.8 KB
~Get Your Files Here !/03 - 2. Data Types/05 - String types.mp4
4.3 MB
~Get Your Files Here !/03 - 2. Data Types/05 - String types.srt
5.1 KB
~Get Your Files Here !/03 - 2. Data Types/06 - Enumeration types.mp4
8.5 MB
~Get Your Files Here !/03 - 2. Data Types/06 - Enumeration types.srt
6.4 KB
~Get Your Files Here !/03 - 2. Data Types/07 - The SERIAL type alias.mp4
5.5 MB
~Get Your Files Here !/03 - 2. Data Types/07 - The SERIAL type alias.srt
4.6 KB
~Get Your Files Here !/04 - 3. Operators and Functions/01 - Comparison operators.mp4
6 MB
~Get Your Files Here !/04 - 3. Operators and Functions/01 - Comparison operators.srt
5.6 KB
~Get Your Files Here !/04 - 3. Operators and Functions/02 - Logical operators.mp4
8.6 MB
~Get Your Files Here !/04 - 3. Operators and Functions/02 - Logical operators.srt
6.7 KB
~Get Your Files Here !/04 - 3. Operators and Functions/03 - Arithmetic operators.mp4
2.2 MB
~Get Your Files Here !/04 - 3. Operators and Functions/03 - Arithmetic operators.srt
2 KB
~Get Your Files Here !/04 - 3. Operators and Functions/04 - Operator precedence.mp4
4.1 MB
~Get Your Files Here !/04 - 3. Operators and Functions/04 - Operator precedence.srt
4.6 KB
~Get Your Files Here !/04 - 3. Operators and Functions/05 - The CASE statement.mp4
4.8 MB
~Get Your Files Here !/04 - 3. Operators and Functions/05 - The CASE statement.srt
4.1 KB
~Get Your Files Here !/04 - 3. Operators and Functions/06 - The IF function.mp4
2.3 MB
~Get Your Files Here !/04 - 3. Operators and Functions/06 - The IF function.srt
2.3 KB
~Get Your Files Here !/05 - 4. Sring Functions/01 - String comparisons.mp4
4.3 MB
~Get Your Files Here !/05 - 4. Sring Functions/01 - String comparisons.srt
3.3 KB
~Get Your Files Here !/05 - 4. Sring Functions/02 - Regular expressions.mp4
3.9 MB
~Get Your Files Here !/05 - 4. Sring Functions/02 - Regular expressions.srt
3.6 KB
~Get Your Files Here !/05 - 4. Sring Functions/03 - String concatenation.mp4
3.4 MB
~Get Your Files Here !/05 - 4. Sring Functions/03 - String concatenation.srt
3.6 KB
~Get Your Files Here !/05 - 4. Sring Functions/04 - Numeric conversions.mp4
3.2 MB
~Get Your Files Here !/05 - 4. Sring Functions/04 - Numeric conversions.srt
2.6 KB
~Get Your Files Here !/05 - 4. Sring Functions/05 - Trimming and padding.mp4
5.4 MB
~Get Your Files Here !/05 - 4. Sring Functions/05 - Trimming and padding.srt
5.4 KB
~Get Your Files Here !/05 - 4. Sring Functions/06 - Case conversion.mp4
3.3 MB
~Get Your Files Here !/05 - 4. Sring Functions/06 - Case conversion.srt
3.1 KB
~Get Your Files Here !/05 - 4. Sring Functions/07 - Substrings.mp4
2.5 MB
~Get Your Files Here !/05 - 4. Sring Functions/07 - Substrings.srt
2.5 KB
~Get Your Files Here !/05 - 4. Sring Functions/08 - Soundex.mp4
4 MB
~Get Your Files Here !/05 - 4. Sring Functions/08 - Soundex.srt
3.6 KB
~Get Your Files Here !/06 - 5. Math Functions/01 - Value functions.mp4
5 MB
~Get Your Files Here !/06 - 5. Math Functions/01 - Value functions.srt
4.3 KB
~Get Your Files Here !/06 - 5. Math Functions/02 - Basic math.mp4
3.4 MB
~Get Your Files Here !/06 - 5. Math Functions/02 - Basic math.srt
2.8 KB
~Get Your Files Here !/06 - 5. Math Functions/03 - Simple trigonometry.mp4
2.3 MB
~Get Your Files Here !/06 - 5. Math Functions/03 - Simple trigonometry.srt
1.7 KB
~Get Your Files Here !/06 - 5. Math Functions/04 - Logarithms.mp4
2.9 MB
~Get Your Files Here !/06 - 5. Math Functions/04 - Logarithms.srt
2.5 KB
~Get Your Files Here !/06 - 5. Math Functions/05 - Radians and degrees.mp4
689.4 KB
~Get Your Files Here !/06 - 5. Math Functions/05 - Radians and degrees.srt
623 B
~Get Your Files Here !/07 - 6. Differences from Standard SQL/01 - String concatenation.mp4
2.1 MB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/01 - String concatenation.srt
2.1 KB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/02 - Quote marks.mp4
2.9 MB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/02 - Quote marks.srt
3.2 KB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/03 - Integer division.mp4
3.6 MB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/03 - Integer division.srt
3.5 KB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/04 - Comments.mp4
4.1 MB
~Get Your Files Here !/07 - 6. Differences from Standard SQL/04 - Comments.srt
4.1 KB
~Get Your Files Here !/08 - Conclusion/01 - Thank you.mp4
2.4 MB
~Get Your Files Here !/08 - Conclusion/01 - Thank you.srt
1.8 KB
~Get Your Files Here !/Bonus Resources.txt
386 B
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/Databases/album-mysql.sql
8 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/Databases/scratch-mysql.sql
2.6 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/Databases/world-mysql.sql
376.4 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap01.sql
2.6 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap02.sql
2.7 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap03.sql
2.1 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap04.sql
1.9 KB
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap05.sql
770 B
~Get Your Files Here !/Ex_Files_MySQL_EssT/Exercise Files/sql-chap06.sql