Course Description
Last Update: 16 February2016
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.
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.
Curriculum
Who should learn SQL?
Add the data rows in a table using INSERT INTO Statement
An Overview of SQL
CHAR and VARCHAR in SQL (String Values)
CLOB and BLOB in SQL (String Values)
Course Introduction
Create example databases, tables and data rows
Data Definition Language(DDL) and Data Manipulation Language(DML)?
DATE, TIME and TIMESTAMP in SQL (Temporal Values)
Delete data rows using DELETE Statement
Derived Tables or Inline Views
Difference between Database Engine, Database Server and Database Software
Fixed-Point Numbers in SQL (Exact Values)
Floating-Point Numbers in SQL (Approximate Values)
Functions in SQL and Types of SQL functions
How to add a new database user and add privileges
How to add the data rows to a database table?
Install MySQL database server on Linux operating system
Install MySQL database server on Mac operating system
Install MySQL database server on Windows operating system
Integer Numbers in SQL (Exact Values)
Introduction
Learn about CROSS JOIN in SQL
Learn about FULL OUTER JOIN in SQL
Learn about INNER JOIN in SQL
Learn about LEFT OUTER JOIN in SQL
Learn about RIGHT OUTER JOIN in SQL
Learn about SQL FROM Clause
Learn about SQL GROUP BY Clause
Learn about SQL HAVING Clause
Learn about SQL ORDER BY Clause
Learn about SQL SELECT Clause
Learn about SQL Statements
Learn about SQL WHERE Clause
Learn how to create and display databases
MySQL shortcut for Windows users
NCHAR and NVARCHAR in SQL (String Values)
Remove or delete database from database management system
Section 1: Introduction
Section 10: SQL Data Types
Section 11: Data Definition Language
Section 2: Setup a Testing Environment
Section 3: An Overview of SQL
Section 4: Important SQL Clauses (Data Manipulation Language)
Section 5: Conditions and Operators (Data Manipulation Language)
Section 6: Data grouping, sorting, select and dates (Data Manipulation Language)
Section 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
Section 8: SQL JOINS (Data Manipulation Language)
Section 9: SQL Functions
Select and use existing database
Setup a Testing Environment
SQL Aliases
SQL AND Operator
SQL AVG() Function
SQL BETWEEN Operator
SQL CASE() Function
SQL CAST() Function
SQL CHAR_LENGTH() Function
SQL COALESCE() Function
SQL Comparison Operators
SQL Concatenation Operator
SQL COUNT() Function
SQL Dates
SQL EXISTS Condition
SQL False Condition
SQL FIRST() Function
SQL FORMAT() Function
SQL IN Operator
SQL INSERT INTO SELECT Statement
SQL LAST() Function
SQL LCASE() Function
SQL LEN() Function
SQL LIKE Operator
SQL LIMIT or TOP Clause
SQL MAX() Function
SQL MID() Function
SQL MIN() Function
SQL NOT IN or NOT EXISTS? Conditions
SQL NULLIF() Function
SQL Numeric Operators
SQL OR Operator
SQL ROUND() Function
SQL SELECT DISTINCT Statement
SQL SUBSTRING() Function
SQL SUM() Function
SQL Temporal Operator
SQL True Condition
SQL UCASE() Function
SQL UNION Operator
SQL VIEWS
SQL Wildcards
Understand Keywords, Identifiers, Constants and Clauses
Update data rows using UPDATE Statement
What are JOINS in SQL? Types of SQL JOINS
What is a database table? How to create and use a database table?
What is a database? How to create and use a database?
What is data type in SQL?
What is DBMS and RDBMS?
What is SQL Injection and How to secure a database?
What is SQL?
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
