MySQL, SQL and Stored Procedures from Beginner to Advanced
4.0 /5- Offered byUDEMY
MySQL, SQL and Stored Procedures from Beginner to Advanced at UDEMY Overview
Duration | 18 hours |
Total fee | ₹389 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
MySQL, SQL and Stored Procedures from Beginner to Advanced at UDEMY Highlights
- Certificate of completion
- 66 downloadable resources
- 30-Day Money-Back Guarantee
- Full Lifetime Access
MySQL, SQL and Stored Procedures from Beginner to Advanced at UDEMY Course details
- Learner will:
- Create, query and update databases
- Use triggers, views and stored procedures
- Understand transactions and database isolation levels
- Understand database users and security
- This course will take learner from beginner in SQL and MySQL to an advanced level
- Whether learners are a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help learner
MySQL, SQL and Stored Procedures from Beginner to Advanced at UDEMY Curriculum
Introduction
Introducing MySQL
Getting Started
Installing MySQL and the Workbench
Using the Command Line
Creating Tables
Multiple Columns, int and Data Types
Null Values and Not Null
Mysql Storage Engines and Configuration
SQL Modes
Deleting All the Data in a Table
Primary Keys
Auto Increment
Narrowing Down Select Statements
Importing and Exporting Data
Exporting and Importing Data
Exporting Using the Command Line
Importing Using the Command Line
MySQL Operators
Some Test Data
Comparison Operators
Logical Operators
018 Exclusive Or
Exercises Part 1
Solutions Part 1
Update, Order and Limit
Beginning Update Statements
Order By
Limiting Results
MySQL Data Types
Mysql Types
Text Types
Floating Point Types and Ints
The Bit Type
Bool
Blobs
Time, Date and Year
Timestamp and Datetime
Enumerations
Brackets and Conditions Revisited
Exercises 2
Solutions 2
Aggregate Functions and Grouping
The distinct keyword
Counting Distinct Values
Aggregate Functions
Arithmetic in MySQL
The Health Survey Dataset
Group By
Having- Restricting Groups By Aggregate Functions
Exercises 3
Solutions 3
Foreign Keys and Multiple Tables
Naming Columns and Tables
Foreign Keys
ER Diagrams
Joins and Cartesian Products
Inner Joins
Left and Right Outer Joins
Joins on Multiple Tables
Querying Chains of Tables
One to Many and One to One
Many to Many
Joining Tables to Themselves
Restrict Foreign Keys
Cascade Foreign Keys
Exercises 4
Solutions 4
MySQL, SQL and Stored Procedures from Beginner to Advanced at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?