课程详情

SQL Course For Beginners: Learn SQL Using MySQL DatabaseThe course was completely updated on 9th December 2024Here Is What You Get By Enrolling In This Course:Word-By-Word Explanation: In the entire course, I explain each line of code, without skipping a single line of code.Practice Examples: Special set of practice examples included at the end of each section. Awesome Quality Content: Over 15+ hours of HD(1080p) Videos.Well Structured & Easy To Learn: Course has been specially designed to make it easy for the students to learn SQL.24 X 7 Support: I will always be there to guide you in your journey to become SQL expert.Note: Student queries and problems will be answered immediately. Here Is Everything You Will Learn In This Complete Course: The entire course is divided into 23 major sections.Here is what is covered in each section:Section 1: Introduction to the courseIn this section we will learn what the course covers and have a brief overview of the topics to be coveredSection 2: Introduction to SQL and DatabasesIn this section We will learn what are databases, what is SQL and what role does SQL play in databases. By the end of this section you will have a brief idea about what databases are and how they are created.Section 3: Installing required toolsWe then install a couple of tools required for learning SQL, we install MySQL and A tool called MySQL workbench will allows us to write SQL queries.Section 4: SQL basics, creating databases, tables & data typesOnce we have MySQL installed we will straightaway start creating and learn how to create our very own databases and database tables. We learn how a database table is created and how data is stored in database tables. We will learn how to create any table in a database by writing SQL syntax. We will also learn about data types and the select clause which allows us to select or query data from our database tables.Section 5: Constraints in MySQLWe then learn about constraints. After creating database tables, we need to enforce certain rules on each table. Constraints allow you to do exactly that, constraint allows us to impose rules on database tables. In this section we learn the different types of constraints and their uses.Section 6: Comparison operators in MySQLTo filter data from our SQL queries, MySQL provides us multiple comparison operators. In this section we will learn about t he different comparison operators like equal, not equal, less than, greater than, between, like, is null and is not null operators. All of these operators allow us to filter data from our query results.Section 7: Logical operators in MySQLMySQL provides logical operators like AND, OR & NOT, we can use these logical operators to combine multiple SQL queries together.Section 8: String functions in MySQLWe then learn about string functions. Most of the data stored in the database is stored in form of strings. MySQL provides built in string functions which can be used to perform string manipulations. Some of the string functions we will be learning are the Concat function, length function, Substring function, Trim function, replace function, Locate function and a lot more.Section 9: Arithmetic operationsMySQL database contains numeric data as well. Hence mysql also provides the ability to perform arithmetic operations on numerical data present in our database. In this section we will learn how arithmetic can be performed on numerical data in our database tables.Section 10: Modifying database tablesWe have already created database tables, but we also need to learn how to modify them and that is exactly what we will learn in this section. We will learn how to add new columns, delete existing columns, change data types of columns, rename columns, rename tables, modify constraints and drop constraints. This will give us superpowers to modify any database table in any way we desire.Section 11: CRUD operationsCRUD stands for CREATE, READ, UPDATE & DELETE In this section we will learn how to perform all the above operations with respect to database tables.Section 12: Aggregate functionsSometimes we have to apply functions on the entire data and aggregate functions allow you to do that. Aggregate functions have the ability to collectively operate on all rows in our table. In this section we will learn about the different aggregate functions provided by MySQL.Section 13: Date & time data types in MySQLDatabase table can also have data and time data in it and we need to learn how to effectively work with that data. In this lecture we will learn exactly that, i.e how to work with data related to date and timeSection 14: Foreign key constraintWe learn what a foreign key is and how it is used to establish a connection between two tables.Section 15: Relationships in MySQLIn a large database, database tables are connected with each other. These database table connections are called as relationships. In this section we will learn the different relationships that can exists between database tables.Section 16: Joins in MySQLIn this section we learn how we could join two tables on the basis of a common column. We learn the different types of joins that can be implemented between two database tables.Section 17: Views in MySQLWe then learn about views, what they are and how to create views in MySQL. Views allow us to write complex queries in MySQL and we learn how to write a complex query using a view.Section 18: Database theory for interviewsThis section is completely theoretical and is added in this course keeping in mind that you might be appearing for interviews. In this section we learn what is a data definition language, data manipulation language. We will also learn what are relational databases, non relational databases and the differences between the two.Section 19: Window functions in MySQLWindow functions are a new concept introduced in MySQL 8. They allow us to apply a function over a specified window.We learn the different types of window functions that exists.Section 20: CTEs in MySQLCTEs also called as common table expression are newly introduced in MySQL, in this section we will learn what CTEs are and how they are created and what purpose they serve in MySQL.Section 21: CASE statement in MySQLIn this section we learn how to create conditional flow in MySQL statements, we learn how the case statement works and how it can be used to write conditional queries.Section 22: Stored Routines in MySQLMySQL allows you to create your own functions and procedures and save them so that you can use them as and when required. In this section we will learn how to implement stored functions and stored procedures.Section 23: Triggers in MySQLIn the last section we will learn about triggers, how triggers are created in MySQL and the different types of triggers that can be created. We learn about the before insert trigger, before update trigger, after update trigger, before update trigger, after delete trigger.So let's begin the journey of becoming an expert in SQL.In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!Make sure to enrol in the course before the price changes.Take yourself one step closer towards becoming a professional SQL developer by clicking the "take this course button" now!Join the journey.Sincerely, Ashutosh Pawar

课程标签

0人关注该课程

主题相关的课程