Description
I'm excited to invite you to take the Databases and SQL Mastery comprehensive course. This course is a complete academy about databases and the SQL language, a skill that will serve you throughout your career as a business information systems specialist. I'm starting from zero and taking you to the most sophisticated use cases, including nested queries, locking, and transactions. This course covers essential technologies and extensions to meet the business requirements of business solutionsIn this course you will understand the principles of Relational Databases, design and implement the database for your customer and master the SQL language to a business-grade level. You will discover: Introduction to databasesInstalling the MySQL DB serverMySQL server data typesThe SQL language: concepts and structureSQL data definition: creating the schema, tablesAssignment 8: Using SQL to create tables, indexes, and relationshipsPopulating DB tables from CSV filesThe SQL select command: joins, scalar, aggregates, union, nested queriesMySQL viewsAdvanced insert and update: with subqueries and joinsTransactions, Locks, Isolation, and VariablesAssignment: Extend the ERD, serve complex business reports and monthly updates using SQLWhat you will get when enrolling to this course:6.45 hours in 20 recorded, hands-on sessionsEach session was carefully planned, its code was written and verified and the video was edited to reflect a balanced blend of slides lecture with hands-on demo. The course is structured to build a gradual learning curve. With each session you conquer another goal, expand your skills and experience.1 QuizThe course closes with a quiz. The quiz is designed to measure your deep understanding of the material. Repeating a sentence you heard in the course is not enough to pass the quiz. Only true understanding gained through practice leads to successful professionals - and that is what I aim for you!2 AssignmentsWriting code that works for real business needs will earn you the practice and skill you need. The assignments are engineered to confront you with real business challenges and are considered an important part of your training. I always say: an assignment is your opportunity to express yourself! Assignment's complete solution: SQL code for downloadI explain my solution for each and every assignment in a dedicated, detailed session, so these are important lessons in and of themselves - don't skip those sessions!
