In this 1-hour long project-based course, you will learn how to use the QuerySet methods and the Q objects to query data in Django. You will generate a sample project and create a view that populates the database with sample data. You will then learn the syntax of keyword arguments to construct queries using the QuerySet methods. You will create complex queries using the Q objects, and finally you will learn how to query across relationships. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

[As described below, this is Part C of a 3-part course. Participants should complete Parts A and B first -- Part C "dives right in" and refers often to material from Part A and Part B.] This course is an introduction to the basic concepts of programming languages, with a strong emphasis on functional programming. The course uses the languages ML, Racket, and Ruby as vehicles for teaching the concepts, but the real intent is to teach enough about how any language “fits together” to make you more effective programming in any language -- and in learning new ones. This course is neither particularly theoretical nor just about programming specifics -- it will give you a framework for understanding how to use language constructs effectively and how to design correct and elegant programs. By using different languages, you will learn to think more deeply than in terms of the particular syntax of one language. The emphasis on functional programming is essential for learning how to write robust, reusable, composable, and elegant programs. Indeed, many of the most important ideas in modern languages have their roots in functional programming. Get ready to learn a fresh and beautiful way to look at software and how to have fun building it. The course assumes some prior experience with programming, as described in more detail in the first module of Part A. Part B assumes successful completion of Part A. The course is divided into three Coursera courses: Part A, Part B, and Part C. As explained in more detail in the first module of Part A, the overall course is a substantial amount of challenging material, so the three-part format provides two intermediate milestones and opportunities for a pause before continuing. The three parts are designed to be completed in order and set up to motivate you to continue through to the end of Part C. Week 1 of Part A has a more detailed list of topics for all three parts of the course, but it is expected that most course participants will not (yet!) know what all these topics mean.

If you love games and want to learn how to make them, then this course is your second step down that path. In this course you will learn the fundamentals of game design, including an understanding of the game world, storytelling, gameplay, user experience, and game technology. You will continue developing videogames using industry standard game development tools, including the Unity game engine. At the end of the course you will have completed a 2D Platformer game, and will be able to leverage an array of game development techniques to create your own basic games.

This is a self-paced lab that takes place in the Google Cloud console. Unity game development

In this 1-hour long project-based course, you will learn how to: • Create a Google Maps Activity in an Android App using Android Studio • Adjust the location accuracy settings of your app, and insert markers in your map • Get a Google Maps API Key to use in your app, and adjust the key restrictions *** You do not need to get a Google Maps API Key to pass the quiz and get the certificate for this project. If you want to get a Google Maps API Key (which is required to make Google Maps function in your app) you will need to set up a free trial google cloud console account as it is through this you would get the key. You do not have to pay anything to have a trial Google Cloud account or to get and use an API Key the way this project uses it, but when you are setting up a google cloud account they do ask you for credit card details for the account to make sure you are not a bot. You do not have to set up a Google Cloud account or get an API Key if you do not want to.*** Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions. Projects in Series 1: 1. Build a Simple App in Android Studio with Java 2. Build a Persistent Storage App in Android Studio 3. Build a Linear Layout App in Android Studio 4. Build a Relative Layout App in Android Studio 5. Build a Table Layout App in Android Studio Projects in Series 2: 1. Build an App in Android Studio using Resources 2. Build an App in Android Studio using Static Files 3. Build an App in Android Studio using Read - Write 4. Build an App in Android Studio using onTouch 5. Build an App in Android Studio using Activities Projects in Series 3: 1. Access CSV in an Android Studio Project 2. Access SQLite in an Android Studio Project. 3. Access WebView in an Android Studio Project. 4. Access NFC in an Android Studio Project 5. Access Maps in an Android Studio Project.

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. By the end of this course, you’ll be able to: - Demonstrate a working knowledge of the concepts and principles that underpin how databases work - Identify and explain the different types of core technology and management systems used in databases - Identify and interpret basic SQL statements and commands - Manipulate records in a database with the use of SQL statements and commands - Outline alternatives to SQL - and plan and design a simple relational database system You’ll also gain experience with the following: • Fundamental concepts in database • Basic MySQL syntax and commands • Database management systems • MySQL software • Relational databases

By the end of this project, you will create a full web-site that is attractive and user friendly using a free content management system, WordPress. You will learn how to create a website utilizing themes and plug-ins using the web creation tool. You’ll have a virtual space to showcase your business with customers who want to stay connected. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

In this intermediate-level course you will explore how CSS (Cascading Stylesheets) can be used to alter the appearance of an image on your web page. HTML is used to add image content to a website and CSS is used to make that content visually appealing to website visitors. You will use the Notepad++ editor to write CSS rules with a variety of selectors and properties that are applied to images to change their appearance. The Chrome browser is used to display the page to test the results of your work. CSS is a very powerful tool and using it to gain more control over the visual aspects of images is a valuable skill for a web developer. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

In this 1-hour long project-based course, you will create a professional and fully functional website for your restaurant having a homepage with a navigation bar along with the restaurant’s logo that can redirect the client to multiple pages to review the full menu or know about the restaurant or back to the homepage, all using HTML and CSS on Visual Studio Code .In this project, you will be able to identify and apply the basic concepts of HTML and CSS starting with HTML elements and links up to tables and use CSS to perform your own styling such as fonts, sizes and colors. You will efficiently grasp the fundamental meaning of every component , be able to use it and identify when to actually make use of this component. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Hello and welcome to the course! In this intermediate course on Typescript. By the end of this course, you will have worked with all the main Typescript types, both simple and advanced. You will have written Typescript code and compiled it using the command line. You will also get experience writing classes in Typescript to understand the way Typescript implements OOP. Finally you will restructure your files to represent a real-world setup In this course, we are going to focus on the following learning objectives: - Understand what Typescript is and why companies use it - Learn all of the basic types and use them, eg, strings, numbers arrays etc - Learn advanced types and use them, eg, enums and interfaces etc - Write classes and understand OOP principles in Typescript - Restructure our project files for real-world dev example By the end of this course you will be comfortable to start using Typescript on real projects