A simple & concise MSSQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.
About this Course
This course is a selection of material from our larger Web Development course.
This course the fundamentals of data management with SQL and MySQL in this course. Learn all you need to know about SQL, the most widely used computer language for handling data. Essentially, this course is about SQL commands. You’ll discover the fundamentals of inquiries.
What You Will Learn
Understanding and installation
Access, Create and Update data stored in a Database
Perform complex queries by learning essential query keywords and functionality.
Administrator duties and creating users
Expand your SQL skills by constructing and manipulating databases with several connected tables.
Upon successful completion of this course, you should be able to:
- Utilize the MySQL DBMS to build and modify relational databases with SQL.
- Understand MySQL database maintenance tasks.
- Create relationships between tables using primary and foreign keys.
SKILLS YOU WILL GAIN
- Data Management
- Database (DMBS)
- Relational Database
- Database Administration