PAC | SQL Beginner To Guru: MySQL Edition - Master SQL With MySQL (2019 EN)

Company: Packt Publishing
Author: John Thompson
Full Title: SQL Beginner To Guru: MySQL Edition - Master SQL With MySQL
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: -
Price: €182.99
-
Files: MP4 (+ Exercises Files, Code Files)
Time: 10:51:05
Video: AVC, 1920 x 1080 (1.778) at 29.970 fps, 500 kbps
Audio: AAC at 103 Kbps, 2 channels, 44.1 KHz



SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

SQL is the programming language used to get data in and out of databases. Relational databases are extremely popular with companies of all sizes. Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.


Learn:
✓ Become a SQL guru! Be that 'go-to' person!
✓ Master SQL to create reports from realistic MySQL databases
✓ See how to aggregate and analyze data using SQL functions
✓ Create your own database through the power of SQL
✓ Understand how to leverage database transactions
✓ Tune SQL statements for optimum performance
✓ Avoid common mistakes with SQL

Features:
✓ Learn to aggregate and analyze data using SQL functions
✓ Learn to master SQL using MySQL.


Lessons:
1. SQL Beginner to Guru MySQL Edition Introduction
001. Getting the Most out of Your SQL Course
002. SQL - Let's write our first SQL!
003. SQL Fiddle Assignment Review
2. Introduction to SQL
004. Introduction to SQL
005. What is a Database?
006. Relational Database Principles
007. Assignment: Create Tables and Insert Data
008. Assignment Review: Create Tables and Insert Data
009. History of SQL
010. What is a Relational Database Management System?
011. History of MySQL
012. RDBMS Deployment Architectures
013. Flashcards
014. Conclusion
3. Installation of MySQL
015. Introduction
016. Review of MySQL Installation Options
017. MySQL Windows 10 Installation
018. MySQL OSX Installation
019. MySQL Linux Installation Ubuntu
020. MySQL Linux Installation CentOS
4. Connecting to MySQL
021. Introduction
022. Connecting to MySQL Overview
023. MySQL Command Line for OSX and Linux
024. MySQL Command Line for Docker
025. MySQL Workbench OSX Installation
5. Selecting Data from a Single Table
026. Introduction
027. Importing the MySQL Employee Database
028. Assignment use SQL to get Row Counts
029. Assignment Review - Use SQL to get Row Counts
030. Review of the SQL Select Statement
031. Selecting Specific Columns from Tables
032. Using Aliases to Name Columns
033. Using the SQL CONCAT Function to Join Columns
034. SQL Arithmetic Operators
035. Using SQL Arithmetic Operators in Selecting Data
036. SQL Data Types
037. Formatting Date Values with MySQL
038. Using the LEFT and RIGHT MySQL Functions
039. Introduction to the SQL WHERE Clause
040. SQL WHERE Clause with Equals and Not Equals
041. Using AND and OR with SQL WHERE Clause
042. Using IN and NOT IN with with SQL WHERE Clause
043. Dealing with NULL Values in SQL WHERE Clause
044. Using Greater Than and Less Than with SQL WHERE Clause
045. Using LIKE and NOT LIKE with SQL WHERE Clause
046. Using BETWEEN and NOT BETWEEN with SQL WHERE Clause
047. Ordering Results with SQL ORDER BY
048. Limit Results with SQL LIMIT Clause
049. Using SQL to Select DISTINCT Values
050. Using SQL Sub-selects with IN in SQL Where Clause
051. Assignment - Fix SQL Statements
052. Assignment Review
053. Conclusion
6. Grouping and Summarizing Data with SQL
054. Introduction
055. Using the SQL GROUP By clause
056. MySQL Aggregate Functions
057. Using the SQL HAVING Clause
058. Using the SQL SUM Function
059. Using the SQL Min and Max Functions
060. Using the SQL AVG Function
061. Assignment - Write SQL Report for Salary Information by Year Excluding Managers
062. Assignment Review
063. Conclusion
7. Using SQL to Select Data from More Than One Table
064. Introduction
065. Overview of SQL Table Joins
066. Introduction to SQL Inner Joins
067. Using Table Aliases with SQL Inner Joins
068. Limiting Columns Displayed with SQL Inner Joins
069. Using a WHERE Clause with SQL Inner Joins
070. Assignment - Create Department Employee Report
071. Assignment Review - Create Department Employee Report
072. Using SQL Natural Joins
073. Using SQL Equi-Joins
074. Using SQL Union Joins
075. Other MySQL Functions
076. Using SQL LEFT OUTER JOINS
077. Assignment - Write SQL LEFT OUTER JOIN
078. Assignment Review - Write SQL LEFT OUTER JOIN
079. Conclusion
8. Using SQL to Insert Data
080. Introduction
081. Overview of the SQL Insert Statement
082. Example SQL Insert Statement
083. Specifying Columns in SQL Inserts
084. Assignment - Use SQL to create a record in DEPARTMENTS table
085. Assignment Review - Use SQL to create a record in DEPARTMENTS table
086. Using a SQL Sub-select with SQL Insert Statements
087. SQL Core Concept - Foreign Key Constraints
088. Assignment - Use SQL Inserts to create a new Employee
089. Assignment Review - Use SQL Inserts to create a new Employee
090. Conclusion
9. Using SQL to Update Data
091. Introduction
092. Overview of the SQL Update Statement
093. Example SQL Update Statement
094. Assignment - Use SQL Update Statement to Change Employee Name
095. Assignment Review - Use SQL Update Statement to Change Employee Name
096. Assignment - Using SQL Update and Insert to Create a New Salary Record
097. Assignment Review - Using SQL Update and Insert to Create a New Salary Record
098. Using SQL to drop the employee database
099. Assignment - Re-import the employee database
100. Assignment - Review re-import employee database
101. Conclusion
10. Using SQL to Delete Data
102. Introduction
103. Overview of the SQL DELETE statement
104. Example of the SQL DELETE Statement
105. Assignment - Create, Update, and Delete an Employee record
106. Assignment Review - Create, Update, and Delete an Employee Record
107. Conclusion
11. Using SQL Transactions
108. Introduction
109. Introduction to SQL Transactions
110. Demonstration of Database Transactions
111. Assignment - Create Employee Using SQL Transactions
112. Assignment Review - Create Employee Using SQL Transactions
113. Demonstration of Database Locks
114. User Defined Variables in MySQL
115. Demonstration of Lost SQL Updates
116. Using SQL Select for Update
117. Conclusion
12. Advanced SQL Reporting
118. Introduction
119. Overview of the Northwind Database
120. Assignment - Import the Northwind Database
121. Assignment Review - Import the Northwind Database
122. Assignment - Create Orders Report
123. Assignment Review - Create Orders Report
124. Assignment - Monthly Sales Report by State
125. Assignment Review - Monthly Sales Report by State
126. Assignment - Create Monthly Profit Report by Item
127. Assignment Review - Create Monthly Profit Report by Item
128. Assignment - Create a Weekly Sales Report by Employee
129. Assignment Review - Create a Weekly Sales Report by Employee
130. Weekly Sales Report by Employee Revisited
131. Conclusion
13. Introduction to DDL Statements - Creating SQL Views
132. Introduction to Views
133. Demonstration using SQL DDL Creating a Database View
134. Assignment - Create Orders View
135. Assignment Review - Create Orders View
136. Materialized Views in MySQL
14. Using SQL to Create MySQL Database Tables
137. Overview of SQL Create Table Syntax
138. Creating a Table with SQL Select
139. SQL Truncate Table Command
140. SQL Drop Table Command
141. SQL Create Table Example
142. SQL Create Table Example with Primary Key
143. SQL Create Table with Auto-Increment Primary Key
144. SQL Create Table with Foreign Keys
145. SQL Create Table with Indexes
146. SQL Create Table with Unique Indexes
147. Assignment - SQL Create Table
148. Assignment Review - SQL Create Table
15. Using SQL to Update Tables
149. Introduction to the SQL Alter Table Command
150. Using SQL Alter Table Command to Add and Remove a Column
151. Using SQL Alter Table to Reorder Columns
152. Using SQL Alter Table Command to Add or Remove an Index
153. Using SQL Alter Table Command to Add or Remove a Foreign Key Constraint
154. Assignment - Add ASIN, UPC, and EAN to Book Table using SQL Alter Table Command
155. Assignment Review - Add ASIN, UPC, EAN to Book Table using SQL Alter Table Cmd
156. Using SQL Alter Table for MySQL Generated Columns

Our members see more. Join us!
-------------
Our members see more. Join us!